Implementing Data Models and Reports with Microsoft SQL Server 2012

PLEASE NOTE: This course has been replaced with M-20466: Implementing Data Models and Reports with Microsoft SQL Server

This 5-day instructor-led course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Project Crescent and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.

Course Outline

Module 1: Overview of Reporting and Data Modeling
Module Goal: Describe the components, architecture, and nature of a BI solution

Module 2: Implementing Reports with Reporting Services
Module Goal: Create reports with Reporting Services

Module 3: Supporting Self-Service Reporting
Module Goal: Create reusable report items that simplify self-service reporting.

Module 4: Managing a Reporting Infrastructure
Module Goal: Manage a reporting infrastructure.

Module 5: Creating Multidimensional Databases
Module Goal: Create a multidimensional database with Analysis Services.

Module 6: Working with Cubes and Dimensions
Module Goal: Implement dimensions in a cube.

Module 7: Working with Measures and Measure Groups
Module Goal: Implement measures and measure groups in a cube

Module 8: Introduction to MDX
Module Goal: Use MDX Syntax

Module 9: Customizing Cube Functionality
Module Goal: Customize a cube

Module 10: Implementing a PowerPivot for Excel Workbook
Module Goal: Implement a Tabular Data Model in PowerPivot

Module 11: Introduction to Data Analysis Expression (DAX)
Module Goal: Use DAX to create measures and calculated columns in a tabular data model

Module 12: Implementing a Tabular Database
Module Goal: Implement a Tabular Database

Module 13: Creating Data Visualizations With Crescent
Module Goal: Use Crescent to create interactive data visualizations

Module 14: Performing Predictive Analysis with Data Mining
Module Goal: Use Data Mining for Predictive Analysis


The primary audience for this course are database professionals who need to fulfil BI Developer role to create analysis and reporting solutions. Primary responsibilities will include:

  • Implement reporting solutions by using SQL Server Reporting Services

  • Implementing multidimensional databases by using SQL Server Analysis Services

  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services

  • Create visualizations of data by using Crescent

  • Create data mining solutions by using SQL Server Analysis Services