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

Days: 5 day
Price: $2995

Course Details

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.

Course Agenda

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