No video :(

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

Подписаться 843 тыс.

Просмотров 322 тыс.

50% 1

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.
Download Microsoft Power BI: powerbi.micros...
Download Apocalypse Dataset: github.com/Ale...
Favorite Power BI Courses:
Power BI for Business Intelligence - bit.ly/3Nfi59i
Power BI A-Z - bit.ly/3MkpYKw
____________________________________________
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:
📖Google Data Analyst Certification: coursera.pxf.i...
📖Data Analysis with Python - coursera.pxf.i...
📖IBM Data Analysis Specialization - coursera.pxf.i...
📖Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
📖Python for Data Analysis and Visualization- bit.ly/3hhX4LX
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
🙌Patreon Page - / alextheanalyst
💻Alex The Analyst Shop - teespring.com/...
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/Ale...
📱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

Опубликовано:

18 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 93

@nnymod Год назад

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

@mphomacamo386 Год назад

I see what you did there 😅

@simonlomas2126 8 месяцев назад

Underrated comment

@sathvikagoud2968 8 месяцев назад

😂😂

@KathyMucher 6 месяцев назад

😄

@cihankenar1 5 месяцев назад

Bravo, sir.

@LukeBarousse 2 года назад

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!

@julianoviedo Год назад

Any chance for the two of you doing a colab? Alex and Luke.

@szklydm 2 года назад

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!

@_the_ordinary_ 2 месяца назад

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.

@sj1795 8 месяцев назад

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 😊

@malcorub 2 года назад

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!

@Mr_Buckle 2 года назад

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.

@rohitsawant5805 2 года назад

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

@Kikkerv11 28 дней назад

For anyone who is confused why the end result is better and how to know that: your end goal should always be to have one column per variable (product, supermarket, date, price) and one row per observation. This is a good practice in Power BI, Python, R etc. Why? Because normally any data can be stored like this, it's universal and simple.

@florence3701 Год назад

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!!

@goon5031 Год назад

Tip for everyone. You can remove a column by right-clicking the column and selecting remove column.

@MarjanR77 5 месяцев назад

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

@livewhilealive 4 месяца назад

Hi Alex, thank you so much for the video, just got one question, if I have like 9 different excel table sheets, how can I generate a power query then and to export into the power BI?

@gilangsatriya3027 Год назад

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

@taihornsby2480 Год назад

Hey Alex! Big fan of your work, you've helped me tremendously in my career the past 6 months. Wanted to help you out and mention that you mispelled "Apocalypse" btw. There's an 'A' in the middle and not an 'O'. Thanks for what you do man! 😊

@AlexTheAnalyst Год назад

You're probably 100% correct - I am not good at spelling and this has been shown time and time again on my channel lmao I will never learn

@elmago1298 Год назад

Another great video, Alex!! THANKS!!!

@annashi5555 2 года назад

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

@niltondiaz7945 8 дней назад

Really though Power Bi was complex but its not. Great vids!

@jacobhadida4400 2 года назад

Love the video, waiting for the rest! thank you

@alexfilo7929 2 года назад

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

@yewandealakija-banjo4944 Год назад

Learning big time. Thanks Alex

@rashmikrishnamohan1736 2 года назад

Been waiting for this ✨ Thank you

@selim.vidangos 11 месяцев назад

Great video! Good examples, it is very clear explanation

@syedhassan1985 4 месяца назад

The video is great like all others that you make. There are store-wise totals in the table in the final product. How would we manage those if it was a real-world scenario?

@adekunleojo7328 Год назад

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?.

@willymwangi3865 Год назад

Thank you so much for sharing this powerful information.

@justo7417 2 года назад

Great tutorial, cheers buddy 👌

@user-zx3xg5jp1o 11 месяцев назад

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

@steveep1983 29 дней назад

Nice video. Can these data transformation steps be reproduced as you might with a record a macro in excel, or do you need to do them manually each time?

@apbosh1 Год назад

Hi Thanks, I'm just entering the BI world (after many years of excel/vba) what happens if you get that data every month, you have to do this every month? or the query editor will apply steps when you change the data source? and will it error if something becomes not compatible e.g. someone moves a column or changes datatype in the excel template

@Rant-gb1zz 7 месяцев назад

Alex, thank you so much for the video. But what did you do about the error in the attribute column?

@user-nr8ts9rg5x 7 месяцев назад

The other columns are not in the downloaded excel

@robin29110 Год назад

Hi Alex, You create great helpful content! I need your suggestion on the following situation. I maintain an excel of my client's campaign performance on google ads. I wanted to make a dashboard and automate it so that the dashboard keeps updating on a daily basis. Can you please suggest how to go about it? Want to use Tableau.

@crowlsyong 2 года назад

Hey, I appreciate you and the work you contribute freely to the world. Also your audio sounds a little funky, like it's compressed or a noise reduction thing is mucking it up just a bit. Not huge, just thought I'd point it out.

@wanyangqiao9829 Год назад

Thanks for sharing your knowledge and effort.

@kvelez Месяц назад

Excellent.

@user-zq6cp7lh3s 7 месяцев назад

Thank You Alex! May God Bless you in Jesus Name!

@VigneshViki143 2 года назад

Waiting for this... Thank you so much Alex

@goomyworms3130 2 года назад

Hey Alex, do you think you can make a video doing a project with Power Bi? Thanks!

@gebrilaboubakr8402 2 года назад

Amazing as usual.👌👏

@danielkopfli3965 Год назад

You’re really good! Thanks a lot!

@notransfat1 Год назад

Super helpful video. But.... I find the mouse pointer you use hard to find when I'm trying to follow along -- small, white on white with gray outline is hard to see. Maybe you could change the settings -- enlarge it, invert colors, or use yellow highlighted pointer. Just an idea. Thanks!

@jadlteif8143 2 года назад

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

@andhuuy 9 месяцев назад

Hi Alex, thank u for the very useful tutorial. but i have a question. in this video, the first dataset doesn't have "month" on the first sheet, how does it appear on pivot table? is there a way to do it? thank u

@kghazi123 2 года назад

Hello Alex. Sorry to ask questions outside the video content. I have two questions regarding Google Data Analytics: 1. The capstone course requires external data to use, or they provide data to work on it? I am asking this since I cannot access company data and its highly confidential too. 2. The public version of tablue is suffient to use it for the course? Thanks in advance!

@user-qh5fr3yo1w 4 месяца назад

Алекс видео супер. Учусь по ним.

@Vikram_8621 2 года назад

Great video! Thanks Alex!

@RitaElkhayal 3 месяца назад

Hello Alex! I have a question when it comes to having "null" in the date column, How can I replace it to be blank? Looking forward to your comment.

@marecare987 2 месяца назад

Hello Alex, I have one question. How did you get Purchase Overview table? Tnx!

@damacandcheese Год назад

Amazing!

@salmashahamiri2335 6 месяцев назад

Hello,where can I find the excel file that you are working on it in the video?

@DPEART6475 5 месяцев назад

Under the video it says when the video was uploaded you will see more click on that and there is a link to download the excel file...hope this works for you.

@khaledhamadi7720 11 месяцев назад

thank you so much

@ayodejianibaba288 2 года назад

Thanks again Alex 😊💯

@oluwaseunjames6502 Месяц назад

Good Job sir. Sir, the data set you used in this video is not among the data set. Please how am i going to get this data set you used in this video Thank You

@jayashukla4799 2 года назад

Thanks for this.

@chrissarong9070 Год назад

Thank you !!

@vicrattlehead9282 22 дня назад

Only for me Power BI seems so tedious compared to Tableau? Alex could you do the material explaining exactly what are the scenarios in real life that would make you use one over the other?

@mp2401 Год назад

Can you explain why using fixed decimal number instead of decimal in your video. I don't understand the difference between them. Thank you.

@Democracy_Manifest 10 месяцев назад

Quality content

@ponnilaxmi2127 Год назад

@alex the analyst when I import the excel data to PowerBI, the comma changes to dot and vice versa, i.e. to my regional settings(Germany) any help here

@shedrachkambai5787 2 месяца назад

On the second video, how did you come up with the pivot table, it was not there from the Excel sheet, the excel was just row data.

@shedrachkambai5787 2 месяца назад

Its okay, I found it, Thank Alex.

@harzenly 12 дней назад

@@shedrachkambai5787 how did u find it, having the same issue!

@shedrachkambai5787 12 дней назад

@harzenly if you download the datasets, Alex already separated it already, check the datasets we are to download

@mohammeda3812 Год назад

Thanks Alex, one question; I have a dataset and created a dashboard from that dataset, but there was a need to add some columns and rename a few columns in the excel sheet (dataset), when i press the refresh button; the message says there is an error because of adding columns and not matching the names! is there anyone to guide me through how to deal with this issue? thanks.

@aaizamerchant9356 Год назад

Add the columns in the excel sheet itself.

@aysoodab8933 Год назад

I can't fine this new file that you use it in this video. could you please help me?

@meomeo7616 6 месяцев назад

How to add a column to data (Excel) and refesh data on Power BI but no change in visual or non-error

@mushtaqahmed2409 Год назад

Can I get link to download this Data, so that I can practice it to arrange it.

@Its.Azaria Год назад

How was the table created in the “purchase overview” tab in the excel worksheet?

@majesticsentinel2482 Год назад

It was like that from the get go, check the link to the file in the description.

@sdlfjlsdirnsfsi232qrlfn Год назад

I have the same question like how was it made?

@AnishaPriyadharshniR 5 месяцев назад

I am unable to see the various sheets in the file shown in this video not sure why

@hozifah8 2 года назад

alex please there are 4 videos are hidden in this playlist

@romeowhiskey1146 11 месяцев назад

Viewers will find your steps EASIER if you CHANGE the SIZE and COLOR of your CURSOR. YELLOW is very easy to see on the screen. A little LARGER would also be great.