Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

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.

Click here to print this page »

Prerequisites


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