:: NOVEDEA TRAINING ::

Home

About us

Courses

Corporate Training

Schedule

Registration

Courses - Microsoft

Microsoft - BI Bootcamp

This 4 day, instructor-led training course provides students with the knowledge and skills necessary to begin designing and developing Business Intelligence solutions using Microsoft BI Stack The bootcamp will empower developers to exploit the BI functionality in the following technologies:

SQL Server 2005 Database Services

SQL Server 2005 Integration Services

SQL Server 2005 Reporting Services

SQL Server 2005 Analysis Services (OLAP)

Course Pre-requisites
Basic understanding of SQL and relational database technology

Course Objectives

Through interactive presentations and concrete hands-on labs, attendees will learn:

How to use Microsoft SQL Server 2005 to build and manage data marts.

How to build data warehouse using SQL Server 2005 Integration Services to extract, transform, and load information into SQL Server 2005 databases.

How to use SQL Server 2005 Reporting Services to develop predefined and ad hoc relational reports.

How to use SQL Server 2005 Analysis Services to create a dimensional model that provides business analytics.

Course Topics

Day 1

Module 1 - Microsoft BI Strategy Overview

Defining Business Intelligence (BI)

Introducing the Microsoft BI Platform

Introducing the BI Developer’s Toolset

Introducing SampleData Company

Module 2 - Introduction to Dimensional Modeling Techniques

Designing the Dimensional Model

Introducing Additional Design Concepts

Lab 02A - Database Modeling

Module 3 - Introduction to ETL Techniques Using SSIS

Reviewing ETL Fundamentals

Introducing SSIS Components

Designing ETL Packages

Lab 03A - Control Flow

Lab 03B - Data Flow

Day 2

Module 4 - Advanced SSIS

Advanced Data Flow

Manageability Features

Programmability

Lab 04A - Slowly Changing Dimensions

Module 5 - Introduction to SSRS

Reporting Fundamentals

Introducing Reporting Services (SSRS)

Basic SSRS Report Design

Lab 05A - Creating Managed Reports

Module 6 - Advanced SSRS

Introducing Report Interactivity

Extending Reports with Custom Logic

Optimizing Report Execution

Managing the Report Server with Utilities

Lab 06A - Advanced Managed Reports

Lab 06B - Advanced SSRS Features

Day 3

Module 7 - Designing a Report Model for ad hoc Reporting

Introducing Report Builder

Reviewing Report Models

Creating Reports with Report Builder

Lab 07A - Report Builder

Module 8 - Publishing and Accessing Reports Using SSRS

Reviewing Report Deployment Options

Accessing Reports in SSRS

Accessing Reports Programmatically

Embedding Reports in .NET Applications

Lab 08A - Programmatic Report Deployment

Lab 08B - Using the ReportViewer Control

Day 4

Module 9 - Introduction to the UDM

Reviewing OLAP Fundamentals

Understanding Database Components

Performance Tuning

Programming SSAS

Lab 09A - Building a Basic Cube

Lab 09B - Working with Dimensions

Lab 09C - Calculations, KPIs and Actions

Lab 09D - Dimension and Cube Processing

Lab 09E - Cube Deployment

Module 10 - Accessing the UDM from SSRS and Excel Services

Accessing the UDM from SSRS

Accessing the UDM from Excel 2007

Lab 10A - UDM Reporting

Lab 10B - UDM Reporting

Current Schedule

Course	Date
PMP	Apr 5th
Microsoft BI	Apr 5th
Datawarehousing	Apr 5th
Business Analyst	Apr 5th
Microsoft SQL Server	Apr 11th
Microsoft SQL Server DBA	Apr 11th
Linux	Apr 25th
Basic Java	Apr 11th
Advanced Java/J2EE	Apr 11th
Microsoft .NET	Apr 18th