1 – Planning a BI Solution
- Elements of a BI Solution
- Planning a BI Project
- The Microsoft BI Platform
- Lab : Planning BI Solutions
2 – Planning BI Infrastructure
- Considerations of BI Infrastructure
- Planning Data Warehouse Hardware
- Lab : Planning BI Infrastructure
3 – Designing a Data Warehouse
- Data Warehouse Design Overview
- Designing Dimension Tables
- Design FACT tables
- Lab : Designing a Data Warehouse Logical Schema
4 – Designing an ETL solution
- ETL Overview
- Planning for Data Extraction
- Planning for Data Transformations
- Planning for Data Loading
- Lab : Designing an ETL Solution
5 – Designing Analytical Data Models
- Introduction to Analytical data Models
- Designing Analytical Data Models
- Lab : Designing Analytical Data Model
- Lab : Designing Dimensions and Hierarchies
6 – Planning a BI Delivery Solution
- Considerations for BI delivery
- Common Reporting Scenarios
- Choosing a Reporting Tool
- Lab : Planning a BI Delivery Solution
7 – Designing a Reporting Services Solution
- Planning a Reporting Solution
- Designing Reports
- Planning Report Consistency
- Lab : Designing a Reporting Services Solution
8 – Designing an Excel Based reporting Solution
- Using Excel for Data Reporting and Analysis
- PowerPivot in Excel
- Power View in Excel
- Lab : Designing and Excel Reporting Solution
9 – Planning a SharePoint Server BI Solution
- 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 PerformancePoint Services
10 – Monitoring and Optimizing a BI Solution
- Overview of BI Monitoring
- Monitoring and Optimizing the Data Warehouse
- Monitoring and Analyzing Analysis Services
- Monitoring and Optimizing Reporting Services
- Lab : Monitoring and Optimizing a BI Solution
11 – Operating a BI Solution
- Overview of BI Operations
- ETL Operations
- Data Warehouse Operations
- Analysis Services Operations
- Reporting Services Operations
- Lab : Operating a BI Solution