Overview
-
Learn how to combine Power Query and Power Pivot, two robust features of Microsoft Excel, to analyze data.
Syllabus
-
Introduction
- Getting the most out of your data
- What you should know
- How Power Query and Power Pivot work together
- Select your data
- Prepare your query
- Use a query to cleanse data
- Enhance your query
- Prepare data for Power Pivot
- Create your data model
- Import additional data
- Build relationships
- Create lookups as new fields
- Analyze data using PivotTables
- Analyze data using PivotCharts
- Scenario 1: Refresh source data
- Scenario 2: Updating queries
- Scenario 3: New reports
- Next steps
