How to Analyze Data with Power Query, Power Pivot & Power BI - Free Masterclass

Join me for a Live Masterclass on Power Query, Power Pivot & Power BI.
We are going to look at a real-life dataset and analyze it using Power BI to answer 5 business questions. Sample data will be provided.
📁 Sample Data File:
Grab the sample data file here chandoo.org/wp/wp-content/upl... if you want to follow-along.
⏱ Video Topics:
==============
0:00: Welcome, hellos & stream formalities
14:23: What we are going to learn (topics and quick demo)
23:34: Data load and EDA with Power Query
28:50: Power BI internal architecture and how it works
33:25: Data Cleansing and EDA in Power Query (contd.)
50:33: Writing measures with DAX and using Power Pivot
1:02:45: How to use Power BI themes to speed up your workflow
1:08:00: Creating maps in Power BI
1:14:30: Creating MEDIAN in Power BI DAX
1:16:30: Using visual filters
1:22:28: Using CALCULATE to get Apartment %
1:30:00: Average distance measure
1:32:00: Demo of the final workbook
1:34:40: Tricks to make your Power BI Tables BEAUTIFUL 💄
1:43:00: Q&A with lots of little Power BI / Power Query / Power Pivot tricks
📺 WATCH other Power BI videos
============================
💥 My Power BI Course - Full length course on Power BI + Power Query + Power Pivot - chandoo.org/wp/power-bi-course/
Power BI Playlist on my channel • Power BI Examples, Dem...
Previous live streams and 1+hr videos • FREE Excel + Power BI ...
~
#powerbi

[@astrachconsultants4417]

Thanks for Supporting our Learning and Inspiring to be better.

[@chandoo_]

You are welcome. Thanks for this super @astrachconsultants4417. 😍

[@tobydave8314]

hello, Mr. Chandoo, from Nigeria

[@dunkwutessy2924]

one very important thing you do that makes you stand out from others is the fact that you always include data to work with as thanks for doing that in all of your video i am a big fan of you thanks so much

[@andrewdove342]

One of the most enjoyable things with your content is that it feels non-intimidating and comfortable for anybody to follow, because you are down to earth and real person, thanks Chandoo!

[@chandoo_]

Wow, thank you!

[@lokeshagarwal6373]

Indeed Sir

[@sik9802]

This is another great workshop as always. Thanks for the streaming!

[@hakim6933]

Thank you for your classes! These are excellent learning materials!

[@user-gh3kn1bx8r]

This is my first time watching you live. I have followed you off and on since 2007. You have a wonderful and unique approach to making your teaching style easy to follow.

[@xkanab2]

Thank you so much, your channel is insightful.

[@vaitheeswaranviswa3911]

Thank you. Very useful for many beginner like me.

[@MuhammadAli-ib4xn]

thanks u r doing great job thanks

[@canirmalchoudhary8173]

This is nice live stream covering power query, power pivot and Power BI,

[@zulumedia6374]

You are a Master. Thanks!!!!

[@abhinav10x]

Awesome learning, thank you sir for this valuable session!!

[@harishbabu4635]

Excellent videos . Learnt much from you sir

[@lokeshagarwal6373]

Absolutely amazing 😍❤❤

[@theoopitoke6395]

Sir, for some reason, I feel I'm not worthy of the enormous knowledge of Excel and PowerBI you keep providing for FREE on a consistent basis. I pray you will always receive the blessings you deserve.

[@chandoo_]

😊 Thank you. But don't forget to pass the torch along. Help others and share the power when you are in a position.

[@manikyash169]

You are amazing Chandoo Loads of love May God bless you Abundantly

[@theoopitoke6395]

Yes, I will live to pass on the knowledge. Such an inspiration!@@chandoo_

[@naveenvjdandhrudu5141]

Hi Chandoo bro Telugu videos cheyandi

[@reenap2286]

Hello Chandoo, I like your interactive, informative session.

[@mymatemartin]

Hi Chandoo, your work is always amazing and I appreciate so much the help you provide.

[@olugbenga.akinyemi]

Hello Chandoo, Great fan of your work 👍👍👍👌👌👌

[@RobynLynn07]

Thank you, Chandoo! I’ve got braces and it can be miserable - so happy you decided to host this live 💕 hopefully you can get some wax to cover the pointy wire bits?

[@chandoo_]

I did that when the wires got too pointy. This month it is better (so far).

[@balamira297]

Thank you so much sir 😊

[@andreashermle2716]

Yeah Chandoo, you are really great! Fantastic tutoring!

[@chandoo_]

Thanks a lot for the love :)

[@solomonwaka-fy6we]

Thanks bro, from Ethiopia

[@kojosafo4407]

Hello Chandoo I am Kojo. I enjoyed the insights on exploratory data analysis by clicking on view

[@joycemonty4262]

Hello, Chandoo, I am in Louisville, Kentucky, USA.

[@MrOsaleh]

Hi Chandoo Great video from an amazing tutor. Thank you so much, you really provide a great help for me. Osama Saleh From Egypt.

[@Saad.PS2009]

Thank you so much

[@waqaskhan3325]

Love from Pakistan ❤

[@bindaas0406]

Chandoo rocks🎉🎉🎉

[@ram_qr]

awesome explanation

[@balamira297]

Thanks!

[@chandoo_]

Thanks for the love and super @balamira297 😍

[@piyushnautiyal6271]

Really fantastic session.. learnt many new things.. thanks chandoo for supporting us 👍👍

[@chandoo_]

Always welcome

[@mahmodi5timetolearn]

Proud of you from Italia

[@chandoo_]

😍

[@lokeshagarwal6373]

I am from Assam Guwahati India

[@pavankumark9025]

Hi Chnadoo it's I'm Visakhapatnam

[@bilalyusaf7822]

excellent session 👏

[@chandoo_]

Glad you liked it!

[@baburajbaburaj8590]

Hi baburaj from Dubai

[@KimYooNaa]

Hi Chandoo! Already I am seeing improvements with your braces, your teeth seem more aligned. Keep it up 😊 Greetings from Romania 🇷🇴

[@chandoo_]

Thank you so much 😁

[@user-zu9qu5cz7m]

sir i dont have any IT experience coz i have prepare for govt exams so many yrs , now i want to come in to power bi ,in fact i have learn salesforce but its coding so i di not get interested but i have got intrest in POWER BI after lesion your classes. sir what else shoud i learn to get a job by put 3 yers of exp ?? plz help me

[@parassharma7989]

Hello Chandoo

[@bobwatkins1271]

Consider posting 4K videos; they would make the spreadsheets more readable.

[@chandoo_]

Sure bro.. all the edited videos are at HD quality. Live stream maxes at 720p for now.

[@uwakmfonalexander6946]

Hi Chandoo, thank you for your lessons. Alex from Nigeria. Okay, why is it that i can only apply only 1250 rows of queries only from my power query editor to power bi report, out of 3100rows that were imported?

[@uwakmfonalexander6946]

N/B: I had used the format on the lower left to include the entire list, instead of the top 1000 default setting. Yet it still loads 1250rows only to my PowerBI Report app.

[@onkardeokar5616]

Please make course on how to become data analyst

[@chandoo_]

I did. See chandoo.org/wp/excel-school for Excel and chandoo.org/wp/power-bi-course/ for Power BI

[@josealejandro711]

Came for the knowledge, stayed for the dad jokes.

[@SoumyaPal-xm9ig]

Hey Chandoo! your videos are truly awesome and really helped me grow professionally. I am facing an issue with Pivots linked to to a data model and was hoping if you can help me. So the pivot is linked to a data model in excel and has subtotals in the layout of the pivot. When I double click to drill down at the subtotal level it gives me the entire dataset and not the data related to the subtotals. For example, If I have 1000 lines in the entire dataset and the subtotal is related to 100 lines out of 1000. the drill down at subtotal does not show be 100 but shows be 1000 records. I am using office 365 and this issue is showing up across our team and not just me. It will be greatly appreciated if you can help me out in this.

[@chandoo_]

Thank you Soumya.. Unfortunately, that is the only behaviour when you use data model pivots. I do not recommend using the "double click" drill down feature for this reason. If you want to show underlying records for some report, I suggest creating another pivot that has all the data (you can use a unique ID on the row-labels and put rest of the fields in values or rows). Then set up a slicer to drill into this pivot to see items for selected category.

[@SoumyaPal-xm9ig]

@@chandoo_ Thanks a lot Chandoo. I will definitely try this out!

[@user-gh3kn1bx8r]

When you do a podcast, do you think you would invite Leila Gharani, Kenji Explains or Danny Rocks?

[@chandoo_]

That is the plan. Let's see if we can get them on the show :)

[@jatinkashyapp]

can someone tell how to make bar chart of how many bedrooms by house count?

[@user-lh9we2dd4v]

Hi I am Watching Today , But picture quality is not too clear

[@abhinav10x]

Map is not showing in my Power BI, please advise

[@joycemonty4262]

I love coffee.

[@chandoo_]

☕=😍

[@adaparachana7182]

bro help me to download powerbi in macbook pro trying from 4 days but its not installing and not finding power websites

[@chandoo_]

Power BI is not available on Mac. Use PC or parallels.

[@adaparachana7182]

@@chandoo_ bro I want to learn full course could u please release full course covering all topics if u have any please share me bro I can easily understand ur way of teaching I can share my email address

[@chandoo_]

Sure. Here is the course page - chandoo.org/wp/power-bi-course/

[@baburajbaburaj8590]

Baburaj first time using power bi

[@aliemmanuel8233]

Hello

[@trueonlytruth1527]

Hi

[@pavankumark9025]

Hi how are u oral. Fixation dental manipulation.

[@deviprasadp8703]

Sir Please make same video in Telugu

[@perfectionist6624]

learn english.. 😵‍💫

[@jameszack7158]

don't bother yourself learning these brain-exhausting stuff. become good friends with important people and they will give you good positions with high salaries, even if you are unskilled. it's called "networking".

[@chandoo_]

Someone is bitter...

[@mahendragupta9599]

your voice is very low

[@sahitidevata1127]

How can i contact u