Thank you Sir !!!! Absolutely fantastic content! Your real-time Power BI projects are incredibly insightful and practical. The step-by-step explanations and real-world applications make it so much easier to understand and implement. Keep up the amazing work-you're truly making a difference for all of us looking to enhance our Power BI skills!
Bro this project was going to be on mysql + power bi project than why you shifted to excel only and if possible make a vedio on data cleaning like if we got messy data than how convert that data into clean data it will be helpful if you can make a vedio btw this vedio is so informative
Thank you so much, excellent video, very well explained usage of Measures and DAX also covered, good data for analyse. I think just you needed to Filtered also Model data column from Excel there is some data that in Power BI came out as date and text column and when showing results in video explanation in Data Cleaning part 22:22. In Excel file Saab company models came out as Date functions i think it should be named Saab 9-3 and Saab 9-5 like a manufacturer models names not as a date format in Excel cells. This data need to be transformed in Power Bi changing data format of the cell to TEXT and after that just like a replacement of Engine column in the video also replacement of Saap company Models need to be replaced in Model column. Everything else is excellent thank you again good work, nice video :)
I watched your two videos of the project, in both videos you had cleaned data. Do you have any power BI project in which you had cleaned data in the power query?
Hello, For the total MTD sales at the last, Should we definitely use that concatenate formula, I think we can also use: Create a new card and import the total MTD measure there and in the visual section, we can change the values in the callout values from auto to Millions and change the decimal point value from auto to 1, We can also change the values to $ in the measure tools section. I think this yields the same result. Or is there any particular reason for using the concat formula?
Great content. I followed your step by step however I’m using my own data and when I attempt the TotalYTD(SUM…. I get a “blank” return? Could you advise on why that is? Thanks, and keep up the great content!
Why You use Rule for coloring the sales difference? You have written a measure and mention the color name. You should have used Field Value and Mentioned Measure Name
I am very very new. This is a SILLY question. But ideally, a dataset provided by a client could be in any format right? Best is if it is provided in EXCEL right?
Hi.... I am following along but i have a question. YOY growth on total sales = total sales -last year sales right? but why did u do, YTD sales-last year sales??? am lost there
@@datatutorials1 u divided by pytd only. its not a mistake. i am just confused, like yoy growth sometimes take total sales but here u have taken ytd sales i cant understand that. Because in the Requirement, you asked YOY growth not YTD growth. but in the video its ytd growth u performed.
Thank you Sir !!!! Absolutely fantastic content! Your real-time Power BI projects are incredibly insightful and practical. The step-by-step explanations and real-world applications make it so much easier to understand and implement. Keep up the amazing work-you're truly making a difference for all of us looking to enhance our Power BI skills!
NO ONE CAN Eeplained like this way.. thank you so much.
Bro this project was going to be on mysql + power bi project than why you shifted to excel only and if possible make a vedio on data cleaning like if we got messy data than how convert that data into clean data it will be helpful if you can make a vedio btw this vedio is so informative
Good Evening, And really in this part its amazing to learn the dax functions and some new concepts there.. nice work
Very informative video..maygod bless you brother 🎉🎉🎉😊...Thank you so much ❤️
Glad you liked!
Sir, do more real world Advance level projects
Well explained! Thanks!
You are really doing great job.
Great !
You're simply the best!
Thank you so much, excellent video, very well explained usage of Measures and DAX also covered, good data for analyse. I think just you needed to Filtered also Model data column from Excel there is some data that in Power BI came out as date and text column and when showing results in video explanation in Data Cleaning part 22:22. In Excel file Saab company models came out as Date functions i think it should be named Saab 9-3 and Saab 9-5 like a manufacturer models names not as a date format in Excel cells. This data need to be transformed in Power Bi changing data format of the cell to TEXT and after that just like a replacement of Engine column in the video also replacement of Saap company Models need to be replaced in Model column. Everything else is excellent thank you again good work, nice video :)
Thanks for your comment and suggestions you mentioned.
your videos all very usefull ....could you make healthcare proivder data project in power bi ?
Finished watching
Can you please do an end project using snowflake cloud also.. ?
Excel sheet provided by you the minimum date is 02-01-2022. But in the video, it starts from 09-03-2022. Is the Excel sheet wrong provided by you?
I think he provided the wrong excel?
In the previous Bank loan project also same problem is there ..
They provide date is worng but, values are same pla check it once
I watched your two videos of the project, in both videos you had cleaned data. Do you have any power BI project in which you had cleaned data in the power query?
The date information in the video is different from what is available from the link?
Hello, For the total MTD sales at the last, Should we definitely use that concatenate formula, I think we can also use:
Create a new card and import the total MTD measure there and in the visual section, we can change the values in the callout values from auto to Millions and change the decimal point value from auto to 1, We can also change the values to $ in the measure tools section. I think this yields the same result. Or is there any particular reason for using the concat formula?
It’s used to add the text we added at start. But there are multiple approaches to achieve this. You can use any
Bro make one powerbi project with MySQL database most people using MySQL
Very Informative...Thank you so much...
Great content. I followed your step by step however I’m using my own data and when I attempt the TotalYTD(SUM…. I get a “blank” return? Could you advise on why that is? Thanks, and keep up the great content!
Do you have date table with correct dates populated
Check the related Columns in same data type..
I am also facing the same issue. Were you able to resolve this ?
Sir, the file which you have given link for has a min date of 2-1-2022, how come 9-3-2022 came as minimum date Sir?
Why You use Rule for coloring the sales difference? You have written a measure and mention the color name. You should have used Field Value and Mentioned Measure Name
I am very very new. This is a SILLY question. But ideally, a dataset provided by a client could be in any format right? Best is if it is provided in EXCEL right?
could you please attach the link for how to build a background in ppt?
Waiting for more projects sir😊
Definitely
Thanks alot I was able to build something like this but I want to add WTD to each KPI how do I go about it?
great one...Thank you
sir where i can buy part 2 can you tell me specific course on your channel.
Not required to buy, i will upload it tomorrow on my channel
I'm not getting the highlighted column of sales diff colours for conditional formatting.
Same here, have you been able to do same now?
how may parts you have for this project. i see two (Car Sales part 1 and 2) but it looks incomplete?
Replace action is not working for me
Hi.... I am following along but i have a question. YOY growth on total sales = total sales -last year sales right? but why did u do, YTD sales-last year sales??? am lost there
No you can check it on google as well for formula. Though i have made a different mistake where we should divide by pytd . You can correct those.
@@datatutorials1 u divided by pytd only. its not a mistake. i am just confused, like yoy growth sometimes take total sales but here u have taken ytd sales i cant understand that. Because in the Requirement, you asked YOY growth not YTD growth. but in the video its ytd growth u performed.
Good one.
DO These DAX formulas work if we have date of 3 or more years (YTD, PYTD)? I triied but it shows different results?
It should work
Great video!
bro im not getting the measure values ..if select a card it shows me blank..how to find out that
At 55:00 my sales diff colour is not showing in rules . Can anyone help
Write just Green and not "Green" at the last stage
Hello Sir , when will you release part 2 ?
After 2 days
@@datatutorials1 thank you so much
excellent projects.. anything for 2-3 years exp ?
This for people have experience from 1 to 6 years, all advanced topics are covered in this video
@@datatutorials1 thnx.. what about the loan project 2nd part? Is it uploaded?
It won’t be uploaded on UA-cam. That comes under paid courses.
@@insidehead yes when will it uploaded
topmate.io/data_tutorials
Get it from here
Can i find this dataset on kaggle or can i find offical dataset? If yes, who can send me link??? Thanks
Bro is totalytd fn excludes year 2022?
No
But,you clearly said in your video that total YTD fn only include latest year( which is already in your data)
Is any job opportunity in power BI
unbale to download your file
Where is Part 2?
Will be uploaded tomorrow
16:00
Formulas are here
Calender Table = CALENDAR(MIN(car_data[Date]), MAX(car_data[Date]))
NOW ADD NEW COLUMN
Year = YEAR('Calender Table'[Date])
Month = FORMAT('Calender Table'[Date], "MMMM")
Week = WEEKNUM('Calender Table'[Date])
DAX Function
YTD Total sales = TOTALYTD(SUM(car_data[Price ($)]), 'Calender Table'[Date])
PYTD Total Sales = CALCULATE(SUM(car_data[Price ($)]), SAMEPERIODLASTYEAR('Calender Table'[Date]))
Sales Difference = [YTD Total sales]-[PYTD Total Sales]
Sales Differece Color = IF([Sales Difference]>0, "Green", "Red")
YOY Sales Growth = [Sales Difference]/[PYTD Total Sales]
MTD KPI = CONCATENATE("MTD Total Sales :", FORMAT([MTD Total Sales]/1000000, "$0.00M"))
Avg Price = SUM(car_data[Price ($)]) / COUNT(car_data[Car_id])
YTD Avg Price = TOTALYTD([Avg Price], 'Calender Table'[Date])
PYTD Avg Price = CALCULATE([Avg Price], SAMEPERIODLASTYEAR('Calender Table'[Date]))
Avg Price Diff = [YTD Avg Price] - [PYTD Avg Price]
Avg Price Color = IF([Avg Price Diff]>0, "Green", "Red")
YOY Avg Price Growth = [Avg Price Diff] / [PYTD Avg Price]
MTD Avg Price = TOTALMTD([Avg Price], 'Calender Table'[Date])
MTD Avg Price KPI = CONCATENATE("MTD Avg Price :", FORMAT([MTD Avg Price] / 1000, "$0.00K"))
YTD Cars Sold = TOTALYTD(COUNT(car_data[Car_id]), 'Calender Table'[Date])
PYTD Cars Sold = CALCULATE(COUNT(car_data[Car_id]), SAMEPERIODLASTYEAR('Calender Table'[Date]))
Cars Sold Diff = [YTD Cars Sold]- [PYTD Cars Sold]
Cars Sold Color = IF(car_data[Cars Sold Diff]>0, "Green", "Red")
YOY Car Sold Growth = [Cars Sold Diff] / [YTD Cars Sold]
MTD Cars Sold = TOTALMTD(COUNT(car_data[Car_id]), 'Calender Table'[Date])
MTD Cars Sold KPI = CONCATENATE("MTD Cars Sold :", FORMAT([MTD Cars Sold] / 1000, "$0.00K"))
hi
provided dataset is diff..