Sunday, June 25, 2017

Advanced Machine Learning with Basic Excel

In this article, I present a few modern techniques that have been used in various business contexts, comparing performance with traditional methods. The advanced techniques in question are math-free, innovative, efficiently process large amounts of unstructured data, and are robust and scalable. Implementations in Python, R, Julia and Perl are provided, but here we focus on an Excel version that does not even require any Excel macros, coding, plug-ins, or anything other than the most basic version of Excel. It is actually easily implemented in standard, basic SQL too, and we invite readers to work on an SQL version.

Who should use the spreadsheet?

First, the spreadsheet (as well as the Python, R, Perl or Julia version) are free to use and modify in any context, even commercial, and even to make a product out of it and sell it. It is part of my concept of open patent, in which I share all my intellectual property publicly and for free. 

The spreadsheet is designed as a tutorial, thought it processes the same data set as the one used for the Python version. It is aimed at people that are not professional coders, people who manage data scientists, BI experts, MBA professionals, and people from other fields, with an interest in understanding the mechanics of some state-of-the-art machine learning techniques, without having to spend months or years learning mathematics, programming, and computer science. A few hours is needed to understand the details. This spreadsheet can be the first step to help you transition to a new, more analytical career path, or to better understand the data scientists that you manage or interact with. Or to spark a career in data science. Or even to teach machine learning concepts to high school students.

The spreadsheet also features a traditional technique (linear regression) for comparison purposes.

Click here to read this article, download the spreadsheet, and start using it.

7 comments:

  1. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. Charlotte Gaskell This is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here!

    ReplyDelete
  2. You can then open the VBA editor, and you can see the code that makes the macro. You can change one or more lines of code, thus altering your macro. The more times you do this the more you learn. excel reporting dashboard

    ReplyDelete
  3. One of some important http://earlyeducationtips.com/ tasks of a teacher is doing the learning management (ranging from planning.!

    ReplyDelete
  4. Writing a blog is a piece of art and the writer has undoubtedly mastered this skill.
    rosin press plates

    ReplyDelete
  5. What could possibly make someone’s day other than reading such beautifully crafted blog such as this.
    http://quilterschoices.com/

    ReplyDelete
  6. Macros and scripts are small software programs usually giving one shot calculations.salesforce datawarehouse

    ReplyDelete
  7. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. Microsoft Excel Training Courses Malaysia

    ReplyDelete

High Precision Computing: Benchmark, Examples, and Tutorial

In some applications, using the standard precision in your programming language of choice, may not be enough, and can lead to disastrous er...