Power BI Project End to End | Dashboard | Beginners | Power BI Tutorial 2023

[@pratikjugantmohapatra18]

its amazing .we highly required these kind of projects . I request all viewers to share this video as much as possible .

[@chimabu00]

Done Tableau, then Excel now starting Power BI. Thank You !!

[@jesperadams7525]

Beautifully explained, definitely the best end-to-end tutorial I have seen! Really love how you covered every step in great detail and went through the project background and stakeholders to begin with which added an interesting user experience element to the project. Really helped me with my first Power BI project 🙂

[@datatutorials1]

Glad it was helpful!

[@gabinkundwa7215]

Thank you very much for making this video! I made my first Power Bi Dashboard and I am planning to create a different one for my class project!!

[@cjbrown3396]

Hello mate thank you so much for your effort! It means a lot and as a student I learned a lot from you. Just a little advice if I may, the sound of the video wasn't very clear. Might need to use a solild desktop mic man. :)

[@chikselems5798]

i love that it is really detailed, and you took the time to explain.. Awesome stuff

[@datatutorials1]

Glad you liked it ✨

[@arcane888]

Great video. Just one slight correction: Casualties cannot be grouped by “fatal”, “slight” and so on. A casualty is a casualty. Those KPIs should be based on Count of Accidents, not Count of Casualties.

[@saniarahman1842]

Casualty doesn't necessarily mean death. It also means a person injured or hurt. Hence, slight or fatal is correct in this context.

[@user-uu2ph1qi2e]

This video has a wealth of useful, helpful information. Thanks for everything you do!

[@datatutorials1]

Thanks for your support ✨

[@Abhishek-dm4pm]

Just completed it, Thank you so much.. Learned so many things through it. ❤

[@datatutorials1]

Great job!

[@tasneemshaikh5139]

How much time u took to complete this project?

[@QatarIsmartVlogs]

30 min just need

[@nehaprasad6665]

This is the best channel for Power Bi tutorials... Thank you loved the video😊❤

[@datatutorials1]

Wow, thank you!

[@Mahanthesh.]

Your way of teaching is excellent sir...we can understand the concept easily and my suggestion is take the more row data then only we can use all types of tools...thank you so much sir

[@shivamshukla3448]

kzbin.info/www/bejne/aYOalqaeiqebnLs

[@chandrashekhara1]

Really really I'm happy for these kind of help. I would like to join as an developer or analyst for that I spent 10K to an institute where they taught only limited feauters, but when I saw this video I'm completely happy bcz Iearnt something

[@datatutorials1]

Thanks for the comment 🙂

[@TataNaresh]

Cool Dashboard 🤩 Thanks for sharing the knowledge bro Appreciate your work.👍

[@vishwassharma3312]

Fantastic sir. 🙏🙏 Very helpful video for cultivating the skills in BI.

[@datatutorials1]

Glad you liked it ✨

[@chandrimakhastagir2402]

Great video and very well explained.Will add it to my project portfolio.

[@datatutorials1]

Sure

[@shailender104]

Really superb, Expecting the source as a DB (sql) it would be more helpful , generate a report by using data base pls make a video upon it

[@datatutorials1]

Sure

[@nallapareddyhimabindu8722]

Excellent video helped to get a understanding of how to use Power BI correctly

[@datatutorials1]

Glad it was helpful!

[@LearnRight]

Thankyou a lot for the amazing video. Really helpful.

[@datatutorials1]

Glad you like it ✨

[@theplaneteers9215]

Thanks For sharing

[@gopinathperiyasamy9896]

You Made a Good Knowledge able video

[@sandhyaprabha9661]

Thankyou so much sir bcz of this video my many doubt is clear and learned many new things..thanks a lot... your effort is appreciated

[@tariqhussain1497]

Good evening, and really amazing video and explanation is very nice and i completed it and learn good things

[@datatutorials1]

Glad to hear that

[@user-nn7bg7yi5j]

Thanks first of all, To be honest you are such a great man as well as great teacher, I really cherish you Sir, today I learnt a lot in your Video thanks again, I don't have a word what I say for your appreciation.

[@datatutorials1]

Thanks for your kind words 😊

[@chibuzorstellamaris9839]

Great video, so amazing to watch your video

[@nailaaslanova03]

Thank u for perfect video ❤

[@swara4697]

Thanks for a Wonderful video . I Learnt new feature i.e. Group

[@datatutorials1]

Glad you liked 🙂

[@HappyPeople357]

thanks i got many ideas for my final project

[@priyankathakur1691]

Great Video. Do add more such PBI videos and help us learn more about challenging projects. Appreciate your effort.

[@datatutorials1]

Sure

[@nileshsingh2852]

It was great learning from you sir

[@datatutorials1]

Glad you liked it ✨

[@vishwassharma3312]

Sir , Kindly upload the video on Google Data Studio. Please.

[@rodrigowalter5647]

Excellent work! you are really good. Thank you so much!

[@KuldeepMohwal]

Great

[@banoj12]

Thanks for this effort. waiting for some more similar practice. 👌

[@datatutorials1]

Sure

[@ami4098]

Thank you for explaining in detail.

[@datatutorials1]

Glad you liked 🙂

[@TebogoSebolaMoreki101]

Very helpful ❤️❤️❤️❤️🙏🙏🙏🙏thank you very much.

[@lorenzololo821]

Awesome. Very helpful.

[@pavanr6100]

So beautiful, so elegant, just looking like a WOW

[@KomailButt]

Please make a video in which you are importing data from a Database for example importing from {Postgresql} and then making a dashboard or a report on it.

[@datatutorials1]

The next video will contain connection to Postgres SQL, multiple tables join

[@shwetabhat9981]

You are just too good sir . Such awesome content from your side always . Thank you so much for all the efforts 🙂

[@datatutorials1]

Thanks for watching, keep supporting 🙂

[@maheshbhortakke896]

Nice to see ur prompt support. Great Work Brother.

[@daviddean8749]

Thanks for sharing. Rebuild it. Can you make a video with a use case using drill down (up, through) ?

[@datatutorials1]

Thanks for watching, sure will try the drill through function

[@harshitha5000]

Thankyou so much ❤Great video it was ..looking for more videos🎉

[@thirumalareddy5537]

Thanks

[@danielolaniyi9887]

Quick question, I’m curious as to why you used to the Number of Casualties Provided as opposed to the new measure of CY Casualties we created.

[@jeetendrakumar7013]

Amazing teaching yr

[@datatutorials1]

Thanks a lot 😊

[@Dumithar]

thanks, it is a great one

[@datatutorials1]

Glad you liked it ✨

[@zoro7492]

Amazing Content!!!!

[@datatutorials1]

Glad you liked it ✨

[@gavidiharish13]

Thank you so much

[@datatutorials1]

Glad you liked it ✨

[@user-hn5pd3tx5s]

1534 rows contain blank values in road_type column and around 3000+ values contain blank values in weather condition column and still some column have blank values which didn't consider while data cleaning in this video. Can anyone explain??

[@sharonss8020]

Thank you for the detailed video

[@user-xe4jz5dm7t]

Great video.. thank you much for this wonderful learning. I have created the same dashboard can I upload this on Linkedin ?

[@datatutorials1]

Sure

[@sarathreddy-bs9qg]

God bless you bro

[@datatutorials1]

Thanks for the motivation 🙂 Glad you liked it ✨

[@oyevictor5555]

Great job, I have a challenge. I tried to replace the "fetal" with fatal but it is not replacing what should I do. I can further the work without the correction

[@gmedia1800]

put exact case, if there is " F " is capital in "Fetal" then put in capital word .

[@user-os7qy9zd3b]

Very nice and educative. Followed from start to end. But I'm having issues understanding this TotalYTD function, if it's actually to calculate the current year, we are in 2023, which is the current year, while is it calculating 2022?

[@export9041]

Sir i practiced this project..how can i describe this project in my resume .will u pls write the description

[@palbogambino3012]

super

[@datatutorials1]

Glad you liked it ✨

[@user-oq7xp8lp1s]

Thank you so much👍

[@yagniksinhjadav3321]

Amazing Video....

[@datatutorials1]

Thank you so much 😀

[@ravinithwin189]

Thank you for the awesome content

[@datatutorials1]

Glad you liked it ✨🙂

[@pankajpadole5236]

Great learning!

[@poojapradhan39]

well Explained

[@datatutorials1]

Thanks, keep supporting 🙂

[@Shortwithsecret]

its amazing, but i have problem with map, visual can not represent any data, any solution?

[@cjbrown3396]

When I extract the file to the PDF, it became a mess. The format was all out. Any idea what happened? :(

[@DataFreak-x2u]

Could you show how to implement this map in excel for this same project? I am finding it difficult

[@user-lm5wb8vi1x]

Finished watching

[@kulkarnisoham]

Should I try it ? Is it worth it ?

[@sumitraut6032]

Great Dashboad and Insights. I was trying to change the % change with conditional formatting to appear values >=0 as red and values less than < as green with Rule but not happening somehow?

[@ambujnayanmishra5550]

it heped me lot actually

[@shahirajlakade7921]

Sir I wanted to make my career in data analyst so can we master any one Business intellegence tool like powerBi or we have to do tableau also and which one companis look for.....Thank you sir with help of your videos i created two powerbi project❤

[@datatutorials1]

Hello, as per current market conditions one should know both power BI and Tableau. Also SQL and an ETL tool is a must.

[@mohcenhaji4807]

Great job

[@fog2640]

finished watching

[@nouralhilal393]

manyyy thanxxx

[@satyamrollno6076]

Sir , what is impact of this project could you explain it ?

[@fog2640]

finished practicing

[@gmedia1800]

hello sir, you explain very well. But at the time of data cleaning process there is some null value in " Road_surface_Condition" and "weather condition" so what I can do for this. can I remove those null value or replace with other road surface condition.

[@girijavarma5271]

@Data Tutorials do you have PowerBI notes also as Tableau?

[@lawaladeniyi9015]

Hi, can you give a brief explanation on why we have to create a new table for date? Thank you

[@datatutorials1]

If you need to use time intelligence functions like total ytd, same period last year, it is recommended to create a date table to get accurate results

[@GabrielAlvarezBarreto]

hello, do you have a video explainig how to do the background on powerpoint if i want another diferent strucutre

[@datatutorials1]

Yes, the video is available on my channel

[@rameezkhan9352]

1 video related for construction workplace

[@maxkamso9354]

My only problem is the last map visualizations , I am getting an error and the map is not displaying....any help? I have put the latitude and set the longitude both to average and the legend too...but not displaying

[@stephenkanu9086]

Pls I am watching your video, I need the the link to download load this dataset for my practice. Am.a.begginer in data analysis. Don't forget I need more dataset to work on. Thanks

[@datatutorials1]

Link available in description of this video

[@GauravSharma-iu5mr]

You can use the First date and last date functions while making a calender.

[@datatutorials1]

Definitely, there are different approaches to do the date table

[@missann2380]

To calculate the PY accident, the syntax is incorrect, i need hlep to navigate this part

[@ajibolaadekunle4884]

Please explain why do you have to divide PY casualties, after subtracting CY casualties from PY casualties to get result for YOY casualties. ([CY casualties] - [PY casualties])/[PY casualties] = YOY casualties. Many thanks in advance

[@datatutorials1]

It the formula to calculate year on year growth

[@ajibolaadekunle4884]

@@datatutorials1 thanks so much. I really appreciate your unflinching effort.

[@brajendrakumarsingh6767]

Sir where we use programing language like python and R library numpy and pandas and matplotlib How we create this type of project please make a videos

[@shubhamshirsat9367]

How to create measure sir , bcoz my cy casualties is not working and create measure part is skipped

[@ruhiscorner7318]

Hello sir, for CY Casualties, I have tried taking the sum of no. of casualties instead of using the TotalYTD function. Can you please explain what is the difference between both the methods and why am I getting different results?

[@datatutorials1]

Hi, if you directly use the sum of casualties in the viz, it will show the correct value if we have a date filter in the dashboard. But if the date filter isn't in the dashboard. This method can be used. But if you are specifically asked to find CY i.e YTD casualties you must use the time intelligence function i.e totalytd

[@ruhiscorner7318]

@@datatutorials1 So basically the TotalYTD is calculating the sum of no. Of casualties only for the year 2022 and not for 2021 right?

[@datatutorials1]

Correct

[@ruhiscorner7318]

@@datatutorials1 Got it, thanks

[@user-dr6wu8xn5j]

why my number seems different from yours after taking ytd calculation

[@akshaybadgujar9344]

sir after load the data the date format of accident date column name was chnaged

[@jaykantkumar4474]

I iam not able to create month column using same command.It's showing error (cannot find table 'mmm'

[@monikamanchanda1626]

please provide link for background creation

[@lkccreation5565]

In real time we bring data from SQL database then how edit that data?

[@Sasta_Shayer]

Last map chart not working 😢how does it work

[@maheshbhortakke896]

What is d difference between Total CY Casualties and Total CY Accidents?

[@datatutorials1]

Total CY accidents are the total accidents taking place in the current year. Total CY Casualties are the people who were injured in the current year in accidents.

[@omareltaweel6573]

why convert Latitude & Longitude to avg ??

[@ailebao9176]

Sir, can you help me how to collect or where to find datasets like yours. Many thanks.

[@datatutorials1]

Kaggle website

[@ff30second49]

bro i have an doubt in this video, you are saying CY casualities which means 2022 data or total casualities

[@datatutorials1]

2022

[@ff30second49]

@@datatutorials1 thanks bro

[@vishalmane3139]

Can u make extensive data Cleaning video on a super messy dataset

[@datatutorials1]

Surely in next video

[@shubham7564]

At 1hr, 22 minutes, why measure (CY casualties) not used in the graph. Why two measures like CY casulties and PY casualties mapped on a graph do not give same result?

[@datatutorials1]

You can show but you have to aggregate them at level of zip code

[@rebel4417]

Great video! Could you make a dashboard for weather forecast of multiple Indian cities using REST API

[@datatutorials1]

Sure

[@vjyrml]

My only problem is also the last map visualizations , I am getting an error and the map is not displaying I have kept as is..., could you reply ..?

[@vjyrml]

When Cleared Cache in the options, it is working..

[@BhuvaneshItte]

Connecting to models shows error