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.
Data Modeling and Visualization Tutorials
Understand the Power Pivot 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.