Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2

Describe the ways in which SQL Server 2008 R2 and SharePoint 2010 can be integrated to create a comprehensive self-service BI platform.

Identify the options available for data warehousing with SQL Server and describe the key features of SQL Server 2008 R2 Parallel Data Warehouse.

This module introduces PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010 and describe how they can be used to empower business users to create their own business analyses by using familiar tools.

Introduction to PowerPivot

Power Pivot for Excel 2010

Data Analysis Expressions (DAX)

Power Pivot for SharePoint 2010

Using PowerPivot for Excel 2010

Using PowerPivot for SharePoint

After completing this module, students will be able to:

Install and configure PowerPivot for Excel and PowerPivot for SharePoint.

Use PowerPivot for Excel to create a PowerPivot workbook.

Use Data Analysis Expressions to build formulas in PowerPivot.

Use PowerPivot for SharePoint to manage PowerPivot workbooks.

This module describes the enhancements to Reporting Services tools and APIs in SQL Server 2008 R2 (enhanced reporting functionality is covered in the next module; this module is specifically focused on changes to the management and development tools and APIs).

Deploying and Managing Reporting Services

Reporting Services Authoring Tool Enhancements

Enabling Self-Service BI Through Item Re-Use

Developing Custom Reporting Services Solutions

Viewing and Managing Reports

Using Report Builder 3.0

Working with Shared Datasets and Report Parts

After completing this module, students will be able to:

Use the enhanced Reporting Services management tools

Use the enhanced Reporting Services authoring tools

Collaborate with other report developers by using shared datasets and report parts

Use the enhanced Reporting Services development APIs

This module describes the enhancements to Reporting Services in SQL Server 2008 R2.

Overview of Report Authoring Enhancements

Visualizing Data

Visualizing Spatial Data with Maps

Using Lookups

Paginating Reports

Visualizing Data with Databars and Sparklines

Visualizing Data with Indicators

Visualizing Spatial Data

After completing this module, students will be able to:

Use new features to create reports that include rotated text boxes, linked data from multiple datasets, include rollup aggregations, and custom pagination behavior.

Create reports that include graphic visualizations of data with Sparklines, Data Bars, and Indicators.

Create reports that include visualizations of spatial data.

This module introduces StreamInsight with an emphasis on its use to enable analytical solutions for real-time streams of data.

Introduction to StreamInsight

StreamInsight Core Concepts

Developing a StreamInsight Solution

Creating a StreamInsight Application

Using Filters and Aggregates

Using the StreamInsight Debugger

After completing this module, students will be able to:

Describe scenarios where Complex Event Processing can be used effectively

Describe the core concepts related to Microsoft StreamInsight.

Create a basic StreamInsight application

This module introduces Master Data Services with an emphasis on its use to enable data consistency across the enterprise to help increase the accuracy of BI solutions.

Introduction to MDS

Key Concepts in Master Data Services

Importing and Browsing Data

Business Rules

Exporting Data to Subscribing Systems

Securing Master Data Services

Installing and Configuring Master Data Services

Creating Master Data Services Objects

Importing Data from a Source System

Creating a Business Rule

Exporting Data to a Subscribing System

After completing this module, students will be able to:

Describe the key scenarios and benefits of MDS

Describe core MDS concepts

Import data into MDS

Implement MDS Business Rules

Export MDS data

Secure MDS

This module introduces SQL Azure and cloud-based data solutions.

Overview of SQL Azure and Cloud Services

Using SQL Azure

Introduction to “Dallas”

After completing this module, students will be able to:

Identify suitable scenarios for cloud-based data solutions

Use SQL Azure for cloud-based data storage

Use the Dallas cloud-data service

This module introduces new and enhanced manageability features in SQL Server 2008 R2.

Database Server Provisioning by Using SQL Server SysPrep

Application Management by Using Data-Tier Applications

Managing Multiple Servers by Using Utility Control Points

Working with Data-Tier Applications

Managing Multiple Servers with a UCP

After completing this module, students will be able to:

Use SQL Server SysyPrep to provision database and reporting servers

Use data-tier applications to manage BI databases

Use Utility Control Points to manage BI database server resource utilization