Home / Courses / Microsoft Technology / 20467B: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

SQL

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

Module 1: Planning a BI Solution

This module discusses how to plan the components of a BI solution.

Lessons

  • Elements of a BI Solution

  • The Microsoft BI Platform

  • Planning a BI Project

Lab : Planning a BI Solution

  • Scoping a BI Solution

  • Determining Software Requirements

After completing this module, students will be able to:

  • Describe elements of a BI Solution.

  • Describe how Microsoft products can be used to implement a BI solution.

  • Describe considerations for a BI project.

Module 2: Planning SQL Server Business Intelligence Infrastructure

This module explains how to plan an appropriate BI infrastructure for a given set of BI services.

Lessons

  • Considerations for BI Infrastructure

  • Planning Data Warehouse Hardware

Lab : Planning a BI Infrastructure

  • Planning Server Topology

  • Planning Data Warehouse Server Hardware

After completing this module, students will be able to:

  • Describe key considerations for BI infrastructure.

  • Plan data warehouse infrastructure.

Module 3: Designing a Data Warehouse

This module explains how to design a data warehouse for a given set of user requirements.

Lessons

  • Data Warehouse Design Overview

  • Designing Dimension Tables

  • Designing Fact Tables

  • Designing a Data Warehouse Physical Implementation

Lab : Designing a Data Warehouse Logical Schema

  • Identifying Business Processes and Dimensions

  • Designing Dimension Models and Data Warehouse Tables

Lab : Designing a Data Warehouse Physical Implementation

  • Designing File Storage

  • Designing Warehouse Data Structures

After completing this module, students will be able to:

  • Describe a process for designing a dimensional model for a data warehouse.

  • Design dimensions tables for a data warehouse.

  • Design fact tables for a data warehouse.

  • Design and implement effective physical data structures for a data warehouse.

Module 4: Designing an ETL Solution

This module explains how to design an ETL solution for a data warehouse.

Lessons

  • ETL Overview

  • Planning Data Extraction

  • Planning Data Transformation

  • Planning Data Loads

Lab : Designing an ETL Solution

  • Preparing for ETL Design

  • Creating Source-to-Target Documentation

  • Using SSIS To Load a Partitioned Fact Table

After completing this module, students will be able to:

  • Describe considerations for designing an ETL solution.

  • Plan data extraction.

  • Plan data transformations.

  • Plan Data loads.

Module 5: Designing Analytical Data Models

This module explains how to design analytical data models for specific BI scenarios.

Lessons

  • Introduction to Analytical Data Models

  • Designing an Analytical Data Model

  • Designing Dimensions

  • Enhancing Data Models

Lab : Comparing Analytical Data Models

  • Creating a Multidimensional Data Model

  • Creating a Tabular Data Model

Lab : Designing Dimensions and Hierarchies

  • Creating Dimensions in a Multidimensional Data Model

  • Creating Dimensions in a Tabular Data Model

Lab : Enhancing Analytical Data Models

  • Enhancing a Multidimensional Data Model

  • Enhancing a Tabular Data Model

After completing this module, students will be able to:

  • Describe options for analytical data models.

  • Design an initial multidimensional or tabular data model.

  • Design dimensions in a multidimensional or tabular data model.

  • Design measures and cubes in a multidimensional or tabular data model.

Module 6: Planning a BI Delivery Solution

This module explains how to choose an appropriate delivery solution for a given scenario.

Lessons

  • Considerations for Delivering BI

  • Common Reporting Scenarios

  • Choosing a Reporting Tool

Lab : Planning a BI Delivery Solution

  • Assessing Reporting Requirements

After completing this module, students will be able to:

  • Describe considerations for delivering BI to users.

  • Describe the key features of common reporting scenarios.

  • Choose an appropriate reporting tool for a particular reporting scenario.

Module 7: Designing a Reporting Services Solution

This module explains how to design a Reporting Services solution.

Lessons

  • Planning a Reporting Services Solution

  • Designing Reports

  • Planning Report Consistency

Lab : Designing a Reporting Services Solution

  • Designing a Reporting Environment

  • Creating Reusable Report Item

  • Creating Reports

After completing this module, students will be able to:

  • Plan a Reporting Services solution.

  • Design reports.

  • Plan report consistency.

Module 8: Designing a Microsoft Excel-Based Reporting Solution

This module explains how to design a reporting solution that uses Excel.

Lessons

  • Using Excel for Data Analysis and Reporting

  • PowerPivot for Excel

  • Power View for Excel

Lab : Designing an Excel Reporting Solution

  • Exercise 1: Planning Excel Features

  • Exercise 2: Analyzing a Cube with Excel

  • Exercise 3: Creating a PowerPivot Workbook

  • Exercise 4: Using Power View in Excel

After completing this module, students will be able to:

  • Describe Excel features that enable users to analyze data.

  • Configure and use PowerPivot for Excel.

  • Configure and use Power View in an Excel workbook.

Module 9: Planning a SharePoint Server BI Solution

This module explains how to design a SharePoint BI solution.

Lessons

  • 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

  • Exercise 1: Creating a SharePoint Server Site for BI

  • Exercise 2: Configuring Reporting Services in SharePoint Server

  • Exercise 3: Configuring PowerPivot for SharePoint

Lab : Implementing a PerformancePoint Services

  • Exercise 1: Creating a PerformancePoint Dashboard

After completing this module, students will be able to:

  • Describe SharePoint Server as a BI platform.

  • Plan security for a SharePoint Server BI solution.

  • Plan Reporting Services configuration.

  • Plan PowerPivot configuration.

  • Plan for PerformancePoint Services.

Module 10: Monitoring and Optimizing a BI Solution

This module explains how to monitor and optimize a BI solution.

Lessons

  • Overview of BI Monitoring

  • Monitoring and Optimizing the Data Warehouse

  • Monitoring and Optimizing Analysis Services

  • Monitoring and Optimizing Reporting Services

Lab : Monitoring and Optimizing a BI Solution

  • Monitoring and Optimizing a Data Warehouse

  • Monitoring and Optimizing Analysis Services

  • Monitoring and Optimizing Reporting Services

After completing this module, students will be able to:

  • Describe key considerations for monitoring a BI solution.

  • Monitor and optimize a data warehouse.

  • Monitor and optimize SQL Server Analysis Services.

  • Monitor and optimize SQL Server Reporting Services.

Module 11: Operating a BI Solution

This module explains how to plan management and maintenance operations for a BI solution.

Lessons

  • Overview of BI Operations

  • ETL Operations

  • Data Warehouse Operations

  • Analysis Services Operations

  • Reporting Services Operations

Lab : Operating a BI Solution

  • Configuring SQL Server Integration Services

  • Automate Data Warehouse Load Tasks

  • Test Automated Operations

After completing this module, students will be able to:

  • Describe core considerations for BI operations.

  • Describe considerations and strategies for managing ETL operations.

  • Describe considerations and strategies for managing data warehouse operations.

  • Describe considerations and strategies for managing Analysis Services operations.

  • Describe considerations and strategies for managing Reporting Services operations.

 

Course Registration

 

5 days
$2,550.00

 

Course Outline

 

Request