Excel: Working Together with Power Query and Power Pivot
Offered By: LinkedIn Learning
Course Description
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
- Scenario 4: New source data
- Scenario 5: Finessing reports
- Next steps
Taught by
Joshua Rischin
Related Courses
Problem Solving with ExcelPwC via Coursera Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Data Analytics for Decision Making
Queen Mary University of London via FutureLearn Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera Excel 2013 Tips and Tricks
LinkedIn Learning