Excel Power Pivot

GPTKB entity

Statements (37)
Predicate Object
gptkbp:instanceOf Microsoft Excel add-in
gptkbp:allows creating relationships between tables
importing large datasets
gptkbp:availableOn gptkb:Microsoft_365
Microsoft Excel Professional Plus
gptkbp:category gptkb:software
Microsoft Office component
gptkbp:compatibleWith gptkb:Excel_for_Mac
gptkbp:developedBy gptkb:Microsoft
gptkbp:documentation https://support.microsoft.com/en-us/office/power-pivot-overview-and-learning-7f6336b8-1c3e-4aab-8b2a-389a86679923
gptkbp:enables data analysis
data modeling
https://www.w3.org/2000/01/rdf-schema#label Excel Power Pivot
gptkbp:integratesWith gptkb:SQL_Server_Analysis_Services
gptkb:Power_BI
gptkb:Power_Query
gptkbp:introducedIn gptkb:Microsoft_Excel_2010
gptkbp:license proprietary
gptkbp:supports filtering
pivot tables
KPIs
row-level security
in-memory data storage
hierarchies
measures
calculated fields
pivot charts
slicers
calculated columns
DAX (Data Analysis Expressions)
columnar data storage
gptkbp:usedFor business intelligence
self-service analytics
data mashups
gptkbp:bfsParent gptkb:Microsoft_BI_stack
gptkb:Data_View
gptkbp:bfsLayer 7