This module provides an introduction to new and enhanced features in SQL Server 2012 Reporting Services.

Lessons

Reporting Services Overview

Reporting Services and Microsoft SharePoint Server

Introduction to Data Alerts

Lab : Using SQL Server 2012 Reporting Services

Viewing SharePoint Mode Configuration

Authoring, Publishing, and Viewing a Report

Creating and Managing Data Alerts

Module 6: Creating Tabular Data Models with PowerPivot

This module provides an introduction to new and enhanced features in PowerPivot.

Lessons

Introduction to Tabular Data Models and PowerPivot Technologies

Using PowerPivot

Using DAX in a PowerPivot Data Model

Lab : Using PowerPivot for Excel

Creating a Tabular Data Model by Using PowerPivot for Excel

Using a Tabular Data Model in Excel

Sharing a PowerPivot Workbook to PowerPivot Gallery

Lab : Creating Calculated Columns and Measures

Creating Calculated Columns

Creating Measures

Module 7: Implementing an Analysis Services Tabular Data Model

This module describes how to create tabular Analysis Services databases.

Lessons

Introduction to Analysis Services Tabular Data Model Projects

Developing an Analysis Services Tabular Data Model

Lab : Working with an Analysis Services Tabular Data Model

Creating an Analysis Services Tabular Data Model Project

Implementing a Perspective

Implementing Partitions

Deploying an Analysis Services Tabular Data Model

Using a Tabular Data Model

Configuring DirectQuery Storage Mode

Implementing Security in a Tabular Data Model

Module 8: Creating Data Visualizations with Power View

This module provides an introduction to Power View, and describes how it can be used to create interactive data visualizations.

Lessons

Introduction to Power View

Visualizing Data with Power View

Lab : Creating Interactive Reports with Power View

Configuring a Tabular Data Model for Power View

Creating a Simple Power View Report

Using Interactive Visualizations

Creating a Scatter Chart and a Play Axis

Exporting a Power View Report to PowerPoint

Module 9: Using Cloud Technologies in a BI Solution

This module introduces Microsoft cloud technologies that can be used in a BI solution.

Lessons

Overview of Cloud Data Sources

SQL Azure

SQL Azure Reporting Services

The Windows Azure Marketplace DataMarket

Lab : Using Cloud Data in a BI Solution

Creating a SQL Azure Solution

Extracting Data from SQL Azure

Obtaining Data from the Windows Azure Marketplace DataMarket

This course may be available for you to purchase through the Microsoft Software Assurance voucher scheme. To book courses using vouchers please call our sales team on 0345 757 3888. Or for more information on claiming vouchers you can speak to our dedicated Software Assurance administration team on 01753 898 351.