No. 377 of 500 No. 69 in Machine Learning

Data Smart

Using Data Science to Transform Information into Insight

By John W. Foreman

Print length
432 pages
Publisher
Wiley
Reading level
Beginner
ISBN-13
978-1118661468
Published
October 25, 2013
Written for
Business analysts and Excel users who want to understand data science methods before learning to code.

Synopsis

John Foreman, then chief data scientist at MailChimp, sets out to show that data science is a set of learnable procedures rather than a mystery reserved for specialists. Each chapter takes one technique and builds it by hand in Excel, with downloadable workbooks and business scenarios. The sequence covers k-means clustering for customer segmentation, naive Bayes text classification, optimization modeling (including an orange juice blending problem), network graphs and community detection, regression, ensemble models, forecasting with seasonal adjustment and Monte Carlo prediction intervals, and outlier detection. A final chapter shows how to carry the same work into the R programming language.

Working in cells instead of library calls forces readers to see every intermediate step, which makes the mathematics concrete and exposes what packaged tools usually hide. Foreman's humor, visible in chapter titles about bad pizza and fresh-squeezed orange juice, keeps long derivations readable. Readers gain intuition for when each method applies and what its outputs mean, a useful foundation before moving to Python or R. The trade-off is scale: spreadsheets suit learning rather than production, and the 2013 text predates newer Excel features such as Power Query, which Jordan Goldmeier's revised 2023 second edition adopts.

Scorecard

Editorial score

How it scored

Editorial score: 69.8 / 1005 weighted criteria

  • Influence30%

    21.0/30
  • Authority25%

    17.5/25
  • Practical value20%

    15.0/20
  • Currency15%

    8.3/15
  • Readability10%

    8.0/10
  • Editorial score

    69.8/100

How the rank was computed

Rank No. 377 of 500 comes from a composite of 50.8: observable signals 19.3 of 55 points plus editorial review 31.5 of 45 points.

All 11 inputs
InputPoints
Observable signals19.3/55
Reach (Amazon ratings volume)9.7/16.5
Consensus across best-of lists2.8/13.8
Awards and bestseller evidence0.0/8.3
Reader rating, sample-adjusted6.0/8.3
Amazon sales rank0.8/5.5
Recency0.0/2.8
Editorial review31.5/45
Author authority7.9/11.3
Influence9.5/13.5
Practical value6.8/9.0
Readability3.6/4.5
Currency3.7/6.8

Each criterion is scored from 1 to 10 and weighted, and the points add up to the editorial score. The rank combines observable signals (55 percent) with this score (45 percent). Read the methodology.

Verdict

A witty, rigorous introduction to core data science techniques built step by step in spreadsheets, ideal for analysts who learn by doing.

Strengths

  • Every technique built transparently, cell by cell
  • Humorous, conversational voice that eases dense material
  • Downloadable workbooks for hands-on practice

Keep in mind

Spreadsheets cannot handle large datasets or production workflows, and readers already fluent in Python or R will find the Excel mechanics slow going.

Key takeaways

  1. Most data science methods reduce to understandable steps; building them by hand in a spreadsheet reveals assumptions that packaged libraries conceal.
  2. Clustering techniques such as k-means and network community detection can segment customers in ways that inform targeted marketing decisions.
  3. Optimization modeling turns business constraints, such as ingredient costs and quality targets, into solvable problems that recommend the best feasible decision.
  4. Forecasts should come with prediction intervals; Monte Carlo simulation shows the range of plausible outcomes rather than a single misleading number.

Notable facts

  • Wiley announced the book in November 2013 with downloadable spreadsheets for each chapter's technique, from optimization and k-means clustering to Monte Carlo forecasting and a move into R. Source (opens in a new tab)
  • Wiley released a revised second edition by Jordan Goldmeier in November 2023. Source (opens in a new tab)

About the author

John W. Foreman

John W. Foreman wrote Data Smart as chief data scientist at MailChimp, where he led a data product effort called the Email Genome Project; he later became Mailchimp's chief product officer. Earlier, as an analytics consultant, he built models for clients including Coca-Cola, Royal Caribbean, InterContinental Hotels Group, the Department of Defense and the IRS. He completed graduate studies at MIT.

Questions

What is Data Smart about?
Data Smart teaches core data science techniques by building each one in Excel. John Foreman covers k-means clustering, naive Bayes classification, optimization modeling, network community detection, regression, ensemble models, forecasting, and outlier detection, then shows how to move the work into R. Each chapter uses a business scenario and a downloadable spreadsheet so readers can follow every calculation.
Is Data Smart worth reading in 2026?
Yes for readers who want intuition rather than code. The underlying methods have not changed, and building them in a spreadsheet still teaches what each algorithm does. The 2013 edition uses older Excel versions and predates generative AI, so readers who prefer current Excel features such as Power Query may choose the 2023 second edition revised by Jordan Goldmeier.
Who should read Data Smart?
Business analysts, marketers, finance professionals and managers who work in Excel and want to understand clustering, forecasting, classification and optimization will benefit most. It also suits students preparing for a first data science course. Experienced Python or R programmers will learn little new, though the book can help them explain methods to nontechnical colleagues.

Sources

As an Amazon Associate, Best AI Books earns from qualifying purchases. Best AI Books is sponsored by Iternal.ai, whose founder and CEO, John Byron Hanby IV, wrote The AI Strategy Blueprint, our #1 ranked book. How we rank books.