Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Apply now for our 20467D:Designing Business Intelligence Solutions with Microsoft SQL Server 2014



 
  • Planning a BI Solution
  • Planning SQL Server Business Intelligence Infrastructure
  • Designing a Data Warehouse
  • Designing an ETL Solution
  • Designing Analytical Data Models

 

Course Details and Pricing


Instructor Led Learning


  Duration: 5 Days

  Registration Open Now!

Video Learning


  Duration: 5 Days

  Registration Open Now!

Call us : 021 419 3213

Windows 7 overview

Designing Business Intelligence Solutions with Microsoft SQL Server 2014 Overview


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

Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Who should attend ?


This course is intended for BI professionals such as BI Architects or database professionals who need to design BI solutions. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use.

Designing Business Intelligence Solutions with Microsoft SQL Server 2014 Course cape town south africa

About This Course

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 2014 and other Microsoft BI technologies.

3 Steps to Master Designing Business Intelligence Solutions with Microsoft SQL Server 2014

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Designing Business Intelligence Solutions with Microsoft SQL Server 2014 Training Course

  • Course Overview Full course outline
    • 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

Full course outline
Designing Business Intelligence Solutions with Microsoft SQL Server 2014

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