MS10778 – Beta: Implementing Data Models and Reports with Microsoft SQL Server 2012

1. Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • The Microsoft Business Intelligence Platform

2.  Implementing Reports with Reporting Services

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports Using Parameters

3.  Supporting Self-Service Reporting

  • Introduction to Report Builder
  • Creating Reusable Report Items

4.  Managing a Reporting Infrastructure

  • Managing Security
  • Managing Report Execution
  • Delivering Reports with Subscriptions
  • Troubleshooting Reporting Services

5.  Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security

6.  Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes

7.  Working with Measures and Measure Groups

  • Working With Measures
  • Working with Measure Groups

8.  Introduction to MDX

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX To Query a Cube

9.  Customizing Cube Functionality

  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

 10.  Implementing a Tabular Data Model by Using Microsoft PowerPivot

  • Introduction to Tabular Data Models and PowerPivot Technologies
  • Creating a Tabular Data Model by Using PowerPivot for Excel
  • Sharing a PowerPivot Workbook and Using PowerPivot Gallery

11.  Introduction to Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

12.  Implementing an Analysis Services Tabular Data Model

  • Introduction to Analysis Services Tabular Data Model Projects
  • Implementing an Analysis Services Tabular Data Model in Business Intelligence Development Studio

13.  Creating Data Visualizations With Power View

  • Introduction to Power View
  • Visualizing Data with Power View

14.  Performing Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Using the Data Mining Add-In for Excel
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to a and Consuming a Data-Mining Model

Methods of the course performing

Multimedia lecture, exercises, labs


Participants of our courses receive:

  • an organized course led by experienced trainer
  • certificate of the course completion
  • course materials
  • tests that check the level of participants’ knowledge and skills in order to select a group of people on similar level (on customer’s wish)
  • individual computer post for each of the course participants
  • catering during brakes (coffee, tea, biscuits)
  • lunch (vegetarian or traditional meals – smorgasbord)
  • free consultancies with a lecturer up to 14 days after the course completion
  • tests that check the level of participants’ knowledge and skills after the training completion (on customer’s wish)


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 Power View and SQL Server Reporting Services, and discover business insights by using data mining.

The Beta version of this course (10778AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 Release Candidate 0 (RC0) is used in this course. Some of the exercises in this course are SQL Azure enabled.


In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

  • 10774A: Writing Queries with Microsoft SQL Server Transact-SQL


Certified Microsoft Trainer

Last viewed

Customer reviews

"Koleje Dolnośląskie S.A. confirms that CI ProLearning performer the course MS6419 – Configuring, Managing and Maintaining Windows Server 2008 servers for our employee between 17-21 June 2013. The course was prepared on the…"

Koleje Dolnośląskie


"„Particiaption of our employees in te course „Complaints and conflict situations handling” contributed to the growth of our products sells and the knowledge gained and applied by our…"

Complaints and conflict situations handling


"Between 3-4.08.2013 we participated in the course MS Excel – advanced level, which was performed by CI ProLearning. The trainer selected deserves our special recognition. He led the course in professional way, taking care of great atmosphere…"

C.H. Robinson

  • Our certifications

Course title:

Hours daily:
Net price :

Your information

- See terms and conditions

Please fill in the form below in order to sign up for chosen exams.

Code * Name * Date * Time Option

Your information

- See terms and conditions