O'Reilly logo

Microsoft System Center Reporting Cookbook by Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating the data model with PowerPivot

This recipe will show you how to use PowerPivot to define your data model and create visualization in your Excel sheet. Using the PowerPivot add-in, you can create relationships between queries, add formulas with Data Analysis Expressions (DAX), or create Key Performance Indicators (KPIs) for your data model.

PowerPivot provides a set table and column properties to improve the visualization experience with tools such as Power View and Power Map. The big difference between Power Query and PowerPivot is the following:

  • Power Query: Here, you can create, transform, and manipulate a dataset
  • PowerPivot: Here, you can create a dataset model that can be used in your Pivot Table, Power View, or Power Map visualization ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required