Module 1: Planning a BI Solution
This module discusses how to plan the components of a BI solution.
Lessons
- Elements of a BI Solution
- The Microsoft BI Platform
- Planning a BI Project
Lab : Planning a BI Solution
Module 2: Planning SQL Server Business Intelligence Infrastructure
This module explains how to plan an appropriate BI infrastructure for a given set of BI services.
Lessons
- Considerations for BI Infrastructure
- Planning Data Warehouse Hardware
Lab : Planning a BI Infrastructure
Module 3: Designing a Data Warehouse
This module explains how to design a data warehouse for a given set of user requirements.
Lessons
- Data Warehouse Design Overview
- Designing Dimension Tables
- Designing Fact Tables
- Designing a Data Warehouse Physical Implementation
Lab : Designing a Data Warehouse Logical Schema
Lab : Designing a Data Warehouse Physical Implementation
Module 4: Designing an ETL Solution
This module explains how to design an ETL solution for a data warehouse.
Lessons
- ETL Overview
- Planning Data Extraction
- Planning Data Transformation
- Planning Data Loads
Lab : Designing an ETL Solution
Module 5: Designing Analytical Data Models
This module explains how to design analytical data models for specific BI scenarios.
Lessons
- Introduction to Analytical Data Models
- Designing an Analytical Data Model
- Designing Dimensions
- Enhancing Data Models
Lab : Comparing Analytical Data Models
Lab : Designing Dimensions and Hierarchies
Lab : Enhancing Analytical Data Models
Module 6: Planning a BI Delivery Solution
This module explains how to choose an appropriate delivery solution for a given scenario.
Lessons
- Considerations for Delivering BI
- Common Reporting Scenarios
- Choosing a Reporting Tool
Lab : Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
This module explains how to design a Reporting Services solution.
Lessons
- Planning a Reporting Services Solution
- Designing Reports
- Planning Report Consistency
Lab : Designing a Reporting Services Solution
Module 8: Designing a Microsoft Excel-Based Reporting Solution
This module explains how to design a reporting solution that uses Excel.
Lessons
- Using Excel for Data Analysis and Reporting
- PowerPivot for Excel
- Power View for Excel
Lab : Designing an Excel Reporting Solution
Module 9: Planning a SharePoint Server BI Solution
This module explains how to design a SharePoint BI solution.
Lessons
- Introduction to SharePoint Server as a BI Platform
- Planning Security for a SharePoint Server BI Solution
- Planning Reporting Services Configuration
- Planning PowerPivot Configuration
- Planning for PerformancePoint Services
Lab : Implementing a SharePoint Server BI Solution
Lab : Implementing a PerformancePoint Services
Module 10: Monitoring and Optimizing a BI Solution
This module explains how to monitor and optimize a BI solution.
Lessons
- Overview of BI Monitoring
- Monitoring and Optimizing the Data Warehouse
- Monitoring and Optimizing Analysis Services
- Monitoring and Optimizing Reporting Services
Lab : Monitoring and Optimizing a BI Solution
Module 11: Operating a BI Solution
This module explains how to plan management and maintenance operations for a BI solution.
Lessons
- Overview of BI Operations
- ETL Operations
- Data Warehouse Operations
- Analysis Services Operations
- Reporting Services Operations
Lab : Operating a BI Solution