Working with PowerPivot
If you’re using Office Professional Plus, you can also use the built-in PowerPivot add-in (New!), which allows you to build simple data models directly in Excel. PowerPivot is helpful when you want to import, filter out, and quickly process millions of rows of data from multiple data sources. You can use PowerPivot to define data hierarchies, calculation fields, and Key Performance Indicators (KPIs), and use the Data Analysis Expressions (DAX) language to create advanced formulas.
Build Data Models with PowerPivot
Click anywhere within the table range or select a range of cells.
Click the PowerPivot tab (New!).
• Enable ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
