How to use Microsoft Power Query

Share this & earn $10
Kevin Stratvert
Published at : 18 Dec 2020
21142 views
1305
9

In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.

👋 Additional resources:
- Sample files: https://1drv.ms/u/s!AmxrofZZlZ-whKZQTEiA4iLu-WPiaQ?e=AkAtOi
- Download Power Query for Excel 2010 or 2013: https://www.microsoft.com/en-au/download/details.aspx?id=39379

⌚ Timestamps
00:00 Introduction
00:59 Sample data
2:14 How to get Power Query
2:31 Get data
3:35 Combine data
5:26 Main Power Query interface
7:00 Transform data
11:21 Applied steps
12:06 Close & Load
12:33 Data imported into Excel
13:34 Insert pivot table & chart
14:46 Importing additional data
16:00 Wrap up

📃 Watch related playlists and videos
- Pivot Table tutorial: https://youtu.be/m0wI61ahfLc
- Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
- Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe

🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818

🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
kevin stratvertpowerpower query

CHAMILLIONAIRE-WARN YOU-MAJOR PAIN

CHAMILLIONAIRE-WARN YOU-MAJOR PAIN

Travis Lee "It's Your Decision" (Alice In Chains Cover)

Travis Lee "It's Your Decision" (Alice In Chains Cover)

22 COOKING TRICKS EVERYONE MUST KNOW

22 COOKING TRICKS EVERYONE MUST KNOW

I PURCHASE AND RAN ON A FAKE ALPHAFLY

I PURCHASE AND RAN ON A FAKE ALPHAFLY

The Lost 1984 Video: young Steve Jobs introduces the Macintosh

The Lost 1984 Video: young Steve Jobs introduces the Macintosh

This Attitude Will Make You Happier (And More Successful)

This Attitude Will Make You Happier (And More Successful)

Biggest Mistake Each Rank Makes in Rocket League

Biggest Mistake Each Rank Makes in Rocket League

Brushy One String | They Are Going Down

Brushy One String | They Are Going Down

AMAZING! Dalgona Coffee Recipe (frothy coffee) | Dalgona Coffee at Home

AMAZING! Dalgona Coffee Recipe (frothy coffee) | Dalgona Coffee at Home

What Makes a Good Researcher?

What Makes a Good Researcher?

Holding a Black Lives Matter Sign in America's Most Racist Town

Holding a Black Lives Matter Sign in America's Most Racist Town

Bathroom Remodeling Timelapse by HoffaH

Bathroom Remodeling Timelapse by HoffaH

Ismail - no surprise (Official Audio)

Ismail - no surprise (Official Audio)

Wonderful! Amazing ideas with cement - making an ornamental planting place

Wonderful! Amazing ideas with cement - making an ornamental planting place

LIBRA~CLARITY! WHY THE SOULMATE BLOCKED YOUR CONNECTION?! DECEMBER 2020 TAROT READING!

LIBRA~CLARITY! WHY THE SOULMATE BLOCKED YOUR CONNECTION?! DECEMBER 2020 TAROT READING!

Top10 Smart Ideas

Top10 Smart Ideas

Discovering Luffy's TRUE BOUNTY | Grand Line Review

Discovering Luffy's TRUE BOUNTY | Grand Line Review

Build A Track Only Using The Behringer Neutron

Build A Track Only Using The Behringer Neutron

Rekindle Romance - Relight His Fire Subliminal

Rekindle Romance - Relight His Fire Subliminal

Bald Eagle Machine Dyno ROUND 2!!! We Found a MAJOR Boost Problem!! (holding back the freedom?)

Bald Eagle Machine Dyno ROUND 2!!! We Found a MAJOR Boost Problem!! (holding back the freedom?)

The Success Is In Your EFFORT - Give Your ALL - Motivational Video

The Success Is In Your EFFORT - Give Your ALL - Motivational Video

My CAT Decides What I Play on ROBLOX!!

My CAT Decides What I Play on ROBLOX!!

YOUNGBVNK - RIGHT HERE FT. LIL MINRA (Prod. By prxmmm)

YOUNGBVNK - RIGHT HERE FT. LIL MINRA (Prod. By prxmmm)

How To Create a WordPress Blog Like H-educate (Step By Step)

How To Create a WordPress Blog Like H-educate (Step By Step)

15 Earth Like Exoplanets that May Support Life

15 Earth Like Exoplanets that May Support Life

TREASURE - ‘BEAUTIFUL’ [COLORCODED LYRICS KAN/ROM/ENG]

TREASURE - ‘BEAUTIFUL’ [COLORCODED LYRICS KAN/ROM/ENG]

STUCK in THE MUD! How to recover a VERY EXPENSIVE military vehicle with an M984 WRECKER!

STUCK in THE MUD! How to recover a VERY EXPENSIVE military vehicle with an M984 WRECKER!

THE SECTOR - SURVIVE FOR OUR LOiFE

THE SECTOR - SURVIVE FOR OUR LOiFE

Which is never

Which is never

Coverking NeoSupreme Seat Covers - Comfortable And Durable

Coverking NeoSupreme Seat Covers - Comfortable And Durable

You Have a Spending Problem - Grant Cardone

You Have a Spending Problem - Grant Cardone

Nightcore - Unstable (Lyrics)

Nightcore - Unstable (Lyrics)

How To Teach A Child To Read - In Two Weeks

How To Teach A Child To Read - In Two Weeks

John Green reads "Mountain Dew Commercial Disguised as a Love Poem"

John Green reads "Mountain Dew Commercial Disguised as a Love Poem"

Channel Your Preferred Reality

Channel Your Preferred Reality

The Roles and Workflows of Producing, Mixing and Mastering in EDM

The Roles and Workflows of Producing, Mixing and Mastering in EDM

Morning Exercise = Mental Health

Morning Exercise = Mental Health

YIN OLUWA | BELIEVE OZAK (OFFICIAL VIDEO)

YIN OLUWA | BELIEVE OZAK (OFFICIAL VIDEO)

How to Barter after the Economy Collapses

How to Barter after the Economy Collapses

How to "Noodle" on guitar and use it as a way to practice. Guitar practice tips - VLog 3

How to "Noodle" on guitar and use it as a way to practice. Guitar practice tips - VLog 3

Blippi Flies in a Private Jet | Airplanes for Kids with The Airplane Song

Blippi Flies in a Private Jet | Airplanes for Kids with The Airplane Song

Joe Satriani Guitar Lesson - How to Build Melody

Joe Satriani Guitar Lesson - How to Build Melody

เพื่อน...ใหม่ (朋友区) - UTTER KAMIKAZE [Official MV]

เพื่อน...ใหม่ (朋友区) - UTTER KAMIKAZE [Official MV]

Publication types

Publication types

"Recognizing Respiratory Distress" by Monica Kleinman, MD for OPENPediatrics

"Recognizing Respiratory Distress" by Monica Kleinman, MD for OPENPediatrics

Most Ideal Tiny House Size?! Permanent Pocket Neighborhood

Most Ideal Tiny House Size?! Permanent Pocket Neighborhood

TRAMPOLINE FILLED WITH 1000 MEGA WHOOPIE CUSHIONS

TRAMPOLINE FILLED WITH 1000 MEGA WHOOPIE CUSHIONS

"It's MASSIVE!" - Mew2King Analyzes Sephiroth

"It's MASSIVE!" - Mew2King Analyzes Sephiroth

Best of Vicious #1

Best of Vicious #1