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 Power Pivot in Microsoft Excel
- Keyboard shortcuts in Excel
Partner Features
Data Modeling and Visualization Tutorials
- Tutorial: Import Data into Excel, and Create a Data Model
- Tutorial: Optimize your Data Model for Power View reporting
- Tutorial: Import Data into Excel, and Create a Data Model
- Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX
- Tutorial: Create Map-based Power View Reports
- Tutorial: Incorporate Internet Data, and Set Power View Report Defaults
- Power Pivot Help
- Tutorial: Create Amazing Power View Reports - Part 2
Power Pivot Videos
- Understanding the Excel Data Model (Office 15-Minute Webinar)
- Understanding Power Pivot for Excel (Office 15-Minute Webinar)
Understand the Power Pivot Data Model
- Create a Data Model in Excel
- Create a memory-efficient Data Model using Excel and Power Pivot
- When to use Calculated Columns and Calculated Fields
- Lookups in Power Pivot Formulas
- VLOOKUP Functionality in Power Pivot
- Upgrade Power Pivot Data Models to Excel 2016
- 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
-
- QuickStart: Learn DAX Basics in 30 Minutes
- Context in DAX Formulas
- Filter Data in DAX Formulas
- DAX Operator Reference
- DAX function reference
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
Work with Power View
- Power View: Explore, visualize, and present your data
- Set table behavior properties for Power View reports
- Tutorial: Optimize your Data Model for Power View reporting