Geeks With Blogs

News Brandy Favilla is currently the Community Engagement Manager at New Horizons of Minnesota ( In this position, she helps people define and build their careers through educational events. Brandy focuses on networking with members of the Information Technology community to form partnerships in education. She strives to maintain New Horizons’ reputation as a high-quality learning center throughout the Twin Cities and beyond. Some of her accomplishments include chairing the committee for both the TechFuse and MindSurf Conferences hosted by New Horizons, co-chairing Twin Cities Code Camp and Twin Cities SharePoint Camp, Co-host of the Twin Cities Developers Guild, VP of PR for TechMasters (, Communications Chair of PACT (, Programs chair for IAMCP, President of the Business Intelligence User Group ( and actively participating in the SharePoint User Group ( *the thoughts and opinions in this blog are my own and do not reflect the opinions of New Horizons of Minnesota
Twin Cities IT and Developer Events Postings by Brandy Favilla

Solving Business Problems in MDX
November 10-12

Location:  New Horizons of MN ( based in Edina MN

Class Overview 
This three-day, instructor-led course provides students with the knowledge and skills to write MDX expressions, calculations and queries for Microsoft SQL Server 2005 Analysis Services in order to implement the most demanding requirements for a Business Intelligence project.

This course was written by Chris Webb, a mentor with Solid Quality Learning. He is a specialist in Analysis Services and MDX, is a co-author of the second edition of "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", a recipient of the Microsoft MVP award and maintains a Microsoft BI-related blog at   

Note: This course may be taught by other qualified Solid Quality Learning mentors, and is not restricted solely to the author.
This course is intended for Business Intelligence professionals seeking to develop solutions using the Microsoft BI platform, including consultants, software developers and business analysts.

Before attending this course, it is recommended that students have the following skills:
Experience working with Microsoft SQL Server Analysis Services 2005, BI Development Studio/Visual Studio and client tools such as Excel to query an Analysis Services cube. No prior experience of MDX is necessary.

Course Length
   3 Days
Course Price
Upon completion of this course, the student will be able to:

  • Understand the basic concepts of MDX such as members, tuples and sets
  • Be able to write SELECT statements to query data
  • Understand what a calculated member is and where to create it
  • Understand how and when to use all major MDX functions
  • Break down a calculation from a business requirement using set-based logic and then express it in MDX - be able to 'think in MDX'
  • Understand the behavior of advanced concepts and features such as solve order, subselects and auto-exists
  • Write MDX queries for use in SQL Server Reporting Services
  • Write MDX expressions for security roles, KPIs and Actions
  • Write scoped assignments in a cube's MDX Script and understand how these assignments can affect the rest of the cube
  • Write efficient MDX
Posted on Thursday, July 17, 2008 11:00 AM | Back to top

Comments on this post: Solving Business Problems in MDX - November 10-12

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © TwinCitiesITandDevEvents | Powered by: