How to use Power Query in Power BI | Microsoft Power BI for Beginners

In this series we will be walking through the basics of Microsoft Power BI. In this video we will be walking through how to use the Power Query Editor in Power BI.

Favorite Power BI Courses:
____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:29 Looking at the Data
1:45 Load data into Power Query
2:32 Power Query UI
5:26 Removing Rows
6:17 Changing the Headers
6:49 Changing Data Types
8:00 Removing Rows with "x" Value
8:58 Removing Columns
9:25 Pivoting/Unpivoting
12:15 Saving Transformation
12:44 Outro

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[nnymod]

Great video, thanks. You did misspell apocalypse but it's not the end of the world.

[LukeBarousse]

Power Query is such a game changer for Power Bi (and Excel)... once you realize the "power" in bringing in data with this tool you'll never look back (For reference, I used to copy and paste excel files into a single excel file... 🤦🏼‍♂ lolz)
Thanks for sharing this, Alex!

[szklydm]

Aaah, this brings back memories of the good old days when I discovered the power of Power BI and Power Query. Even though I've been using them for the past 2 years, I found this content thoroughly enjoyable. Thanks Alex!

[sj]

I took a Power BI certification course a few months ago. It was super dry and brain numbing. But now that I'm following along your Power BI series I can really see the value and fun in using this tool. As always, THANK YOU ALEX!!

[lisamgreenleaf]

I've been learning the basics of power query and power BI. It was great to follow this along and understand it to the level I'm at, imbedding my learning 😊

[_the_ordinary_]

I like your approach, you take a messy table an show us step by step how to deal with it! Thanks a lot! I did Power BI course a few months ago but haven't been using it at all, so this was a great refresher for me.

[malcorub]

This is one of the things Power BI Desktop beats Tableau Desktop at, the embedded ETL tool Power Query. Sure there is Tableau Prep for data cleaning, but I believe it is a separate tool. Nice video Alex!

[rohitsawant]

Thank you Alex for starting Power BI series. Eagerly waiting for your videos. Tableau series was very helpful, keep up the good work.

[florence]

I love this, these tools especially Tableau and Power bi, are reminding me of using Excel, though advanced of course but its awesome because it takes alot of fear out of learning something new for me lol Thank you Alex!!

[Mr_Buckle]

Hi Alex,
Could you please make a video explaining real-life projects that you perform at work? I would like to have rough idea what projects are carried out in the healthcare industry.

[gilangsatriya]

I used to work with Tableau as BI Analyst but kinda curious about how Power BI differents with Tableau, makes me excited!

[jacobhadida]

Love the video, waiting for the rest! thank you

[zxxgjpo]

You are very good! Thank you, a great refresher video!. Learning big time. Thanks Alex.

[annashi]

Than you Alex! It is really helpful and I am looking forward to see you in next video !

[MarjanR]

Thank you for your great teaching . the way you teach is really understandable. you are a perfect teacher.

[elmago]

Another great video, Alex!! THANKS!!!

[alexfilo]

You should create a video specifically about portfolio projects. What type of projects you should do how to find data for them.
Feel like you talk about portfolio projects a ton within other videos but should make 1 just dedicated to that

[jadlteif]

You are very good! Thank you, a great refresher video!

[adekunleojo]

Thanks Alex but how do we treat the null values in the product_cost column? Are we going to remove it or just leave it there?.

[VigneshViki]

Waiting for this... Thank you so much Alex