This module covers the creation, execution and deployment of an ETL project using the SQL Server Integration Services (SSIS). Several examples were provided to show how data from different sources can be Extracted from the source, Transformed into meaningful forms and Loaded to the data warehouse.
Reports are integral part especially of any database-driven application. Data, regardless of volume, need to be processed and retrieved from a variety of sources and later presented to the desired users in various forms. Out of these reports, appropriate actions are normally carried out by the respective users.
This resource introduces the Reporting Services which is one of the Business Intelligence projects under the umbrella of SQL Server technologies. It walks you through the creation, deployment and subscription of server-side report whose deployment and data-driven subscription are made possible through SQL Server Reporting Services (SSRS).