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

Course Description Schedule Course Outline
 

Course Content

This course teaches students how to design and implement a BI infrastructure and helps prepare students for Microsoft Exam 70-467. The course discusses design, installation, and maintenance of a BI platform.

Who should attend

Business Intelligence professionals, Business Intelligence Architects or Database Professionals who need to design Business Intelligence solutions.

Certifications

This course is part of the following Certifications:

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.

Students who attend this training can meet the prerequisites by attending the following courses.

  • M10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • M10778: Implementing Data Models and Reports with Microsoft SQL Server 2012

Course Objectives

  • Plan the components of a BI solution.
  • Plan a BI infrastructure.
  • Design a data warehouse.
  • Design an ETL solution.
  • Plan analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design an Excel reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Plan for BI operations.

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

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
Classroom Training
Modality: G

Duration 5 days

Price
  • Canada: CAD 2,795
  • SA Voucher: 5
Dates and Booking
Online Training
Modality: U

Duration 5 days

Price
  • Canada: CAD 2,795
  • SA Voucher: 5
Dates and Booking
 
Click on town name to book Schedule
This is an Instructor-Led Classroom course
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
  *   This class is delivered by a partner.
Canada
Feb 26-Mar 2, 2018 Quebec City, QC 08:30 Canada/Eastern Course language: French * Enroll
Europe
France
May 28-Jun 1, 2018 Paris * Enroll
Italy
May 14-18, 2018 Milan Enroll
Aug 27-31, 2018 Rome Enroll
Nov 12-16, 2018 Milan Enroll
Poland
Mar 12-16, 2018 Warsaw Enroll
Sep 17-21, 2018 Warsaw Enroll
Latin America
Argentina
Aug 27-31, 2018 Online Training Time zone: America/Buenos_Aires Enroll
Chile
May 7-11, 2018 Online Training Time zone: America/Santiago Enroll
Colombia
May 21-25, 2018 Online Training Time zone: America/Bogota Enroll
Mexico
Jun 11-15, 2018 Online Training Time zone: America/Mexico_City Enroll
Peru
Nov 12-16, 2018 Online Training Time zone: America/Lima Course language: Spanish Enroll
Middle East
Qatar
Jul 22-26, 2018 Doha Course language: English Enroll
United Arab Emirates
Jul 22-26, 2018 Dubai Course language: English This course is being delivered by iTLS. Enroll
Africa
Egypt
Mar 18-22, 2018 Cairo Course language: English Enroll
Sep 16-20, 2018 Cairo Course language: English Enroll