Calculated Columns, Measures, and KPIs, Oh My!

Speaker(s)Michael Antonovich 

Duration: 60 minutes

Track: Information Delivery

To do serious work in a Power Pivot table or even a SQL Analytics Cube, you must know the difference between calculated columns, measures, and KPIs, how to define them, use them, and display them.  This session will take you step by step through the creation of each of these components of a typical pivot table or cube showing you how to define the necessary expressions and then how they are displayed in tables and charts that transform mere data into meaningful managerial information.  To keep examples simple enough for all attendees to go back and try on their own, Excel Power Pivot Tables will be used, but the same techniques apply almost without change to SSAS cubes.

Accompanying Materials:

No material found.