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..
@SANDATA76424 күн бұрын
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-em4xu3 күн бұрын
Bro where are the logo links given which are used in the video in the headers?
@adrianagonzalez995128 күн бұрын
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.
@madhusudhanreddyt28384 күн бұрын
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
@prasad168615 күн бұрын
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🙏🙏🙏
@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.
@michelhebert39756 күн бұрын
I love the birds sound at the beginning of sections.😊
@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
@gbadebokehinde2099Ай бұрын
Thank you so much chandoo I always love your lessons I wish I could send you the screenshot of what I replicated
@sachinsbabar223123 күн бұрын
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 🙏🏻🌹
@vvnserylАй бұрын
Thank you chandoo anna , you covered many topics in just this one single project. Very helpful for freshers .. Thank you
@ifeomajames870224 күн бұрын
Sometimes I forget I have you and what a genius you are !!!
@NilimaParbatani20 күн бұрын
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!
@Sanj2010116 күн бұрын
Thanks Chandoo, It was awesome project. Learned a lot. You are a good teacher :)
@arbazahmad7177Ай бұрын
Excellent..🎉.. Great explanation.. thanks for sharing....
@melvinlicaros51428 күн бұрын
I think it's better to compute the Total Costs this way ;) Total Costs = SUMX( shipments, shipments[Boxes] * RELATED( products[Cost per box] ) )
@tashrifmahamudsiddiquee418324 күн бұрын
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.
@madhusudhanreddyt28384 күн бұрын
@@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
@maciejkopczynski5528 күн бұрын
Awesome Choc... project! Thank You Chandoo!
@hairavyadav657923 күн бұрын
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❤
@storieswithtarasharma2914Ай бұрын
Thank you Chandoo, I keep waiting for all your video, I knew your hair are not like its showing in your account picture🤪
@mbhupal18Ай бұрын
Great Explanation! Insightful Dashboard
@aftabsuco523313 күн бұрын
Thank you so much ♥ your work is exceptionally good
@madhusudhanreddyt28384 күн бұрын
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...
@bushmaster75Ай бұрын
Excellent Tutorial. Definitely A+
@sravanikonijeti51Ай бұрын
Thank you so much for uploading sir ... Please put this video in telugu also 🙏 it would be helpful a lot
@zakhelezwide1911Ай бұрын
Thanks so much for sharing this video.
@nikhildhongade291Ай бұрын
Informative and Descriptive as always..
@shraddhanandedkarАй бұрын
Thank you so much for such details version of PBI report
@taizoondean689Ай бұрын
Thank You Sir. God Bless You
@harshalkate3128 күн бұрын
very informative thanks for teaching us
@aman-alyticsАй бұрын
1:52:00 We can also add GIFs. Using Html also we can do lot more!
@mohithgana8587Ай бұрын
GOOD MASTER CLASS ON POWER BI BROTHER !
@mahalakshmisreekarthikeyan9428Ай бұрын
Thank you so much for sharing this video.
@gurvindersingharora5301Ай бұрын
Hi Chandoo Could you create a video where we could learn when to combine filter with ALL function while creating measures !❤
@kayespedal10Ай бұрын
You're the best. Thank you
@samimkakakhil6891Ай бұрын
Thanks Chandoo for the useful information
@wasekarАй бұрын
Exellent Chandoo really a fantastic work
@chandoo_Ай бұрын
Thank you so much 😀
@chrism9037Ай бұрын
Excellent Chandoo!
@rehanbaig7121 күн бұрын
@00:17:43 - Using the Calendar table to make "time intelligence" measures
@rams_stuffАй бұрын
Thanks Chandoo garu.
@ruhiscorner73187 күн бұрын
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?
@jagatkrishna1543Ай бұрын
Thanks Sir ❤🙏🙏🙏
@muhammadsaadme301721 күн бұрын
Thank you sir
@rehanbaig7121 күн бұрын
@00:27:22 - Wireframe design for our dashboard
@user-ob2nf9zr3eАй бұрын
Excellent. ❤
@aaspaas1834Ай бұрын
Profit percentage should be Divide([Total Profit], [Total Cost])
@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
@LetsTalkAboutMoviessАй бұрын
Thanks Chandoo! It would be great if you give the pbix file of this report.
@harshithharsha4066Ай бұрын
Thank You @Chandoo
@darkre95716 күн бұрын
Hey Chandoo, I don't see the icons file in the description. Great video btw!
@ericmwangi430915 күн бұрын
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
@DHARMRAJ_99Ай бұрын
Muje sikhna hai so it will be useful for my accounting field
@suvzar6194Ай бұрын
Please make a dashboard for sourcing side. Your ideas are good.
@durgeshkrishan540Ай бұрын
Great video, please also provide logo in the description.
@jayasuriyaa.d.7018Ай бұрын
really helpful
@dubemsanctityАй бұрын
Thank you chandoo
@JoshgamingofficalАй бұрын
awesome👌👍
@krishnakantapanda683524 күн бұрын
we can calculate Costs using a measure- Total Costs= sumx ( shipment, shipment[boxes]*related (products[cost per box]) )
@krishnakantapanda683523 күн бұрын
Really informative video. Loved it! Thank you for making such quality contents @Chandoo We want more of such useful videos!
@Sc20004Ай бұрын
Thank you..
@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?
@dineshkumar-uk8ohАй бұрын
Sir we were waiting in telugu
@solomonwaka-fy6weАй бұрын
Thanks bro
@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.
@MuhammedSwalihTАй бұрын
Thanks
@mgnregszaffergadh9277Ай бұрын
Thanq sir
@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.
@himanshuphirke9924 күн бұрын
I cannot find the images and logo file
@hearambasharmaАй бұрын
First 15m viewers😊
@tashrifmahamudsiddiquee418324 күн бұрын
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?
@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?
@jagatkrishna1543Ай бұрын
SIR, not getting twitter and any mail from Your side God Bless You 🙏🙏🙏
@NilimaParbatani18 күн бұрын
my vote to version 2
@swaroopsam1968Ай бұрын
Why is profit % = total profit/total sales .... By formula it should be total profit/total costs Profit % = (SP-CP)/CP Right ?? Please correct me if I'm wrong
@RehanShaikh-em4xu3 күн бұрын
Where have you given the links for the logo?
@cinephile8094Ай бұрын
Sir Please provide the pbix file also
@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?
@thiyanez27 күн бұрын
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..
@Mnopqrstuvwxyz....Ай бұрын
Can you pls share a video how to link Google sheet to Power Bi & update regularly?
@akhilareddyambati955927 күн бұрын
Sir I have one question To become Data Analyts did we have to learn full python and Excel?
@chandoo_26 күн бұрын
It depends on the profile. Most jobs require one of the two tools. So start learning. All the best. Here is my 2024 recommendation and road map for becoming a data analyst - kzfaq.info/get/bejne/iJmSjZN9sdyXdp8.html
@krantikumarm270518 күн бұрын
sir i understood power bi but some DAX i am struggling to get it like big formulas
@santhoshl-zq1op19 сағат бұрын
Shall I do this to showcase in my resumae
@chandoo_19 сағат бұрын
Sure. As long as you credit the source.
@suryakantranjan18324 күн бұрын
15:55
@user-dc2dh2xy7s18 күн бұрын
Hi sir in measure i have applied Latest MoM Sales Change % = var 1d=[Latest Date] var this_month_sales = [total sales latest month] var prev_month_sales = CALCULATE([Total Sales], 'calendar'[Start of Month] = EDATE(1d-1) return divide(this_month_sales-prev_month_sales,prev_month_sales) it is showing error
@RajGupta-hi9ttАй бұрын
Pbix file?
@ifeomajames870224 күн бұрын
Why didn’t you divide the profit by total costs to get profit percentage
@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.
@manjeshk3493 күн бұрын
can Chandoo/someone please explain how to get that line when slicer/parameter is selected on time 1.46?
@chandoo_3 күн бұрын
Adding the line requires creating a measure to know which field parameter is selected and then using conditional formatting to check if the measure selected is same as the measure shown in the card. Then change the color.
@RehanShaikh-em4xu3 күн бұрын
Please give the links for the logo's
@abdullahtammourАй бұрын
May I ask why we need a separate calendar table if we already have a date column in the fact table?
@chandoo_Ай бұрын
Caledar table is a best practice when it comes to serious BI reporting. It will help you deal with multiple date columns, simplifies date intelligence calculations (such as MoM / YTD) and keeps your model fast. The built-in data columns can be slow, tedious and even dangerous when dealing with large fact tables.
@ifeomajames870223 күн бұрын
I think the parameter feature dosent work in my version of power bi because when I added it to my chart on the y axis, the chart was blank
@chandoo_23 күн бұрын
It has been around for a while. I suggest checking again. If the parameter is a dimension, then it should go to the dimension axis (for example, on a column / line chart, this would be x axis). Likewise, if the parameter is for measures, then it should go to the value axis.
@gentleman8536Ай бұрын
I am not able to find the link to download sample file
@farookmohammad27Ай бұрын
Hello sir , i cant find files used in videos like .png etc except .csv , please share those .. Thank you
@lakshmanvajjakeshavula5380Ай бұрын
🎉
@naseerhussain608012 күн бұрын
Icons were not uploaded to git
@shahnawazali67542 күн бұрын
We don't get the excel data 😢
@mdmahmooduddin36974 күн бұрын
can you share the data link pls
@pranav981526 күн бұрын
So much to learn
@wasekarАй бұрын
instead of donut can we use map there ?
@chandoo_Ай бұрын
We can. As we have only 6 countries that are geographically spread apart, the map will have large amount of blank space.
@Mr.LOL8889 күн бұрын
where is the sample data?
@Sc20004Ай бұрын
Hi Could you pls share the data file as I do not see in description as suggested in the video?
@chandoo_Ай бұрын
They are available in the description. Here again: Github link: github.com/chandoo-org/Power-BI/blob/main/ac-sample-data.xlsx Mirror link: chandoo.org/wp/wp-content/uploads/2024/07/ac-sample-data.xlsx