FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files 📁)

[@lovesonmukombiwa9979]

Thank you Chandoo, you are helping a lot of people to be honest, this is good , you are saving our jobs at workplaces out there

[@AP-eb8hd]

I echo this..

[@nikhilm7556]

This was an excellent tutorial video.... 1 thing i would like to add is.... While preparing a PBI report... I would like to consider the color theme which will relate to the organizations LOGO etc. For e.g. : If we are preparing a report for a chocolate company, then we need to consider brown color accents which will appeal more to the audience. Just a thought from my end..... Its an individual choice at the end 🙂

[@chandoo_]

Great point! Branding is definitely something to keep in mind while designing reports. 🙂

[@rameshep2633]

This was extremely helpful, covering all essentials for PBI Dashboard. I have never come across with such a detailed and simplified project demo. Moreover nicely explained. Learned a lot from this single project. Thanks a lot.👍

[@adrianagonzalez9951]

This is the best Masterclass video that I've found because of the amount of tips, tricks and topics covered in one single project. I've learned way more in this 2 hours than watching tons of videos about particular topics, that then I struggle to compile and put in practice. Thank you so much, please keep doing this type of videos (full projects build from cero). I have a couple of doubts Why do we store the values in variables for the formula of the Mom Change % instead of using directly DIVDIDE (Total Sales - Total Sales (prev month), Total Sales (prev month)? I was not able to change the color of the line chart, it only changes the view where all lines are shown. Little suggestion: Please don't accelerate the video when you enhance the visuals. It is useful to see how you make them look from beautiful to even more beautiful.

[@madhusudhanreddyt2838]

if you store the values or the results in a variable, it will avoid repetitive calculations or re calculations (reduces the time it takes to load the data)and helps us in debugging the dax code easily and helps us in breaking the complex code into bits so that it provides better readability

[@shubham7564]

Functions Learned 1) LastDate 2) FirstDate 3) Calculate 4) Related 5) Divide 6) Edate 7) If 8) Var + Return Features Learned 1) How to create bins 2) How to create parameters/dynamic visual based on slicer 3) How to create Bookmark+Selection switch functionality 4) Learned to use new cards, with reference values (Design option for separate formatting) 5) Gauge with Target setting 6) Learned Zoom slider 7) Image insertion in a table 8) Icon creation in tables, based on performance indicator column made with help of If function 9) Learned to create tooltip Other things that I learned 1) Modeling 2) Observed how multiple tables got picked from same excel file in one go 3) Use of Icons 4) Visually appealing slicers on left panel

[@hairavyadav6579]

When I start power bi .... I think what is var and return in power bi i think I not able perform dax using this var or return but when watch this video it's clear and so simple.... Thanks a lot❤

[@SANDATA764]

Wow, what an amazing project, full of insights and knowledge. It took me nearly half a day to follow along and replicate it, but it was worth every minute. Kudos to you for always being one step ahead. I look forward to more practical projects like this one. Thank you very much, Chandoo. You are an awesome mentor. Salute to you.

[@RehanShaikh-em4xu]

Bro where are the logo links given which are used in the video in the headers?

[@vvnseryl]

Thank you chandoo anna , you covered many topics in just this one single project. Very helpful for freshers .. Thank you

[@jayasuriyaa.d.7018]

I started creating dashboard along with u and it's amazing

[@sachinsbabar2231]

Chandoo Sir, You are Awesome, I'm following you from long time starting from ms excel. You're always an inspiration for all of us 🙏🏻🌹

[@theMilgarStudio]

Thank you so much, man. I will recreate this project and post it on LinkedIn, tagging you. Not just for the comments, but you've truly been a helping hand so many times in this data analysis world.

[@engineeringtechnology3113]

Wow, this video had me taking notes like I’m cramming for a Power BI final exam! 😂 Seriously though, the way you explained Dax, Slicers, Parameters, functions, bins and Icons in PowerPoint etc. made it click for me. I can’t wait to impress my colleagues with this fancy dashboards. They’ll think I’ve become a Power BI wizard overnight! 🧙‍♂ Keep up the awesome work, and thanks for making learning this fun! Can’t wait for the next one (and maybe more DAX magic?) by the way your wife Suggestion is good, but I like your Rounded Corner and White Color Inside Design. It would be so interesting if we know whose design was more liked Wife or Chandoo?😇

[@chandoo_]

Woohoo.. "Power BI Wizard Overnight 🧝‍♀️" 🤣 I guess that should be my new tagline 😎 Going by the previous comments, "Wife is always right" seems to be the consensus 😂

[@CuriousJo1122]

This video is really the BEST! I just finished it and shared it with everyone I know... even though they have no desire to do Power BI lol Just in case, right?! - TY so much. I also think your wife was right, the white on gray looked a bit better. I made mine all kinds of cute colors, but my tables were white on a more purple background.

[@chandoo_]

🎉Woo hoo. If there is anything that I learned from knowing Jo for the last 21years, it is that "she is always right" 😍

[@prumrithy271]

Thank you Chandoo, you are helping a lot of people to learn on PBI.

[@prasad1686]

I love ❤your content it is straight to the point, you do not waste any time and it is meaningful. I learned a lot in this project. Thank you so much🙏🙏🙏

[@ifeomajames8702]

Sometimes I forget I have you and what a genius you are !!!

[@CuriousJo1122]

This is the BEST!!! Thank you, and I will share this and take even more if you have them. This is such a great tutorial!!!

[@societyrelations6015]

Chandoo Bhai. Excellent project demo. You are such a talented and humble teacher. Wish you and your family all the best.

[@SaiMahesh-xe7vo]

chala thanks anna ela unaru we happy after seeing your videos

[@cyclopelab]

2 hours took me 6 days. Lots of stuff.

[@nickbell6311]

One of the best online tutor

[@cyclopelab]

I love the birds sound at the beginning of sections.😊

[@dipinanda1]

Chandoo Bhai is the bestest!!! You just are as awesome as the Most Popular chocolate of "Awesome chocolates"...!!

[@gbadebokehinde2099]

Thank you so much chandoo I always love your lessons I wish I could send you the screenshot of what I replicated

[@sravanikonijeti51]

Thank you so much for uploading sir ... Please put this video in telugu also 🙏 it would be helpful a lot

[@Sanj20101]

Thanks Chandoo, It was awesome project. Learned a lot. You are a good teacher :)

[@anastasiosvra9024]

Great video and learning experience thanks so much! On the edge of properly finishing this dashboard but I can grasp what can we do, what dax measure will allow us to have the accent bar displayed on top of the cards once we select a measure from the slicer beneath . Can you give a hint or helping clue Chandoo? Really liked the attention to detail of this end to end power bi project!🔝😀

[@storieswithtarasharma2914]

Thank you Chandoo, I keep waiting for all your video, I knew your hair are not like its showing in your account picture🤪

[@madhusudhanreddyt2838]

instead of creating a calculated column which is going to run under the row context where it is going to evaluate the expression for each row in the table..best option is to create a calculated measure using the sumx and related functions Total Cost = SUMX(Fact_Shipments, Fact_Shipments[Boxes] * RELATED(Dim_Product[Cost per box])) creating the calculated columns will occupy space and are stored in the model. which in turn is going to increase the file size...

[@NilimaParbatani]

Thank you for making this. If I could give more than 1 likes, I wish. I have learned so much from this. thanks Chandoo. A Brilliant job!

[@arbazahmad7177]

Excellent..🎉.. Great explanation.. thanks for sharing....

[@gurvindersingharora5301]

Hi Chandoo Could you create a video where we could learn when to combine filter with ALL function while creating measures !❤

[@aftabsuco5233]

Thank you so much ♥ your work is exceptionally good

[@bamise2400]

You are the best ! Thank you so much

[@Vikramhhj]

TQ sir for sharing it really helpful and interesting as well

[@maciejkopczynski55]

Awesome Choc... project! Thank You Chandoo!

[@melvinlicaros514]

I think it's better to compute the Total Costs this way ;) Total Costs = SUMX( shipments, shipments[Boxes] * RELATED( products[Cost per box] ) )

[@tashrifmahamudsiddiquee4183]

Will it not be processing heavy and cause lag in terms of performance? As SUMX is an iterative function it will go through each rows and perform action.

[@madhusudhanreddyt2838]

@@tashrifmahamudsiddiquee4183 measures are calculated on the fly. the calculations are done in the memory whenever you are going to interact with them in the visuals and they do not occupy any space and store in the data model

[@SandipanSarkar-c8v]

Finished watching

[@wasekar]

Exellent Chandoo really a fantastic work

[@chandoo_]

Thank you so much 😀

[@hairavyadav6579]

Make video around 8 hrs with all function which is essentials for data analyst

[@shraddhanandedkar]

Thank you so much for such details version of PBI report

[@Analyst-Noman]

You are just amazing!

[@X4Xubi]

Sir a very humble request. Please start using different data sets for useful long videos like this so we can benefit from looking at different scenarios, like some time HR data, Biotechnology data set, Data related to Telecom, A pharmacy, Logistics based company, Housing, Government related, and likewise or rather pick a data set which is challenging, broke and needs efforts to clean and transform...Barfoughny, Jehu and Juices are not helping anymore. Sir please try to understand the need of people from different backgrounds.

[@bamise2400]

Thank you for so much for the video!

[@harshalkate31]

very informative thanks for teaching us

[@nikhildhongade291]

Informative and Descriptive as always..

[@mbhupal18]

Great Explanation! Insightful Dashboard

[@greenvally8467]

Hi Chandoo. your videos are really awesome. Just wanted to know whether your power BI course has 20 hours video lecture as mentioned in comments section(You can get the complete Power BI file, full HD video and more than 20 hours of Power BI lessons in my online Power BI course) or as 9+ hours as mentioned in your Power BI play date. please also can you cover in depth of Power BI service in your course.

[@chandoo_]

Thanks for this lovely comment. Sorry for the description confusion. The course has 20+ lessons, but the total duration is around 10 hours. I have updated the video description now. I am planning to add videos on Power BI service, newer features and SQL integration to the course by the end of 2024. If you enrol, you will automatically access those videos too. See chandoo.org/wp/power-bi-course/ for all the details.

[@greenvally8467]

@@chandoo_ Thank you.

[@Mohith_Golla]

GOOD MASTER CLASS ON POWER BI BROTHER !

[@kavalimahesh4230]

Awesome project. can't thank enough for proving such a quality content. Can someone help me find the icons used in the project for creating dashboard

[@samimkakakhil6891]

Thanks Chandoo for the useful information

[@darkre9571]

Hey Chandoo, I don't see the icons file in the description. Great video btw!

[@zakhelezwide1911]

Thanks so much for sharing this video.

[@taizoondean689]

Thank You Sir. God Bless You

[@durgeshkrishan540]

Great video, please also provide logo in the description.

[@suvzar6194]

Please make a dashboard for sourcing side. Your ideas are good.

[@rams_stuff]

Thanks Chandoo garu.

[@DHARMRAJ_99]

Muje sikhna hai so it will be useful for my accounting field

[@chrism9037]

Excellent Chandoo!

[@ericmwangi4309]

Hi @Chandoo, thanks for the videos, am becoming more better at using power bi, i was able to create the final dashboard you created and added the accent bars for measure selection fields when selected it changes color the problem was doing the same for the KPIs added the accent bars but wudnt be able to sync the two to show same colour on the accent bar when a measure selection field is selected. The other problem was the measure to use for the up by 11% so it can change dynamically when a particular field is selected e.g. sales

[@roybijlhout9918]

Hi Chandoo, Where can i find the file so i can follow your course

[@kayespedal10]

You're the best. Thank you

[@ruhiscorner7318]

Hello Chandoo, thankyou so much for the video. Just wanted to ask if the Profit% should be tota profit/Total cost and not total sales?

[@aman-alytics]

1:52:00 We can also add GIFs. Using Html also we can do lot more!

[@dubemsanctity]

Thank you chandoo

[@jagatkrishna1543]

Thanks Sir ❤🙏🙏🙏

[@gloystar]

Another great video, thank you Chandoo. I need a formula that adds the digits of any number I type in a cell. Is it possible?

[@harshithharsha4066]

Thank You @Chandoo

[@jayasuriyaa.d.7018]

really helpful

[@SyedMuhammadKamran-t3s]

Excellent. ❤

[@Joshgamingoffical]

awesome👌👍

[@LetsTalkAboutMoviess]

Thanks Chandoo! It would be great if you give the pbix file of this report.

[@dineshkumar-uk8oh]

Sir we were waiting in telugu

[@bharaths5906]

Thank you sir

[@rehanbaig71]

@00:17:43 - Using the Calendar table to make "time intelligence" measures

[@krishnakantapanda6835]

we can calculate Costs using a measure- Total Costs= sumx ( shipment, shipment[boxes]*related (products[cost per box]) )

[@krishnakantapanda6835]

Really informative video. Loved it! Thank you for making such quality contents @Chandoo We want more of such useful videos!

[@mgnregszaffergadh9277]

Thanq sir

[@aaspaas1834]

Profit percentage should be Divide([Total Profit], [Total Cost])

[@solomonwaka-fy6we]

Thanks bro

[@Sc20004]

Thank you..

[@saravananmohandas9960]

Hi If not getting table and model under data tab please enable preview features under global in file and option settings

[@MuhammedSwalihT]

Thanks

[@rehanbaig71]

@00:27:22 - Wireframe design for our dashboard

[@Myinterest2]

When we have field parameters, how can we capture the screenshot of each tab or measure in the automated mail that is scheduled every day?

[@hearambasharma]

First 15m viewers😊

[@Mnopqrstuvwxyz....]

Can you pls share a video how to link Google sheet to Power Bi & update regularly?

[@shubham7564]

Hi @Chandoo, I tried a lot, but not able to create 'Up by ...' visual based on slicer parameter. Though individually for sales, profit etc, I was able to create % change using firstdate function. Can you let me know how to create 'Up By...' dynamically?

[@himanshuphirke99]

I cannot find the images and logo file

[@aunali3651]

Hello Chandoo Just like MoM % I was trying QoQ % in my reference label but it seems to be giving me wrong answers. Could you please help. Just to add I have taken latest date as Lastdate(‘date[start of quarter]’)

[@muhammedsherinkc3195]

How to do that change above line color when we click parameters?

[@kashisharora8682]

sir i would like to ask that during data modelling you are creating relationships in date and geography but when i am applying the same step during my practice it is not creating it and showing error and saying that due to the duplicates in the table relationship cannot created. Please help me out I am not able to clarify it, I would appreciate your effort. Also i would like to thank you for this extremely helpful video with brief explanation

[@chandoo_]

Here are the relationships you need Shipments -> Geo Shipments -> Calendar Shipments -> Product Shipments -> People

[@kashisharora8682]

@@chandoo_ sir neither OK option is appearing while creating relationships and managing relationships

[@kashisharora8682]

@@chandoo_ sir I have tried creating shipment->geo and shipment->calendar still it is showing error of duplicates and also I have created this shipment->people and shipment->product in this relationship it’s not showing error. Please help sir

[@chandoo_]

Make sure your geo and calendar tables are clean. See if there is a blank row or extra data coming in (by looking at the tables in Power Query).

[@kashisharora8682]

@@chandoo_ ok thank you so much sir for your great effort and it’s created now thank you sir for helping me

[@tashrifmahamudsiddiquee4183]

Shouldn't the Profit % be DIVIDE([Profit], [Total Costs])? I am confused here and not sure whether I am making a mistake. Could you please provide the answer?

[@JATINKUMAR-qu4vi]

[@smithbhandari]

Hello Mr. Chandoo, Request you to please read this and suggest an solution; I am having a large data set of sales register of last 4 year containing data of invoice wise SKU wise sales with buyer code, buyer name, gross and net values, taxes etc etc. To give an idea these excel data files have data till like 7-8 lakh rows and columns going up to DA and even further sometimes. At times it needs to be updated as per various management reporting requirement in terms of product category grouping etc. I tried to connect it with power bi desktop app, however it is taking too long. How to resolve that ??

[@chandoo_]

Looks like you are using a slower computer (processor / memory / both). I suggest saving the file as CSV (won't work if it has formulas) and trying again. If that is also slow, test it on a faster computer with more memory and resources.

[@harshbhavsar5741]

Q. can we do MOM and YOY changes by quick measures function ?

[@chandoo_]

You can try. I think in this case, it might work.

[@akashdeshmukh116]

12:23 HOW TO Calculate by using DAX measure.. what will be the formula??🤔🤔

[@SyedMozammilMoiz]

Total Cost = SUMX(shipments, shipments[Boxes] * Related(products[Cost per box])

[@surabhibhat-j3c]

What if the sales data are missing in few years,will line chart be continuous or non- continuous?I'm getting continuous line chart instead of non continuous line chart,How to solve this?

[@thiyanez]

The name suggests it's a line chart it will show the trendline even though you don't have some points in between.. if you want to represent just the points try to use other visuals..

[@SanaSm-d2t]

Why am i not able to find total row when visuals is converted to table

[@shraddhakale1172]

Where is sample data... didn't found it in description box

[@NilimaParbatani]

my vote to version 2