Report Builder and PerformancePoint 2010 Combo Pack

This module introduces the interface of Report Builder 3.0, the different features available, and variances in data sources and sets.

Plan Your Reports

The Interface

Variances Between SQL Versions

How to Use Report Builder 3.0 with SQL Express 2012

Data Sources

Datasets

Explore Report Builder 3.0

Create Embedded Data Sources and Sets

Create Shared Data Sources and Sets

After completing this module, students will be able to:

Plan the reports.

Use Report Builder 3.0 and understand the parts of the interface.

Launch Report Builder 3.0 from multiple sources.

Create embedded and shared data sources and datasets.

This module explains the wizards.

Explore the Report Builder 3.0 Wizards

Create Reports with the Wizards

Report Builder 3.0 Wizards

After completing this module, students will be able to:

Use the wizards to create reports.

This module covers report basics with lists, matrix, and tables, then goes into parameters and the expresionable aspect of reports.

Report Lists

Report Tables

Report Matrix

The Data Region

Report Parameters

Report Expressions

Formatting Reports

Create a Report Using a List

Create a Report Using a Table

Create a Report Using a Matrix

Create a Report Using Multiple Data Regions

Use Report Parameters

Use Report Expressions

Format the Report

Save Report Parts for Reuse

After completing this module, students will be able to:

Create a report using a list.

Create a report using a table.

Create a report using a matrix.

Create a report using multiple data regions.

Use report parameters.

Use report expressions.

Format the report.

This module is a detailed look at graphics including embedded and Bing maps.

Report Charts

Report Images

Report Sparklines

Report Data Bars

Report Gauges

Report Maps

Create a Report with Charts

Create a Report with Images

Create a Report with Sparklines

Create a Report with Data Bars

Create a Report with Gauges

Create a Report with Maps

After completing this module, students will be able to:

Create a report with charts.

Create a report with images.

Create a report with sparklines.

Create a report with data bars.

Create a report with maps.

Create a report with gauges.

This module covers intermediate reporting with emphasis on actionable reports.

Time Intelligence

Drill Through

Subreports

Interacting with Actionable Reports

Reuse Report Parts

Create Subreports

Use Drill Through

Create a Report That Allows Interaction

Reuse Report Parts

Use Time Intelligence

After completing this module, students will be able to:

Create subreports.

Use drill through.

Create a report that allows interaction.

Reuse Report Parts.

Use Time Intelligence.

This module is a collection of how-to with examples.

This module is a collection of how-to with examples.

After completing this module, students will be able to:

Use the tips and tricks.

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

SQL 2008 R2 Business Intelligence Platform

SQL Analysis Services

SQL Reporting Services

Performance Management Tools

SharePoint 2010

Multidimensional Space

MDX

Data Mining

Understanding the Terminology

Explore Business Intelligence Development Studio

Connect into a SQL Server Analysis Services Cube

Use SQL Server Management Studio

Explore SharePoint 2010

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Integration with SharePoint Server 2010

Integration with SharePoint Server 2010

New PerformancePoint Features

Storage Security

Time Intelligence and Dynamic Filters

Linking of Web Parts

KPI Details Report

KPI Details Report

Use SharePoint to Create a Site Collection

Configure Central Administration for PerformancePoint Services

Create and Explore a PerformancePoint Business Intelligence Center

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

What is a Dashboard?

What is a Scorecard?

Scorecards in PPS

KPI Collections

Dashboard Design Guidelines

Dashboards Designed to Monitor

Dashboards Designed to Analyze

Dashboards Designed as Management Views Such as Six Sigma

Paper Lab

Design Each of the Three Categories of Dashboards

Group Review

Design Your Company Dashboard

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Dashboard Designer Internals

Dashboard Designer Interface

First-Class Objects

Main Window

Properties

Dashboard Designer Features

Create a Data Connection

Create a Basic Dashboard

Deploy the Dashboard

Explore the Dashboard in PPS

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Data Sources

Multidimensional

Multidimensional

Specific Sources

SSAS

Excel

SharePoint List

Time Intelligence

Create a New Business Intelligence Site for Lab as a Subsite

Create a SQL Server Analysis Services Connection and Use It as a Source

Create a Data Connection Using Excel Services

Create a Data Source Using Import Workbook

Connect into a Tabular SharePoint List as a Data Source

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Visual Indicators

Categorizing Indicators

Performance Measures

KPI Characteristics

KPI Details

KPI Templates

Formatting Numbers

Data Mappings

Calculation Metrics

Scoring Patterns

Banding Methods

KPI Details Report

Best Practices

Visual Indicators and Key Performance Indicators

Create Several KPIs

Create a Basic Scorecard to Host Your KPIs

Utilize a Cube as a Data Source

Create an Objective KPI

Create a Multivalued KPI

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Types of Reports

Analytic Chart

Analytic Grid

Excel Services

ProClarity Analytics

SQL Server Reporting Services

Filters

Filtering

Provider and Consumer

Member Selection

Named Set

STPS to MDX

Post Formula

Create an Analytic Grid

Create a Member Selection Filter

Create an Analytic Chart

Create a Strategy Map

Create a Time Intelligence Filter

Use Time Intelligence in a Report

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Three Categories

SSAS Template

Standard Template

Tabular Scorecards

Data Sources

Implementing Interactivity

Display Values

Using Filters

Using Filters

Create a KPI for Use in Lab

Add a Dimension Filter

Wire-Up Filters

Compare the Effects of Filtering

Change Scorecard Settings

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues

This module explains how to name, declare, assign values to, and use variables. It also describes how to store data in an array. (e.g. This module explains how to install, upgrade and migrate to Windows 7. It also describes the key features, editions, and hardware requirements of Windows 7)

Dashboard Hierarchy

Dashboard Variance

Dynamic Dashboards

Dashboard Interactivity

Develop Multiple Dashboards

Change Deployed Dashboards

Provide Interactive Help for Your Dashboards

Monitor Dashboard Utilization

Control Dashboard Updates

After completing this module, students will be able to:

Describe the key features, editions, and hardware requirements of Windows 7.

Perform a clean installation of Windows 7

Upgrade and Migrate to Windows 7 from an earlier version of Windows.

Perform an image-based installation of Windows 7

Resolve common application compatibility issues