• Course
  • Vendor

In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions. You will learn about data modeling by creating multidimensional databases, cubes & dimensions, measures & measure groups, MDX fundamentals

  • Course Start Date: 2019-06-24
  • Time: 11:30:00 - 19:30:00
  • Duration: 5 days 11:30 AM - 07:30 PM
  • Location: Virtual
  • Delivery Methods(s): Virtual Instructor Led
REGULAR PRICE $2,995.00 Save $299.50
2 discount seats left!
or make an offer

Course Outline


Minimum two years experience with relational databases Knowledge and skills that include: Normalized database design Creating tables and relationships Querying with Transact-SQL Data warehouse schema topology, including Star and Snowflake schemas Basic programming constructs: looping and branching Key business priorities for revenue, profitability, and financial accounting


In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions. You will learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services, and Data Analysis Expressions (DAX). You will then learn how to create and publish reports using reporting services, report execution and delivery, SharePoint PerformancePoint Services, and data mining.

This course incorporates material from the Official Microsoft Learning Product 20466: Implementing Data Models and Reports with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-466 and along with on-the-job experience, helps you prepare for the exam.

Our Microsoft Training Exclusives*
  • Six months of anytime access to your course labs and lab environment
  • Six months of 24/7 access to mentoring via chat, email, and phone
  • Six months of on-demand access to indexed, searchable recordings of your Virtual Classroom or Virtual Classroom Fit class
  • Six months of unlimited retakes of your class

* Terms and conditions may apply

Did You Know?

This class is available in our Virtual Classroom -- live online training that combines premium skills development technologies and expert instructors, content, and exercises to ensure superior training, regardless of your location.

What You'll Learn
  • Components, architecture and nature of a BI solution
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Multidimensional Expressions (MDX) syntax
  • Cube customization
  • Implement tabular data model in SQL Server Analysis Services
  • Enhance a tabular model using DAX
  • Reporting services
  • Report enhancement using charts and parameters
  • Report execution and delivery management
  • Implement a dashboard in SharePoint Server with PerformancePoint Services
  • Predictive analysis using data mining
Who Needs to Attend
  • Database professionals who fulfill a BI developer role
  • Database professionals who create analysis and reporting solutions whose responsibilities include:
    • Implementing analytical data models, such as OLAP cubes
    • Implementing reports and managing report delivery
    • Creating business performance dashboards
    • Support data mining and predictive analysis
Follow-On Courses
  • Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (M20467)
Certification Programs and Certificate Tracks

This course is part of the following programs or tracks:

  • MCSE: Business Intelligence
Course Outline
1. Introduction to Business Intelligence and Data Modeling
  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Plan an Enterprise BI Project
2. Create Multidimensional Databases
  • Multidimensional Analysis
  • Create Data Sources and Data Source Views
  • Create a Cube
  • Cube Security
3. Work with Cubes and Dimensions
  • Configure Dimensions
  • Attribute Hierarchies
  • Sorting and Grouping Hierarchies
4. Work with Measures and Measure Groups
  • Define Fact Tables
  • Associate Dimensions with Measures
5. Multidimensional Expressions (MDX)
  • MDX Fundamentals
  • Add Calculations to a Cube
  • Using MDX to Query a Cube
6. Enhance a Cube
  • Implement Key Performance Indicators (KPIs)
  • Implement Actions, Perspectives, and Translations
7. Implement an Analysis Services Tabular Data Model
  • Analysis Services Tabular Data Models
  • Create a Tabular Data Model
  • Analysis Services Tabular Data Models in the Enterprise
8. Data Analysis Expression (DAX)
  • DAX Fundamentals
  • Enhance a Tabular Data Model with DAX
9. Implement Reports with SQL Server Reporting Services
  • Reporting Services
  • Create a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publish and View a Report
10. Enhance Reports with SQL Server Reporting Services
  • Show Data Graphically
  • Filter Reports Using Parameters
  • Visualizing Data with Power View
11. Manage Report Execution and Delivery
  • Manage Report Security
  • Manage Report Execution
  • Subscriptions and Data Alert
  • Troubleshoot Reporting Services
12. Deliver BI with SharePoint PerformancePoint Services
  • SharePoint Server as a BI Platform and PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards
13. Perform Predictive Analysis with Data Mining
  • Data Mining
  • Create a Data Mining Solution
  • Validate a Data Model
  • Consume Data Mining Data
Lab 1: Explore BI Solutions
Lab 2: Create a Multidimensional Database
  • Create a Data Source
  • Create and Modify a Data Source View and Cube
  • Add a Dimension
Lab 3: Define Dimensions
  • Configure Dimensions and Attributes
  • Create Hierarchies
  • Create a Hierarchy with Attribute Relationships and a Ragged Hierarchy
  • Browse Dimensions and Hierarchies in a Cube
Lab 4: Configure Measures and Measure Groups
  • Configure Measures and Measure Group Storage
  • Regular Relationship
Lab 5: Use MDX
  • Create Calculated Members
  • Query a Cube using MDX
Lab 6: Customize a Cube
  • Implement an Action, Perspectives and a Translation
Lab 7: Implement an Analysis Services Tabular Data Model
  • Configure Columns and Relationships
  • Deploy an Analysis Services Tabular Data Model
Lab 8: Enhance a Tabular Data Model using DAX
  • Create Calculated Columns, Measures, and KPI
  • Implement a Parent-Child Hierarchy
Lab 9: Create a Report with Report Designer
Lab 10: Enhance a Report
  • Add a Chart and Parameters to a Report
  • Use Data Bars, Sparklines, and a Map
Lab 11: Configure Report Execution and Delivery
  • Implement a Standard and a Data-Driven Subscription
Lab 12: Implement a SharePoint Server BI Solution
  • Create a SharePoint Server Site for BI
  • Configure PerformancePoint Data Access
  • Create PerformancePoint Reports, Scorecards and Dashboards
Lab 13: Use Data Mining to Support a Marketing Campaign
  • Table Analysis Tools
  • Create a Data Mining Structure
  • Add a Data Mining Model to a Data Mining Structure
  • Validate a Data Mining Model and Use in a Report

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Training Location

Online Classroom
your office

your city, your province
your country   

About Global Knowledge


Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate themselves and thrive. Our learning programs, whether designed for a global organization or an individual professional, help businesses close skills gaps and foster an environment of continuous talent development.

Training Provider Rating

This vendor has an overall average rating of 4.39 out of 5 based on 424 reviews.

No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platfo ... Read more

Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platform.. from adobe to something called zoom; I had to call support line cause it stated our instructor wasn’t present. Thankfully I called cause everyone online was in the adobe virtual classroom waiting for what looked like a teacher who didn’t show up for class (IT didn’t get anything resolved until 10mins after start time). I felt like he was really getting hung up on very basic knowledge for the first half of the course (talking about how to create tabs and drag formulas as an example). I completed files a few times before he was done explaining. There was a scheduled fire drill for them (roughly 30mins)that also cut into our time, which wasn’t deducted from the hour lunch break or the two, fifteen min breaks. I also really wish he touched base more on the automating workbook functions portion which we barely did. I'm happy there were/are those study guides (learning videos) and exams to take on my own time that I hope after I've had the class are still available for me to learn from.

No comment
No comment
No comment
No comment
It was difficult to practice on my PC while trying to watch the presentation online.
No comment
David was excellent!! I am very for having this course!!

Course Reviews

No Reviews Yet

More Courses from Global Knowledge

More Courses in 'Microsoft SQL Training' Category