> > > 20467 Detailed outline

Designing Self-Service Business Intelligence and Big Data Solutions (20467)

Course Description Schedule Course Outline

Detailed Course Outline

Module 1: Planning a BI Solution

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

Module 2: Planning SQL Server Business Intelligence Infrastructure

  • Considerations for BI Infrastructure
  • Planning Data Warehouse Hardware

Module 3: Designing a Data Warehouse

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Designing Fact Tables
  • Designing a Data Warehouse Physical Implementation

Module 4: Designing an ETL Solution

  • ETL Overview
  • Planning Data Extraction
  • Planning Data Transformation
  • Planning Data Loads

Module 5: Designing Analytical Data Models

  • Introduction to Analytical Data Models
  • Designing an Analytical Data Model
  • Designing Dimensions
  • Enhancing Data Models

Module 6: Planning a BI Delivery Solution

  • Considerations for Delivering BI
  • Common Reporting Scenarios
  • Choosing a Reporting Tool

Module 7: Designing a Reporting Services Solution

  • Planning a Reporting Services Solution
  • Designing Reports
  • Planning Report Consistency

Module 8: Designing a Microsoft Excel-Based Reporting Solution

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

Module 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

Module 10: Monitoring and Optimizing a BI Solution

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

Module 11: Operating a BI Solution

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

Labs

  • Planning a BI Solution
  • Planning a BI Infrastructure
  • Designing a Data Warehouse Logical Schema
  • Designing a Data Warehouse Physical Implementation
  • Designing an ETL Solution
  • Comparing Analytical Data Models
  • Designing Dimensions and Hierarchies
  • Enhancing Analytical Data Models
  • Planning a BI Delivery Solution
  • Designing a Reporting Services Solution
  • Designing an Excel Reporting Solution
  • Implementing a SharePoint Server BI Solution
  • Implementing a PerformancePoint Services
  • Monitoring and Optimizing a BI Solution
  • Operating a BI Solution
 

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!