Full Project in Excel with Interactive Dashboard | Excel Project | Excel Project from Start to End

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 576

  • @ipnnemkhan
    @ipnnemkhan Рік тому +70

    A to Z . Excel dashboard learning the greatest tutorial I have ever seen

    • @datatutorials1
      @datatutorials1  Рік тому +6

      Thanks for your support 😊

    • @pabitramohanty30
      @pabitramohanty30 Рік тому +2

      ​@@datatutorials1 l

    • @aduntoridas010
      @aduntoridas010 6 місяців тому

      Yeah, If you're a beginner you cant even start this project. How the hell do you even open the data to excel?

    • @waqassheikh8366
      @waqassheikh8366 5 місяців тому

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

    • @allaboutpriya1996
      @allaboutpriya1996 4 місяці тому

      ​@@datatutorials1Thank you for making us understand this so easily

  • @himanshutiwari1935
    @himanshutiwari1935 Рік тому +46

    At 10:10 Data cleaning is also required in Junction control, where "Auto traffic sigl" should be replaced with "Auto traffic signal"

    • @echodelta7680
      @echodelta7680 Рік тому

      Correct

    • @noluthandosibiya982
      @noluthandosibiya982 Рік тому

      Noticed that too@@echodelta7680

    • @F_ckOffThanks
      @F_ckOffThanks 10 місяців тому

      It's a lot more in that column, at least 4-5 different errors

    • @sohaybemad623
      @sohaybemad623 4 місяці тому

      @@F_ckOffThanks can you explain what else is wrong in that column?

    • @aminushehu4114
      @aminushehu4114 Місяць тому

      ​@@sohaybemad623many ,enough blanks

  • @SayaliTawade-v2i
    @SayaliTawade-v2i Рік тому +30

    Done finishing your tutorial, it was worth my time! So helpful and informative. Please make more such content!

  • @bolumekenejoan6360
    @bolumekenejoan6360 Рік тому +10

    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

    • @FelixTola-Winjobi
      @FelixTola-Winjobi Рік тому

      Did you notice that in the Accident_Index column, many of the cells have 2.01E+12? What did you do about it?

    • @shafiqurrehman8476
      @shafiqurrehman8476 Рік тому +1

      @@FelixTola-Winjobi turn them into number format instead of scientific notation.

  • @elijahxavion9509
    @elijahxavion9509 Рік тому +17

    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!

  • @victorialatavish4266
    @victorialatavish4266 Рік тому +6

    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.

  • @harunrhimu
    @harunrhimu 11 місяців тому +10

    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

  • @habibkhanjadoon1150
    @habibkhanjadoon1150 Рік тому +5

    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 🎉

  • @TheManOfTheHourEveryHour
    @TheManOfTheHourEveryHour Рік тому +5

    I've learned more following along with this than any of the courses I've taken. Tysm!

  • @pradipbhatta4986
    @pradipbhatta4986 Рік тому +3

    Landed into best learning platform. Just finished this project. Thank you

  • @okorouche6934
    @okorouche6934 5 місяців тому +1

    Not a regular UA-cam commenter but I really appreciate this. You are wonderful for sharing this knowledge

  • @maheshrathod204
    @maheshrathod204 10 місяців тому

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

  • @esthermelihanah
    @esthermelihanah Рік тому +3

    Wow!! Good job. Thank you for doing this. I has increased my confidence level in building dashboard.

  • @SaugatShrestha-im7pi
    @SaugatShrestha-im7pi 4 місяці тому +1

    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

  • @njamrutharikka4105
    @njamrutharikka4105 11 місяців тому +11

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

    • @tariqazam-k8j
      @tariqazam-k8j Місяць тому

      Hey! Did you get a job through these kind of projects please reply

  • @Shivam-ow8sd
    @Shivam-ow8sd Рік тому +1

    full of insights , knowlageble session , it took me around 4+ hrs to complete , but learnt so much . Thankyou so much for this effort

  • @abhasabessolo1
    @abhasabessolo1 Рік тому +1

    Thank you very much. This is the best Excel dashboard I have completed. Thank you very much.

  • @asomya87
    @asomya87 8 місяців тому

    I totally enjoyed working on this project alongside. It took me more than 2 hours to complete, but learn't a lot. Great work!

  • @jjk435
    @jjk435 Рік тому +14

    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

  • @kylemunsami6039
    @kylemunsami6039 Рік тому +8

    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.

  • @Benson_promise
    @Benson_promise 3 місяці тому

    For the first time am seeing a complete end to end excel dashboard thanks for the knowledge

  • @RAGHUPATI.1SI18EC07
    @RAGHUPATI.1SI18EC07 10 місяців тому +1

    it was second dashboard, nice explanation and well designed. I Completed it. Thanks for this , Love❣

  • @kunalkumaraiml2365
    @kunalkumaraiml2365 Рік тому +3

    wow what a project, learn lot of insightful things. Thank you so much.

  • @ziddneyyy
    @ziddneyyy Рік тому +1

    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.

  • @nyati-rd8rk
    @nyati-rd8rk 8 місяців тому +1

    Thank you man, you've helped me complete my first excel project.

  • @KavitaShinde-d1e
    @KavitaShinde-d1e Рік тому +1

    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.

  • @shumettefera3258
    @shumettefera3258 Рік тому +2

    This is So Helpful and shows that you are knowledgeable & gifted to be a teacher!

  • @Karansingh-xw2ss
    @Karansingh-xw2ss Рік тому +3

    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.

  • @shubhamlodha7462
    @shubhamlodha7462 Рік тому +1

    I appreciate your recognition of efforts in providing assistance and guidance, Thanks !!

    • @datatutorials1
      @datatutorials1  Рік тому

      Thanks for kind words, keep supporting

    • @shubhamlodha7462
      @shubhamlodha7462 Рік тому

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

  • @sohaybemad623
    @sohaybemad623 4 місяці тому +1

    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.

  • @tosinwilliams9343
    @tosinwilliams9343 Рік тому +2

    Pls make more excel projects I really do enjoy learning it and how you make it simple❤❤❤

  • @providentheightmotivations1067

    Bro Thank so much for your videos , they are super, well explained and above all industry standard . Keep the good work.

  • @sggamingzone4284
    @sggamingzone4284 2 місяці тому

    dude.. you're pro yaar, this excel sheet is really impressive.

  • @TechKeeda0708
    @TechKeeda0708 5 місяців тому +1

    this was so amazing experience....thank you sir for your guidance

  • @seunfashina
    @seunfashina 11 місяців тому

    I enjoyed every bit of this tutorial. Thank you so much man. You covered alot of important things

    • @datatutorials1
      @datatutorials1  11 місяців тому

      Glad you enjoyed it ✨

    • @aminushehu4114
      @aminushehu4114 Місяць тому

      ​@@datatutorials1nice work,I really enjoyed it..the blanks ,are we removing it?

  • @analytical_lab
    @analytical_lab Рік тому +5

    This is beautiful. Thank you. I just added this to my resume

  • @sohaybemad623
    @sohaybemad623 4 місяці тому +1

    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 !!?

  • @markies_gaming
    @markies_gaming Рік тому +1

    Very Informative Sir.. Beautiful Dashboard.. Thanks for this Content..I learn a lot for this.

  • @rajan_chauhan_
    @rajan_chauhan_ 8 місяців тому

    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.

  • @shersingh1130
    @shersingh1130 Рік тому +1

    Thank you Bhaiya for teaching us how to make a highly interactive Dashboard👍

  • @bloodyred633
    @bloodyred633 Рік тому +1

    The greatest excel project i've ever seen..thanks a lot for the detailed information

  • @davui_21
    @davui_21 9 місяців тому +1

    59:50
    Well done 🎉
    God bless you so much for the effort

  • @navinjakkula4041
    @navinjakkula4041 Рік тому

    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

  • @vasanthkumarcroos8605
    @vasanthkumarcroos8605 4 місяці тому

    "Goat" teaching - Thankyou so much ❤

  • @mdfurkanansari3916
    @mdfurkanansari3916 Місяць тому +1

    Great Dashboard
    Great Explanation

  • @modassarhossain735
    @modassarhossain735 7 місяців тому +2

    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.

  • @bidisha7347
    @bidisha7347 10 місяців тому +1

    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

    • @raghunathrajendran9576
      @raghunathrajendran9576 10 місяців тому

      Had the same issue. Please do let me know if you figure it out. Thanks!

    • @akinjolebolaji2912
      @akinjolebolaji2912 9 місяців тому

      PLEASE i am currently having same issues.Any help?@@raghunathrajendran9576

  • @christinemburu1166
    @christinemburu1166 Рік тому +1

    I really enjoyed this tutorial. Thank you. Please can you do one for product analysis

  • @technofreak-tl5zd
    @technofreak-tl5zd Рік тому +1

    Great work every beginner should watch this video

  • @sohaybemad623
    @sohaybemad623 4 місяці тому +1

    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

  • @mentalvault111
    @mentalvault111 Рік тому

    Indeed you’re a great teacher. Thank you very much🙏🏻

  • @priyankapatil5800
    @priyankapatil5800 Рік тому +4

    Very informative and explained in detail. I liked the detailing and how every point was explained. Thankyou Sir. I have learned alot !!!!!

  • @Allokkkkkk
    @Allokkkkkk 10 місяців тому +1

    Thank you for this project.i learned a lot from this

  • @not_a_userz
    @not_a_userz Рік тому +1

    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 )

    • @newconceptdigital8641
      @newconceptdigital8641 Рік тому +1

      Learn SQL and POWER BI and you are good for a good job

    • @ghaniksahni
      @ghaniksahni Рік тому

      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

    • @rishusingh8216
      @rishusingh8216 Рік тому

      @@ghaniksahni you can start from w3 school its good for beginners.

  • @MonkeyDLuffy4885
    @MonkeyDLuffy4885 6 місяців тому +1

    I “PARTICULARLY” liked this video❤

    • @datatutorials1
      @datatutorials1  6 місяців тому

      I got that, thats in my every sentence 😅

    • @MonkeyDLuffy4885
      @MonkeyDLuffy4885 6 місяців тому +1

      @@datatutorials1 But great dashboard, I am halfway done.....

  • @RoshniMishra-zg5ot
    @RoshniMishra-zg5ot 9 місяців тому +1

    awesome...all details has been shown..thank you sir..

  • @sujoymondal6977
    @sujoymondal6977 Рік тому

    I watched this video without skip ,your teaching method is too nice, thankyou ♥️

  • @GangsterNerd1
    @GangsterNerd1 2 місяці тому

    This was such a great tutorial. Great explanations awesome Guidence. New subscriber.

  • @satyamkumar1534
    @satyamkumar1534 Рік тому

    Thanku so much sir ❤️🙏please keep uploading more and more projects like that so we could learn it... 🙏😃

  • @sandrambonani2564
    @sandrambonani2564 Рік тому +1

    Fantastic stuff! Keep up the good work!

  • @ezehconfidenceadaeze6189
    @ezehconfidenceadaeze6189 9 місяців тому +1

    Thank you so much for this guided project🙂

  • @kirangurudas5666
    @kirangurudas5666 Місяць тому

    Thank you, it was very informative and easy to follow. 👍

  • @SandeepK75551
    @SandeepK75551 Рік тому +2

    Love you bro for providing such an informative and detailed video. Eagerly waiting for your next video

  • @Mr.Potato23
    @Mr.Potato23 Рік тому +5

    Great tutorial buddy, learned a lot from this project tutorial.

  • @amnestyigbinedion9433
    @amnestyigbinedion9433 6 місяців тому

    Learnt a lot from this tutorial. Thank you!

  • @RachaelAlufa
    @RachaelAlufa 6 місяців тому +2

    Infact you are the best i love this

  • @nikimath91
    @nikimath91 Рік тому

    Soo informative Dashboard thanks for detailed explaination.

  • @shubhamtiwari4024
    @shubhamtiwari4024 Рік тому

    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.

  • @raghunathrajendran9576
    @raghunathrajendran9576 10 місяців тому

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

  • @wengangdit
    @wengangdit 5 місяців тому +1

    thanks you so i really learnt alot from this project

  • @Wealth2025
    @Wealth2025 8 місяців тому

    this is cool, thanks lots of love from kathmandu,Nepal

  • @mokererikelvin
    @mokererikelvin Рік тому +4

    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?

  • @SithuChill
    @SithuChill 10 місяців тому +2

    Good Job and clear explanation, Keep it up

  • @hashirhassan3244
    @hashirhassan3244 2 місяці тому

    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

    • @datatutorials1
      @datatutorials1  2 місяці тому +1

      It is cleaning mistake, delete those records please

  • @geraldineorieoma7169
    @geraldineorieoma7169 Рік тому

    This was super helpful. Really gave me the boost I needed. Thank you sir

  • @SriramJoshi-j6h
    @SriramJoshi-j6h Рік тому

    Project added to my portfolio, Thanks

  • @mrtharunprao
    @mrtharunprao Рік тому +1

    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

  • @Komongsam
    @Komongsam 11 місяців тому +1

    Fantastic presentation. it was really awesome and helpful. please where do i get the data you have use for practice?

    • @datatutorials1
      @datatutorials1  11 місяців тому +2

      In the description

    • @Komongsam
      @Komongsam 11 місяців тому

      I got it. Thank you very much@@datatutorials1

  • @swati0880
    @swati0880 Рік тому +1

    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
      @datatutorials1  Рік тому +1

      Try bringing all the pivot tables in one sheet and then try

    • @swati0880
      @swati0880 Рік тому +1

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

  • @sravan.mahendra4639
    @sravan.mahendra4639 11 днів тому

    Thank u Clear Explanation 🙂

  • @seniorplanner2154
    @seniorplanner2154 Рік тому +1

    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

  • @srirajmavila5234
    @srirajmavila5234 Рік тому

    Bro you are doing an amazing job, this is awesome, thank you so much for sharing the great knowledge

  • @poojasalunkhe7416
    @poojasalunkhe7416 10 місяців тому +1

    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 ?

  • @bhagyashree3279
    @bhagyashree3279 Рік тому +1

    Thank you so much sir for this useful video 👍👍👍👍

  • @nexusveersamuel2099
    @nexusveersamuel2099 10 місяців тому

    Very nice tutorial, but prefer we use Fn+f5, select special then blanks so we can easily find the blanks int he data.

  • @Omale-e4d
    @Omale-e4d 11 місяців тому

    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?

    • @datatutorials1
      @datatutorials1  11 місяців тому

      Check in report connection if they are connected

  • @HumanVsDestiny1
    @HumanVsDestiny1 3 дні тому

    THANKS FROM EGYPT

  • @thegirlwhowanders6436
    @thegirlwhowanders6436 Рік тому

    I really enjoyed this video. Taught me a lot. Thank you.

  • @FasugbaOlamide
    @FasugbaOlamide 11 місяців тому

    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?

  • @yashsmartboy
    @yashsmartboy Рік тому

    This is amazing dashboard, thanks for sharing this.

  • @Tate_the_top_G_
    @Tate_the_top_G_ Рік тому

    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

  • @mohamedbng-j9v
    @mohamedbng-j9v 5 місяців тому

    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

  • @KiranSodheja
    @KiranSodheja Рік тому +1

    Thank you so much, For such a detailed and learning dashboard

  • @abduljabbarbabu6609
    @abduljabbarbabu6609 Рік тому

    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

  • @suryamanikantaponnada7583
    @suryamanikantaponnada7583 Рік тому

    Thank you Anna
    For your wonderful explanation 👍

  • @MicahJohns
    @MicahJohns 4 місяці тому

    Really great, thanks for this

  • @mdsakirhussain3383
    @mdsakirhussain3383 9 місяців тому

    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.

  • @plant.nursary
    @plant.nursary Рік тому

    I have completed this project thank u very much sir

  • @jmaxlinestandard2592
    @jmaxlinestandard2592 Рік тому

    This is really amazing. I've learnt a lot. Thanks for this

  • @mohamedabbe3508
    @mohamedabbe3508 Рік тому +1

    Biiiig thanks sir
    So clear & informative