Data Mining With Excel - Top 4 Skills for ANY Professional

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 ก.ค. 2024
  • 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
    @DaveOnData  3 ปีที่แล้ว +4

    👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
    📺 th-cam.com/video/xIXymabyFIM/w-d-xo.html
    💥 Learning R programming is easy for Excel users! 💥
    📺 th-cam.com/video/MNpsyjSuR20/w-d-xo.html

  • @klj6742
    @klj6742 2 ปีที่แล้ว +3

    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
    @tasia3651 2 ปีที่แล้ว +3

    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!

  • @abebarreda2179
    @abebarreda2179 2 ปีที่แล้ว +1

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

  • @quangminhnguyenle5081
    @quangminhnguyenle5081 ปีที่แล้ว

    Super interesting video! Thank you!

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 ปีที่แล้ว +5

    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
      @DaveOnData  3 ปีที่แล้ว +2

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

    • @danjarupath
      @danjarupath 2 ปีที่แล้ว

      Great 👍👍👍

  • @williamstan1780
    @williamstan1780 2 ปีที่แล้ว +1

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

  • @vaibhavjoshi6853
    @vaibhavjoshi6853 2 ปีที่แล้ว +1

    Thanks so much 🙏

  • @ecah101
    @ecah101 2 ปีที่แล้ว +1

    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

  • @cirilotradio9717
    @cirilotradio9717 2 ปีที่แล้ว +1

    thank you!

  • @andriikulishov3371
    @andriikulishov3371 2 ปีที่แล้ว +1

    Thanks!

  • @rehab222151
    @rehab222151 ปีที่แล้ว

    Love it and i am great full

  • @tello9504
    @tello9504 3 ปีที่แล้ว +2

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

    • @DaveOnData
      @DaveOnData  3 ปีที่แล้ว +1

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

  • @granand
    @granand 3 ปีที่แล้ว +2

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

    • @DaveOnData
      @DaveOnData  3 ปีที่แล้ว +1

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

  • @abidmehdi6103
    @abidmehdi6103 2 ปีที่แล้ว +2

    Thanks for this awesome explanation,you Helped me alot.

    • @DaveOnData
      @DaveOnData  2 ปีที่แล้ว +1

      My pleasure, glad you found the content useful!

  • @kuntemanoj
    @kuntemanoj 2 ปีที่แล้ว +2

    Thank you for very informative session.

    • @DaveOnData
      @DaveOnData  2 ปีที่แล้ว +1

      My pleasure, glad you found the content useful!

  • @amrshoula2141
    @amrshoula2141 3 ปีที่แล้ว +2

    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
      @DaveOnData  3 ปีที่แล้ว +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

  • @pvacaesar2942
    @pvacaesar2942 3 ปีที่แล้ว +2

    Very helpful!

    • @DaveOnData
      @DaveOnData  3 ปีที่แล้ว +1

      Thank you! Glad you liked the video.

  • @alexo5303
    @alexo5303 6 หลายเดือนก่อน +1

    Great video, thanks for sharing

    • @DaveOnData
      @DaveOnData  6 หลายเดือนก่อน

      You are welcome! Glad you enjoyed the content.

  • @chintabindhusri5879
    @chintabindhusri5879 2 หลายเดือนก่อน +1

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

    • @DaveOnData
      @DaveOnData  2 หลายเดือนก่อน

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

  • @sujatabhambere4130
    @sujatabhambere4130 2 ปีที่แล้ว +1

    Is this course free of cost

  • @riccardocimei7293
    @riccardocimei7293 2 หลายเดือนก่อน +1

    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
      @DaveOnData  2 หลายเดือนก่อน

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

  • @xJoeKing
    @xJoeKing 3 ปีที่แล้ว +3

    Do you need hair made of silk?

    • @DaveOnData
      @DaveOnData  3 ปีที่แล้ว +1

      Ha! The hair is 100% optional! 🤣