1311
Chapter 58: Creating and Deploying BI Semantic Models
58
- Expand the Sum of Reseller Sales Gross Profi t KPI. You will notice a Green-Yellow-
Red icon next to it. - Drag Value and Target to the Values section. Figure 58-11 shows the Excel
PivotTable with the KPI status icon.
FIGURE 58-11
Excel PivotTable with KPI status.At this point you have successfully created and displayed a KPI using PowerPivot and Excel
Pivot Tables.Creating Hierarchies in PowerPivot
Hierarchies provide a better user experience by enabling users to drill-down from an aggre-
gate top level down to more detail level data. Hierarchies also help users understand rela-
tionships between attributes.One of the easiest to understand hierarchies is the Product Drilldown hierarchy. The
AdventureWorksDW2012 database contains 606 products categorized under 37 subcategories
and 4 main categories from which you can create a hierarchy to facilitate navigation and
aggregation.Each of these category levels are contained in normalized tables in a database table
arrangement often referred to as a snowfl ake schema in the data warehousing industry.c58.indd 1311c58.indd 1311 7/31/2012 10:36:02 AM7/31/2012 10:36:02 AM
http://www.it-ebooks.info