SQL Server 2012 BI

Updating your Business Intelligence Skills to Microsoft SQL Server 2012

Length: 3   Days
Language(s): English
Audience(s): IT   Professionals
Level: 200
Technology: Microsoft SQL Server 2012
Type: Course
Delivery   Method: Instructor-led   (classroom)



About   this Course

This three-day instructor-led   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.

Audience   Profile

This course is intended for BI professionals with experience of using SQL Server 2008 R2.

At   Course Completion

After completing this course,   students will be able to:

  •   Describe key new and enhanced features for BI in SQL Server 2012.
  •   Use new and enhanced features in SQL Server Integration   Services.
  •   Manage data quality by using SQL Server Data Quality Services.
  •   Manage master data by using new and enhanced features of SQL   Server Master Data Services.
  •   Use new and enhanced features of SQL Server Reporting Services.
  •   Create tabular data models with PowerPivot and DAX.
  •   Implement a tabular data model in SQL Server Analysis Services.
  •   Use Power View to create interactive data visualizations.
  •   Integrate Microsoft cloud technologies into a BI solution.

Course Details

Course Outline

Module 1: Introduction to SQL   Server 2012 for Business Intelligence

Module 2: New and Enhanced   Features in SQL Server Integration Services

Module 3: Data Quality   Services

Module 4: Master Data   Services

Module 5: SQL Server 2012   Reporting Services

Module 6: Creating Tabular   Data Models with PowerPivot

Module 7: Implementing an   Analysis Services Tabular Data Model

Module 8: Creating Data   Visualizations with Power View

Module 9: Using Cloud   Technologies in a BI Solution


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.