There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.
Plus, get prepped for Microsoft exam 70-768, a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Mar 3 - 5
9:00 AM - 4:30 PM EST
Online (AnyWare)
Jun 28 - 30
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Aug 25 - 27
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Jan 5 - 7
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Feb 23 - 25
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.This course can help you prepare for the following Microsoft certification exam — 70-768: Developing SQL Data Models
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
Lab: Exploring a BI Solution
After completing this module, students will be able to:
This module describes how to create multidimensional databases using SQL Server Analysis Services.
Lessons
Lab: Creating a multidimensional database
After completing this module, students will be able to:
This module describes how to implement dimensions in a cube.
Lessons
Lab: Working with Cubes and Dimensions
After completing this module, students will be able to:
This module describes how to implement measures and measure groups in a cube.
Lessons
Lab: Configuring Measures and Measure Groups
After completing this module, students will be able to:
This module describes the MDX syntax and how to use MDX.
Lessons
Lab: Using MDX
After completing this module, students will be able to:
This module describes how to customize a cube.
Lessons
Lab: Customizing a Cube
After completing this module, students will be able to:
This module describes how to implement a tabular data model in PowerPivot.
Lessons
Lab: Working with an Analysis services tabular data model
After completing this module, students will be able to:
This module describes how to use DAX to create measures and calculated columns in a tabular data model.
Lessons
Lab: Creating Calculated Columns and Measures by using DAX
After completing this module, students will be able to:
This module describes how to use data mining for predictive analysis.
Lessons
Lab: Perform Predictive Analysis with Data Mining
After completing this module, students will be able to:
Multidimensional databases using SQL Server Analysis Service (SSAS), SQL data models are created for analyzing SASS.
We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs.
Yes! This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
This course helps prepare you for the Microsoft 70-768 certification exam, Developing SQL Data Models.
Yes! It fulfills a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics certifications.
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.