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

By:   |   Comments (3)   |   Related: More > Professional Development Certifications


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:

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

Friday, February 2, 2024 - 4:34:55 AM - uppi Back To Top (91915)
Nice article. Thank you for sharing with us.

Tuesday, January 30, 2024 - 4:57:53 AM - GCPMASTERS Back To Top (91893)
Amazing information. Thank you for sharing.

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

This is superb!

get free sql tips
agree to terms