> > > 20467 Detailed outline

Designing Business Intelligence Solutions with Microsoft SQL Server (20467)

Course Description Schedule Course Outline

Detailed Course Outline

Module 1: Planning a BI Solution
This modules discusses how to plan the components of a BI solution.

Lessons

  • Elements of a BI Solution
  • Planning a BI Project
  • The Microsoft BI Platform

Lab : Planning a BI Solution

  • Exercise 1: Scoping a BI Solution.
  • Exercise 2: Reviewing a Suggested Solution

Module 2: Planning a BI Infrastructure
This modules explains how to plan an appropriate BI infrastructure for a given set of BI services.

Lessons

  • Planning a Data Warehouse Infrastructure
  • Planning an ETL Infrastructure
  • Planning Analysis Services Infrastructure
  • Planning Reporting Services Infrastructure

Lab : Planning a BI Infrastructure

  • Exercise 1: Determining Required Servers
  • Exercise 2: Determining Data Warehouse Server Hardware Requirements
  • Exercise 3: Reviewing a Suggested Solution

Module 3: Designing a Data Warehouse
This module explain how to design a data warehouse for a given set of user requirements.

Lessons

  • Designing a Logical Schema
  • Designing a Physical Schema

Lab : Designing a Data Warehouse Logical Schema

  • Exercise 1: Identifying Required Dimensions
  • Exercise 2: Identifying Measures and Hierarchies
  • Exercise 3: Designing a Data Warehouse Schema
  • Exercise 4: Reviewing a Suggested Solution

Module 4: Designing an ETL Solution
This module explains how to design an ETL solution for a data warehouse.

Lessons

  • Planning for Data Extraction
  • Planning for Data Transformation
  • Planning for Data Loading
  • Planning for SSIS Package Deployment

Lab : Designing an ETL Solution

  • Exercise 1: Reviewing Data Sources
  • Exercise 2: Creating Source-to-Target Maps
  • Exercise 3: Planning ETL Processes
  • Exercise 4: Reviewing a Suggested Solution

Module 5: Designing Analytical Data Models
This module explains how to design analytical data models for specific BI scenarios.

Lessons

  • Options for Analytical Models
  • Data Model Design Considerations

Lab : Comparing Analytical Data Models

  • Exercise 1: Creating a Multidimensional Model
  • Exercise 2: Creating a Tabular 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 BI Delivery
  • Choosing a Delivery Approach

Lab : Planning a BI Delivery Solution

  • Exercise 1: Assessing Reporting Requirements

Module 7: Designing a Reporting Services Solution
This module explains how to design a Reporting Services solution.

Lessons

  • Designing Reports
  • Considerations for Report Execution
  • Planning a Reporting Solution

Lab : Designing a Reporting Services Solution

  • Exercise 1: Planning a Reporting Services Solution
  • Exercise 2: Planning a Report Delivery Environment
  • Exercise 3: Configuring Report Execution

Module 8: Designing an Excel-Based Reporting Solution
This module explains how to design a reporting solution that uses Excel.

Lessons

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

Lab : Designing an Excel Reporting Solution

  • Exercise 1: Planning Excel Features
  • Exercise 2: Analyzing a Cube with Excel
  • Exercise 3: Using PowerPivot
  • Exercise 4: Using Power View

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 : Planning a SharePoint Server BI Solution

  • Exercise 1: Planning SharePoint Server Security
  • Exercise 2: Configuring Reporting Services in SharePoint Server
  • Exercise 3: Managing PowerPivot Data Refresh
  • Exercise 4: Reviewing PowerPivot Activity
  • Exercise 5 (Optional) 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

  • Exercise 1: Monitoring and Optimizing a Data Warehouse
  • Exercise 2: Troubleshooting Analysis Services Queries
  • Exercise 3: Monitoring and Optimizing Reporting Services

Module 11: Planning BI Operations
This module explains how to plan management and maintenance operations for a BI solution.

Lessons

  • Overview of BI Operations
  • Automating ETL Tasks
  • Post ETL Tasks
  • Planning a Backup Strategy for a BI Solution

Lab : Planning BI Operations

  • Exercise 1: Planning ETL and Processing Tasks
  • Exercise 2: Planning a Backup Strategy
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!