Friday, August 17, 2007

Passed 70-445 BI Exam

 When the beta exams for Business Intelligence showed up in January, I immediately signed up, wrote both of them, and found out after 4 months that I failed both. :)  Considering I didn't have any time to study (I was on a heavy client engagement), didn't have a lot of knowledge around the data mining aspects of Analysis Services, whipped through the questions at light speed, and ate a big lunch beforehand, I was more surprised that I didn't fall asleep than failing.  Plus, since they were beta, I'm sure some of my answers were correct and it was the questions that were wrong!

Today, after putting a bit of effort in, I passed 70-445, the implementation & maintenance exam with flying colors.  The betas were brutally long - this one didn't seem half as bad, though as usual the test computer was slow and there was a bunch of outside distractions & banging ductwork in the room. 

My studying strategy:

  1. Get the outline from MS's site.
  2. Export it to Excel and select the items I'm not familiar with.
  3. Bring them into One Note.
  4. Create tabs for each item to expand on.
  5. Cross them out as I get the research.
  6. Google 70-445, 70-445 filetype:ppt (pdf, doc, etc.) to get things like course outlines & demo exams.
  7. Search Blogsearch & Technorati.
  8. Search for the specific items I'm not familiar with using the same wording as the ms outline.
  9. Read the books.

My pretesting strategy:

  1. Always write the exam on a Friday at 1:15pm (a happy day!)
  2. Have a light lunch.
  3. Have a coffee and a quick jog around the block.
  4. Show up a bit early.

My testing strategy: 

  1. Don't spend more than 1 -2 minutes per question, mark it for later. 
  2. When in doubt, pick the answer that matches the text of the question, or is the opposite of the question, or C.
  3. Watch for the yahoo question writers who stick in those trick questions involving percentage calculations or not logic.

Here's one statistic that blew me away.  I didn't realize that BI was such a niche.  There have been only 71 MCITP + BI certifications since June.  Perhaps because the exams are only a couple of months old?  Next will be the BI Requirements & Design exam 70-446.  Sounds like case studies to me....

The Microsoft Certified Professionals (MCP) program was established in 1992. To date, more than 2 million people have achieved Microsoft Certification worldwide.

Based on customer feedback, we have updated this list to include both the credential and the number of professionals on each release or certification. Because the MCP program is constantly growing, you may not see your most recent certification listed. We will add accurate data as it becomes publicly available. These numbers are current as of June 27, 2007.

Source: Number of Microsoft Certified Professionals Worldwide

8 comments:

Anonymous said...

How much time did you take to prepare for the test ?
I have worked on Sql 2005 BI platform but not in depth with all the aspects.

wavesmash said...

You'll need to know some MDX syntax, some sql syntax, lots of data mining, integration services, analysis services, and reporting services.

If you follow the outline of the exam and ensure you know the key parts it should not be a problem.

I have been working with SQL for over 10 years and it really helped that I had hands on experience with all of the pieces.

I wrote the betas and then really started studying again about 3 weeks ago.

Manisha said...

I want to be certified for BI developer for that certification
The follwoing two exams has to passed:

Exam 70-445 :BI Implementation & Maintenance
Exam 70-446 Designing a BI Infrastruture by Microsoft SQL Server 2005
Can you please help in giving the link for Dumps (freely available)

Paul said...

Really enjoyed reading about your views and thoughts relating to the exam in general.

I have just been told that I need to get some MS certification for my job and i'm a little unsure as to what is the best route. I do mainly reporting on MS Reporting Services and SQL work, not really anything else as such so my awareness of other stuff is quite limited.

Any ideas on a starting point? I thought I could learn the stuff for 70-431, with a view of moving onto 445/446 but without exposure to these areas I am sure it would be very difficult to grasp on a self-study basis?

If you can offer any pointers, excellent. Nice post btw

Paul said...

Really enjoyed reading about your views and thoughts relating to the exam in general.

I have just been told that I need to get some MS certification for my job and i'm a little unsure as to what is the best route. I do mainly reporting on MS Reporting Services and SQL work, not really anything else as such so my awareness of other stuff is quite limited.

Any ideas on a starting point? I thought I could learn the stuff for 70-431, with a view of moving onto 445/446 but without exposure to these areas I am sure it would be very difficult to grasp on a self-study basis?

If you can offer any pointers, excellent. Nice post btw

Pedro said...

Hi!
I made the exam 70-445 today with a score of 842.
The questions are mainly focus on Reporting Services and Data Mining.
If you want more feedback, visit my blog or send me an email!
Regards

BOLunatic said...

I need to know
1.The number of questions for 70-445 exam
2.The time allocated for that
thanks
Regards,
Suresh

singh.devender said...

I took that exam yesterday and i got 100%.