M40009 - Updating your Business Intelligence Skills to Microsoft SQL Server 2012 — A 3 day course

contact usEnquire about this course

Synopsis

This three-day instructor-led Microsoft M40009 course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.

Objectives

On completion of the Microsoft MS40009 training course, delegates should be able to:

Contents

Introduction to SQL Server 2012 for Business Intelligence

This module provides an overview of how SQL Server 2012 can be used to build BI solutions.

New and Enhanced Features in SQL Server Integration Services

This module describes the new and enhanced features in SQL Server Integration Services that can be used to create an ETL solution to load a data warehouse.

Data Quality Services

This module provides an introduction to SQL Server Data Quality Services, and teaches you how to build knowledge based data quality solutions for cleansing and matching data.

Master Data Services

This module provides an introduction to master data management with SQL Server 2012 Master Data Services.

SQL Server 2012 Reporting Services

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

Creating Tabular Data Models with PowerPivot

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

Implementing an Analysis Services Tabular Data Model

This module describes how to create tabular Analysis Services databases.

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.

Using Cloud Technologies in a BI Solution

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

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.

Suitable For

The Microsoft 40009 course is intended for BI professionals with experience of using SQL Server 2008 R2.

Prerequisites

Before attending this course, students must have:

Experience of creating database solutions in SQL Server, including basic Transact-SQL programming

Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting