Implementing Data Models and Reports with Microsoft® SQL Server® 2012
Interest in course

Implementing Data Models and Reports with Microsoft® SQL Server® 2012 (MOC10778)

This five-day instructor-led course teaches students how to build a multi-dimensional data model, and create reports and data visualizations for business users. This course maps to the skills and knowledge measured by Microsoft Exam 70-466, and in conjunction with on-the-job experience, can help prepare you for the exam.

The course is included in the following categories: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014

Difficulty of the course: Advanced

Course duration: 5 days

Contents of the course:

  • Introduction to Business Intelligence and Data Modeling
  • Implementing Reports with SQL Server Reporting Services
  • Supporting Self Service Reporting
  • Managing Report Execution and Delivery
  • Creating Multidimensional Databases
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing a Tabular Data Model with Microsoft PowerPivot
  • Introduction to DAX
  • Implementing an Analysis Services Tabular Data Model
  • Creating Data Visualizations with Power View
  • Performing Predictive Analysis with Data Mining

Expected knowledge: 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


Course dates:

04.02. 08.02.2019 Brno
25 450 CZK (without VAT)
11.02. 15.02.2019 Praha
25 450 CZK (without VAT)
25.02. 01.03.2019 Brno 25 450 CZK (without VAT) Order
11.03. 15.03.2019 Praha 25 450 CZK (without VAT) Order
18.03. 22.03.2019 Brno 25 450 CZK (without VAT) Order