@@aduntoridas010 Atleast your should a knowledge to open system, he cannot do anything for it, what else you are expecting from him.? Very usefull resource.
I finished creating exact dashboard and i must confess this was really good. I mean I learned what I didn't learn from paid course in one day and practiced for less than 5 days. Thank you so much @datatutorials
Learn by doing. At last, I finished within 2/3 hours of investing. I think at least I know something in Excel to create charts and present them in a well-organized way. Thanks a lots
I appericiate your video. Although I am using excel from last 10 year for calculation but I learned aloat in data analytics perspective as well as accounts related few things from your video. Habib fro Pakistan for you 🎉
"It was truly a wonderful journey of learning. I am a working professional and can't dedicate much time to this. Your video was almost 1.4 hours long, so I finished this project within 3 days by dedicating 1 to 1.5 hours per day. Thank you so much, and I am looking forward to hearing from you."
There were so many precious information, I mean minute details that I haven't found in any other video. Thank you for teaching and keep making such videos
Hey I believe that right after using the formula for months and years, we must change results in value format because sometimes if we remove certain data from a row, it might end up changing the values associated with the formula
Thank you brother. What an amazing tutorial. I learned more than I expected. Really informative, well explained and clearly delivered. God bless you. Love from South Africa.
@@datatutorials1 I am having a small query,if you solved it really appricable. In Accident Data Slicer I am not getting option to select all pivottables it just shows pivote tables of KPI not others, please help me out.
Thanks for you effort sir. I think instead of creating calculated items then hide the original items, we can use the group field option in the group section in PivotTable Analyzer.
Thanks you for this awesome video. i have a question please, why when we made the line chart we did not make only one pivot table that has months ar rows and year as columns then we create a line pivotchart !!?
21:50 create "Sum of Number_of_Casualties" column 2 time and select column and right click show value as > % Parent row total... you will get percentage wrt total for all 3 in single click.
At 1:19:00 I get some different values of the no of casualties compared to the video I check every possible way to know why it happened so even though it works good . This video made me to do more projects on data analytics keep doing
Brother there are some blanks : Carriageway_Hazards have blanks, Road_Surface_Conditions have some blanks, Road_Type have some blanks, time have some blanks, Weather_Conditions have some blanks. What will I do with those blanks? I have done so far 19:46 minutes. I dont know if you have talked about those blanks later part of the video. Should we leave those blanks or what to do ? Plz write.
My timeline doesn’t reflect all the pivots created in different sheets. Apart from that would like to mention that this session has been really helpful. Thank you! Please help with the “Timeline not reflecting all the pivot” issue
i'll add this as a project on my linked in profile and will mentioned you in it. its my second excel dashboard project because i am a beginner. Thanks for this wonderful video. At last i have a query what should i learn first after excel, SQL or POWER BI (done with python already )
@Data Tutorials Thanks for such amazing content. Hey everyone! I just finished this project, but my timeline doesn't seem to affect the Casualties by Location/Area & Light Condition Charts. The corresponding Pivots won't show up when I try to add them on the Report Connections tab. Any help would be much appreciated. Thanks!
In data cleaning process at 8:36 you said the "accident index" is the primary key but it has nearly 110,000 duplicate values but some has minor or major difference between each record (means accident date, junction etc are different) what should be done in that case? Junction Control has typo mistake 10:01 "Carriageway hazards" have blanks (empty cells) also "ROAD surface conditions", "road type", "time" and "weather condition" has so many blanks. Shouldn't it be replaced with "unknown" or "None" ? or it should be deleted
Thank you for this complete detailed end to end Data analysis project... Thank you once again.. Please upload the complete project on healtcare and FMCG industry. Please it's a request. Thank you
Hi. Thank you for your very useful video. I am facing an issue with the filter panel in dashboard. In timeline tab all the pivot tables are not visible due to which all the charts are not getting filtered based on the timeline. What's the issue and how to correct it? I checked on internet but not getting satisfactory resolution. Please help.
@@datatutorials1 It was helpful for some extent. It seems there was an issue with data source selection. I created all the pivots in one sheet and then changed the data source for all tables and then my timeline was able to filter all the pivots. Thanks for your help.. ☺️
I did some projects like this, but if you want to do a project on this way you must be clear the objectives and the benefits of its. The principal benefits of any initiative like this is repeatability and its incorporation into work processes relatives to the take dicisions
Very informative and helpful video thank you sir. If i want add such projects in my resume then what have to do or How can we use this project in resume ?
Thanks so much for these, I really learnt a lot. But I discovered "Casualty type i.e severe, fatal ,slight) doesn't connect with my timeline, please what should I do?
Thank you so much this was really helpful, it took me 3days to finish but while trying to make the the data analysis sheet, I noticed all the figure has changed. Please I don't what I pressed. what do I do?
When added Timeline so that to ensure the Donut charts and data are flexible. I'm not getting any response from the Donut charts but the pivot table data are flexible and changing
hello there thanks for you effort , just i wanna say if you working in the same file that you shared with us there are lots of blank values in more than one column so how come did you skiped them
A to Z . Excel dashboard learning the greatest tutorial I have ever seen
Thanks for your support 😊
@@datatutorials1 l
Yeah, If you're a beginner you cant even start this project. How the hell do you even open the data to excel?
@@aduntoridas010 Atleast your should a knowledge to open system, he cannot do anything for it, what else you are expecting from him.? Very usefull resource.
@@datatutorials1Thank you for making us understand this so easily
At 10:10 Data cleaning is also required in Junction control, where "Auto traffic sigl" should be replaced with "Auto traffic signal"
Correct
Noticed that too@@echodelta7680
It's a lot more in that column, at least 4-5 different errors
@@F_ckOffThanks can you explain what else is wrong in that column?
@@sohaybemad623many ,enough blanks
Done finishing your tutorial, it was worth my time! So helpful and informative. Please make more such content!
I finished creating exact dashboard and i must confess this was really good. I mean I learned what I didn't learn from paid course in one day and practiced for less than 5 days. Thank you so much @datatutorials
Did you notice that in the Accident_Index column, many of the cells have 2.01E+12? What did you do about it?
@@FelixTola-Winjobi turn them into number format instead of scientific notation.
This is my 2nd iteration in learning to create excel dashboards! Just finished it and I learned a ton! Thank you for this content brother!
Glad it was helpful!
Thank you ! I learned so much! I'm a retired teacher who is changing careers. Your video helped me so much in understanding data analysis.
Glad it was helpful!
Learn by doing.
At last, I finished within 2/3 hours of investing. I think at least I know something in Excel to create charts and present them in a well-organized way.
Thanks a lots
how u get this dataset bro?
How to get the dataset? I'm unable to download it.
I appericiate your video. Although I am using excel from last 10 year for calculation but I learned aloat in data analytics perspective as well as accounts related few things from your video.
Habib fro Pakistan
for you 🎉
I've learned more following along with this than any of the courses I've taken. Tysm!
Landed into best learning platform. Just finished this project. Thank you
Glad it helped!
Not a regular UA-cam commenter but I really appreciate this. You are wonderful for sharing this knowledge
"It was truly a wonderful journey of learning. I am a working professional and can't dedicate much time to this. Your video was almost 1.4 hours long, so I finished this project within 3 days by dedicating 1 to 1.5 hours per day. Thank you so much, and I am looking forward to hearing from you."
Wow!! Good job. Thank you for doing this. I has increased my confidence level in building dashboard.
There were so many precious information, I mean minute details that I haven't found in any other video. Thank you for teaching and keep making such videos
Completed Second project on Data Analysis with Excel.Thank you so much for the wonderful guidance and helping me towards the steps to reach my goal.😀
Hey! Did you get a job through these kind of projects please reply
full of insights , knowlageble session , it took me around 4+ hrs to complete , but learnt so much . Thankyou so much for this effort
ua-cam.com/video/i7HNL4Cn-g8/v-deo.htmlsi=7qQRHrlrLFNNoGpf
Thank you very much. This is the best Excel dashboard I have completed. Thank you very much.
I totally enjoyed working on this project alongside. It took me more than 2 hours to complete, but learn't a lot. Great work!
Glad you enjoyed it!
Hey I believe that right after using the formula for months and years, we must change results in value format because sometimes if we remove certain data from a row, it might end up changing the values associated with the formula
ua-cam.com/video/i7HNL4Cn-g8/v-deo.htmlsi=7qQRHrlrLFNNoGpf
Thank you brother.
What an amazing tutorial.
I learned more than I expected.
Really informative, well explained and clearly delivered.
God bless you.
Love from South Africa.
ua-cam.com/video/i7HNL4Cn-g8/v-deo.htmlsi=7qQRHrlrLFNNoGpf
For the first time am seeing a complete end to end excel dashboard thanks for the knowledge
it was second dashboard, nice explanation and well designed. I Completed it. Thanks for this , Love❣
wow what a project, learn lot of insightful things. Thank you so much.
thank you so much, I hope every good deeds from the people u close with or even stranger woud be paid back to you, Aameen.
Thanks dear 😊
Sir, timeline is not showing in my excel@@datatutorials1
Thank you man, you've helped me complete my first excel project.
Thank you so much for this tutorial, it was worth watching the whole video, being a newbee in data analysis field have learnt so many things.
This is So Helpful and shows that you are knowledgeable & gifted to be a teacher!
Thanks for these kink words 🙂
What an amazing video for creating Dashboard in Ms Excel. I found it very useful and it gave me more confidence for building a Dashboard.
so true its same with me.
I appreciate your recognition of efforts in providing assistance and guidance, Thanks !!
Thanks for kind words, keep supporting
@@datatutorials1 I am having a small query,if you solved it really appricable. In Accident Data Slicer I am not getting option to select all pivottables it just shows pivote tables of KPI not others, please help me out.
Thanks for you effort sir.
I think instead of creating calculated items then hide the original items, we can use the group field option in the group section in PivotTable Analyzer.
Pls make more excel projects I really do enjoy learning it and how you make it simple❤❤❤
Bro Thank so much for your videos , they are super, well explained and above all industry standard . Keep the good work.
Thank you so much 🙂
dude.. you're pro yaar, this excel sheet is really impressive.
this was so amazing experience....thank you sir for your guidance
I enjoyed every bit of this tutorial. Thank you so much man. You covered alot of important things
Glad you enjoyed it ✨
@@datatutorials1nice work,I really enjoyed it..the blanks ,are we removing it?
This is beautiful. Thank you. I just added this to my resume
Cool
Thanks you for this awesome video.
i have a question please, why when we made the line chart we did not make only one pivot table that has months ar rows and year as columns then we create a line pivotchart !!?
Very Informative Sir.. Beautiful Dashboard.. Thanks for this Content..I learn a lot for this.
So nice of you
21:50 create "Sum of Number_of_Casualties" column 2 time and select column and right click show value as > % Parent row total... you will get percentage wrt total for all 3 in single click.
Thank you Bhaiya for teaching us how to make a highly interactive Dashboard👍
The greatest excel project i've ever seen..thanks a lot for the detailed information
You are most welcome
59:50
Well done 🎉
God bless you so much for the effort
Thanks and welcome
At 1:19:00 I get some different values of the no of casualties compared to the video I check every possible way to know why it happened so even though it works good . This video made me to do more projects on data analytics keep doing
"Goat" teaching - Thankyou so much ❤
Great Dashboard
Great Explanation
Brother there are some blanks : Carriageway_Hazards have blanks, Road_Surface_Conditions have some blanks, Road_Type have some blanks, time have some blanks, Weather_Conditions have some blanks. What will I do with those blanks? I have done so far 19:46 minutes. I dont know if you have talked about those blanks later part of the video. Should we leave those blanks or what to do ? Plz write.
I removed mine
My timeline doesn’t reflect all the pivots created in different sheets. Apart from that would like to mention that this session has been really helpful. Thank you! Please help with the “Timeline not reflecting all the pivot” issue
Had the same issue. Please do let me know if you figure it out. Thanks!
PLEASE i am currently having same issues.Any help?@@raghunathrajendran9576
I really enjoyed this tutorial. Thank you. Please can you do one for product analysis
I have uploaded more recently
Great work every beginner should watch this video
Thanks for the comment, keep supporting 🙂
I think instead of the duplication of the values from the pivot tables , we can save the values from the pivot table as named ranges
Indeed you’re a great teacher. Thank you very much🙏🏻
Please, how do you access the raw data. I didn't see link to download it.
Very informative and explained in detail. I liked the detailing and how every point was explained. Thankyou Sir. I have learned alot !!!!!
Glad you liked it ✨
Thank you for this project.i learned a lot from this
i'll add this as a project on my linked in profile and will mentioned you in it. its my second excel dashboard project because i am a beginner.
Thanks for this wonderful video.
At last i have a query what should i learn first after excel, SQL or POWER BI (done with python already )
Learn SQL and POWER BI and you are good for a good job
Hello Brother I am from a non tech background could you recommend me some python websites for data analysis so it begins from the beginning
@@ghaniksahni you can start from w3 school its good for beginners.
I “PARTICULARLY” liked this video❤
I got that, thats in my every sentence 😅
@@datatutorials1 But great dashboard, I am halfway done.....
awesome...all details has been shown..thank you sir..
I watched this video without skip ,your teaching method is too nice, thankyou ♥️
This was such a great tutorial. Great explanations awesome Guidence. New subscriber.
Thanku so much sir ❤️🙏please keep uploading more and more projects like that so we could learn it... 🙏😃
Fantastic stuff! Keep up the good work!
Thank you so much for this guided project🙂
Thank you, it was very informative and easy to follow. 👍
Did u remove the blank?
Love you bro for providing such an informative and detailed video. Eagerly waiting for your next video
Glad you liked it ✨
Great tutorial buddy, learned a lot from this project tutorial.
Learnt a lot from this tutorial. Thank you!
Infact you are the best i love this
Soo informative Dashboard thanks for detailed explaination.
Glad you liked !🙂
I have learnt a lot through your this video. I already did a few projects earlier but this is the most thorough video of all. Thanks a lot sir.
ua-cam.com/video/i7HNL4Cn-g8/v-deo.htmlsi=7qQRHrlrLFNNoGpf
@Data Tutorials Thanks for such amazing content.
Hey everyone! I just finished this project, but my timeline doesn't seem to affect the Casualties by Location/Area & Light Condition Charts. The corresponding Pivots won't show up when I try to add them on the Report Connections tab. Any help would be much appreciated. Thanks!
thanks you so i really learnt alot from this project
this is cool, thanks lots of love from kathmandu,Nepal
Hello sir, I followed this tutorial step by step and built a dashboard with the same data, is it okay if I use it in my project portfolio?
Good Job and clear explanation, Keep it up
In data cleaning process at 8:36 you said the "accident index" is the primary key but it has nearly 110,000 duplicate values but some has minor or major difference between each record (means accident date, junction etc are different) what should be done in that case?
Junction Control has typo mistake 10:01
"Carriageway hazards" have blanks (empty cells) also "ROAD surface conditions", "road type", "time" and "weather condition" has so many blanks. Shouldn't it be replaced with "unknown" or "None" ? or it should be deleted
It is cleaning mistake, delete those records please
This was super helpful. Really gave me the boost I needed. Thank you sir
Project added to my portfolio, Thanks
Thank you for this complete detailed end to end Data analysis project...
Thank you once again.. Please upload the complete project on healtcare and FMCG industry. Please it's a request.
Thank you
Fantastic presentation. it was really awesome and helpful. please where do i get the data you have use for practice?
In the description
I got it. Thank you very much@@datatutorials1
Hi. Thank you for your very useful video. I am facing an issue with the filter panel in dashboard. In timeline tab all the pivot tables are not visible due to which all the charts are not getting filtered based on the timeline. What's the issue and how to correct it? I checked on internet but not getting satisfactory resolution. Please help.
Try bringing all the pivot tables in one sheet and then try
@@datatutorials1 It was helpful for some extent. It seems there was an issue with data source selection. I created all the pivots in one sheet and then changed the data source for all tables and then my timeline was able to filter all the pivots. Thanks for your help.. ☺️
Thank u Clear Explanation 🙂
I did some projects like this, but if you want to do a project on this way you must be clear the objectives and the benefits of its. The principal benefits of any initiative like this is repeatability and its incorporation into work processes relatives to the take dicisions
Bro you are doing an amazing job, this is awesome, thank you so much for sharing the great knowledge
Very informative and helpful video thank you sir.
If i want add such projects in my resume then what have to do or How can we use this project in resume ?
Thank you so much sir for this useful video 👍👍👍👍
Very nice tutorial, but prefer we use Fn+f5, select special then blanks so we can easily find the blanks int he data.
Thanks so much for these, I really learnt a lot. But I discovered "Casualty type i.e severe, fatal ,slight) doesn't connect with my timeline, please what should I do?
Check in report connection if they are connected
THANKS FROM EGYPT
I really enjoyed this video. Taught me a lot. Thank you.
Thank you so much this was really helpful, it took me 3days to finish but while trying to make the the data analysis sheet, I noticed all the figure has changed. Please I don't what I pressed. what do I do?
This is amazing dashboard, thanks for sharing this.
When added Timeline so that to ensure the Donut charts and data are flexible. I'm not getting any response from the Donut charts but the pivot table data are flexible and changing
hello there thanks for you effort , just i wanna say if you working in the same file that you shared with us there are lots of blank values in more than one column so how come did you skiped them
Thank you so much, For such a detailed and learning dashboard
Glad you liked it ✨
It was excellent. I want know which version of ms excel you user? I use 2016 so that there I don't find all options. Thank you
Used 2021
Thank you Anna
For your wonderful explanation 👍
Really great, thanks for this
6:05 Could you please let me know how a Excel work sheet contains 3.07 million rows? By default there are 1.4 million something rows.
Didn't get your doubt
I have completed this project thank u very much sir
Glad you liked it ✨
This is really amazing. I've learnt a lot. Thanks for this
Biiiig thanks sir
So clear & informative
Glad you liked, keep supporting