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.