Designing Business Intelligence Solutions with Microsoft SQL Server 2014 Overview

The course discusses design, installation, and maintenance of a BI platform

Apply Today

Instructor Led Learning

Duration: 5 Days
Registration Open Now!

Video Learning

Duration: 5 Days
Registration Open Now!

  • Lesson 1 : Planning a BI Solution
  • Lesson 2 : Planning SQL Server Business Intelligence Infrastructure
  • Lesson 3 : Designing a Data Warehouse
  • Lesson 4 : Designing an ETL Solution
  • Lesson 5 : Designing Analytical Data Models
  • Lesson 6 : Planning a BI Delivery Solution
  • Lesson 7 : Designing a Reporting Services Solution
  • Lesson 8 : Designing a Microsoft Excel-Based Reporting Solution
  • Lesson 9: Planning a SharePoint Server BI Solution
  • Lesson 10 : Monitoring and Optimizing a BI Solution
  • Lesson 11 : Operating a BI Solution
BI professional skills such as BI Architect

Database professional skills

Lesson 1: Planning a BI Solution

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

Lesson 2: Planning SQL Server Business Intelligence Infrastructure

  • Considerations for BI Infrastructure
  • Planning Data Warehouse Hardware
  • Lab : Planning a BI Infrastructure

Lesson 3: Designing a Data Warehouse

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Designing Fact Tables
  • Designing a Data Warehouse Physical Implementation
  • Lab : Designing a Data Warehouse Logical Schema
  • Lab : Designing a Data Warehouse Physical Implementation

Lesson 4:Designing an ETL Solution

  • ETL Overview
  • Planning Data Extraction
  • Planning Data Transformation
  • Planning Data Loads
  • Lab : Designing an ETL Solution

Lesson 5:Designing Analytical Data Models

  • Introduction to Analytical Data Models
  • Designing an Analytical Data Model
  • Designing Dimensions
  • Enhancing Data Models
  • Lab : Comparing Analytical Data Models
  • Lab : Designing Dimensions and Hierarchies
  • Lab : Enhancing Analytical Data Models

Lesson 6: Planning a BI Delivery Solution

  • Considerations for Delivering BI
  • Common Reporting Scenarios
  • Choosing a Reporting Tool
  • Lab : Planning a BI Delivery Solution

Lesson 7:Designing a Reporting Services Solution

  • Planning a Reporting Services Solution
  • Designing Reports
  • Planning Report Consistency
  • Lab : Designing a Reporting Services Solution

Lesson 8: Designing a Microsoft Excel-Based Reporting Solution

  • PowerPivot for Excel
  • Power View for Excel
  • Lab : Designing an Excel Reporting Solutionl

Lesson 9:Lab : Designing an Excel Reporting Solution

  • Introduction to SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning Reporting Services Configuration
  • Planning for PerformancePoint Services
  • Lab : Implementing a SharePoint Server BI Solution
  • Lab : Implementing a PerformancePoint Services

Lesson 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 Service
  • Lab : Monitoring and Optimizing a BI Solution

Lesson 11: Operating a BI Solution

  • Overview of BI Operations
  • ETL Operationsn
  • Data Warehouse Operations
  • Analysis Services Operations
  • Reporting Services Operations
  • Lab : Operating a BI Solution

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

Become Part of MasterGrade IT to Further Your Career.