Wednesday, December 15, 2010

How to prepare for SQL SERVER 2008 Business Intelligence – MCTS 70-448

Yesterday I clear my first Microsoft certification which has make me MCTS in sql server 2008 BI 70-448 (Paper Code of MS), it was quite tough for me as I have studied sql server after a quite long time, previously I have work immensely in sql server 2000 where we use dts packages and there was no such Strong BI Support at that time, any how this paper is divided into three parts.

SSIS – Sql server integration services
SSAS – Sql server analysis services
SSRS – Sql server reporting services

Difficult level in above three parts I felt most was SSAS,
SSRS and SSIS is not that tough.

In SSAS there are further parts
1.) Developing Cube with dimentions and measures
2.) Data mining
3.) KPIs

In above, the most difficult I found was Data mining Extension (DMX) but thanks to Microsoft it doesn’t include much questions on datamining hardly 2 to 3 questions I saw while attempting paper, the best way to learn DMX is msdn ( .
For most of the preparation I used Microsoft press book for 70-443 and CBT Nuggets, I use to go through both of them twice which has taken almost one month.
Good luck to the guys who are going to attempt this paper in near future.