Database Reference
In-Depth Information
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 relation-
ships 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 experi-
ence 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
