Implementing Data Models and Reports with Microsoft SQL Server
Have you heard if training kits for 70-466 and 467 on the roadmap?
I was looking for the same thing. I found the training kits for the MCSA exams very helpful.
there seem to be training kits for SQL Server 2008 but I haven't seen anything for 2012
Here's a link to the book I used. Go to oreilly.com and search for sql 2012 training kit. search.oreilly.com
I found this list of resources -- they are really helpful. I am aiming at writing in the 28 March. :-)
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.
• Analysis Services
Since this is the bulk of the exam, you need to spend most of your 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:
o Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model
o DAX Formulas for PowerPivot: The Excel Pro’s Guide to Mastering DAX
o SSAS Performance and Operations Guide
o Many-to-Many Dimensions: Query Performance Optimization Techniques
o Practical MDX Queries
o Expert Cube Development
o Many to Many Revolution 2.0
• Reporting Services
If you do know SSRS – spend time focusing mostly on the new features with SQL Server 2012 (Data Alerts, Power View, etc). Outside of those presentations (and a few hours on MSDN reviewing things like RSConfig.exe, RS.exe, etc)
It seems that MS Press has just not published these training kits even now. AND, I just got the notification that 2014 has gone RTM, too. Oh well, there are other ways. Thanks all for replying along the way!
I have signed up to a few MVA courses that look useful :-)
Not many for 2014 but quite a few for 2012 which is fine - as far as I'm aware these exams will be updated to include 2014 material but not replaced.
Just passed 70-466 this morning. :-) One to go :-) I used the resources I published above. They are great to get to know the product and get the job done - although I am a BI Consultant, I would not have coped if I did not work my way through all the resources in my previous post. Good luck all.
what materials did you use in preparing for the exam