Exploratory Data Analysis With Excel - Part 1 - Basic Numerics

[@DaveOnData]

💥 From Excel to Machine Learning. No, Really! (Full Webinar) 💥 📺 kzbin.info/www/bejne/mGfLmqyCeqt0la8 👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68

[@venkatasatyaprakashkanduku1956]

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]

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

[@ara197]

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

[@aobane6037]

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.

[@MalcanniPlus]

Thank you so much! This was super helpful.

[@suzettepowell2848]

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]

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

[@HarmanderSinghMaan]

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

[@DaveOnData]

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

[@manishavyas1]

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

[@DaveOnData]

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

[@williamtwichell2285]

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

[@DaveOnData]

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

[@datarob]

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

[@randomlee7126]

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

[@DaveOnData]

Awesome! So glad you are finding the content useful.

[@waynelast1685]

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

[@katebackshall1961]

These videos are so easy to follow! Thanks David!

[@DaveOnData]

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

[@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]

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

[@descenthove2875]

I love your way of teaching man.

[@DaveOnData]

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

[@baljeetgill3738]

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

[@atulp3360]

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]

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]

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

[@DaveOnData]

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

[@niko73le]

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

[@banonkekeirnowo1304]

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

[@DaveOnData]

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

[@sandrapaul4094]

thank you David.Great video.

[@DaveOnData]

You are welcome, glad you liked the content!

[@marciofranco6085]

Excellent thanks 👍

[@-Hussainnn]

Amazing!

[@DaveOnData]

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

[@dyglesias]

Hey dude... You rock.

[@DaveOnData]

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

[@meaghannichols4455]

thank you

[@muhammaduseram9405]

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

[@rodrigowalter5647]

thanks a lot!

[@gunhild1951]

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]

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]

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.

[@dilaraesmer]

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]

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

[@dilaraesmer]

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

[@RadityaMokoginta-o8u]

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

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

[@SamsungA-wv5bh]

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?

[@Anonymous-bl6bl]

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!

[@tutsecret499]

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

[@rahulpareek328]

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]

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.

[@dawatsering6919]

data analysis toolpack works even in ms excel 2010

[@OhueThomas]

ATLEO. from Nigeria.

[@DaveOnData]

Greetings! 👋

[@rajatpathak3509]

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

[@sanadmasoud5818]

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

[@sanadmasoud5818]

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]

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

[@sanadmasoud5818]

@@DaveOnData THANK YOU FOR ANSWERING QUICKLY

[@datascientistoflife8550]

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

[@NAMELESSHOSTAGE]

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

[@francisco93ify]

where you from

[@annupriya7227]

Formula??

[@neiltristanyabut]

so much hands