Learn more about SQL Server tools

mssqltips logo
giveaway
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

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


By:   |   Read Comments (1)   |   Related Tips: More > Professional Development Certifications

Problem

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?

Solution

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?

700/1000

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:



Last Update:






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





More SQL Server Solutions











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    Notify for updates 


SQL tips:

*Enter Code refresh code     



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

This is superb!


Learn more about SQL Server tools