MS-20467 - Designing Business Intelligence Solutions with Microsoft SQL Server

This five-day instructor-led course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to use Microsoft SQL Server Reporting Services, and Microsoft Excel to deliver a self-service BI solution, and how to use Microsoft Windows Azure HDInsight to incorporate Big Data analysis into a BI scenario. Microsoft Azure is required or used as part of the lab for this course, and may not be available in all countries. Please check with your Microsoft training provider that this cloud service is available in your area. Training Providers please reference the course setup guide for more details.

*This course utilizes higher hosting resources for online labs and therefore, post-class access is limited to 30 days.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


This course requires that you meet the following prerequisites:
  • Knowledge of data warehousing and data modeling principles.
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Detailed Class Syllabus

Module 1: Planning a BI Solution

Elements of a BI Solution
Planning a BI Project
The Microsoft BI Platform

Module 2: Planning BI Infrastructure

Considerations of BI Infrastructure
Planning Data Warehouse Hardware

Module 3: Designing a Data Warehouse

Data Warehouse Design Overview
Designing Dimension Tables
Design FACT tables

Module 4: Designing an ETL solution

ETL Overview
Planning for Data Extraction
Planning for Data Transformations
Planning for Data Loading

Module 5: Designing Analytical Data Models

Introduction to Analytical data Models
Designing Analytical Data Models

Module 6: Planning a BI Delivery Solution

Considerations for BI delivery
Common Reporting Scenarios
Choosing a Reporting Tool

Module 7: Designing a Reporting Services Solution

Planning a Reporting Solution
Designing Reports
Planning Report Consistency

Module 8: Designing an Excel Based reporting Solution

Using Excel for Data Reporting and Analysis
PowerPivot in Excel
Power View in Excel

Module 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

Module 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

Module 11: Operating a BI Solution

Overview of BI Operations
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations