How to Analyze Data with Power Query, Power Pivot & Power BI - Free Masterclass
ฝัง
- เผยแพร่เมื่อ 27 ก.ค. 2023
- 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 - บันเทิง
Thanks for Supporting our Learning and Inspiring to be better.
You are welcome. Thanks for this super @astrachconsultants4417. 😍
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
Thank you for your classes! These are excellent learning materials!
This is another great workshop as always. Thanks for the streaming!
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.
Thank you so much, your channel is insightful.
Excellent videos . Learnt much from you sir
Thank you. Very useful for many beginner like me.
You are a Master. Thanks!!!!
This is nice live stream covering power query, power pivot and Power BI,
Awesome learning, thank you sir for this valuable session!!
Hi Chandoo, your work is always amazing and I appreciate so much the help you provide.
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!
Wow, thank you!
Indeed Sir
Absolutely amazing 😍❤❤
thanks u r doing great job thanks
Hello from Kenya
Hello Chandoo, I like your interactive, informative session.
Thanks bro, from Ethiopia
Hello, Chandoo, I am in Louisville, Kentucky, USA.
Hi Chandoo
Great video from an amazing tutor. Thank you so much, you really provide a great help for me.
Osama Saleh From Egypt.
Yeah Chandoo, you are really great! Fantastic tutoring!
Thanks a lot for the love :)
Hello Chandoo, Great fan of your work 👍👍👍👌👌👌
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?
I did that when the wires got too pointy. This month it is better (so far).
Thank you so much sir 😊
hello, Mr. Chandoo, from Nigeria
awesome explanation
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.
😊
Thank you. But don't forget to pass the torch along. Help others and share the power when you are in a position.
You are amazing Chandoo
Loads of love
May God bless you Abundantly
Yes, I will live to pass on the knowledge. Such an inspiration!@@chandoo_
Hi Chandoo bro Telugu videos cheyandi
Thank you so much
Hello Chandoo I am Kojo. I enjoyed the insights on exploratory data analysis by clicking on view
Chandoo rocks🎉🎉🎉
Hi Chnadoo it's I'm Visakhapatnam
Thanks!
Thanks for the love and super @balamira297 😍
Really fantastic session.. learnt many new things.. thanks chandoo for supporting us 👍👍
Always welcome
Hello Chandoo
Proud of you from Italia
😍
Hi baburaj from Dubai
I am from Assam Guwahati India
Love from Pakistan ❤
excellent session 👏
Glad you liked it!
Hi Chandoo! Already I am seeing improvements with your braces, your teeth seem more aligned. Keep it up 😊 Greetings from Romania 🇷🇴
Thank you so much 😁
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
Consider posting 4K videos; they would make the spreadsheets more readable.
Sure bro.. all the edited videos are at HD quality. Live stream maxes at 720p for now.
can someone tell how to make bar chart of how many bedrooms by house count?
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?
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.
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.
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.
@@chandoo_ Thanks a lot Chandoo. I will definitely try this out!
Please make course on how to become data analyst
I did. See chandoo.org/wp/excel-school for Excel and
chandoo.org/wp/power-bi-course/ for Power BI
When you do a podcast, do you think you would invite Leila Gharani, Kenji Explains or Danny Rocks?
That is the plan. Let's see if we can get them on the show :)
Hi I am Watching Today , But picture quality is not too clear
Came for the knowledge, stayed for the dad jokes.
Map is not showing in my Power BI, please advise
I love coffee.
☕=😍
bro help me to download powerbi in macbook pro trying from 4 days but its not installing and not finding power websites
Power BI is not available on Mac. Use PC or parallels.
@@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
Sure. Here is the course page - chandoo.org/wp/power-bi-course/
Hello
Baburaj first time using power bi
Hi
Hi how are u oral. Fixation dental manipulation.
Hello, can see you have been indoors for sometime. Wishing you fast recovery
Sir
Please make same video in Telugu
learn english.. 😵💫
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".
Someone is bitter...
your voice is very low
How can i contact u
Hello Chandoo