The Microsoft Business Intelligence 2010 Stack

• Connect into a SQL Server Analysis Services Cube

• Use SQL Server Management Studio

• Explore SharePoint 2010

• UDM Defined

• User Experience: Relational vs. UDM

• Advantages

• Trouble in River City

• Creating a Data Mart using Business Intelligence Development Studio.

• Enabling Table Compression

• Major Components

• New or Changed Features

• Script Task

• SSIS and ETL

• Transformers

• Best Practices 1

• Best Practices 2

• Create A SSIS Project

• Add a Data Source

• Create A Data Flow

• Create Another Data Flow

• Load Data via a SQL Statement

• Populating the Fact Table

• Loading Manufacturing Facts

• Handling Errors

• Inventory Fact Flow

• Key Concepts

• Schemas

• Measures

• Dimensions

• Cube Processing

• Partitions

• Proactive Caching

• Aggregations

• Define an OLAP Cube

• Working with Measures and Measure Groups

• Time and Hierarchies

• Relating Dimensions

• Build Deploy and Browse the Cube

• Multiple Partitions

• Set Storage

• Design Aggregations

• Default Members

• Integration with SharePoint

• Report Builder 3.0

• Differences Between Environments

• Tablix

• Charts

• SSRS Projects Report Wizard

• Report Builder 3.0

• Creating Charts

• What is MDX?

• MDX Query Editor

• Select Statement

• Key Concepts

• Sets

• Functions

• Time Intelligence

• Understand the Cell

• Write a Tuple

• MDX Sets

• Write a SELECT statement

• Write a Function

• Implement Time

• Integration with SharePoint Server 2010

• Common Service Application Framework

• New PerformancePoint Features

• Storage Security

• Time Intelligence and Dynamic Filters

• Linking of Web Parts

• KPI Details Report

• Retired Features

• Scorecards in PPS

• KPI Collections

• Dashboard Design Guidelines

• Dashboard Designer Internals

• Dashboard Designer Interface

• First Class Objects

• Main Window

• Properties

• Dashboard Designer Features

• Use SharePoint to create a site collection

• Configure Central Administration for PerformancePoint Services

• Create and Explore a PerformancePoint Business Intelligence Center

• Create a Basic Dashboard

• Deploy the Dashboard

• Explore the Dashboard in PPS

• Integration with SharePoint Server 2010

• Storage Security

• Single version of the truth

• Excel Web Services

• New capabilities in Excell Services

• Business Connectivity Services

• Deploy a Excel spread sheet for a single version of the truth

• Utilize Excel Web Services

• Business Connectivity Services

• Integration with SharePoint Server 2010

• Understanding Modeling

• Explore Excel PowerPivot

• Key Terms in Data Mining

• Types of Data Mining Algorithms

• The Algorithm

• Excel and The BI Extensions

• Visio 2010

• Utilize the Excel Data Mining Tools