Data Smart

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.

Table of Contents

Chapter 1 Everything You Ever Needed to Know About Spreadsheets but Were Too Afraid to Ask

Chapter 2 Set It and Forget It: An Introduction to Power Query

Chapter 3 Na’ive Bayes and the Incredible Lightness of Being an Idiot

Chapter 4 Cluster Analysis Part 1: Using K-Means to Segment Your Customer Base

Chapter 5 Cluster Analysis Part II: Network Graphs and Community Detection

Chapter 6 Regression: The Granddaddy of Supervised Artificial Intelligence

Chapter 7 Ensemble Models: A Whole Lot of Bad Pizza

Chapter 8 Forecasting: Breathe Easy: You Can’t Win

Chapter 9 Optimization Modeling: Because That “Fresh-Squeezed” Orange Juice Ain’t Gonna Blend Itself

Chapter 10 Outlier Detection: Just Because They’re Odd Doesn’t Mean They’re Unimportant

Chapter 11 Moving on From Spreadsheets

Chapter 12 Conclusion

About the Author

Jordan Goldmeier is an award-winning author in analytics, data science, and data visualization, and 11-time Microsoft MVP winner. Jordan has served analytics solutions for global organizations like NATO, The World Bank and Habitat for Humanity, and Fortune 500 companies likes Principal Financial and H&M. He has taught as an instructor for Wake Forest University, and served as a volunteer Emergency Medical Technician in New York City.