Microsoft Certification : request for exclusive certification for Analysis Services

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


Heba ElDesouky said...

you are true, we really need such a certification.

Nettech India said...

I found so many interesting in your blog especially its discussion. keep up the good work.
Microsoft certification in mumbai

Unknown said...

thanks for the post, you may also like this
Power BI Online Training USA

Unknown said...

 wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
Power BI Online Course
Power BI Online Course Bangalore

soumya Teja said...

This information really useful for the beginner's thanks for your patience to provide for us. keep share more content on MSBI Online Training

My Articles


Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage

Fact table design for “State Workflow Analysis”: Analysis Services Dimensional modeling

Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005 SP2 : Cube design tip

Identifying intra-dimensional members relationship and reducing cube sparsity in Analysis Services 2005 SP2 : Cube design tip

Leaves() : An example to understand it for both regular hierarchies as well as parent child hierarchies

Aggregation design: useful tips

Level based attribute hierarchy: MDX query performance woes in SQL Server 2005 SP2: Is it fixed in post SP2 hotfix?

Parent child hierarchy to level base hierarchy conversion: hiding placeholder dimension members in client application

Trouble / Troubleshooting

Aggregate(), Sum() functions using calculated members does not work in Analysis Services 2005 SP2 (9.00.3042.00 version) but works in Analysis Services 2000 SP4

Analysis Services 2005 migration tool: Custom member formula issues in migrated database

Cube Partitions: Fact table not listing in Business Intelligence Development Studio in partition wizard

Analysis Services 2005: Many-to-Many relationship does not support unary operators with parent-child dimension


NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels

Selecting dimension's default member based on a member property

Sorting members on member codes / member properties

Time Dimension: How to set Default Member to Current Month

Setting dynamic default member in dimension X based on the current member of dimensions Y


Code : utility code for converting cellset to a data table


Google specialized search for Analysis Services and MDX web resources integrated in my blog

Art of reading MDX articles

MDX Expression Builder : Need for a tool making it easier for functional users to write MDX expressions, queries.