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

By:   |   Comments (4)   |   Related: 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:

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Monday, December 7, 2020 - 7:07:55 PM - Dave Bolton Back To Top (87891)
Thank you so much for this article. This is an awesome compilation.


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

Thank you very much. Nice compilation.

Tuesday, June 6, 2017 - 7:45:44 AM - Arulmouzhi Back To Top (56873)

 Thanks Daniel for your useful information.


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


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

Thank you,
Jeremy Kadlec
Community Co-Leader

get free sql tips
agree to terms