- When to use Power Query (Get & Transform or Get Data)
- When to use Power Pivot
- Working with the Query Editor
- Options for loading data in Excel
- Working with text-specific and number-specific query editing tools
- Creating a rolling calendar with Power Query
- Grouping and aggregating data with Power Query
- Modifying Excel workbook queries
- Merging and appending queries
- Pivoting and unpivoting data with Power Query
Skill Level Intermediate
(gentle music) - [Chris] Hey, everyone, Chris Dutton here. And welcome to Excel Business Intelligence Part One, Power Query. In this part of the course, we'll kick off with a quick summary of the Power Excel landscape, explain when and why to use tools like Power Query and Power Pivot, and then focus on connecting and transforming data, using Excel's Query editing tools. We'll cover basic table transformations, date and text editing tools, and pro tips, like creating custom roll and calendars, pivoting and un-pivoting data, and merging and appending queries.
Now keep in mind that this is part one of a three-part series, so make sure to check out part two, Data Modeling 101, as well as part three, Power Pivot and Dax. We've got a lot to cover, so let's dive in.