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
- Learn more about data analysis tools in Excel
- Power Pivot: Powerful data analysis and data modeling in Excel
- Start the Power Pivot add-in
- Keyboard shortcuts in Excel
Data Modeling and Visualization Tutorials
- Tutorial: Import Data into Excel, and Create a Data Model
- Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX
Understand the Power Pivot Data Model
- Create a Data Model in Excel
- Create a memory-efficient Data Model using Excel and the Power Pivot Add-in
- When to use Calculated Columns and Calculated Fields
- Data Model specification and limits
- Data types in Data Models
- Freeze columns
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
- Create a relationship between tables in Excel
- Create relationships in Diagram View in Power Pivot
- Delete relationships between tables in a Data Model
- Troubleshoot table relationships
- Work with Relationships in PivotTables
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.
Work with Dates and Time
- Dates in Power Pivot
- Understand and create date tables in Power Pivot in Excel
- Time Intelligence in Power Pivot in Excel
- Filter dates in a PivotTable or PivotChart report
Errors and Messages
- Power Pivot error: Maximum Memory or File Size Exceeded
- Power Pivot error: “Initialization of the data source failed
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.