2nd Edition. —John Wiley & Sons Australia, Ltd., 2024. — 448 p. — ISBN: 978-1-119-93139-3.
A straightforward and engaging approach to data science that skips the jargon and focuses on the essentials
In the newly revised second edition of Data Smart: Using Data Science to Transform Information into Insight, accomplished data scientist and speaker Jordan Goldmeier delivers an approachable and conversational approach to data science using Microsoft Excel’s easily understood features. The author also walks readers through the fundamentals of statistics, machine learning and powerful artificial intelligence concepts, focusing on how to learn by doing.
You’ll also find• Four-color data visualizations that highlight and illustrate the concepts discussed in the book
• Tutorials explaining complicated data science using just Microsoft Excel
• How to take what you’ve learned and apply it to everyday problems at work and life
A must-read guide to data science for every day, non-technical professionals, Data Smart will earn a place on the bookshelves of students, analysts, data-driven managers, marketers, consultants, business intelligence analysts, demand forecasters, and revenue managers.
Introduction
Everything You Ever Needed to Know About Spreadsheets but Were Too Afraid to Ask
Set It and Forget It: An Introduction to Power Query
Naïve Bayes and the Incredible Lightness of Being an Idiot
Cluster Analysis Part 1: Using K-Means to Segment Your Customer Base
Cluster Analysis Part II: Network Graphs and Community Detection
Regression: The Granddaddy of Supervised Artificial Intelligence
Ensemble Models: A Whole Lot of Bad Pizza
Forecasting: Breathe Easy: You Can’t Win
Optimization Modeling: Because That “Fresh-Squeezed” Orange Juice Ain’t Gonna Blend Itself
Outlier Detection: Just Because They’re Odd Doesn’t Mean They’re Unimportant
Moving on From Spreadsheets
Conclusion