Power BI Project From Start to End Part 1 | Car Sales | Advanced DAX | End to End |2024
Вставка
- Опубліковано 7 лип 2024
- #powerbi #dataanalytics #dataanalytics
Power BI Project From Start to End | Car Sales | Advanced DAX Functions | End to End |2024 #powerbi
Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
Welcome to this comprehensive Data Analyst Project tutorial! In this tutorial, I will guide you through the complete process of building a data analysis project using popular tools such as Power BI, Tableau, SQL, and Excel.
Data Download - drive.google.com/drive/folder...
📱Follow me on Facebook - profile.php?...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
⭐Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - • Data Analyst Roadmap 2...
Details mentioned below-
email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
➖➖➖➖➖➖➖➖➖➖➖➖➖
Content
Introduction to Dashboard 0:00
Dashboard Overview 01:00
Problem Statement 09:09
Functionalities You will Learn 14:57
Software's Used 15:31
Data Walkthrough 16:08
Power BI Connection to Data 19:47
Data Cleaning 22:22
Calendar Table 31:02
Data Modeling 39:16
Background Design 42:01
Total Sales KPI (YTD/PYTD/YoY/MTD) 44:46
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related keywords:
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
sql project for data analyst
project for beginners
sql portfolio project
data analyst sql project
data analyst full project
data analyst resume project
sql project
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project
power bi dashboard,power bi for beginners,power bi,power bi tutorial for beginners,power bi tutorial,power bi hr analytics dashboard,power bi project,power bi desktop,power bi training,power bi dashboards,power bi dashboard tutorial,power bi projects for practice,power bi dashboard examples,microsoft power bi,power bi projects for beginners,power bi reports,power bi dashboard design,dashboard,start to end dashboard development,end to end power bi project
You're simply the best!
great one...Thank you
Very Informative...Thank you so much...
Good one.
You are really doing great job.
Good Evening, And really in this part its amazing to learn the dax functions and some new concepts there.. nice work
Great video!
Sir, do more real world Advance level projects
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
Very informative video..maygod bless you brother 🎉🎉🎉😊...Thank you so much ❤️
Glad you liked!
Can you please do an end project using snowflake cloud also.. ?
Waiting for more projects sir😊
Definitely
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.
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?
The date information in the video is different from what is available from the link?
could you please attach the link for how to build a background in ppt?
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?
It’s used to add the text we added at start. But there are multiple approaches to achieve this. You can use any
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 ?
bro im not getting the measure values ..if select a card it shows me blank..how to find out that
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?
how may parts you have for this project. i see two (Car Sales part 1 and 2) but it looks incomplete?
I'm not getting the highlighted column of sales diff colours for conditional formatting.
Same here, have you been able to do same now?
Can i find this dataset on kaggle or can i find offical dataset? If yes, who can send me link??? Thanks
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
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
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
16:00
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.
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
Is any job opportunity in power BI
Hello Sir , when will you release part 2 ?
After 2 days
@@datatutorials1 thank you so much
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 ..
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
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)
Where is Part 2?
Will be uploaded tomorrow
unbale to download your file
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..