I need help on deciding the track for certification in BI. I did search MS website , however it left me a little confused. Looking for latest information on :
1.The Path/track and time involved in preparing and taking the test. How effective are MS training materials?
2. What is the cost if one takes it independently?
thank you !!
First of all I'm assuming you are looking at the 2008 track since you didn't specify otherwise :-). The 2012 track is completely different and I've only looked at it briefly. I've done the 2008 Administrative track and I'm working on the Development one (no BI) but hopefully my experience will be close enough.
First the MCTS. I'm fairly cheep so I don't do any of the classes I just went out and bought the MS Press book on the test, read that, and then bought another book on the subject and read that. That was enough, just barely. You need to look at the "Skills Tested" link for the exam and make sure you are at least familiar with each subject. Even then you will get some screwball questions. I ended up with one about trace flags. I'd never studied trace flags, they weren't in either book. I had to guess.
Second the MCITP. There are no books specific to this test. At least no books that get anything like a good review. There are classes but again I'm far to cheep. I reread the books I had and got a couple more. I watched selected MCM readiness videos. You can search for them on line. They are really excellent free training videos. They are at a higher level, but to my mind that is all to the good. Then I went through the "Skills Tested" list and made sure I had hit every subject at least once. This went much better than the MCTS test had.
Right now I'm reading the sections of the books I have on development, making sure I hit the skills on the "Skills Tested" list that I'm not strong at, and watching the MCM Videos that seem appropriate. I'm hoping to test in the next month or so.
Both tests were $150 each + 4-5 books at about $50 each for a total cost of ~$500. One thing you should note though is that the 2008 exams will no longer be given after the middle of next year. June or July I'm not sure off the top of my head which.
Hope that helps. If you need help with the 2012 BI track I can probably take a look and walk through it here but I don't have any experience with 2012 yet.
I was once offered a wizards hat but it got in the way of my dunce cap.
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Link to my Blog Post --> www.SQLStudies.com