English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 46m | 518 MB
The Power Query and Power Pivot features in Microsoft Excel can make a powerful combination. Power Query enables you to discover, connect to, and import data, and Power Pivot lets you quickly model that data. In this concise course, Excel power user Joshua Rischin shows how to work seamlessly with Power Query and Power Pivot. Joshua walks step-by-step through using Power Query to select data, prepare a query, cleanse data, and prepare data for Power Pivot. Next, he walks through the Power Pivot workflow, showing how to create a data model, import additional data if needed, build relationships between data, and create calculations and measures. The final chapter provides three real-world scenarios for working together with Power Query and Power Pivot.
Topics include:
- Preparing queries
- Cleansing data with Power Query
- Enhancing queries
- Creating a data model in Power Pivot
- Building relationships
- Analyzing data with PivotTables and PivotCharts
- Using Power Query with PowerPivot
Table of Contents
1 Getting the most out of your data
2 What you should know
3 How Power Query and Power Pivot work together
4 Select your data
5 Prepare your query
6 Use a query to cleanse data
7 Enhance your query
8 Prepare data for Power Pivot
9 Create your data model
10 Import additional data
11 Build relationships
12 Create lookups as new fields
13 Analyze data using PivotTables
14 Analyze data using PivotCharts
15 Scenario 1 Refresh source data
16 Scenario 2 Updating queries
17 Scenario 3 New reports
18 Next steps
Resolve the captcha to access the links!