As an OLAP professional, I eat, sleep and drink "Analysis Services". A certification would help in stamping my expertise in this area (and may be enhance my salary too :) )
Analysis Services is a subject area deep enough that does not leave anytime for me to practice other Microsoft BI tools such as Reporting Services, Data Mining, Integration services and so on.
However, if I need to get certified in Analysis Services, there seems to be only one exam available below:
Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance
The exam covers the following subject areas:
- Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services (includes Data Mining too)
- Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
- Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
Can Microsoft come with an exam exclusively focusing on Analysis Services where they test the in-depth knowledge of Analysis Services?
Analysis Services is a pretty in-depth technology that needs the following expertise:
- Dimensional, cube, KPI, drill-through, Actions modeling
- Business problem solving using analysis services
- Underlying relational schema & data source view design
- Aggregation and partition design
- Write backs
- MDX calculations and queries
- Security
- Performance improvements
- .Net stored procedure extensions
- Administration
- Many more that I might have missed
Posts
