Module 1: Planning a BI Solution
This module enables students to plan the components of a BI Solution.
Module 2: Planning BI Infrastructure
This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.
Module 3: Designing a Data Warehouse
This module describes how to design a data warehouse given a set of user requirements.
Module 4: Designing an ETL solution
This lesson describes how to design an extract, transform and load (ETL) solution.
Module 5: Designing Analytical Data Models
This module describes how to design analytical data models for specific BI scenarios.
Module 6: Planning a BI Delivery Solution
This module describes how to choose an appropriate delivery solution for a given scenario.
Module 7: Designing a Reporting Services Solution
This module describes how to design a reporting services solution.
Module 8: Designing an Excel Based reporting Solution
In this module students will learn how to design a reporting solution using Excel.
Module 9: Planning a SharePoint Server BI Solution
This module introduces the use of SharePoint Server as a BI solution.
Module 10: Monitoring and Optimizing a BI Solution
At the conclusion of this module you will be able to optimize and monitor a BI solution.
Module 11: Operating a BI Solution
At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.