E-DB02: “Implementing Microsoft SQL Server 2012-2014 Business Intelligence ”

This 5-days instructor-led course is how to implement a data warehouse and create a managed enterprise BI solutions.

Objective

After completing this course, students will be able to:

​

·         Design and implement a data warehouse.

·         Implement Data Flow in an SSIS Package.

·         Implement Control Flow in an SSIS Package.

·         Debug and Troubleshoot SSIS packages.

·         Implement an ETL solution that supports incremental data extraction.

·         Implement an ETL solution that supports incremental data loading.

·         Extend SSIS with custom scripts and components.

·         Deploy and Configure SSIS packages.

·         Create a multidimensional database with Analysis Services.

·         Implement dimensions in a cube.

·         Implement measures and measure groups in a cube.

·         Use MDX Syntax.

·         Customize a cube.

·         Create reports with Reporting Services.

·         Enhance reports with charts and parameters.

·         Manage report execution and delivery.