Skip to main content

Microsoft 70-466: Implementing Data Models & Reports with SQL Server

Advanced13 Hours 4 Minutes47 Course Videos42 Test Questions

$99.00

Build SQL Server data models and reports with this Microsoft 70-466 course. Learn SSRS, cubes, MDX, tabular models, DAX and data mining in 13 hours 4 minutes of video.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft 70-466: Implementing Data Models and Reports with SQL Server teaches you to build the reports and data models behind business intelligence. It follows the Microsoft 70-466 exam for SQL Server 2012 and suits BI developers, database admins and data analysts. You get 13 hours 4 minutes of self-paced training across 47 video lessons.

What you will learn

  • Explain the Microsoft business intelligence platform and where each tool fits
  • Build and publish reports with SQL Server Reporting Services (SSRS)
  • Support self-service reporting for business users
  • Manage report execution, subscriptions and data alerts
  • Create multidimensional databases, data sources and cubes in Analysis Services
  • Work with dimensions, measures and measure groups
  • Write MDX and add calculations to a cube
  • Build tabular data models and write DAX formulas
  • Create data visuals with Power View
  • Run predictive analysis with data mining

Course outline: Microsoft 70-466

  1. Introduction to business intelligence and data modelling: the Microsoft BI platform.
  2. Implementing reports with SQL Server Reporting Services: designing and building reports.
  3. Supporting self-service reporting: helping users build their own reports.
  4. Managing report execution and delivery: execution, subscriptions and data alerts.
  5. Creating multidimensional databases: data sources, data source views and cubes.
  6. Working with cubes and dimensions: sorting and grouping attributes.
  7. Working with measures and measure groups: how values are stored and summed.
  8. Introduction to MDX: queries and cube calculations.
  9. Customising cube functionality: extending what a cube can do.
  10. Implementing a tabular data model: the tabular approach to modelling.
  11. Introduction to DAX: formulas for tabular models.
  12. Implementing an Analysis Services tabular data model: building and deploying it.
  13. SQL Analysis Services: working with the Analysis Services engine.
  14. Creating data visualisations with Power View: interactive visuals.
  15. Supporting self-service reporting: a second look at user-led reporting.
  16. Performing predictive analysis with data mining: finding patterns in data.
  17. Predictive analytics: using models to forecast results.

Who this course is for

  • Business intelligence developers
  • Database administrators who support reporting
  • Data analysts who want to build models and reports
  • IT professionals who need data reporting skills
  • Report writers who want to move into data modelling

Before you start

You should be at ease with SQL Server and relational databases, including writing basic queries. Some time with Excel or reporting tools will help you follow the BI lessons. If you have not used Analysis Services before, do not worry, as the course starts with how the Microsoft BI platform fits together.

About the 70-466 exam

The 70-466 exam, Implementing Data Models and Reports with Microsoft SQL Server 2012, was issued by Microsoft as part of its MCSE business intelligence path. It tested your skill with SSRS reports and with multidimensional and tabular models in Analysis Services. Microsoft has retired the 70-series exams, so you can no longer sit this exam. The skills still apply wherever SSRS and Analysis Services are in use.

Jobs this course supports

  • Business Intelligence Developer
  • Data Analyst
  • Database Administrator
  • Reporting Analyst

Skill level

Advanced
Duration

13 Hours 4 Minutes
Videos

47 Course Videos
Questions

42 Test Questions
Certification

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam code

70-466
Certification body

Microsoft
Prerequisites

Working knowledge of SQL Server and relational databases.
Best for

Business intelligence developers, database administrators, data analysts, reporting specialists
Topics covered

SQL Server Reporting Services, Self-service reporting, Multidimensional cubes, MDX, Tabular data models, DAX, Power View, Data mining
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

17 modules and 47 lessons. Here is the full outline.

Module 1: Introduction To Business Intelligence And Data Modeling6 lessons
  1. Introduction To Business Intelligence and Data Modeling Part1
  2. Introduction To Business Intelligence and Data Modeling Part2
  3. The Microsoft Business Intelligence Platform Part 1
  4. The Microsoft Business Intelligence Platform Part 2
  5. The Microsoft Business Intelligence Platform Part 3
  6. The Microsoft Business Intelligence Platform Part 4
Module 2: Implementing Reports The SQL Server Reporting Services8 lessons
  1. Implementing Reports the SQL Server Reporting Services Part 1
  2. Implementing Reports the SQL Server Reporting Services Part 2
  3. Implementing Reports the SQL Server Reporting Services Part 3
  4. Implementing Reports the SQL Server Reporting Services Part 4
  5. Implementing Reports the SQL Server Reporting Services Part 5
  6. Implementing Reports the SQL Server Reporting Services Part 6
  7. Implementing Reports the SQL Server Reporting Services Part 7
  8. Implementing Reports the SQL Server Reporting Services Part 8
Module 3: Supporting Self Service Reporting2 lessons
  1. Supporting Self Service Reporting Part 1
  2. Supporting Self Service Reporting Part 2
Module 4: Managing Report Execution And Delivery3 lessons
  1. Managing Report Execution And Delivery
  2. Managing Report Execution
  3. Subscriptions And Data Alerts
Module 5: Creating Multidimensional Databases3 lessons
  1. Creating Multidimensional Databases
  2. Creating Data Sources And Data Source Views
  3. Creating And Browsing a Cube
Module 6: Working With Cubes And Dimensions2 lessons
  1. Working with Cubes And Dimensions
  2. Sorting And Grouping Attributes
Module 7: Working With Measures And Measure Groups1 lessons
  1. Working With Measures and Measure Groups
Module 8: Introduction To MDX2 lessons
  1. Introduction To MDX
  2. Adding Calculations To A Cube
Module 9: Customizing Cube Functionality3 lessons
  1. Customizing Cube Functionality Part 1
  2. Customizing Cube Functionality Part 2
  3. Customizing Cube Functionality Part 3
Module 10: Implementing A Tabular Data Model2 lessons
  1. Implementing A Tabular Data Model Part 1
  2. Implementing A Tabular Data Model Part 2
Module 11: Introduction To DAX4 lessons
  1. Introduction to DAX
  2. Demonstration Making A Tabular Model Part 1
  3. Demonstration Making A Tabular Model Part 2
  4. Using DAX
Module 12: Implementing An Analysis Services Tabular Data Model3 lessons
  1. Implementing An Analysis Services Tabular Data Model Part 1
  2. Implementing An Analysis Services Tabular Data Model Part 2
  3. Deploying A Tabular Data Model
Module 13: SQL Analysis Services2 lessons
  1. SQL Analysis Services Part 1
  2. SQL Analysis Services Part 2
Module 14: Creating Data Visualizations With Power View1 lessons
  1. Creating Data Visualizations With Power View
Module 15: Supporting Self Service Reporting1 lessons
  1. Supporting Self Service Reporting
Module 16: Performing Predictive Analysis With Data Mining2 lessons
  1. Performing Predictive Analysis With Data Mining
  2. Using The Data Mining Wizard
Module 17: Predictive Analytics2 lessons
  1. Predictive Analytics Part 1
  2. Predictive Analytics Part 2

Your learning path

Where Microsoft 70-466: Implementing Data Models & Reports with SQL Server fits. Build your skills one step at a time.

Take firstMicrosoft 70-461: Querying SQL ServerTake firstMicrosoft 70-463: Implementing a Data Warehouse with SQL Server
You are hereMicrosoft 70-466: Implementing Data Models & Reports with SQL Server
Next stepMicrosoft 70-467 - Designing Business Intelligence Solutions with SQL Server

Frequently asked questions

Can I still take the Microsoft 70-466 exam?

No. Microsoft retired the 70-series exams linked to MCSA and MCSE. The course still teaches SSRS and Analysis Services skills used in many businesses.

What is the difference between MDX and DAX?

MDX is the query language for multidimensional cubes. DAX is the formula language for tabular models. This course teaches the basics of both.

Does the course cover SQL Server Reporting Services?

Yes. Several modules cover building SSRS reports, self-service reporting, report execution, subscriptions and data alerts.

Does the course include data mining?

Yes. The last modules cover predictive analysis with data mining and predictive analytics.

How does this course relate to 70-467?

70-466 focuses on building data models and reports. The 70-467 course focuses on designing full business intelligence solutions, so it is a good next step.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$99.00
Buy course