The book provides nine tutorials on optimization, machine learning, data mining, and forecasting all within the confines of a spreadsheet. Each tutorial uses a real-world problem and the author guides the reader using query's the reader might ask as how to craft a solution using the correct data science technique. Hosting these nine spreadsheets for download will be necessary so that the reader can work the problems along with the book.

About the Author

John W. Foreman is Chief Data Scientist for MailChimp.com, where he leads a data science product development effort called the Email Genome Project. As an analytics consultant, John has created data science solutions for The Coca-Cola Company, Royal Caribbean International, Intercontinental Hotels Group, Dell, the Department of Defense, the IRS, and the FBI.

Table of Contents:
Introduction 1 Everything You Ever Needed to Know about Spreadsheets but Were Too Afraid to Ask 2 Cluster Analysis Part I: Using K-Means to Segment Your Customer Base 3 Naïve Bayes and the Incredible Lightness of Being an Idiot 4 Optimization Modeling: Because That "Fresh Squeezed" Orange Juice Ain't Gonna Blend Itself 5 Cluster Analysis Part II: Network Graphs and Community Detection 6 The Granddaddy of Supervised Artificial Intelligence--Regression 7 Ensemble Models: A Whole Lot of Bad Pizza 8 Forecasting: Breathe Easy; You Can't Win 9 Outlier Detection: Just Because They're Odd Doesn't Mean They're Unimportant 10 Moving from Spreadsheets into R Conclusion Index