Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Study material for exam 70-466 Implementing Data Models and Reports Preparation Materials

By:   |   Last Updated: 2016-02-16   |   Comments (3)   |   Related Tips: More > Professional Development Certifications


I would like to know what books, videos, links and advice you could give me to pass SQL Server exam 70-466?


There is no Training Kit for this exam (at least not yet), the official Microsoft course for this certification (Course 20466: Implementing Data Models and Reports with Microsoft® SQL Server®) is very useful, but it is not enough to pass the exam (the official courses never cover all the Microsoft certification exam topics).

So, what can we do to pass this exam?

This tip will give you links and tips for this very complex and difficult exam.

If you are a beginner in SQL Server Business Intelligence or you do not have experience in the Microsoft Certification exams, we strongly recommend taking exam 70-463 first. The 70-466 exam is very complex and difficult.

If you already passed exam 70-463, this tip is for you. We will give you advice, books and useful links for your exam.

Getting started

Here we compiled the links to SQL Server web sites, books, manuals:

Design dimensions and measures

Implement and configure dimensions in a cube

Design a schema to support cube architecture

Create and configure measures

Implement a cube

Create Multidimensional Expressions (MDX) queries

Implement custom logic in a data model

Implement storage design in a multidimensional model

Select an appropriate model for data analysis

Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database

Analyze data model performance

Process data models

Troubleshoot data analysis issues

Deploy SSAS databases

Install and maintain an SSAS instance

Build a tabular data model

Configure permissions and roles in a tabular model

Implement a tabular data model

Implement business logic in a tabular data model

Implement data access for a tabular data model

Build a report with SQL Server Reporting Services (SSRS)

Design a report

Implement a report layout

Configure authentication and authorization for a reporting solution

Implement interactivity in a report

Troubleshoot reporting services issues

Manage a report environment

Configure report data sources and datasets


As you can see, there are a lot manuals, links and videos to study. If you already have real life experience in these topics it usually takes 3 months to study the material. Otherwise, plan on 6 months or more.

If you believe there are other useful links for the exam feel free to comment and share your material.

Next Steps

There are several links that will be useful to you:

Last Updated: 2016-02-16

get scripts

next tip button

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Sunday, September 10, 2017 - 1:44:52 PM - Aakash Back To Top

Thank you very much. Nice compilation.

Tuesday, June 06, 2017 - 7:45:44 AM - Arulmouzhi Back To Top

 Thanks Daniel for your useful information.


Tuesday, February 16, 2016 - 10:39:41 AM - Jeremy Kadlec Back To Top


Thank you for completing the research and pulling this tip together.

Thank you,
Jeremy Kadlec
Community Co-Leader

Learn more about SQL Server tools