Course Content
Course 20467B
MCSE: 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012
5 Days
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
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
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
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
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
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
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
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
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
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
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