March 4, 2013 at 6:57 am
Can anyone give me any guidance on training kits for 70-466 exam?Thanks in advance for your help.
December 19, 2013 at 4:45 am
I'm actually interested in this myself. Just got my MCSA for SQL Server 2012 today and want to move on to the MCSE (BI Edition). There don't appear to be any training kits available from Microsoft at the moment. So can somebody please tell me:
1) Is there a target date for when the training kits for 70-466 and 70-467 will be released? If nobody knows, do you know a contact at Microsoft from whom I can inquire this?
2) If Microsoft isn't planning on releasing the training kits, is there any third party that will or that will at least give some preparation for this exam? No course though, my employer is not willing to dish out 2.000 + Euros for this.
3) Can anybody at least recommend any book(s) for this exam?
I'm not willing to write these exams without any prior preparation since if I am to ask my employer to sponsor me, I want to be sure that I can provide results.
December 20, 2013 at 1:24 pm
We are also interested in finding prep material for both 466 and 467.
There are people in my org that have recently completed 461, 462 and 463 and now have their MCSA: SQL Server 2012 certification.
They are eager to move on to 466 and 467 to get the MCSE: Business Intelligence cert but cannot find any study material.
Seems odd since (I think) these exams have been out there for more than a year.
Anyone have any helpful suggestions?
December 20, 2013 at 3:39 pm
Haven't found much on these exams. I did find this advice: http://byobi.com/blog/2013/04/passed-70-466-and-70-467-exams-study-guides/
January 13, 2014 at 1:00 pm
From the Microsoft certification site (http://www.microsoft.com/learning/en-us/sql-certification.aspx):
Q.How will the updates for SQL Server 2014 impact official Microsoft training and certifications?
A.SQL Server 2014 certifications will only be offered at the MCSE level. The new product features focus on performance tuning and high availability and are best suited for the MCSE level. As a result, the following updates are planned:
•The MCSA: SQL Server 2012 credential and associated exams (461/462/463) will remain in market without any alterations. No MCSA: SQL Server 2014 credential will be offered.
•In March 2014, the MCSE: Data Platform (464/465) and MCSE: Business Intelligence (466/467) exams will be appropriately updated with SQL Server 2014 topics. The exam numbers will remain the same.
At least one month prior to the update, details on the original and revised exam objectives will be made available for review in the Skills measured section of each exam detail webpage.
•Also in March 2014, recertification options for maintaining the MCSE credentials will be made available.
I suspect that this is the reason why none of these training kits (464,465,466,467) have been published yet since they intend on updating the objectives and exam content in a few months.
April 2, 2014 at 5:44 am
Passed the 70-466 after 3 months. Thanks everybody for your help.
Steve - The list in the link is a bit exhausting but I prepared with the following materials:
- Microsoft SQL Server 2008 MDX Step By Step
- Microsoft SQL Server Analysis Services 2008 Step by Step
- Pro Sql Server 2012 BI Solutions - A very straight forward, step by step general overview of BI with SQL Server
- Professional Microsoft SQL Server 2012 Reporting Services - very detailed book on SSRS (both Sharepoint and Native mode)
- Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model - I had no experience with the Tabular model prior to this book and even though DAX is extremely difficult to grasp compared to the Multidimensional Model and MDX, this book does a good job of guiding you through. Just make sure to read it twice, since the material is difficult.
- Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide ( http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx#MicrosoftSQLServerAnalysisServicesMultidimensionalPerformanceandOperationsGuide ) - This book is very abstract and will over prepare you for the performance based questions
- The following whitepaper: http://www.microsoft.com/en-us/download/details.aspx?id=137
Overall there is a lot to know for the exam: SSRS - both Native and Sharepoint mode, SSAS - both Multidimensional and Tabular, Data Warehouse architecture so I would suggest that anybody takes their time.
June 16, 2014 at 7:16 pm
I have just found a package by http://www.quickcert.com, has anyone had any experience with these? The main benefit I see is that they should focus on what you need to know.
Unfortunately due to time constraints, I can't afford to spend time in material that is less relevant.
http://www.quickcert.com/microsoft/mcse-business-intelligence-195888m
April 2, 2015 at 10:16 pm
Graham Whiteman (6/16/2014)
I have just found a package by http://www.quickcert.com, has anyone had any experience with these?
No but if you do a search they have a t-e-r-r-i-b-l-e reputation.
April 28, 2015 at 2:17 pm
I know this is an old question. However my reply maybe helpful for someone.
I passed the 70-466 exam with the help of; - http://www.selftestsoftware.com/certtestprep/practice-test/microsoft/70-466.kap.
Continual reference to; - https://www.microsoft.com/learning/en-us/exam-70-466.aspx
Books; -
SQL Server Analysis Services 2012 Cube Development Cookbook
By: Baya Dewald; Paul Turley; Steve Hughes
Publisher: Packt Publishing
Pub. Date: December 26, 2013
Print ISBN-13: 978-1-84968-980-9
Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
By: Marco Russo, Alberto Ferrari, and Chris Webb
Publisher: Microsoft Press
Last Updated: 19-APR-2015
Pub. Date: July 15, 2012 (Estimated)
Print ISBN: 978-0-7356-7009-9
Professional Microsoft SQL Server 2012 Reporting Services
By: Paul Turley; Robert M. Bruckner; Thiago Silva; Ken Withee; Grant Paisley
Publisher: Wrox
Pub. Date: June 5, 2012
Print ISBN: 978-1-118-10111-7
Working through the following tutorials; -
https://msdn.microsoft.com/en-us/library/hh231701.aspx?f=255&MSPPError=-2147217396
https://msdn.microsoft.com/en-us/library/bb522859(v=sql.105).aspx
I hope this helps.
Kind Regards,
Kieran.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply