…brew your own Business Intelligence

Passed 70-466 and 70-467 Exams + Study Guides

Earlier this month, I passed the following two exams putting me 1 away (70-462) from the MCSE Business Intelligence certification.

70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012

70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Below is an outline of the material I worked through in preparation for these exams.

70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012

This exam focuses on SSAS/SSRS at a developer level.  For experienced BI developers you’ll want to spend time covering features and functionality in detail, doing quick lab-like activities, re-familiarizing yourself with functionality you don’t use frequently…basically refresh the mind’s eye for developer-tasks.

 

70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

This is an architecture level exam covering the whole stack (DB Engine, Data Warehouse Design/Implementation, SSIS, SSRS, SSAS, MDS/DQS, Sharepoint integration, etc). For experienced Microsoft BI practitioners, this exam is much easier to prepare for…and that’s because you can’t really prepare for it! The material covered in this exam can only be obtained from actual experience and deliberate practice.

For this exam, you’ll need to understand how the various pieces of the Microsoft BI stack fit together in a solution.  And you’ll need to have a deep enough understanding to determine the best solution (from a list of other valid, but less optimal, solutions) for a given task based on information (infrastructure, business requirements, technical requirements, etc) in the case studies.

That said, I did read the following whitepapers and use MSDN to confirm my understanding of a few features:

 

Overall Thoughts

Some may argue that my preparation is a bit overkill…after all, why not simply purchase one of the exam preparation kits, work through the practice tests, and study the areas where you answered incorrectly?  That’s a perfectly valid option and will certainly be a more efficient approach…if getting the certification is your ultimate goal.

On the other hand, if deep knowledge and understanding is the goal, then I’d argue you would be better served with more reading and more deliberate practice.  In the long run, only technical experts (with good personalities) will consistently land the coolest (and highest paying) projects.  Few feelings rival that of the fireman who shows up to put out the client fire…cramming the week before the exam with a preparation kit will not give you this ability.

By the way…no data mining in the 70-466 exam…seriously?  Perhaps Microsoft should consider rebranding the SSAS Maestro into a SSAS MCM track (written + lab) that includes deep data mining expertise.

10 thoughts on “Passed 70-466 and 70-467 Exams + Study Guides

  1. Jai says:

    Very useful info

  2. Miguel says:

    Thank you for info

  3. hbalagere says:

    You mention “For those who don’t feel very strong in SSAS, I’d recommend adding an additional book that focuses on Multidimensional to the following reading list:”. Do you recommend anything particular? A book that concentrates on this may be?

    1. Bill says:

      Absolutely! If you haven’t worked with SSAS, then you’ll want to start with something that covers it end to end from a high-level such as Professional Microsoft SQL Server Analysis Services 2008 with MDX. Then once you understand the basics and have already build or augmented a few cubes, Expert Cube Development with Microsoft SQL Server 2008 Analysis Services will take you to the next level. Finally, and only if you are REALLY REALLY interested in understanding the minute details, check out Microsoft SQL Server 2008 Analysis Services Unleashed.

  4. Sarah says:

    Hi, Would you still recommend the Professional Microsoft SQL Server Analysis Services 2008 with MDX book for someone who has not worked with SSAS now? Or is there a newer version of this book that you would now recommend?

    1. Bill says:

      Hi Sarah, that’s definitely been my recommendation in the past for those who haven’t yet worked much with SSAS multidimensional. The reading list in the post (for the 70-466 exam) assumes (and builds upon) a working knowledge of SSAS multidimensional …it supplements with SSAS-tabular (i.e. Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model) and more advanced SSAS-multidimensional (i.e. Expert Cube Development, Performance/Operations Whitepaper, Many-to-Many).

      I just noticed a 2012-version of the Professional Microsoft SQL Server Analysis Services book which appears to cover both Tabular and Multidimensional modeling. This may be a nice place to start if you’re unfamilar with both technologies (Multidimensional & Tabular). Use it to get the foundational knowledge base, work a bunch of examples/labs – perhaps a project at work. Start focusing on any areas which may seem confusing (specific books, blogs, etc)…expand, apply, rinse, repeat. Journey not a destination 😉

  5. Sudha says:

    Do you have any information on 6 day boot camp being offered by training companies ? Are they good to consider going to get trained and certified? Do you have any recommendation on any of those? I am a BI Professional, but new to Microsoft BI stack.

    1. Bill says:

      thanks Kelly – link updated!

  6. ashi says:

    Hi Bill,
    I am planning to take 70-466 but my doubt is .. Can i go ahead with this exam without taking 70-461,70-462,70-463 i.e. the earlier versions. Can i just take 70-466 and add it to my profile.

Leave a Reply