@@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.
"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."
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 🎉
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
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.
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
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.
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 !!?
@@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.
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
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.
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 ?
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 )
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
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
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?
@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!
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
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
"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."
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.
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 🎉
Not a regular RUclips commenter but I really appreciate this. You are wonderful for sharing this knowledge
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!
Landed into best learning platform. Just finished this project. Thank you
Glad it helped!
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!
I've learned more following along with this than any of the courses I've taken. Tysm!
Done finishing your tutorial, it was worth my time! So helpful and informative. Please make more such content!
For the first time am seeing a complete end to end excel dashboard thanks for the knowledge
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
full of insights , knowlageble session , it took me around 4+ hrs to complete , but learnt so much . Thankyou so much for this effort
ruclips.net/video/i7HNL4Cn-g8/видео.htmlsi=7qQRHrlrLFNNoGpf
Wow!! Good job. Thank you for doing this. I has increased my confidence level in building dashboard.
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!
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
Great Dashboard
Great Explanation
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
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.
dude.. you're pro yaar, this excel sheet is really impressive.
Thank you man, you've helped me complete my first excel project.
"Goat" teaching - Thankyou so much ❤
Pls make more excel projects I really do enjoy learning it and how you make it simple❤❤❤
Thank you Bhaiya for teaching us how to make a highly interactive Dashboard👍
this was so amazing experience....thank you sir for your guidance
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.
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
59:50
Well done 🎉
God bless you so much for the effort
Thanks and welcome
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
ruclips.net/video/i7HNL4Cn-g8/видео.htmlsi=7qQRHrlrLFNNoGpf
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.
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.
ruclips.net/video/i7HNL4Cn-g8/видео.htmlsi=7qQRHrlrLFNNoGpf
I “PARTICULARLY” liked this video❤
I got that, thats in my every sentence 😅
@@datatutorials1 But great dashboard, I am halfway done.....
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 !!?
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?
Thank you so much for this guided project🙂
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.
awesome...all details has been shown..thank you sir..
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 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
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 for this project.i learned a lot from this
thanks you so i really learnt alot from this project
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?
Great work every beginner should watch this video
Thanks for the comment, keep supporting 🙂
I really enjoyed this tutorial. Thank you. Please can you do one for product analysis
I have uploaded more recently
Very Informative Sir.. Beautiful Dashboard.. Thanks for this Content..I learn a lot for this.
So nice of you
The greatest excel project i've ever seen..thanks a lot for the detailed information
You are most welcome
This is beautiful. Thank you. I just added this to my resume
Cool
Thanku so much sir ❤️🙏please keep uploading more and more projects like that so we could learn it... 🙏😃
I watched this video without skip ,your teaching method is too nice, thankyou ♥️
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 🙂
Learnt a lot from this tutorial. Thank you!
Thank you, it was very informative and easy to follow. 👍
Did u remove the blank?
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.
Good Job and clear explanation, Keep it up
Project added to my portfolio, Thanks
Very nice tutorial, but prefer we use Fn+f5, select special then blanks so we can easily find the blanks int he data.
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 ?
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.
Infact you are the best i love this
This was such a great tutorial. Great explanations awesome Guidence. New subscriber.
Soo informative Dashboard thanks for detailed explaination.
Glad you liked !🙂
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
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 love indians because they share knowledge
Fantastic stuff! Keep up the good work!
Nice Excel Project
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
I have completed this project thank u very much sir
Glad you liked it ✨
This is amazing dashboard, thanks for sharing this.
Thanks from Indonesian 😊
this is cool, thanks lots of love from kathmandu,Nepal
excellent teaching
30 Percent of advancen Excel i learnt here ❤
Amazing learning lesson thank you very much ❤❤
good project
Thank you so much sir for this useful video 👍👍👍👍
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
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?
@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!
good learning. nice to learn more.
Great explanation sir! Can we use power query for cleaning the data?
This is an awesome presentation
Thank you very much Sir. I learned a lot!
In the cleaning phase, there are two options that has the same meaning which are
Darkness - lights unlit
Darkness - no lighting, Is that right?
Thank you Anna
For your wonderful explanation 👍
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.
ruclips.net/video/i7HNL4Cn-g8/видео.htmlsi=7qQRHrlrLFNNoGpf
thanks for your hard work
It's my pleasure
awesome video ple make more like this
I really enjoyed this video. Taught me a lot. Thank you.
This was super helpful. Really gave me the boost I needed. Thank you sir
Thank you so much... i learnt a lot from this project.
Quick question, my slicers are not connecting with all my sheets, what do i do?
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 for shared knowledge
Thank you for tutorial, really helpful.