Training

Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (M20467)

Description: 

Prerequisites

  • A basic understanding of dimensional modeling (star schema) for data warehouses
  • The ability to create Integration Services packages that include control flows and data flows
  • The ability to create a basic multidimensional cube with Analysis Services
  • The ability to create a basic tabular model with PowerPivot and Analysis Services
  • The ability to create Reporting Services reports with Report Designer
  • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
  • Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel

Related Certifications

Course Brief

In this course, you will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2014. You’ll learn to design a data warehouse and Business Intelligence solutions including: ETL, BI Delivery, Reporting Services, Excel Reporting, SharePoint Server BI along with how to monitor and optimize a BI solution.

 Course Outline

1. Plan a BI Solution

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

2. Plan SQL Server Business Intelligence Infrastructure

  • Considerations for BI Infrastructure
  • Plan Data Warehouse Hardware

3. Design a Data Warehouse

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

4. Design an ETL Solution

  • ETL Overview
  • Plan  Data Extraction, Transformation, and Loads

5. Design Analytical Data Models

  • Introduction to Analytical Data Models
  • Design an Analytical Data Model
  • Design Dimensions
  • Enhance Data Models

6. Plan a BI Delivery Solution

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

7. Design a Reporting Services Solution

  • Plan a Reporting Services Solution
  • Design Reports
  • Plan Report Consistency

8. Design a Microsoft Excel-Based Reporting Solution

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

9. Plan a SharePoint Server BI Solution

  • Introduction to 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

10. Monitoring and Optimizing a BI Solution

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

11. Operate a BI Solution

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

 

 

  Subsidiaries of Totheburn Trading