Power Pivot provides advanced data modeling features in Microsoft Excel. Use the resources below to learn about how you can use Power Pivot to help you gain new insights into your data.
Get started
Partner Features
Data Modeling and Visualization Tutorials
Power Pivot Videos
Understand the Power Pivot Data Model
Add Data
-
Find out which data sources are used in a workbook data model
-
Tip: Power Query for Excel is a new add-in you can use to import data from many different source into your Excel workbooks and data models. Learn more at Microsoft Power Query for Excel Help.
Work with Relationships
Work with Hierarchies
Work with Perspectives
Work with Calculations and DAX
-
Tip: The DAX Resource Center Wiki on TechNet provides an extensive number of articles, videos, and examples from BI experts.