Exploratory Data Analysis With Excel - Part 1 - Basic Numerics

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

КОМЕНТАРІ • 68

  • @DaveOnData
    @DaveOnData  3 роки тому +5

    💥 From Excel to Machine Learning. No, Really! (Full Webinar) 💥
    📺 ua-cam.com/video/b6hiyLEFA_M/v-deo.html
    👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
    📺 ua-cam.com/video/xIXymabyFIM/v-deo.html

  • @venkatasatyaprakashkanduku1956
    @venkatasatyaprakashkanduku1956 3 роки тому +21

    Hi Dave, I came across your videos on Excel, R, and SQL recently. Believe me, you are one of THE BEST in teaching. I love the way you explain each concept and help the budding data scientists. I myself have been in teaching for nearly 12 years but have seen very few like. Keep doing such a great job. May GOD bless you and your family. Keep smiling and helping everyone. Cheers :)

    • @DaveOnData
      @DaveOnData  3 роки тому +4

      Thank you so much for taking the time to provide this feedback - it is very much appreciated! 🙏🙇‍♂️ So glad you like the content.

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

      Hi Dave, can I use this session for sensor data analysis in excel. This video looks promising.

  • @aobane6037
    @aobane6037 2 роки тому +3

    Currently a business data analyst and I must say this is gold. Obtaining my masters in data science graduating in June of 2022, and you put my professors to shame. Clear and straight to the point. Will definitely be checking out more of your stuff.

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

    Thanks David. You always make a complex subject like statistics, look fun and easy. One of the best educational resources available on UA-cam 👍

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

      Wow! Thank you so much for the kind words! I'm glad to hear you are finding my content useful.

  • @suzettepowell2848
    @suzettepowell2848 2 роки тому +2

    I am so happy that you decided to teach this topic. I will be watching the others in the series. Very clear delivery. Thanks.

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

    Hi David! This is pure gold. Thanks for sharing your knowledge!

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

    you are one of the best teachers I must say very useful videos. very informative, clear and to the point.

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

      Wow! Thank you so much for the feedback. I am glad you are finding my videos useful.

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

    Thank you so much! This was super helpful.

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

    Just getting to these videos. They are fantastic for people looking to use data to find things out

  • @williamtwichell2285
    @williamtwichell2285 3 роки тому +4

    Great video! Showed up in my recommended a couple days ago and I plan to watch many more on your channel.

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      Excellent! Thank you for taking the time to comment and so glad you liked the video.

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

    5:00 is pretty insightful... I have not heard that much before.

  • @katebackshall1961
    @katebackshall1961 3 роки тому +2

    These videos are so easy to follow! Thanks David!

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      You are welcome and glad you are finding the content useful!

  • @randomlee7126
    @randomlee7126 3 роки тому +2

    ya so the teacher sent a whole playlist of this, which is great!

    • @DaveOnData
      @DaveOnData  3 роки тому +2

      Awesome! So glad you are finding the content useful.

  • @descenthove2875
    @descenthove2875 3 роки тому +1

    I love your way of teaching man.

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      Thank you for the feedback!
      I hope that you find the other tutorials on my channel of similar quality.

  • @methodical-monkey
    @methodical-monkey Рік тому

    Thank You. You are helping me understand and put to use the basic statistics I learned from GradCoach channel. I truly appreciate your work.

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

    very great sir you have dive into the concepts that i am looking for a long time finally here thank you

  • @baljeetgill3738
    @baljeetgill3738 2 роки тому +1

    You Rock, David😀
    Absolutely love your videos and I am a beginner in Data Analysis

  • @atulp3360
    @atulp3360 2 роки тому

    David - just came across your series.. these are fantastic... and appreciate the patient teaching. Love the content and style in your videos! Thanks for doing these!

  • @sorosfox3801
    @sorosfox3801 2 роки тому

    You're fantastic David. Thank you so much for these videos. I'm learning so much. Please keep them coming. You're a lifesaver.

  • @Flow_with_G
    @Flow_with_G 3 роки тому +1

    Thank you so much! Great video and teaching. I can't wait to learn more from you!

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      You are welcome and so glad you are finding my content useful!

  • @sandrapaul4094
    @sandrapaul4094 3 роки тому +1

    thank you David.Great video.

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      You are welcome, glad you liked the content!

  • @banonkekeirnowo1304
    @banonkekeirnowo1304 3 роки тому +2

    this is what i am looking for... thank for the add in... it's so usefull...\

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      You are welcome! FYI - Parts 3 & 4 will be out Wednesday and Friday of this week.

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

    Amazing!

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

      Thank you so much! I'm glad you enjoyed the video.

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

    Exploratory data analysis can have many hearts, don't worry about it!😂

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

    Hi, Dave! Thank you for this video, it really came handy. I have one question, is it ok to use the mean gotten from the description analysis to fill in the blanks in the age column? Looking forward to your response.

  • @dyglesias
    @dyglesias 3 роки тому +1

    Hey dude... You rock.

    • @DaveOnData
      @DaveOnData  3 роки тому +2

      Thank you for the feedback! I will try to keep on rocking it with the content. 🤘

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

    Excellent thanks 👍

  • @gunhild1951
    @gunhild1951 3 роки тому +2

    Hi David!
    Great material. I am really going to keep watching your videos. I like the way you teach.
    One question, when you did a descriptive and summary statistics on the identifier column I was wondering if that is typical thing? I would like to know more reasons on why to perform descriptive and summary statistics on identifiers.

    • @DaveOnData
      @DaveOnData  3 роки тому +1

      Thank you for the feedback, glad you are liking the content!
      In general, if you know the column is an identifier (e.g., CustomerID), then there's not need to perform summary stats on it.
      However, there are times when you are working with new data (especially in legacy systems) where columns turn out to be identifiers, even though they are not explicitly labeled such. One common example are database columns that get reused for some long-forgotten reason (trust me, it happens 😁).

    • @gunhild1951
      @gunhild1951 3 роки тому +1

      Hi again @@DaveOnData , I really appreciate you taking time and answering :) Im new when it comes to statistics so I'm eager to learn everything about it.

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

    we should perform whole eda after cleaning and pre processing the data, Right?

  • @SamsungA-wv5bh
    @SamsungA-wv5bh 2 роки тому

    Hello David,
    Is it possible to automate output of summary statistics in formula or something instead of going through the process over and over again?

  • @rahulpareek328
    @rahulpareek328 3 роки тому

    Hello David,
    I hope you are doing well!
    I haven’t included any project in my resume, should I include this as my project in my resume? Will this project be effective for entry level data analyst job?

  • @CaribouDataScience
    @CaribouDataScience 2 роки тому

    Has your hair, got longer over the years? When I started learning R ( five or six years ago) your videos was some of the first I watched.

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

    thank you

  • @RadityaMokoginta-o8u
    @RadityaMokoginta-o8u 11 місяців тому +1

    hi, can i get the raw data please???

  • @Anonymous-bl6bl
    @Anonymous-bl6bl 2 роки тому

    Hi David, I really like your videos. Just to make you aware that all your links of "Part 7 of the Series - TreemapCharts" in the all the other parts direct us to Part 2. I managed to find the video typing it, but so you are aware that the hyperlink to part 7 is not the right one. Take care and thanks!

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

    thanks a lot!

  • @dilaraesmer
    @dilaraesmer 3 роки тому +1

    Thank you for sharing in this video by using dataset on your github account, in addition to i will also try to implement in R :)

    • @DaveOnData
      @DaveOnData  3 роки тому +3

      You are welcome! Trying EDA in R is a very good idea (shocking coming from a R fan like myself, no? 🤣).

    • @dilaraesmer
      @dilaraesmer 3 роки тому +1

      @@DaveOnData i knew, you love to use R programming from linkedln :))

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

    What really means Descriptive Statistics. I am extreme beginner. Can you give me some scenarios examples.

  • @rajatpathak3509
    @rajatpathak3509 2 роки тому

    Hi Dave,
    I can not download datasets from your github.

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

    ATLEO. from Nigeria.

  • @dawatsering6919
    @dawatsering6919 2 роки тому

    data analysis toolpack works even in ms excel 2010

  • @sanadmasoud5818
    @sanadmasoud5818 8 місяців тому +1

    يقدر حد يعطيني مواضيع الفيديو
    هل رح يشرح أكسل للمايعرف بالمره ولا لعند معرفة عامة عنه

    • @sanadmasoud5818
      @sanadmasoud5818 8 місяців тому +1

      Can someone tell me what are the main Articles in this video
      Is he going to tell basics of excel or more complicated
      If the question isn't clear please tell me to clarify the question

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

      This video tutorial series covers data analysis fundamentals. The series assumes basic Excel knowledge like creating Excel tables, PivotTables, and charts.

    • @sanadmasoud5818
      @sanadmasoud5818 8 місяців тому +1

      @@DaveOnData THANK YOU FOR ANSWERING QUICKLY

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

    where you from

  • @datascientistoflife8550
    @datascientistoflife8550 3 роки тому +1

    No we can use male column if we want to what is % of male and female on the ship and which are the and male and female we can combined with age and in categorical and which class people are most affected in this tragedy..

  • @annupriya7227
    @annupriya7227 2 роки тому

    Formula??

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

    Palsson, Master. Gosta Leonard
    Age- 2
    Survived- 0
    😢

  • @neiltristanyabut
    @neiltristanyabut 2 роки тому

    so much hands