How to Analyze Data with Power Query, Power Pivot & Power BI

No video

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

Рет қаралды 54,868

Күн бұрын

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... 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 Playlist on my channel • Power BI Examples, Dem...
Previous live streams and 1+hr videos • FREE Excel + Power BI ...
~
#powerbi

Пікірлер: 89

@astrachconsultants4417 Жыл бұрын

Thanks for Supporting our Learning and Inspiring to be better.

@chandoo_ Жыл бұрын

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

@dunkwutessy2924 8 ай бұрын

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

@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 6 ай бұрын

Hi Chandoo bro Telugu videos cheyandi

@omar0972. Ай бұрын

Hello Sir, I'm from Bangladesh.

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

@canirmalchoudhary8173 Жыл бұрын

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

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

@harishbabu4635 Жыл бұрын

Excellent videos . Learnt much from you sir

@mymatemartin Жыл бұрын

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

@kojosafo4407 Жыл бұрын

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

@sik9802 Жыл бұрын

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

@tobydave8314 3 ай бұрын

hello, Mr. Chandoo, from Nigeria

@zulumedia6374 9 ай бұрын

You are a Master. Thanks!!!!

@hakim6933 Жыл бұрын

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

@joycemonty4262 Жыл бұрын

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

@abhinav10x Жыл бұрын

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

@solomonwaka-fy6we 4 ай бұрын

Thanks bro, from Ethiopia

@reenap2286 Жыл бұрын

Hello Chandoo, I like your interactive, informative session.

@vaitheeswaranviswa3911 Жыл бұрын

Thank you. Very useful for many beginner like me.

@xkanab2 Жыл бұрын

Thank you so much, your channel is insightful.

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

@alexanthony-bf8ee 2 ай бұрын

Hello Chandoo

@andreashermle2716 Жыл бұрын

Yeah Chandoo, you are really great! Fantastic tutoring!

@chandoo_ Жыл бұрын

Thanks a lot for the love :)

@lokeshagarwal6373 Жыл бұрын

Absolutely amazing 😍❤❤

@olugbenga.akinyemi Жыл бұрын

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

@_itsMweiiiiiii 2 ай бұрын

Hello from Kenya

@MuhammadAli-ib4xn Жыл бұрын

thanks u r doing great job thanks

@waqaskhan3325 Жыл бұрын

Love from Pakistan ❤

@ram_qr 9 ай бұрын

awesome explanation

@balamira297 Жыл бұрын

Thanks!

@chandoo_ Жыл бұрын

Thanks for the love and super @balamira297 😍

@lokeshagarwal6373 Жыл бұрын

I am from Assam Guwahati India

@bindaas0406 Жыл бұрын

Chandoo rocks🎉🎉🎉

@piyushnautiyal6271 Жыл бұрын

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

@chandoo_ Жыл бұрын

Always welcome

@Saad.PS2009 Жыл бұрын

Thank you so much

@balamira297 Жыл бұрын

Thank you so much sir 😊

@pavankumark9025 Жыл бұрын

Hi Chnadoo it's I'm Visakhapatnam

@mahmodi5timetolearn Жыл бұрын

Proud of you from Italia

@chandoo_ Жыл бұрын

😍

@baburajbaburaj8590 7 ай бұрын

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 😁

@bilalyusaf7822 Жыл бұрын

excellent session 👏

@chandoo_ Жыл бұрын

Glad you liked it!

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

@user-lh9we2dd4v 6 ай бұрын

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

@uwakmfonalexander6946 11 ай бұрын

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 11 ай бұрын

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.

@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 :)

@SoumyaPal-xm9ig 8 ай бұрын

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_ 8 ай бұрын

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 8 ай бұрын

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

@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

@jatinkashyapp 6 ай бұрын

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

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

@joycemonty4262 Жыл бұрын

I love coffee.

@chandoo_ Жыл бұрын

☕=😍

@abhinav10x Жыл бұрын

Map is not showing in my Power BI, please advise

@baburajbaburaj8590 7 ай бұрын

Baburaj first time using power bi

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

@aliemmanuel8233 Жыл бұрын

Hello

@trueonlytruth1527 Жыл бұрын

@emilyenyi7666 2 ай бұрын

Hello, can see you have been indoors for sometime. Wishing you fast recovery

@pavankumark9025 Жыл бұрын

Hi how are u oral. Fixation dental manipulation.

@deviprasadp8703 Жыл бұрын

Sir Please make same video in Telugu

@perfectionist6624 Жыл бұрын

learn english.. 😵‍💫

@mahendragupta9599 Жыл бұрын

your voice is very low

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