Presentation Summary

Practical MDX: Using MDX with Microsoft OLAP/BI Tools

Level: Intermediate
Track: n/a
Starts: Apr 5 2008 9:10 AM
Ends: Apr 5 2008 10:25 AM
Room: Providence
Speaker: Kevin Goff

I'm a contract trainer for a Microsoft Gold Partner in the areas of MDX programming with Microsoft BI tools - this is a session on "best practices" for applying MDX. If you are at all interested in programming BI solutions, this is a MUST-SEE presentation. So you’re learning MDX, and wonder how to effective “use” it in an OLAP environment. You’re also looking at different Business Intelligence reporting tools and wonder how to create customized output, KPIs, etc. As it turns out, the key to building flexible BI dashboards and reports, as well as powerful KPIs, is knowing how (and where) to incorporate MDX code with such tools as Reporting Services, PerformancePoint server, and other BI tools. This session demonstrates a variety of examples for building reusable MDX queries, expressions, and named sets for consumption by different BI reporting tools. You’ll walk away with a substantial amount of sample MDX code and reusable techniques for applying MDX code into different BI scorecards, reports, and charts. You’ll also pick up some great tips for building BI dashboards. This is THE session to attend for learning extending MDX code.

Technical Areas

  • Analytics
  • SQL Server
  • SQL Server Reporting Services
© 2006-2007 thedevcommunity.org (Version: 1.0.021)