How to Make a Sales Dashboard in Power BI - FREE Live Masterclass

Power BI is the most rapidly growing business intelligence and reporting platform in the world. You can easily connect and visualize any data with Power BI, share the interactive insights with your audience and make lasting impact with it.
In this FREE & in-depth masterclass learn:
* How to use Power BI Desktop application - Quick tour
* Analyzing Chocolate Sales data
* Creating and using DAX measures for powerful insights
* Making a sales dashboard page
* Publishing and sharing the dashboard with your audience
* Updating data and refreshing reports
* Next steps for learning and using Power BI in your work
👉👉👉 Sample file & datasets:
===========================
Completed Power BI Sales Dashboard - files.chandoo.org/pbix/demo%2...
Preview the dashboard online - chandoo.org/wp/hwrv
Sample data blank file - chandoo.org/wp/wp-content/upl...
Extra data (to test the refresh process) - chandoo.org/wp/wp-content/upl...
All files and other resources (Now updated) - chandoo.org/wp/powerbi-intro-...
Additional videos you should watch on Power BI:
=======================================
Power Query - deep dive video - • Power Query Tutorial -...
Power Pivot & DAX Intro (Live stream from May 2021) - • Getting started with P...
All my Power BI videos - playlist - • May the Power BI with ...
Channels you should subscribe for Power BI content:
===========================================
​‪@GuyInACube‬ - / @guyinacube
‪@CurbalEN‬ - / @curbalen
‪@MicrosoftPowerBI‬ - / mspowerbi
~~~
More Power to you 💡⚡😍

[@user-fp4md4zs3m]

i cannot watch a video continuously more than 15 minutes, i am wondered i made this at one go, its great sir

[@LearnAccessByCrystal]

thanks, Chandoo. I've watched 30 minutes for now and saved the link to watch the rest later. Really appreciate all you do to share your knowledge ~

[@vijayarjunwadkar]

Thank you so much Chandoo! I could not attend the live session due to timing, but so happy to see this video replay! Wanted to get Power BI knowledge from you always... 😊👍

[@chandoo_]

You are welcome Vijay...

[@afolayanolusegunabraham914]

Chandoo never disappoints. I enjoy all of your training sessions on data analysis. Thank you

[@maduvu]

Thank you for the wonderful session

[@shakeelpbi2062]

Great Session Chandu ji, keep on posting more videos which will help for Beginners and Real-time as well!!

[@tessabio679]

Awesome ! I gonna watch again and again to fully understand all of this, thanks so much

[@chandoo_]

Thanks Thuy... Let me know how it goes once you implement Power BI for some of your data challenges.

[@aadityadixit2075]

Thank you so much chandoo, for this comprehensive tutorial.
I'm Thankful!

[@user-ir6ct3xh3y]

Hello Chandoo. I like your videos on Power BI. They are brief and to the point and very helpful.

[@ndebilitechizoba598]

Thank you Chandoo. This is so impactful 😊
From Nigeria.

[@Firestarter009]

You my first guru, as i started loving excel since 2007 just because of your UA-cam videos 🙏🙏🙏👌

[@9833525861]

Thank you for such a great session of 2 hours. I got some good confidence now to with Power BI. Thanks a lot Chandoo, you are simply grt!!!

[@chandoo_]

Thanks Rajesh. I feel blessed to teach & empower people like you 😀

[@binoythomas2974]

Congrats on attaining 100k subscribers. You are always presenting valuable lessons in an easy to understand and cool way. Thank you

[@chandoo_]

Thank you Binoy. I am glad you enjoy this.

[@payalpayal9154]

Thank you Chandoo, you videos and teachings are very clear and informative.

[@mahmoudmohsen8105]

Thanks a lot for the precious time and for the recommendation. I feel sad for not being able to join the live streams due to being in a different time zone (Egypt) But I enjoy my weekend mornings watching your fruitful long long videos Thanks again and looking forward to more soon

[@priyadcosta46]

You are a rockstar Chandoo, amazing depth and calm & compose in explaining the concept. God bless

[@dayanandarajapakse9476]

Very clear and loud enough 👌

[@RahulSindhwani]

this is just peak channel, everything on point

[@gospelmoto2833]

So kind of you to share your knowledge. Very Helpful. Thanks so much.

[@user-ir6ct3xh3y]

I am from Muscat OMAN. Your videos are real good and worth watching.

[@maruthiraoyarapathineni2012]

Thank you Very much Chandoo Garu. You are Awesome. Worth to spend 2 hours.. Very valuable.

[@Gavsenberg]

Wonderful Session.
Keep up the good work.

[@Larwai]

Hello Chandoo. Accept my Salaam from USA. I learned much from your videos. Thank you

[@sudarshang2500]

good job chandoo! you r helping many people like me, the content which you are providing was very help full. thank you soo much

[@alldaynerio9421]

Thank you Chandoo for all of these Power BI videos! Your videos have helped tremendously! 1 Question though: I still don't really understand why we create a measure for like "Total Amount" when we already have the numbers in the Sum Amount Column. Aren't the backend calculations already there?

[@mvr7297]

Really Valuable, worth watching video and learning many new ideas on Power BI , Thank you Chandoo sir, india

[@banerjeenandan]

Wonderful & Awesome explanation... Learnt a Lot... Thanks Chandoo...

[@bashap8548]

Thank you so much Chandoo

[@hardik7385]

Amazing Thanks !!!This helps to explore more 👍

[@mpsivakumar]

Excellent Video Chandru. Thank you so much

[@natyanaty4170]

Thank you for this informative training, I look forward to your sessions again

[@subhajitnaskar1]

Awesome! Thank you Chandoo!

[@shabbirchandiwala4216]

I have been following your excel videos which are very informative and productive. I must say it is Awesome. Thanks so much

[@chandoo_]

Thank you Shabbir.

[@Samcrazy4u]

You're doing awesome job for helping BI cummunity and adding value to their career and life

[@chandoo_]

Thank Sami...

[@SivaKumar-fv6lk]

Yes it’s clear

[@arnab6154]

​@@chandoo_❤

[@meditubebrand]

Perfect work for Sales and Power bi

[@lifeoftravel535]

Really Nice and Really Beautiful " Make a Sales Dashboard in Power BI in one hour". Stay Connected!😍😍😍🤗🤗🤗

[@shyamnarayan6788]

Thank very much Chandoo

[@dhananjaypinjan2643]

Hi Chandoo.. You're deserving more subscribers.. Heartiest Congratulations🙏🙏🙏

[@chandoo_]

Thanks Dhananjay...

[@mohdsibgatullah5555]

Thanks a lot 🙏 💓...you are helping so many people... great service.

[@chandoo_]

It's my pleasure

[@louvierejacques]

your videos are awesome! thanks for all your hard work.

[@abduljabbar2984]

Thank you so much Chandoo. I missed your Live

[@chandoo_]

No worries. You can catch me next month. I do these last Friday, every month.

[@geetakalyanaraman3534]

Awesome explanation 👌 👏 👏.

[@trainworlds3954]

Sir you doing so good job sir, i don't have enough finances support for paid course ,but you video are the best source of knowledge thanks a lot sir

[@omprakashvishwakarma6307]

Clear & crisp..

[@chandoo_]

:)

[@SivaKumar-fv6lk]

Thank you

[@riteshchouhan7312]

Great sir 👍, amazing

[@manthuribalabala7092]

Thank you so much bro Ind

[@abeerattia4523]

Thanks Chandoo for this lecture, Excellent as usual, Abeer From Egypt

[@chandoo_]

My pleasure

[@Samcrazy4u]

Thanks chando

[@kunalborge5474]

Thanks a ton...

[@surendervadde1123]

Excellent classes sir.

[@kanchan7618]

you are doing awesome Chandoo. God bless.

[@chandoo_]

You are welcome Luvdeep :)

[@aldengraham]

Hi Chandoo! This could be a fun Power BI fun dashboard!

[@mr.benardwesonga9964]

This is a very good video, it has helped me to gain alot of skills.

[@prathapchenna]

chandoo, now its 391k subscribers. congratulations

[@user-gp7kp5jo8e]

thanks for sharing your knowledge

[@adithyavarma758]

thank you sir

[@anitharamesh9721]

Enjoyed your class on Power BI 101, will continue to watch other videos

[@chandoo_]

Awesome, thank you!

[@oumardiakhate15]

Congratulations my brother....... good Job 👍🏾

[@chandoo_]

Thanks Oumar...

[@upskilltoedge9689]

Awesome Sir. You are a true Guru. My problem in Power BI is - How to achieve star schema in excel file ? I wish not to have any database separately and connect power BI to excel only, but facing challenge is establishing multiple relationships.

[@flowdata]

The challenge is through you excel file, analyzing what data explain your tables and once you've understood the data, you have to denormalize the data in the tabular model searching the star schema that would be able to answer the business question. Although sometimes you may build up some star schema that finally becomes a snowflake... but the key it's understanding your data and try to get a model that answer the business questions.

[@gillgarry841]

Bro you are the best. Your videos helped me a lot with my work. Anyway I’m watching this drinking rum 🍹

[@chandoo_]

Cheers 🍹

[@kandhavel4858]

Am your website user and finally I got you in UA-cam as well😀😀😀

[@chandoo_]

Welcome Kandha Vel... :)

[@simuislam5752]

Thanks

[@honnurswamy6292]

Teaching style it's very awesome...chandoo

[@chandoo_]

It's my pleasure

[@basuml7657]

very good question from Cheryl at 1:02:40

[@vijaybhaskarkandula]

Your are videos on powerbi is very good, sir some more live section on DAX function's

[@chandoo_]

Thanks Vijay... Please see my live stream on DAX here - ua-cam.com/video/eCuPRqQNe6Y/v-deo.html

[@ravindradandge5234]

Congratulations 100k subscriber sir

[@ezraasefa2695]

Amazing content!!!

[@chandoo_]

Glad you enjoyed it

[@timrichards5708]

Cheers. Could not make live session. Great to see replay

[@chandoo_]

Thanks Tim. Glad you are able to catch it here.

[@diligentdagger3277]

Thanks!

[@chandoo_]

Thanks DD for the love and super. 😍

[@johnabdou4647]

Thank you for sharing all that valuable knowledge and amazingly comprehensive explanations.. It helps me enjoy my career and be confident in what i do :) what a great job you have!

[@chandoo_]

You are welcome John :)

[@shivkumardhodkunde636]

Thank you For Sharing

[@chandoo_]

My pleasure

[@mkgeidam]

Hey Chandoo, Congratulations with 100k, you deserve more than that, keep it up Thanks.

[@chandoo_]

Thanks Mustapha...

[@Helltrues]

i thought i got an idea intially you have to tell requirements in excel sheet by showing the reqirement and doing project is very understanble

[@pabeader1941]

"Always joining the tables." GROAN!!! ( :) )

[@chandoo_]

How does a table with no friends keep itself busy?
With self joins 🤣

[@rajatvashishtha7472]

Sir I like your vdos please give some more time with us

[@chandoo_]

Thank you Rajat... I am thinking of doing a Q&A live session sometime in June. I will run a poll to see how much interest is there...

[@ImpactHub680]

Yes, I can hear you

[@uwakmfonalexander6946]

Hi Chandoo,
Thank you for your lessons.
You mentioned that you have attached the link to the sample datasheet for our practice, but i cant find it. Can you drop the link here pls.

[@urvindarkaur0278]

Hi, could you please tell me where should I begin as I am a fresher to POWER BI? I started following this playlist and first video (Beginner to pro) felt too fast for me. Should I start from the second video (this video) onwards ? or any other playlist?

[@gopichand5717]

Congratulations sir for 100k

[@chandoo_]

Thanks Gopi...

[@samirsourav6880]

Congratulation for 100k+

[@chandoo_]

Thank you Samir...

[@yogeshbansal7184]

Thanks राम

[@Kaming220]

Hi. Is the Customer column in your file represents the customer ID or the total amount of customer purchasing the product on that one specific date? The 323K doesn't seem to make sense. Good job on the presentation. I learned a lot and this is my first time using Power BI.

[@chandoo_]

Sorry for the confusion Robert. The customer column refers to *number of customers* who are part of the transaction. So 323k is the total of the customers column

[@excellover7172]

Very clear, crystal clear. Which microphone do you use ?

[@chandoo_]

I am using Yeti X mic. See my gear list here - www.amazon.com/shop/chandoo

[@martinbulenda5623]

Hello from DRC

[@rojasgroup6452]

Sir, Thank you so much for the great knowledge share, Request you to help me with creation of employee card, my office 365 donot show structured column

[@jagatkrishna1543]

Whahooo! YES

[@ibrahimokubena3144]

Hi Chandoo, happy new year, please can we have the sample data till December, 2021. I need to update the Power BI report I created after the session.

[@prabandhabiswal903]

Thanks you very mush for the lovely insight.I have started making the similar dashboard by taking the excel sheet shared by you in this video..How ever i am getting deviation in amount (Example Bars : 4685674 but in your PBIX it's 3947762...where exactly am i going wrong).I again thank you for this wonderful video. It really helps.

[@chandoo_]

Hi Prabandha...
Thanks for your comments.
We both are right. When I started the video, we only have data up to 31 May, but towards the end I show how to update the report with new data, so added June data and then the totals change. Hope that helps.

[@prabandhabiswal903]

@@chandoo_ thanks for the clarification.👍

[@Phoenix-wd2qw]

Hi Chandoo
Thanks for the awesome video, Can we reduce the white space around the graphs and left align the header to the graph? Thank you

[@chandoo_]

You can resize and move around the visuals. Header alignment options can be found in the visual format settings.

[@maynardzhu4520]

A greeting from China

[@chandoo_]

thank you so much for your love and super 😍

[@emmanuelemokpae9464]

Nice work, thank you... How did you create the "profit target thumbs up/thumbs down"?

[@chandoo_]

You are welcome. I think that is explained in the video.

[@LearnItSimply15]

How we can publish and share our report as a link to those who are not in our organization and not having power BI account

[@xcellent38]

Thank you! Do you think it is posible to create a stock aging in Power BI?

[@chandoo_]

You are welcome Xcellent.. It is possible, but I would try that with Power Query first. If you have a sample dataset, send it to me (email in the about section) so I can use it for a explanation video in future.

[@sharunkumar4806]

Hello and good day Chandoo,
Greetings from Bangalore.
Please can you make a video on how to transition to Data Analyst in the shortest time when people are working in different domain.
Regards,
Sharun

[@chandoo_]

Hi Sharun... Good idea. I will make a video on this topic.

[@radhakrishnadasari6137]

How can we share that preview powerbi report, if I want to put it in my resume...not the exact one , the report I created.
Thanks!

[@naveenvjdandhrudu5141]

Hi Chandoo garu, I came across a doubt on above video @ 57:00 duration. there is one new column created " But use had used new measure how to create new col using new measeure is new measure, new col are same?

[@hasfiz]

I cannot find options to change the title "Profit Target Met?" to "?" like in the video. I can do it only by changing the measure's name.

[@Vilaskar]

Hi sir
Iam from Hyderabad

[@chandoo_]

Welcome to the replay stream Vilaskar...

[@jagatkrishna1543]

Hi Sir 🙏💕💲😊