Power BI Project From Start to End Part 1 | Car Sales | Advanced DAX | End to End |2024

Подписаться 113 тыс.

Просмотров 35 тыс.

50% 1

#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

Опубликовано:

22 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 62

@tariqhussain1497 11 часов назад

Good Evening, And really in this part its amazing to learn the dax functions and some new concepts there.. nice work

@atulpatil9330 4 месяца назад

great one...Thank you

@aapbeete9761 4 месяца назад

Good one.

@akshayranalkar1396 2 месяца назад

Very Informative...Thank you so much...

@ocraking 24 дня назад

You're simply the best!

@WarEagleTimeMachine 4 месяца назад

Great video!

@asp4628 3 месяца назад

Sir, do more real world Advance level projects

@prakashpr9500 4 месяца назад

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

@rahul2506 4 месяца назад

Can you please do an end project using snowflake cloud also.. ?

@bea06abhishekranjitbarua75 2 месяца назад

Very informative video..maygod bless you brother 🎉🎉🎉😊...Thank you so much ❤️

@datatutorials1 2 месяца назад

Glad you liked!

@ganeshgani3325 4 месяца назад

Waiting for more projects sir😊

@datatutorials1 4 месяца назад

Definitely

@paparazziwhizz6185 3 месяца назад

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?

@danieltemesgen2125 3 месяца назад

could you please attach the link for how to build a background in ppt?

@DDi-er1vf 4 месяца назад

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 4 месяца назад

Thanks for your comment and suggestions you mentioned.

@yosefsisay7645 3 месяца назад

The date information in the video is different from what is available from the link?

@TeyusAyele 25 дней назад

how may parts you have for this project. i see two (Car Sales part 1 and 2) but it looks incomplete?

@martingutierrez9356 4 месяца назад

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 4 месяца назад

Do you have date table with correct dates populated

@vanid5228 3 месяца назад

Check the related Columns in same data type..

@GoatCRISTIANOcr7 Месяц назад

I am also facing the same issue. Were you able to resolve this ?

@atharshaik5868 2 месяца назад

bro im not getting the measure values ..if select a card it shows me blank..how to find out that

@charanmarc5376 2 месяца назад

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 2 месяца назад

It’s used to add the text we added at start. But there are multiple approaches to achieve this. You can use any

@xpetruchiox5906 3 месяца назад

Can i find this dataset on kaggle or can i find offical dataset? If yes, who can send me link??? Thanks

@dikkhatrainingconsultancy8526 28 дней назад

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

@sayantanganguly494 24 дня назад

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?

@aaravsharma9150 3 месяца назад

I'm not getting the highlighted column of sales diff colours for conditional formatting.

@remkas5042 8 дней назад

Same here, have you been able to do same now?

@rohitchowhan37 2 месяца назад

16:00

@abhishekkumar-qi3is 4 месяца назад

sir where i can buy part 2 can you tell me specific course on your channel.

@datatutorials1 4 месяца назад

Not required to buy, i will upload it tomorrow on my channel

@vibithas87 4 месяца назад

Is any job opportunity in power BI

@insidehead 4 месяца назад

excellent projects.. anything for 2-3 years exp ?

@datatutorials1 4 месяца назад

This for people have experience from 1 to 6 years, all advanced topics are covered in this video

@insidehead 4 месяца назад

@@datatutorials1 thnx.. what about the loan project 2nd part? Is it uploaded?

@datatutorials1 4 месяца назад

It won’t be uploaded on RU-vid. That comes under paid courses.

@cryofficial2873 4 месяца назад

@@insidehead yes when will it uploaded

@datatutorials1 4 месяца назад

topmate.io/data_tutorials Get it from here

@chalanatyjostna2229 4 месяца назад

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 4 месяца назад

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 4 месяца назад

@@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.

@TheIndiaEntertainment 16 дней назад

DO These DAX formulas work if we have date of 3 or more years (YTD, PYTD)? I triied but it shows different results?

@datatutorials1 13 дней назад

It should work

@dhruvikdetroja1993 4 месяца назад

Hello Sir , when will you release part 2 ?

@datatutorials1 4 месяца назад

After 2 days

@cryofficial2873 4 месяца назад

@@datatutorials1 thank you so much

@jyotyprakash29 Месяц назад

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 Месяц назад

I think he provided the wrong excel?

@vinayakalur5660 20 дней назад

In the previous Bank loan project also same problem is there ..

@user-gg2dj3bb4p 4 месяца назад

Bro is totalytd fn excludes year 2022?

@datatutorials1 4 месяца назад

@snehlatamaurya2332 4 месяца назад

But,you clearly said in your video that total YTD fn only include latest year( which is already in your data)

@anujkhandelwal2658 Месяц назад

At 55:00 my sales diff colour is not showing in rules . Can anyone help

@user-gg3hg7nr8m Месяц назад

Write just Green and not "Green" at the last stage

@AJAYKUMAR-vf4df 12 дней назад

unbale to download your file

@martingutierrez9356 4 месяца назад

Where is Part 2?

@datatutorials1 4 месяца назад

Will be uploaded tomorrow

@user-uq4eu1kr4f 2 месяца назад

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"))