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


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.

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


Setiabudi 2 Building. 6th Floor. Unit 606. Jl. HR. Rasuna Said. Kav. 62. Jakarta Selatan. Indonesia



+62 21 5210 793

Contact         @ExecuTrain_JKT

  • w-tbird

 2013 by ExecuTrain of Jakarta.