MicroSoft – BI
(SSIS, SSAS, SSRS)
SSIS–Objectives:
Plan data transfer and staging solutions for an ETL operation.
Plan an SSIS Solution
Design and implement data flows
Incorporate logging, error handling, and reliability into a package.
Optimize an SSIS solution
Deploy and operate an SSIS solution.
SSAS – Objectives:
Describe how SQL Sever Analysis Service can be used to implement Analytical Solutions.
Create multidimensional analysis solutions with SQL Server Analysis Services.
Implement dimensions in an Analysis Services Solution.
Implement measure and measure group in an Analysis Services Solution.
Query a multidimensional Analysis Service Solution.
Customize an Analysis Service cube.
Deploy and Secure an Analysis Service database.
Maintain a multidimensional Analysis Service Solution.
Implement a Data Mining Solution.
SSRS – Objectives:
Describe SQL Server Reporting Services and its Components.
Create a Reporting Services report.
Enhance a Reporting Service report.
Create and manipulate data sets.
Use report models to implement reporting for business users.
Configure report publishing and execution settings.
Implementing subscription for reports.
Implement custom Reporting Services applications.
