Wednesday, December 15, 2010

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.

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

In SSAS there are further parts1.) Developing Cube with dimentions and measures2.) Data mining3.) 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 (http://msdn.microsoft.com/en-us/library/ms132058.aspx) .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.

About Me

My name is Imran Raza Panjwani. I am freelance custom web/desktop application consultant with 9 Years of experience in the field of custom software development which includes different business verticals Currently working with Asp.net , WPF, BizTalk , Share point. I have very strong and sound skills in database designing, mining and ware housing. Also I am associated with PMI being a member of one of the most prestigious project management institute. Recently I have also completed my PMP Certification and now i am PMP Certified. The PMP® Certification offered by the Project Management Institute (PMI) is recognized as the most esteemed Project Management Certification available. In addition to confirming the proficiency of a professional in project management, PMP certification is a useful tool for companies to determine which project managers have the experience and knowledge to do the job right. PMP certification is gaining in popularity with over 200,000 PMPs practicing in over 120 countries. These figures will continue to increase in the coming days. More and more organizations are recognizing the PMP certification as the industry standard for excellence in project management.