Day 1 October 15

7:30 AM – 8:00 AM
Welcome and Registration
8:00 AM – 09:00 AM
Module 0 - Introductions and Lab Setup
9:00 AM – 09:45 AM
Module 1 - Introduction to Business Intelligence
9:45 AM – 10:30 AM
Module 2 - Preparing Data for Analytics
10:30 AM – 10:45 AM
-- BREAK --
10:45 AM – 11:15 AM
LAB 2
11:15 AM – 11:45 AM
Module 3 - Introduction to ETL Process and Techniques
11:45 AM – 12:45 PM
Module 4 - Integration Services Basics – Implementing Workflows in Microsoft SQL Server Integration Services
12:45 PM – 1:45 PM
LUNCH (Not included)
1:45 PM – 2:30 PM
LAB 4
02:30 PM – 3:00 PM
Module 5 - Advanced Features in Microsoft SQL Server Integration Services
03:00 PM – 03:30 PM
Module 6 - Processing Data using Microsoft SQL Server Integration Services
03:30 PM – 03:45 PM
-- BREAK --
03:45 PM – 05:00 PM
Module 6 - Processing Data using Microsoft SQL Server Integration Services
03:45 PM – 06:30 PM
LAB 6

Day 2 October 16th

8:00 AM – 09:30 AM
Module 7 - Introduction to Microsoft SQL Server Analysis Services
9:30 AM – 10:15 AM
LAB 7
10:15 AM – 10:30 AM
-- BREAK --
10:30 AM – 11:45 AM
Module 8 - Customizing the Cube, Dimensions and Measure Groups
11:45 AM – 12:15 PM
LAB 8
12:45 PM – 1:45 PM
LUNCH (Not included)
1:45 PM – 2:30 PM
Module 9 - Advanced Analysis Services Features
02:30 PM – 3:30 PM
Module 10 - Reporting against the UDM using SQL Server 2008 Reporting Services
03:30 PM – 03:45 PM
-- BREAK --
03:45 PM – 04:15 PM
LAB 10
04:15 PM – 05:15 PM
Module 11 - Advanced Reporting against the UDM
05:15 PM – 06:00 PM
LAB 11
06:00 PM – 06:30 PM
-- Q&A --

Introduction to Business Intelligence
We will provide a brief introduction to Business Intelligence and the need and value of Business Intelligence in an organization. We will also discuss the various components of a Business Intelligence solution and introduce the various technologies that make Business Intelligence possible.

Preparing Data for Analytics
In this topic we will cover Dimensional Modeling concepts including Fact and Dimension tables and how to implement a dimensional model within your organization. We will also address the needs for implementing dimensional models and talk about Data Warehousing and Data Marts. We will also briefly discuss processes for loading data into these dimensional tables.

Introduction to ETL Process and Techniques
This module will provide an insight into ETL processes. We will also discuss overall process planning, data discovery process, data cleansing, reference tables and staging requirements.

Integration Services Basics – Implementing Workflows in SQL Server 2008 Integration Services
Starting with an Introduction to SSIS fundamentals and the productive development tools for visually creating and debugging Integration Services packages, we will quickly dive down into the control flow element of SSIS where we will look at the different features that enable us to create workflows that form the basic framework of our ETL processes. Here you will learn about tasks, containers, variables and constraints. You will also learn about managing connections through the connection manager.

Advanced Features in Microsoft SQL Server Integration Services
Building upon the control flow features, we will look at some advanced features such as SSIS Expressions, Event Handlers and also a few important package properties that you will find useful in the development of dynamic packages.

Processing Data using Microsoft SQL Server Integration Services
One of the most exciting features of Integration Services is the Data Flow component. This is a high performance data transformation engine that can be used to implement complex transformation routines to data. The data flow component allows you to efficiently pull data from multiple data sources and load transformed data to multiple destinations in a variety of different formats. The transformation components allow you to efficiently transform this data to desired shape and error handling capabilities of the data flow can help isolate bad data for additional processing. We will look at how to implement data flows to transform our data for loading our data marts.

Introduction to Microsoft SQL Server Analysis Services
Here, we will introduce key concepts of Analysis Services and the Unified Dimensional Model (UDM) and introduce the design, development and management tools for Analysis Services. We will also see how to build our first cube, deploy it and analyze information in this cube. As we walk through the demos, we will look at Data Sources and Data Source Views and their features and also review the cube wizard. We will also discuss deployment and processing of the Analysis Services project.

Customizing the Cube, Dimensions and Measure Groups
We will look at various properties of the cube, dimensions and measure groups and understand how these properties impact analysis and user experience. We will also cover dimensional hierarchies and member properties of attributes. We will also cover the concepts of role playing dimensions and the different types of relationships between cube dimensions and measure groups.

Advanced Analysis Services Features
This topic will look at some advanced features in Analysis Services that extend the value of the information by using Calculations, defining KPI’s and adding Actions.

Reporting against the UDM Using SQL Server 2008 Reporting Services
This topic is an introduction to Reporting Services. We will see how to create reports against the UDM. We will also look at creating parameters as well as other features of Reporting services to format these reports and make them dynamic. We will also learn to deploy these reports.

Advanced Reporting against the UDM
This topic will cover some other key technologies that can be used by end-users to report against this data. We will see how to expose the UDM to end users for self service reporting using Report Builder, use pivot tables in Excel to report against the UDM and also highlight some features in Excel 2007 that make data analysis easier for the end user. Finally we will briefly discuss other technologies for reporting against the UDM including ProClarity, Excel Services and MOSS, Business Scorecard Manager and Performance Point Server.

Labs
The labs will be built on Adventure Works LT which is a scaled back version of Microsoft’s Adventure Works sample database. Using this relational database as our transactional source, we will design a data mart model for analysis, create ETL packages that will transform this data and load the data mart, design a Unified Data Model to expose this data for multi-dimensional analysis and finally report against this OLAP data store in a variety of formats. The labs are designed to give you a sense of how to apply the different Microsoft technologies to build complete BI solution. This course or labs are not intended to be a comprehensive education in implementing and using these technologies, because there are many facets of these technologies that the time constraint of this course does not permit us to go into. However, you will walk away with a very good idea on the basics of BI and these technologies that enable BI.

The cost of this 2 Days Boot Camp is 999.00$ plus taxes.

Space is limited to 35 attendees. Register early!
12 seat left (Update Oct. 1st)

In order to complete the labs, you will need a machine. Here are your options. Please read the requirements of each option carefully. If you do not have a machine ready during training, you will not be able to work on any of the labs in class.

Option 1 - Rent-a-Laptop

Rent a laptop from DevTeach. Call us if you need a laptop.