Question

Looking forward to current and future needs in your own industry or one in which you desire to work, describe how the more advanced SQL server integration services (SSIS) data migration software, SQL server analysis services (SSAS) online analytical processing technology, or SQL server reporting services (SSRS) report software could be useful for the industry's current needs as well as to propel growth. Justify your ideas with support from the Topic Materials or relevant industry examples.

Answer 1

SQL Server integration services (SSIS) data migration software will help to move the data from one database to another. And it can extract the data from a variety of sources like MS Excel, Oracle, etc. In any industry, for example in the manufacturing sector, the marketing department may need information from the selling department. To get the data it needs to be transferred from the selling database to the database of the marketing department for further planning. Also maybe some branches in the rural area are maintaining the data in a simple Excel file and in the Urban area they are professionally using Oracle. So the marketing department needs to extract the data from all of them.

SQL server analysis services (SSAS) is an analytical engine that helps in proper decision making for the management in an organization. For example, after collecting all the data from the selling department the marketing managers need to use the data to find some trend or mine the data (Data Mining) so that the resultant find out can help them to make further decisions to help their organization grow.

When the managers find out some valuable information from the data they need to convey it to the other employees in the organization so that all the employees can get the idea about what to do or not. To make the information easy to understand the SQL server reporting services (SSRS) can help in creating, managing and deploying the reports and the report can be accessed from any devices (Mobile or PC) by providing in a responsive layout.

These three tools can help an organization to collect the real-time data from heterogeneous sources and analyze it to find out valuable information from the available data and then conveying the information among each level of the organization so that they can modify their processes according to the current trend. This will help an organization to gain the desired growth.