There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program.  It is a five-day, deep-dive course on Analysis Services 2008 R2 that gives architects and consultants the education and hands-on experience needed to deliver the highly complex and highest scalable OLAP solutions.  It is prepared and presented by SQLCAT, top industry experts and the SQL Server Analysis Server team.  The primary objective of this course is equip you with the latest SSAS best practices and case studies.

Microsoft has a Masters Certification (MCM) for the SQL Server Database Engine.  There is no corresponding certification for Analysis Services.  The Maestro Program is the first step toward creating that certification.

Think of it as the equivalent of the SQL Server 2008 MCM, but for BI (i.e. SQL BI MCM).  It is a bit like SQL Rangers (the home-grown event prior to it becoming SQL Server MCM).  This has a good chance of this moving into an ANSI compliant certification program in the future.

This is exactly what I have been waiting for.  Since there was no SQL BI MCM, I have been studying for the next best thing, the SQL Server 2008 Microsoft Certified Master (MCM). But the problem with that is there was nothing on the test about BI, which is what I concentrate on.  This fills that gap.  Now I will turn my attention to studying for the SSAS maestro test.

Attendees that satisfactorily pass the assessment will be endorsed by Microsoft, and subsequently promoted within the SQL Server community and recommended for suitable engagements. Assessment will be based on:

• 100% attendance during the five-day course
• The consistent ability to contribute to, and at times lead, discussions
• The satisfactory completion of all labs and an online exam to be done after you return home
• A comprehensive 4000 word case study due 30 days after the course completion that demonstrates an applied deep understanding of the product and technology, and strong written communication skills

Upon successful completion of this course, assessment and case study evaluation by industry experts, attendees will:

• Be a part of the elite group of SSAS Maestros
• The SSAS Maestros list will be published on a Microsoft site for your customers to reference
• When SQLCAT needs someone to help with a complex SSAS engagement or needs to refer to a partner – Microsoft we will refer to a SSAS Maestro
• SQLCAT and the Analysis Services team will be creating SSAS Maestros-only webcasts and Q&A sessions – This will be an exclusive forum to discuss the latest best practices and share critical knowledge

The first round of classes (SSAS Maestro v1.0) was by invitation only and consisted of a 3-day course in Redmond, Hong Kong, and London last February.  SSAS Maestros v1.2 was a 5-day course in June and July in Redmond and Madrid.  Registration required screening and approval of qualified attendees.  Here was the agenda.  An excellent review of the class as well as recommended reading for the class is by Vidas Matelis.  There is also a PowerPoint presentation that gives an overview of the program.

The next course is in July 2012 in Milan: SSAS Maestro Training in July 2012