YoVDO

Excel: Working Together with Power Query and Power Pivot

Offered By: LinkedIn Learning

Tags

Power Query Courses Data Analysis Courses Microsoft Office 365 Courses Data Modeling Courses Data Preparation Courses Data Cleansing Courses Power Pivot Courses PivotTables Courses PivotCharts Courses

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
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

Taught by

Joshua Rischin

Related Courses

Problem Solving with Excel
PwC 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