Friends of SQL Server, For Database Administrators, For IT Professionals

SQT10 Getting the Most Out of PerformancePoint Services


4:15PM - 5:30PM

Level: Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

Many people know that you can use PPS 2010 to create KPI scorecards. But PPS has a wealth of other features for creating an integrated dashboard environment. In this presentation, I'll demonstrate a 6-page dashboard that incorporates KPI scorecards, PPS analytic charts and grids, as well as content from Excel and Reporting Services. I'll also show how developers can use MDX to extend PPS content. By the end of the session, you're likely to learn at least one (and hopefully more than one) capability in PPS that you didn't know existed!

You will learn:

  • How PerformancePoint Services is more than just a "scorecarding" tool - it's a specialized dashboard designer that can incorporate content from other BI tools
  • How MDX skills are often needed to extend the capabilities of PerformancePoint