2013
7 hours
01. Introduction Data Warehousing 2012
0101 What You Will Learn
0102 Data Warehouse Concepts And Architecture
0103 Data Warehouse Solutions
02. Data Warehouse Hardware
0201 Data Warehouse Challenges – Memory
0202 Data Warehouse Challenges – Physical
0203 Data Warehouse Architectures
0204 Data Warehouse Appliances
03. Designing And Implementing A Data Warehouse
0301 Data Warehouse Logical Design
0302 Data Warehouse Physical Design
0303 Exercise: Implementing A Data Warehouse Schema
0304 Solution For Implementing A Data Warehouse Schema
04. Design And Implement A Data Warehouse Schema
0401 ETL And SSIS
0402 Defining A Data Source
0403 Implementing A Data Flow – Part 1
0404 Implementing A Data Flow – Part 2
0405 Exercise: Implementing A SSIS Package
0406 Solution For Implementing A SSIS Package
05. Control Flows And SSIS Package
0501 Introduction To Control Flows
0502 Dynamic Packages
0503 Defining Containers – Part 1
0504 Defining Containers – Part 2
0505 Manage Consistency
0506 Exercise: Implement Control Flows In SSIS
0507 Solution For Implementing Control Flow SSIS
06. Debugging And Troubleshooting SSIS Packages
0601 Debugging SSIS
0602 Error Log Providers
0603 Error Handling And SSIS – Part 1
0604 Error Handling And SSIS – Part 2
0605 Exercise: Debugging And Troubleshooting SSIS
0606 Solution For Debugging And Troubleshooting SSIS
07. Incremental ETL Process
0701 Introduction To Incremental ETL Processes
0702 Extract Modified Data – Part 1
0703 Extract Modified Data – Part 2
0704 Load Modified Data
0705 Exercise: Load Incremental Data
0706 Solution For Incremental Load
08. Enforcing Data Quality
0801 Data Cleansing
0802 Data Quality Services
0803 Data Quality Services And Matching Data
0804 Exercise Cleansing Data
0805 Solution For Cleansing Data
0806 Exercise: De-Duplicating Data
0807 Solution For De-Duplicating Data
09. Master Data Services
0901 What Is Master Data Services
0902 Implementing Master Data Services
0903 Excel Add-In For Master Data Services
10. Extending SSIS
1001 Custom SSIS Components
1002 Scripting And SSIS – Part 1
1003 Scripting And SSIS – Part 2
11. Deploying SSIS Packages
1101 Overview Of SSIS Deployment
1102 Deploying SSIS Packages – Part 1
1103 Deploying SSIS Packages – Part 2
1104 Planning SSIS Package Execution
1105 Exercise: Deploying An SSIS Package
1106 Solution For Deploying SSIS Package
12. Consuming Data
1201 Data Warehouse Using Excel
1202 Using PowerPivot And Data Warehouse
1203 Data Warehouse And SSRS
1204 Exercise: Using Excel And PowerPivot
1205 Solution For Excel And PowerPivot