Excel: Working Together with Power Query and Power Pivot

Learn how to combine Power Query and Power Pivot, two robust features of Microsoft Excel, to analyze data.

Introduction

• Getting the most out of your data
• What you should know

1. Understanding Power Query and Power Pivot

• How Power Query and Power Pivot work together

2. Using Power Query

• Select your data
• Prepare your query
• Use a query to cleanse data
• Enhance your query
• Prepare data for Power Pivot

3. Using Power Pivot

• Create your data model
• Import additional data
• Build relationships
• Create lookups as new fields
• Analyze data using PivotTables
• Analyze data using PivotCharts

4. Using Power Query with Power Pivot

• Scenario 1: Refresh source data
• Scenario 2: Updating queries
• Scenario 3: New reports
• Scenario 4: New source data
• Scenario 5: Finessing reports

Conclusion

• Next steps