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

[@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]

Underrated comment

[@sathvikagoud2968]

😂😂

[@KathyMucher]

😄

[@cihankenar1]

Bravo, sir.

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

[@julianoviedo]

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

[@sj1795]

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

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

[@_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.

[@rohitsawant5805]

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

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

[@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 😊

[@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.

[@livewhilealive]

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?

[@chinuzoejima8971]

i just started the bootcamp and i'm enjoying every bit of it thank you so much alex

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

[@MarjanR77]

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

[@goon5031]

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

[@Kikkerv11]

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.

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

[@rashmikrishnamohan1736]

Been waiting for this ✨ Thank you

[@annashi5555]

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

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

[@San_Martin_Rubi]

Great tool!!! Thank you very much!!! An easy and simple way to start learning about this amazing tool.

[@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

[@davidbrown3168]

The reason you are Alex the Analyst. Thank you

[@alexfilo7929]

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

[@sajibislam3281]

Thank you so much alex.. You are a gem ✌️

[@jacobhadida4400]

Love the video, waiting for the rest! thank you

[@niltondiaz7945]

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

[@justo7417]

Great tutorial, cheers buddy 👌

[@yewandealakija-banjo4944]

Learning big time. Thanks Alex

[@gebrilaboubakr8402]

Amazing as usual.👌👏

[@NixonBranch]

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

[@willymwangi3865]

Thank you so much for sharing this powerful information.

[@syedhassan1985]

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?

[@VigneshViki143]

Waiting for this... Thank you so much Alex

[@goomyworms3130]

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

[@Rant-gb1zz]

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

[@juanete69]

Good tutorial. It would be nice to have higher resolution.

[@wanyangqiao9829]

Thanks for sharing your knowledge and effort.

[@andhuuy]

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

[@JOANNNEOMA-m1j]

The other columns are not in the downloaded excel

[@steveep1983]

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?

[@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.

[@marecare987]

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

[@Vikram_8621]

Great video! Thanks Alex!

[@jadlteif8143]

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

[@RitaElkhayal]

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.

[@kghazi123]

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!

[@WorkJob-g3o]

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

[@danielkopfli3965]

You’re really good! Thanks a lot!

[@crowlsyong]

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.

[@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

[@СергейКондулуков-з9ч]

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

[@salmashahamiri2335]

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

[@DPEART6475]

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.

[@ayodejianibaba288]

Thanks again Alex 😊💯

[@juanochoa4005]

Great video. Thanks

[@AnastasiaFreeland]

very helpful thank you

[@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.

[@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?

[@shedrachkambai5787]

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]

Its okay, I found it, Thank Alex.

[@harzenly]

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

[@shedrachkambai5787]

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

[@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

[@damacandcheese]

Amazing!

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

[@vicrattlehead9282]

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?

[@Kenkaneki007q]

Hello, I am having a problem. I cannot do the Count Disctinct value for DATA TYPE "TEXT" inside the Transformation Data model. The option for statistics is not accessible for TEXT type data. Available only for Whole number, currency and number. Any solution? Because of the tutorial Im watching, they are not telling me about the solution. Themks!

[@kvelez]

Excellent.

[@mushtaqahmed2409]

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

[@jayashukla4799]

Thanks for this.

[@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.

[@johnprechious8367]

Can we get access to the data you are using ?

[@majesticsentinel2482]

It's in the description

[@Democracy_Manifest]

Quality content

[@mariano37531]

why my powerbi does not recognize the row and columns as it should be ? mine says COLUMN1 instead of sum of rice. how can i fix it so it can be imported correctly?

[@meomeo7616]

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

[@aysoodab8933]

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

[@chrissarong9070]

Thank you !!

[@khaledhamadi7720]

thank you so much

[@AnishaPriyadharshniR]

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

[@AbolfazlMohammadpour-ky2vl]

Great!

[@agbamlincoln995]

Where’s the document to download

[@hozifah8]

alex please there are 4 videos are hidden in this playlist

[@romeowhiskey1146]

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.

[@sanjaydsouza7123]

i am not able to download the file . Please Advice

[@odracir3300]

the file doesn't contain 3 sheets, only one !! :(

[@eslamsh3ban359]

7 unavailable videos , Please check it Alex

[@AlexTheAnalyst]

Those are queued up to be released in future weeks

[@daviddguy6885]

@@AlexTheAnalyst Please I can't wait. #1 fan. any time range.

[@samuelraj5613]

Done

[@CoachStaci]

Is apocalypse really all you can think of? Seriously?