IMPLEMENTING DATA WAREHOUSE WITH MICROSOFT SQL SERVER® 2014

Modular Course (Select your Modules)

   This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Datawarehouse ( 1 day)

• Introduction to Data Warehousing

• Data Warehouse Hardware Considerations

• Designing and Implementing a Data Warehouse

ETL Fundamental (1.5 days)

• Creating an ETL Solution with SSIS

• Implementing Control Flow in an SSIS Package

• Debugging and Troubleshooting SSIS Packages

• Implementing an Incremental ETL Process

• Enforcing Data Quality

• Using Master Data Services

• Extending SQL Server Integration Services

• Deploying and Configuring SSIS Packages

ETL Advanced Topics & Deployment (2 days)

Additional Topic (0.5 day)

• Consuming Data in a Data Warehouse

Visit

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

 

Call

T: +62-21-521-0793
F: +62-21-521-0794

 

Contact         @ExecuTrain_JKT

sales@executrain.co.id

  • w-tbird

 2013 by ExecuTrain of Jakarta.