Data Mining With Excel - Top 4 Skills for ANY Professional

Рет қаралды 40,332

Күн бұрын

Data mining with Excel is wildly useful for ANY professional! In this video, I will cover my Top 4 data mining techniques using nothing more than Excel tables, common functions, and a little bit of Power Query.
In this video I show ANY professional - regardless of role/background - can benefit from the following data mining techniques and data mining algorithms:
1 - Exploratory data analysis (EDA)
2 - Market basket analysis
3 - Cluster analysis using K-means
4 - Naive bayes classification
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 • Introduction to Busine...
💥 Learning R programming is easy for Excel users! 💥
📺 Check out the video: • Learning R Programming...
Stay healthy and happy data sleuthing!
#DataMiningWithExcel #DataMiningTechniques #DataMining

Пікірлер: 35

@DaveOnData 3 жыл бұрын

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzfaq.info/get/bejne/rq-IrNCSx9-qeYE.html 💥 Learning R programming is easy for Excel users! 💥 📺 kzfaq.info/get/bejne/g7SgptybuNu2YmQ.html

@klj6742 2 жыл бұрын

This was fantastic. You are a fabulous teacher and I have learned so much! I never knew how versatile Excel is. I'll be back to look at your other videos. Thank so much

@tasia3651 2 жыл бұрын

Hi David! I'm so impressed with your amazingly thorough understanding of data mining. I'm taking a data mining course in grad school right now and I'm STRUGGLING! I'm glad I found you. Also, I think you could get even more clicks to your other videos if you put the links to videos 1 - 4 right next to their titles in your description box. Thanks for the helpful videos!

@vijayarjunwadkar 2 жыл бұрын

A saying goes as "When the student is ready, a teacher appears!" I was hunting for this kind of analysis in Excel and David, you appeared as a savior! Thanks a lot for this and related videos! 😊👍

@DaveOnData 2 жыл бұрын

Awesome! So glad you found my content and are finding it useful.

@danjarupath 2 жыл бұрын

Great 👍👍👍

@abebarreda2179 2 жыл бұрын

Admire the level of love for data! feeds my interest! Supporting your content, good sir!

@quangminhnguyenle5081 Жыл бұрын

Super interesting video! Thank you!

@ecah101 2 жыл бұрын

This is an awesome video and definitely will follow and learn more for newbies like me. Thank you very much and really appreciated it. I am going to apply this to my work and research studies. The top 4 Data Mining techniques are: 1) Exploratory Data Analysis 2) Market Basket Analysis 3) K-Means Cluster Analysis 4) Naive Bayes Classificationn

@williamstan1780 2 жыл бұрын

Just bought you coffee. Excellent Contents, very informative and practical

@vaibhavjoshi6853 2 жыл бұрын

Thanks so much 🙏

@cirilotradio9717 2 жыл бұрын

thank you!

@andriikulishov3371 2 жыл бұрын

Thanks!

@tello9504 3 жыл бұрын

Jajajajjaa me encantan tus miniaturas. Thanks for everything, sensei! Great video.

@DaveOnData 3 жыл бұрын

Thank you for the feedback and glad you found the content useful!

@rehab222151 Жыл бұрын

Love it and i am great full

@amrshoula2141 3 жыл бұрын

Genuine content, no copycats! Respects and thanks for that. Quick one, if you'd extend the list to the top 10, data mining techniques, what other 6 would you add after these 4?

@DaveOnData 3 жыл бұрын

Glad you liked the video! Given my personal definition of "Data Mining" I would add the following in no particular order: Process mining RFM analysis Decision trees The mighty random forest DBSCAN (a clustering algorithm) Process behavior charts

@abidmehdi6103 2 жыл бұрын

Thanks for this awesome explanation,you Helped me alot.

@DaveOnData 2 жыл бұрын

My pleasure, glad you found the content useful!

@granand 3 жыл бұрын

As always thank you sir. Each of your video is so awesome

@DaveOnData 3 жыл бұрын

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

@kuntemanoj 2 жыл бұрын

Thank you for very informative session.

@DaveOnData 2 жыл бұрын

My pleasure, glad you found the content useful!

@alexo5303 5 ай бұрын

Great video, thanks for sharing

@DaveOnData 5 ай бұрын

You are welcome! Glad you enjoyed the content.

@pvacaesar2942 3 жыл бұрын

Very helpful!

@DaveOnData 3 жыл бұрын

Thank you! Glad you liked the video.

@chintabindhusri5879 Ай бұрын

Could you please provide Excel which you have used in this video!? Sir

@DaveOnData Ай бұрын

Check out this GitHub: github.com/DaveOnData/DataAnalysisWithExcel

@riccardocimei7293 Ай бұрын

Using 5k to 100k rows is easy....try to run a pivot on 900 thousand row and see how excel will spin for 30 min....

@DaveOnData Ай бұрын

As always, right tool for the job! Won't be long before Python in Excel will be another option.

@sujatabhambere4130 2 жыл бұрын

Is this course free of cost

@xJoeKing 3 жыл бұрын

Do you need hair made of silk?

@DaveOnData 3 жыл бұрын

Ha! The hair is 100% optional! 🤣