Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (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

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

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 Business Intelligence Solutions with Microsoft SQL Server 2014 (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
  • United States: US$ 2,895
  • SA Voucher: 5
    hardcoded default SA
Enroll now
Online Training
Modality: U

Duration 5 days

Price
  • United States: US$ 2,895
  • SA Voucher: 5
    hardcoded default SA
Enroll now
 
Click City Name To Book Schedule
This is an Instructor-Led Classroom course
This is an Instructor-Led Online (ILO) course. These sessions are conducted via WebEx in a VoIP environment and require an Internet Connection and headset with microphone connected to your computer or laptop.
United States

Currently there are no training dates scheduled for this course.  You can schedule a private, onsite training session or request a public date by emailing info@fastlaneus.com.

Europe
Italy
May 27-31, 2019 Rome Enroll
Sep 9-13, 2019 Milan Enroll
Dec 2-6, 2019 Rome Enroll
Latin America
Argentina
Nov 4-8, 2019 Online Training Time zone: America/Buenos_Aires Enroll
Brazil
May 13-17, 2019 Online Training Time zone: America/Sao_Paulo Enroll
Nov 4-8, 2019 Online Training Time zone: America/Sao_Paulo Enroll
Chile
May 13-17, 2019 Online Training Time zone: America/Santiago Enroll
Costa Rica
Nov 4-8, 2019 Online Training Time zone: America/Costa_Rica Enroll
Mexico
May 13-17, 2019 Online Training Time zone: America/Mexico_City Enroll
Nov 4-8, 2019 Online Training Time zone: America/Mexico_City Enroll
Peru
Aug 5-9, 2019 Online Training Time zone: America/Lima Course language: Spanish Enroll
Middle East
Qatar
Jul 7-11, 2019 Doha Course language: English Enroll
United Arab Emirates
Apr 14-18, 2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
Jul 7-11, 2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
Oct 13-17, 2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
Africa
Egypt
Apr 14-18, 2019 Cairo Course language: English Enroll
Jul 7-11, 2019 Cairo Course language: English Enroll
Oct 13-17, 2019 Cairo Course language: English Enroll