Designing Business Intelligence Solutions with Microsoft SQL Server 2016 (Course Code 20467) Overview

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2016 and other Microsoft BI technologies.

Instructor Led Learning

Duration: 5 Days
Registration Open Now!

Video Learning

Duration: 5 Days
Registration Open Now!

What you will learn

  • Plan a BI solution.
  • Plan SQL Server BI infrastructure.
  • Design a data warehouse.
  • Design an extract, transform and load (ETL) solution.
  • Design analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design a Microsoft Excel-based reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Operate a BI solution.

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • A basic understanding of dimensional modeling (star schema) for data warehouses
  •  Basic server hardware knowledge
  • 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

FULL COURSE OUTLINE

Module 1: Planning a BI Solution
This module enables students to plan the components of a BI Solution.
Lessons

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

Module 2: Planning BI Infrastructure
This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.
Lessons

  • Considerations of BI Infrastructure
  • Planning Data Warehouse Hardware

Module 3: Designing a Data Warehouse
This module describes how to design a data warehouse given a set of user requirements.
Lessons

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Design FACT tables

Module 4: Designing an ETL solution
This lesson describes how to use Power Query in Microsoft Excel to find and import data.
Lessons

  • ETL Overview
  • Planning for Data Extraction
  • Planning for Data Transformations
  • Planning for Data Loading

Module 5: Designing Analytical Data Models
This module describes how to use Power View in Microsoft Excel to create interactive data visualizations.
Lessons

  • Introduction to Power View
  • Creating Dynamic Data Visualizations

Module 6: Planning a BI Delivery Solution
This module describes how to choose an appropriate delivery solution for a given scenario.
Lessons

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

Module 7: Designing a Reporting Services Solution
This module describes how to design a reporting services solution.
Lessons

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

Module 8: Designing an Excel Based reporting Solution
In this module students will learn how to design a reporting solution using Excel.
Lessons

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

Module 9: Planning a SharePoint Server BI Solution
This module introduces the use of SharePoint Server as a BI solution.
Lessons

  • 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
At the conclusion of this module you will be able to optimize and monitor a BI solution.
Lessons

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

Module 11: Operating a BI Solution
At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.
Lessons

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

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.