Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (M20467B)

Learn to design, install, and maintain a business intelligence infrastructure with Microsoft SQL Server 2012.

GK# 0914 Vendor# M20467B

$2795 - $2995 CAD

Enroll Request Group Training

Course Overview


In this course, you will learn how to design, install, and maintain business intelligence (BI) infrastructures, including data warehouse, an extract, transform, and load (ETL), Analysis Services, Reporting Services, and SharePoint Server.

This course incorporates material from the Official Microsoft Learning Product M20467B: Designing Business Intelligence Solutions for Microsoft SQL Server 2012.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • 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


Viewing outline for:

Virtual Classroom Live 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


Viewing labs for:

Virtual Classroom Live Labs

Lab 1: Plan a BI Solution

  • Scope a BI Solution
  • Determine Software Requirements

Lab 2: Plan a BI Infrastructure

  • Plan Server Topology
  • Plan Data Warehouse Server Hardware

Lab 3: Design a Data Warehouse Logical Schema

  • Identify Business Processes and Dimensions
  • Design Dimension Models and Data Warehouse Tables

Lab 4: Design a Data Warehouse Physical Implementation

  • Design File Storage
  • Design Warehouse Data Structures

Lab 5: Design an ETL Solution

  • Prepare for ETL Design
  • Create Source-to-Target Documentation
  • Use SSIS to load a Partitioned Fact Table

Lab 6: Compare Analytical Data Models

  • Create a Multidimensional Data Model
  • Create a Tabular Data Model

Lab 7: Design Dimensions and Hierarchies

  • Create Dimensions in a Multidimensional Data Model
  • Create Dimensions in a Tabular Data Model

Lab 8: Enhance Analytical Data Models

  • Enhance a Multidimensional Data Model
  • Enhance a Tabular Data Model

Lab 9: Plan a BI Delivery Solution

  • Assess Reporting Requirements

Lab 10: Design a Reporting Services Solution

  • Design a Reporting Environment
  • Create Reusable Report Item
  • Create Reports

Lab 11: Design an Excel Reporting Solution

  • Plan Excel Features
  • Analyze a Cube with Excel
  • Create a PowerPivot Workbook
  • Use Power View in Excel

Lab 12: Implement a SharePoint Server BI Solution

  • Create a SharePoint Server Site for BI
  • Configure Reporting Services in SharePoint Server
  • Configure PowerPivot for SharePoint

Lab 13: Implement a PerformancePoint Service

Lab 14: Monitoring and Optimizing a BI Solution

  • Monitoring and Optimizing a Data Warehouse, Analysis Services, and Reporting Services

Lab 15: Operating a BI Solution

  • Configure SQL Server Integration Services (SSIS)
  • Automate Data Warehouse Load Tasks
  • Test Automated Operations

Who Should Attend


IT professionals such as BI architects or database professionals who need to design BI solutions and are responsible for the overall design of the BI infrastructure, including how it relates to other data systems

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Virtual Classroom Fit

Attend live, online training sessions for a total of 24 hours spread over four weeks.

Duration: 5 day

Request this course in a different delivery format.