Microsoft 20467B – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

In this course you will learn how to design, install and maintain busines intelligence infrastructure such as data warehouse, extract, transform and load (ETL), Analysis Services, Reporting Service and SharePoint Server.

Who needs to attend

Who needs to attend?
This course is aimed at business intelligence architects and database professionals responsibe for designing business intelligence solutions.

what you will learn

What you will learn
Upon completion you will know how to:

  • Plan the components of a BI solution
  • Design a data warehouse solution
  • Design an ETL solution
  • Plan analytical data models
  • Plan a BI delivery solution
  • Design a Reporting Services solution
  • Design an Excel reporting solution
  • Plan a SharePoint Server BI solution
  • Monitor and optimize a BI solution
  • Plan for BI operations

Students need to have:

  • Basic understanding of dimensional modeling (star schema) for data warehouses
  • Ability to create integration services packages that include control flows and data flows
  • Ability to create a basic multidimensional cube with Analysis Services
  • Ability to create a basic tabular model with PowerPivot and Analysis Services
  • Ability to create Reporting Services reports with Report Designer
  • Ability to implement authentication and permissions with the SQL Server database engine, Analysis Services, and Reporting Services
Course outline

Course Outline

1. Planning a BI Solution

Elements of a BI Solution
The Microsoft BI Platform

2. Planning SQL Server Business Intelligence Infrastructure

Considerations for BI Infrastructure
Planning Data Warehouse Hardware

3. Designing a Data Warehouse

Data Warehouse Design Overview
Design Dimension Tables and Fact Tables
Design a Data Warehouse Physical Implementation

4. Designing an ETL Solution

ETL Overview
Plan Data Extraction, Data Transformation, and Data Loads

5. Designing Analytical Data Models

Introduction and Designing an Analytical Data Model
Designing Dimensions
Enhancing Data Models

6. Planning a BI Delivery Solution

Considerations for Delivering BI
Common Reporting Scenarios
Choosing a Reporting Tool

7. Designing a Reporting Services Solution

Planning a Reporting Services Solution
Designing Reports
Planning Report Consistency

8. Designing a Microsoft Excel-Based Reporting Solution

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

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

10. Monitoring and Optimizing a BI Solution

Overview of BI Monitoring
Monitoring and Optimizing the Data Warehouse, Analysis Services, and Reporting Services

11. Operating a BI Solution

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

Follow on
There no follow-ons for this course.

Certification programs
There are no certifications associated with this course.