Тёмный

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

Data Tutorials
Подписаться 116 тыс.
Просмотров 19 тыс.
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.
Whether you are a beginner or an experienced data analyst, this tutorial will provide you with the necessary knowledge and hands-on experience to successfully complete a data analysis project. Join me on this journey and unlock the power of these essential data analysis tools.
Data Download - drive.google.com/drive/folder...
📱Follow me on Facebook - profile.php?...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
⭐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
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
✅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...
➖➖➖➖➖➖➖➖➖➖➖➖➖
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

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

 

15 янв 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 89   
@bea06abhishekranjitbarua75
@bea06abhishekranjitbarua75 3 месяца назад
Literally brother just finished the project 😢...Getting a hudge satisfaction to add it in portfolio...Thank you so much for helping 💗 💕 ❤ 💓
@nimishaantony6400
@nimishaantony6400 Месяц назад
Excellent video! It's presented clearly and offers top-notch quality, making it easy to understand and enjoy.🥰
@datatutorials1
@datatutorials1 Месяц назад
Glad you liked it!
@user-mt5jr9vl9e
@user-mt5jr9vl9e 5 месяцев назад
Hello Swapnjeet Sir. Your content is great and the explanation is always On-point. You are the only educator/ content creator whom I follow for the learning and the projects. It is a humble request from your suscribers to upload the *Power BI Dashboard part for the Financial Domain project* as soon as possible. It would be very helpful for us.....as we are just stuck in the middle of the project, till the sql part.😓 PLEASE SIR...🙏🙏
@vishalnaik5453
@vishalnaik5453 4 месяца назад
I learned a lot from this video, thank you!
@reshmabenson9826
@reshmabenson9826 Месяц назад
Hats of to you sir for this wonderful learning experience . Hoping to learn a lot of projects with various adavnced dax functions...keep up the work
@user-uw5or5ru5k
@user-uw5or5ru5k 5 месяцев назад
This is the best video I have seen till now from the day I wanted to become a data analyst. Thank you for the work you have done in this project.
@datatutorials1
@datatutorials1 5 месяцев назад
Glad it helped you
@rodrigowalter5647
@rodrigowalter5647 3 месяца назад
This tutorial is incredible. thank you so much. What do you want to show at minute 46 when you put conditional formatting on the bars? why did you do that? I could not understand.
@debabrataroy1777
@debabrataroy1777 19 дней назад
Sir, In "YoY Car Sold Growth", "Cars Sold Diff" must be divided by "PYTD Cars Sold". Not by "YTD Cars Sold"🙏 Learnt from you sir🙏
@datatutorials1
@datatutorials1 19 дней назад
This was mistake happened while recording, I hope u corrected at your end
@adebayonuatin9071
@adebayonuatin9071 4 месяца назад
Great content Can you please do a project where you will show how to do RFM analysis in power bi and excel 🙏🏿
@shreejipaliwal1215
@shreejipaliwal1215 5 месяцев назад
Thank you so much sir. For providing this type of valuable content. I'm Following most of your videos continuously from 15 days. Please also make project videos that covers all the important topics for data analysis in Python & SQL to crack interviews.
@datatutorials1
@datatutorials1 5 месяцев назад
Definitely
@arjunkhanal5076
@arjunkhanal5076 17 дней назад
Thank you for this
@Auto-Analytix
@Auto-Analytix 5 месяцев назад
You provide great content and value add to many individuals in this field. Please keep it going!
@datatutorials1
@datatutorials1 5 месяцев назад
Thanks bro
@mr.vivekss
@mr.vivekss 4 месяца назад
Thank you sir 😊
@anshrohatgi4202
@anshrohatgi4202 5 месяцев назад
Thanks you very muchhhhhh!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@swapnilpalsapure9781
@swapnilpalsapure9781 4 месяца назад
Super tutorial sir❤
@ocraking
@ocraking Месяц назад
YOU'RE THE BEST
@ssankar4655
@ssankar4655 3 месяца назад
Thank u so much sir
@anjuli_
@anjuli_ 5 месяцев назад
Hello, Thank you for your amazing explanation !!! I have a doubt while calculating YoY car sold growth there should be PYTD Car Sold value in the denominator. But you have used YTD Car Sold Value.Could you please explain why ?
@datatutorials1
@datatutorials1 5 месяцев назад
Really, it might be by mistake, can you add the time stamp where i used it
@anjuli_
@anjuli_ 5 месяцев назад
yes , please check 19:52
@datatutorials1
@datatutorials1 5 месяцев назад
@anjuli_ ohh yes, thanks for noticing, please change while you are building dashboard. I might have forgotten in rush. Sorry for that.
@anjuli_
@anjuli_ 5 месяцев назад
No Problem.Thanks for building such insightful dashboard ...
@monishramesh3844
@monishramesh3844 Месяц назад
Had the same doubt. Its cleared now🙂
@akshayranalkar1396
@akshayranalkar1396 3 месяца назад
Thank you so much... Very helpful and informative video...
@datatutorials1
@datatutorials1 3 месяца назад
Glad it was helpful!
@user-ur8ph9lj6f
@user-ur8ph9lj6f 5 месяцев назад
This is such a valuable content for us 👏🏼... please make videos on Data Analyst interviews covering various aspects on SQL, Power BI, Excel , Python etc 😊
@datatutorials1
@datatutorials1 5 месяцев назад
Sure
@dadizalamite
@dadizalamite 5 месяцев назад
Thank you for Sharing
@datatutorials1
@datatutorials1 5 месяцев назад
Thanks for watching!
@ghoshsubhosmita
@ghoshsubhosmita 4 месяца назад
Thank you so much to you for this tutorial...
@sakthivignesh9734
@sakthivignesh9734 4 месяца назад
sis can you please send me this dashboard? because my dashboard suddenly erased.
@avilipsapadhi7745
@avilipsapadhi7745 2 месяца назад
thanks
@alexrosen8762
@alexrosen8762 3 месяца назад
Fantastic tutorial right through the whole process. Thank you so much 🙏I have learned a lot 👌 But you never did dimension tables except for Calendar? Is it not best practice?
@datatutorials1
@datatutorials1 3 месяца назад
Depends on requirements from customer
@AkashSingh-ud4ng
@AkashSingh-ud4ng 4 месяца назад
Hello sir very insightful video, I have been practicing creating dashboard since day 1 . Thank you for providing this kind of videos By the way I just saw that 20:26 In this section in the case of YOY car sold you divided the sold difference with the YTD cars sold but it should be divided with PYTD cars sold .. A Little correction just
@datatutorials1
@datatutorials1 4 месяца назад
Ya that was a mistake. Thanks for noticing
@fariahasan3965
@fariahasan3965 5 месяцев назад
Thanks
@datatutorials1
@datatutorials1 5 месяцев назад
Welcome
@limlydia7138
@limlydia7138 Месяц назад
Hi, Sir, could enquire why YoY Car sold growth should use over PYTD Cars Sold instead of YTD Cars Sold . Thank you
@tasoseudaimon167
@tasoseudaimon167 8 дней назад
I have the same question!
@syedamanullah7251
@syedamanullah7251 4 месяца назад
Excellent Sir Syed Amanullah Pakistan
@user-ok1tx2ku7s
@user-ok1tx2ku7s Месяц назад
⚠⚠Quick Question on 20:12 why did you use "YTD Cars sold" instead of "PYTD Cars Sold" to calculate the "YoY Cars sold Growth". it seems inconsistent with what you did before. ⚠⚠
@never-give-up078
@never-give-up078 Час назад
YoY Growth = (Current year- Previous Year)/Previous Year, he did the wrong division.
@shivayteam9479
@shivayteam9479 2 месяца назад
Thanks a lot brother ❤❤
@datatutorials1
@datatutorials1 2 месяца назад
Always welcome
@pritipetale7231
@pritipetale7231 2 месяца назад
Thank you for this amazing project it help me to learn, but I stuck in table visuals I unable to do aggregation on measures due to Dynamic format string can help u me how to change measures data type.
@datatutorials1
@datatutorials1 2 месяца назад
This is due to need version. You can use visual calculations for the same. See my latest video on how to use visual calculations
@manishasutradhar2961
@manishasutradhar2961 5 месяцев назад
Max point is not visualizing on the area chart. It gives the following error: Calculation error in measure car_data[Max Point]: The function MAXX cannot work with values of type Boolean. How to resolve this? Please help.
@abhishekchaturvedi6981
@abhishekchaturvedi6981 5 месяцев назад
Can't we use direct function AVERAGE to calculate Average Price Analysis in KPI
@datatutorials1
@datatutorials1 5 месяцев назад
Yea you can use
@yuvrajsinghbhadoria9357
@yuvrajsinghbhadoria9357 4 месяца назад
While calculate year on year cars sold we divide by previous year cars sold not ytd car sold
@avi417
@avi417 3 месяца назад
Hii bubble chart is not show how to add please guide me
@debabrataroy1777
@debabrataroy1777 19 дней назад
"MTD Cars Sold" should be a number sir🙏
@datatutorials1
@datatutorials1 19 дней назад
It is number
@tuhinislam7900
@tuhinislam7900 5 месяцев назад
In the updated version there is no data aggregation option, so how to calculate the % of the grand total?
@datatutorials1
@datatutorials1 5 месяцев назад
Which version, can you name it
@tuhinislam7900
@tuhinislam7900 5 месяцев назад
(December 2023)
@pritipetale7231
@pritipetale7231 2 месяца назад
I am facing same problem due to Dynamic format string add in the new updated power bi & due this unable to do aggregation on measures .
@datatutorials1
@datatutorials1 2 месяца назад
@pritipetale7231 all, just calculate it using dax. And then use it in charts.
@chinyu5934
@chinyu5934 5 месяцев назад
i m having problem in max point (area chart).it is not visualizing on the area chart .
@datatutorials1
@datatutorials1 5 месяцев назад
It depends on how correctly you format the chart, select specific column while formatting the chart
@chinyu5934
@chinyu5934 5 месяцев назад
@@datatutorials1 got it sir... before equal sign(=) i had to put the parenthesis after the total cells .
@insidehead
@insidehead 5 месяцев назад
AFTER CLICKING ON CAR DATA(DETAILS PAGE) ALL THE CARD VALUE BECOME BLANK ? WHAT WHOULD BE THE REASON..
@datatutorials1
@datatutorials1 5 месяцев назад
That should not happen, send me your workbook on swapnjeet555@gmail.com
@user-mt5jr9vl9e
@user-mt5jr9vl9e 4 месяца назад
@@datatutorials1 I am also facing the same problem. What should I do sir?
@oski18w
@oski18w 3 месяца назад
There is a mistake ! When you are doing the YoY Cars Sold Growth you divide by YTD and not PYTD
@datatutorials1
@datatutorials1 3 месяца назад
That was a mistake while recording, please correct at your end. Thanks for noticing
@nomalware2811
@nomalware2811 3 месяца назад
Yes. Thanks 😊
@chalanatyjostna2229
@chalanatyjostna2229 5 месяцев назад
there is a question. while calculating pytd total sales, you used YTD sales in calculate function. like this "PYTD Sales = CALCULATE([YTD Sales],SAMEPERIODLASTYEAR(Calender[Date].[Date]))" but while calculating PYTD Avg Price, u just used avg price instead of ytd avg price ?????? i mean instead of writing PTYD Avg Price = CALCULATE([YTD Avg Price],SAMEPERIODLASTYEAR(Calender[Date].[Date])) why have u written PTYD Avg Price = CALCULATE([ Avg Price],SAMEPERIODLASTYEAR(Calender[Date].[Date])) ???? There is a mistake in the two formulas, Please check
@datatutorials1
@datatutorials1 5 месяцев назад
There might be typo mistake, please correct for your case
@chalanatyjostna2229
@chalanatyjostna2229 5 месяцев назад
@@datatutorials1 what? i dont understand.... so what is correcct? is it PTYD Avg Price = CALCULATE([YTD Avg Price],SAMEPERIODLASTYEAR(Calender[Date].[Date])) or PTYD Avg Price = CALCULATE([ Avg Price],SAMEPERIODLASTYEAR(Calender[Date].[Date])) so the numbers in the dashboard will be different
@datatutorials1
@datatutorials1 5 месяцев назад
@chalanatyjostna2229 second one is correct
@chalanatyjostna2229
@chalanatyjostna2229 5 месяцев назад
@@datatutorials1 so the first set of kpis, for total sales are wrong numbers and have to modify the formula?
@datatutorials1
@datatutorials1 5 месяцев назад
@chalanatyjostna2229 send me time stamp where i hv used incorrectly the formula
@PakFan786
@PakFan786 4 месяца назад
can you give us a copy of the report ie pbix file to download from drive ?
@datatutorials1
@datatutorials1 4 месяца назад
No dear
@najmilfuad1786
@najmilfuad1786 4 месяца назад
why in the YoY Car sold, you used (Different car sold / YTD Car sold) ?? meanwhile in the previous YoY Avg price and YoY total sales, you divided with PYTD. Can you explain it ?
@abhishekchauhan6553
@abhishekchauhan6553 4 месяца назад
It Should be [Car Sold Diff]/[PYTD Car Sold], this is the right one.
@9868410964
@9868410964 4 месяца назад
Car sold will also be on numbers since we are counting, why there is dollar sign. Its not currency
Далее
glos bibir cokelat
00:18
Просмотров 5 млн
glos bibir cokelat
00:18
Просмотров 5 млн