"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

20467D:Designing Business Intelligence Solutions with Microsoft SQL Server 2014

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.


20467D: Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Module 1: Planning a BI Solution

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

Module 2: Planning SQL Server Business Intelligence Infrastructure

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

Module 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

Module 4: Designing an ETL Solution

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

Module 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

Module 6: Planning a BI Delivery Solution

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

Module 7: Designing a Reporting Services Solution

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

Module 8: Designing a Microsoft Excel-Based Reporting Solution

  • Using Excel for Data Analysis and Reporting
  • PowerPivot for Excel
  • Power View for Excel
  • Lab : Designing an Excel Reporting Solution

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 for PerformancePoint Services
  • Lab : Implementing a SharePoint Server BI Solution
  • Lab : Implementing a 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 Service
  • Lab : Monitoring and Optimizing a BI Solution

Module 11: Operating a BI Solution

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

Duration:

Learning Materials:

Prerequisites:

What course next:

5 Days

All included

Get a Quote today »

 

Course Content
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
   • Planning a BI Delivery Solution
   • Designing a Reporting Services Solution
   • Designing a Microsoft Excel-Based Reporting Solution
     Planning a SharePoint Server BI Solution
   • Monitoring and Optimizing a BI Solution
   • Operating a BI Solution

 

Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.

Name

Email

Phone

Location

Message


Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

Shaun2.jpg
- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

zaheer1.jpg
- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

rene1.jpg
- René Leandro Borges

I enjoyed doing the course in my own time!

sadia.jpg
- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup

Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.