Study material for exam 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server

By:   |   Updated: 2017-01-11   |   Comments (1)   |   Related: More > Professional Development Certifications

Please do not scroll away - stay informed.
Dear Database Professional,

Did you know that publishes new SQL Server content on a daily basis as well as offers free webinars and tutorials?

Let us help you stay informed and learn something new each day. Click here to keep informed.

Thank you,
Greg Robidoux and Jeremy Kadlec ( Co-Founders)

I want to pass the Designing Business Intelligence Solutions with Microsoft SQL Server exam 70-467. I failed twice and I do not want to fail again. Can you help me to pass the exam?


Yes, in this new tip, we will talk about books and material to pass this exam.

Which exam should I take before this one?

The Microsoft 70-463 Exam, Implementing a Data Warehouse with Microsoft SQL Server 2012/2014.

Is this exam difficult?

It is subjective, but in our opinion it is the most difficult exam. It is hard to find information to study and it is a complex exam that requires a lot of effort to study and pass.

What is the score to pass?


Which books do you recommend for this exam?

Unfortunately, there is no Microsoft Training Kit book for this exam. However, here are some books that might be useful:

  1. Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX is a great book to study MDX and DAX.
  2. Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) is a great and complete book about SQL Server Integration Services (SSIS).
  3. Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer is another Excellent book about SSIS.
  4. Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Developer Reference) is my favorite book about Tabular. Any article or book with Marco Russo and/or Alberto Ferrari is a good book about SSAS.
  5. Professional Microsoft SQL Server 2012 Reporting Services 1st Edition.
  6. Visualizing Data with Microsoft Power View will exceed the requirements to pass the exam in the Power View topics.
  7. Microsoft SharePoint 2013 Step by Step will help you to start with SharePoint and in the chapter 13, you will find useful information about SharePoint with Business Intelligence including Power View.
  8. Expert Cube Development with Microsoft SQL Server 2008 Analysis Services.
  9. The Data Warehouse Toolkit, 3rd Edition.

What courses should I take for this exam?

The following courses will help you to pass the exam:

Which simulation exams do you recommend?

What links do you recommend to study?

Here you have some links to help you pass the exam:

Plan business intelligence (BI) infrastructure

Design BI infrastructure

Design a reporting solution

Design an ETL solution

Next Steps

For more information, refer to these links:

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

Article Last Updated: 2017-01-11

Comments For This Article

Friday, January 27, 2017 - 8:27:36 AM - Reuben Anderson Back To Top (45619)

This is superb!

get free sql tips
agree to terms