Microsoft Business Intelligence End to End with SQL Server 2008 R2 and SharePoint 2010 — A 5 day course

contact usEnquire about this course
Retired Course; no longer available

Synopsis

Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server 2008 R2 Integration Services, Analysis Services, Reporting Services, PerformancePoint Monitoring/Analytics and ProClarity.

Suitable For

This workshop style course is designed for IT professionals who are interested in learning how to implement Business Intelligence solutions on the Microsoft BI Stack. Basic knowledge of common business requirements for a BI solution is assumed and some experience with SQL Server is required.

Prerequisites

Before attending this course, students must:

Basic knowledge of Business Intelligence

Knowledge of relational database systems

Delegates will gain the most from this course if they are experienced with SQL Server database to the level of Microsoft course M2779 or M6232. However, as minimum requirement, delegates should have a good working knowledge of T-SQL to level of M50027 or M2778

Schedule

This course has been retired and is no longer available.


Contents

Business Intelligence Overview

This module will introduce the course concepts and the Microsoft Business Intelligence stack (Line-of-business -> SSIS -> Data Warehouse -> SSAS -> SSRS / ProClarity / PerformancePoint / SharePoint). Includes a discussion of the BI burger.

Define terms and products

Evaluating BI requirements

Documenting requirements

Demonstrations

Labs

Three business requirements that the delegates need to identify which Microsoft products are needed to fulfil requirement

Designing Business Intelligence Solution

Reviewing requirements

Discuss whether to use a staging database

Discuss use of slowly changing dimensions (SCD)

Introduce temporal / rapidly changing dimensions (RCD) Discuss use of surrogate keys

Discuss data warehousing techniques Discuss timely delivery of data from source to destination (daily, hourly, real-time)

Discuss data warehouse schema design with advantages and disadvantages

Discuss designing a time dimension

References

Demonstrations

Labs

Creating the Data Warehouse

Table design

Index considerations

References

Demonstrations

Labs

Loading the Data Warehouse

SSIS basics

Configurations

Logging

Lookups

Fast-load and table partitioning

Using switch and merge

Late arriving data

Change Data Capture (CDC - SQL 2008 sources only)

Package design

Transactions

Checkpoints

Demonstrations - SSIS package basics

Labs

Creating the Analysis Cube

Data source views

Dimensions

Dimension Attributes

Measures

Cubes

Best practice warnings

Demonstrations

Labs

Enhancing the Analysis cube

Cubes

Demonstrations

Labs

Producing the User Interface

Best Tool for the job

Infrastructure design

Where to use SSRS , PAS, PerformancePoint

Creating reports with Reporting Services

Show differences between BIDS and Report Builder 2.

Creating a report

Tools

Related reports

Parameters

Deploying

References

Demonstrations

Labs

Creating dashboards with Excel PowerPivot

Describe positioning of Microsoft PowerPivot

Designing pages

Saving and publishing PowerPivot views

Introduce slicers

References

Demonstrations

Labs

Creating dashboards with PerformancePoint Services

Dashboard design best practice

Data Sources

Reports

Dashboard

References

Demonstrations

Labs