Power Pivot

E36149
Microsoft Excel add-in business intelligence tool data modeling tool

Power Pivot is an Excel data modeling and analysis add-in that enables users to create sophisticated data models, relationships, and DAX calculations for business intelligence reporting.

Jump to: Surface forms Statements Referenced by

Observed surface forms (7)

Surface form Occurrences
Power Pivot for Excel 2
Excel Power Pivot 1
Microsoft Excel add-ins ecosystem 1

Statements (48)

Predicate Object
instanceOf Microsoft Excel add-in ⓘ
business intelligence tool ⓘ
data modeling tool ⓘ
abbreviation Power Pivot self-linksurface differs ⓘ
surface form: Power Pivot for Excel
availableIn Excel Professional Plus editions ⓘ
Microsoft 365 enterprise plans ⓘ
basedOn xVelocity in-memory analytics engine ⓘ
category self-service BI technology ⓘ
compatibleWith SQL Server Analysis Services Tabular ⓘ
developer Microsoft ⓘ
enables building analytical dashboards ⓘ
creating reusable semantic models ⓘ
creation of data models inside Excel ⓘ
joining data from different sources ⓘ
introducedBy Power Pivot self-linksurface differs ⓘ
surface form: Microsoft SQL Server 2008 R2 PowerPivot for Excel
partOf Excel ⓘ
surface form: Microsoft Excel

Microsoft Office ⓘ
primaryUse ad-hoc data analysis ⓘ
interactive reporting ⓘ
self-service business intelligence ⓘ
requires Excel desktop application ⓘ
runsOn Windows ⓘ
supportsFeature DAX formulas ⓘ
KPIs ⓘ
Power BI integration ⓘ
Power View integration ⓘ
VertiPaq compression ⓘ
calculated columns ⓘ
calculated measures ⓘ
column-level calculations ⓘ
data aggregation ⓘ
data filtering ⓘ
data modeling ⓘ
data refresh ⓘ
data relationships ⓘ
data summarization ⓘ
hierarchies ⓘ
importing data from multiple sources ⓘ
in-memory analytics ⓘ
linked tables from Excel ⓘ
many-to-many relationships ⓘ
relationships diagram view ⓘ
row-level calculations ⓘ
tabular data models ⓘ
time intelligence calculations ⓘ
targetUser business analysts ⓘ
power users ⓘ
usesLanguage Data Analysis Expressions ⓘ

Referenced by (11)

Full triples — surface form annotated when it differs from this entity's canonical label.

Power Pivot → abbreviation → Power Pivot self-linksurface differs ⓘ
this entity surface form: Power Pivot for Excel
Power View → dataSource → Power Pivot ⓘ
this entity surface form: PowerPivot
DAX → executionEngine → Power Pivot ⓘ
this entity surface form: VertiPaq
Power BI → hasComponent → Power Pivot ⓘ
Power Pivot → introducedBy → Power Pivot self-linksurface differs ⓘ
this entity surface form: Microsoft SQL Server 2008 R2 PowerPivot for Excel
Power Map → partOf → Power Pivot ⓘ
this entity surface form: Microsoft Excel add-ins ecosystem
Power Map → relatedTo → Power Pivot ⓘ
Excel → supports → Power Pivot ⓘ
subject surface form: Microsoft Excel
DAX → usedIn → Power Pivot ⓘ
this entity surface form: Excel Power Pivot
DAX → usedIn → Power Pivot ⓘ
this entity surface form: Power Pivot for Excel
Power View → uses → Power Pivot ⓘ
this entity surface form: PowerPivot data models