Complete Introduction to Excel Power Pivot

Learn how to use Excel Power Pivot to analyze and visualize large volumes of data,create relationships and DAX formulas

Created by: Ian Littlejohn
Microsoft Power BI and Business Intelligence Specialist

What Will I Learn?

• Quickly learn to use Power Pivot in Excel for powerful data analysis
• Work with millions of rows of data, create relationships between tables and learn the DAX formula language
• Have a COMPREHENSIVE understanding of creating data models in Excel
• Create calculated fields and calculated measures using DAX in Excel
• Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Segmentation
• Create RELATIONSHIPS between tables of data
• Analyze data using Pivot Tables and Pivot Charts

Requirements

• You will require a power pivot compatible version of Excel (2013 or newer or Office 365). Power Pivot is not currently Mac-compatible.
• You should be able to work with data in Excel and do basic reporting
• You will require the Excel Power Pivot licence

Target audience

• Excel users who want to learn how to use the Power Pivot Data Model
• Excel users who want to learn how to use the DAX formula language