Data Wrangling in Excel with Power Query

Focused View

Jordan Goldmeier

1:32:34

169 View

01 - Introduction

01 - Introduction to Power Query.mp4

04:37

02 - A short history of Power Query.mp4

07:23

02 - 1. Manipulating Data

01 - Wrangling dirty data in Excel with Power Query.mp4

03:43

02 - Data wrangling steps.mp4

12:07

03 - Using the Power Query Applied Steps to track actions.mp4

08:05

04 - What M code is and where to find it.mp4

03:52

05 - Tour of Power Query features.mp4

13:06

06 - Using the Column from Example feature.mp4

04:48

07 - Sending feedback to Microsoft.mp4

02:38

03 - 2. Working with Multiple Data Sources

01 - Combining multiple data sources using Merge Query.mp4

03:12

02 - Creating a flat table from multiple data sources to see everything at once.mp4

11:25

04 - 3. File from Folder

01 - Creating a list of instructions for Power Query to perform across multiple files.mp4

04:12

02 - Using the File from Folder feature.mp4

03:45

03 - Editing the sample file.mp4

09:41

Description

Most Excel users still wrangle their data with hard-to-read formulas, copying and pasting, and a myriad of steps they’ve perfected over the years to get the data just right. What many don’t know is that Microsoft has taken a long hard look at this workflow and created a technology to streamline all of it! Enter Power Query. Despite the name, Power Query is not a very complicated tool. In this course, Jordan Goldmeier gets you started with Power Query, showing you how to retrieve data from any source and then use Power Query to slice and dice it. He takes you through multiple workflow examples that bring together various features of Power Query. Throughout the course, Jordan provides demos and case studies so that you can learn as you go.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Warehouse

Microsoft Power BI

Jordan Goldmeier

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.