NO ONE CAN Eeplained like this way.. thank you so much.
@ALIYANHAIDER-k7f
2 ай бұрын
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!
@prakashpr9500
8 ай бұрын
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
@tariqhussain1497
4 ай бұрын
Good Evening, And really in this part its amazing to learn the dax functions and some new concepts there.. nice work
@gospelmoto2833
2 ай бұрын
Well explained! Thanks!
@mhdrizwan5240
Ай бұрын
Great !
@adarshkashyap7402
3 ай бұрын
You are really doing great job.
@bea06abhishekranjitbarua75
7 ай бұрын
Very informative video..maygod bless you brother 🎉🎉🎉😊...Thank you so much ❤️
@datatutorials1
7 ай бұрын
Glad you liked!
@SandipanSarkar-c8v
Ай бұрын
Finished watching
@ocraking
5 ай бұрын
You're simply the best!
@asp4628
7 ай бұрын
Sir, do more real world Advance level projects
@meraji-e6x
23 күн бұрын
your videos all very usefull ....could you make healthcare proivder data project in power bi ?
@akshayranalkar1396
7 ай бұрын
Very Informative...Thank you so much...
@rahul2506
8 ай бұрын
Can you please do an end project using snowflake cloud also.. ?
@knowledgeshowtv9471
3 ай бұрын
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?
@yosefsisay7645
7 ай бұрын
The date information in the video is different from what is available from the link?
@atulpatil9330
8 ай бұрын
great one...Thank you
@ganeshgani3325
8 ай бұрын
Waiting for more projects sir😊
@datatutorials1
8 ай бұрын
Definitely
@DDi-er1vf
8 ай бұрын
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 :)
@datatutorials1
8 ай бұрын
Thanks for your comment and suggestions you mentioned.
@prayanshusharma987
Ай бұрын
Bro make one powerbi project with MySQL database most people using MySQL
@jyotyprakash29
6 ай бұрын
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?
@abubuckerj7314
6 ай бұрын
I think he provided the wrong excel?
@vinayakalur5660
5 ай бұрын
In the previous Bank loan project also same problem is there ..
@tejeswararao2517
28 күн бұрын
They provide date is worng but, values are same pla check it once
@sayantanganguly494
5 ай бұрын
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?
@ifoodieTV
Ай бұрын
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?
@aapbeete9761
8 ай бұрын
Good one.
@charanmarc5376
7 ай бұрын
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?
@datatutorials1
7 ай бұрын
It’s used to add the text we added at start. But there are multiple approaches to achieve this. You can use any
@dikkhatrainingconsultancy8526
5 ай бұрын
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
@WarEagleTimeMachine
8 ай бұрын
Great video!
@danieltemesgen2125
8 ай бұрын
could you please attach the link for how to build a background in ppt?
@paparazziwhizz6185
7 ай бұрын
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?
@NerdIntern
Ай бұрын
Replace action is not working for me
@martin.a.gutierrez
8 ай бұрын
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!
@datatutorials1
8 ай бұрын
Do you have date table with correct dates populated
@vanid5228
8 ай бұрын
Check the related Columns in same data type..
@GoatCRISTIANOcr7
6 ай бұрын
I am also facing the same issue. Were you able to resolve this ?
@TeyusAyele
5 ай бұрын
how may parts you have for this project. i see two (Car Sales part 1 and 2) but it looks incomplete?
@aaravsharma9150
8 ай бұрын
I'm not getting the highlighted column of sales diff colours for conditional formatting.
@remkas5042
4 ай бұрын
Same here, have you been able to do same now?
@abhishekkumar-qi3is
8 ай бұрын
sir where i can buy part 2 can you tell me specific course on your channel.
@datatutorials1
8 ай бұрын
Not required to buy, i will upload it tomorrow on my channel
@atharshaik5868
7 ай бұрын
bro im not getting the measure values ..if select a card it shows me blank..how to find out that
@TheIndiaEntertainment
5 ай бұрын
DO These DAX formulas work if we have date of 3 or more years (YTD, PYTD)? I triied but it shows different results?
@datatutorials1
4 ай бұрын
It should work
@chalanatyjostna2229
8 ай бұрын
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
8 ай бұрын
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.
@chalanatyjostna2229
8 ай бұрын
@@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.
@insidehead
8 ай бұрын
excellent projects.. anything for 2-3 years exp ?
@datatutorials1
8 ай бұрын
This for people have experience from 1 to 6 years, all advanced topics are covered in this video
@insidehead
8 ай бұрын
@@datatutorials1 thnx.. what about the loan project 2nd part? Is it uploaded?
@datatutorials1
8 ай бұрын
It won’t be uploaded on KZitem. That comes under paid courses.
@cryofficial2873
8 ай бұрын
@@insidehead yes when will it uploaded
@datatutorials1
8 ай бұрын
topmate.io/data_tutorials Get it from here
@dhruvikdetroja1993
8 ай бұрын
Hello Sir , when will you release part 2 ?
@datatutorials1
8 ай бұрын
After 2 days
@cryofficial2873
8 ай бұрын
@@datatutorials1 thank you so much
@xpetruchiooxx
7 ай бұрын
Can i find this dataset on kaggle or can i find offical dataset? If yes, who can send me link??? Thanks
@vibithas87
8 ай бұрын
Is any job opportunity in power BI
@Ahana-q3d
8 ай бұрын
Bro is totalytd fn excludes year 2022?
@datatutorials1
8 ай бұрын
No
@snehlatamaurya2332
8 ай бұрын
But,you clearly said in your video that total YTD fn only include latest year( which is already in your data)
@anujkhandelwal2658
6 ай бұрын
At 55:00 my sales diff colour is not showing in rules . Can anyone help
@ΒασίληςΚουκορέμπας
5 ай бұрын
Write just Green and not "Green" at the last stage
@rohitchowhan37
7 ай бұрын
16:00
@martin.a.gutierrez
8 ай бұрын
Where is Part 2?
@datatutorials1
8 ай бұрын
Will be uploaded tomorrow
@AJAYKUMAR-vf4df
4 ай бұрын
unbale to download your file
@KranthikumarBhukya-h7o
7 ай бұрын
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"))
Пікірлер: 74