Updating your Business Intelligence Skills to Microsoft SQL Server 2012

3 Day Course
Code M40009

This course has been retired. Please view currently available Microsoft System Centre Training.

Modules

Collapse all

Module 1: Introduction to SQL Server 2012 for Business Intelligence (7 topics)

  • This module provides an overview of how SQL Server 2012 can be used to build BI solutions.
  • Lessons
  • Overview of SQL Server 2012 for Business Intelligence
  • SQL Server 2012 for Enterprise Integration Management
  • SQL Server 2012 for Data Warehousing
  • SQL Server 2012 for Data Analysis and Reporting

Module 2: New and Enhanced Features in SQL Server Integration Services (9 topics)

  • 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.
  • Lessons
  • Using the CDC Control Task for Incremental Data Loads
  • Deploying and Operating SSIS Packages
  • Lab : Using SQL Server Integration Services
  • Extracting Modified Data
  • Deploying and Operating an SSIS Project

Module 3: Data Quality Services (15 topics)

  • 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.
  • Lessons
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
  • Lab : Cleansing Data
  • Creating a DQS Knowledge Base
  • Using a DQS Project to Cleanse Data
  • Using DQS in an SSIS Package
  • Lab : Deduplicating Data
  • Creating a Matching Policy
  • Using a DQS Project to Match Data

Module 4: Master Data Services (14 topics)

  • This module provides an introduction to master data management with SQL Server 2012 Master Data Services.
  • Lessons
  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab : Implementing Master Data Services
  • Creating a Master Data Services Model
  • Using the Master Data Services Add-in for Excel
  • Enforcing Business Rules
  • Loading Data into a Model
  • Consuming Master Data Services Data

Module 5: SQL Server 2012 Reporting Services (11 topics)

  • 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 (15 topics)

  • 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 (14 topics)

  • 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 (12 topics)

  • 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 (12 topics)

  • 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

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

Course PDF

Print

Sections