Edition 1·Updated 2026-07-22·21 min read
Sources behind this guide
Sources
Sources behind this guide
Explore the sources listed below. Follow the references in the guide to investigate individual ideas.
Books and authors
Analytics at Work: Smarter Decisions, Better Results
Thomas H. Davenport, Jeanne G. Harris, Robert MorisonMost companies are awash in data yet make 40 percent of major decisions on gut instinct, leaving money and competitive advantage on the table.
In this sequel to Competing on Analytics, Davenport, Harris, and Morison move beyond the rare analytical competitors to the broad base of organizations that simply want to become more analytical—one decision at a time. The book organizes the prerequisites for analytical success under the memorable DELTA framework (accessible high-quality Data, an Enterprise orientation, analytical Leadership, strategic Targets, and Analysts), pairs it with a five-stage maturity model, and then explains how to sustain analytical capability by embedding analytics in business processes, building an analytical culture, and continually reviewing models and assumptions. Illustrated with examples from Best Buy, Progressive, Humana, 1-800-Flowers, Capital One, and many others, it offers frameworks, assessment tools, and pragmatic advice—a compass rather than a rigid map—for managers who want to unleash the value buried in their data.
Big Data: A Revolution That Will Transform How We Live, Work, and Think
Viktor Mayer-Schönberger, Kenneth CukierBig Data: A Revolution That Will Transform How We Live, Work, and Think argues that we are entering a new era in which the sheer scale of available data changes not just what we know but how we know it.
Mayer-Schönberger and Cukier show how using all the data (N=all) instead of samples, accepting messiness instead of demanding precision, and embracing correlation instead of obsessing over causation unlocks enormous new economic and social value—from predicting flu outbreaks and airfare prices to preventing infrastructure failures and saving premature babies. Through vivid examples (Google Flu Trends, Farecast, Amazon recommendations, exploding manholes), the authors explain the mechanics of datafication—rendering ever more aspects of reality into quantifiable, analyzable form—and reveal how data's value increasingly lies in its reuse and option value. But they also confront the dark side: the erosion of privacy, the menace of punishing people for predicted (not actual) behavior, and the danger of a 'dictatorship of data.' The book offers a framework for governance—shifting from individual consent to data-user accountability, safeguarding human agency, and creating a new profession of 'algorithmists.' It is at once an enthusiastic primer, a business strategy guide, and a cautionary meditation on humanity's place amid a quantifiable world.
Data Science Bookcamp turns Python coders into employable data scientists by abandoning passive reading in favor of persistent, hands-on problem solving.
Built around five real-world case studies—from finding the winning strategy in a card game to detecting social circles in Facebook data—the book teaches probability, statistics, supervised and unsupervised machine learning, and the core Python data libraries (NumPy, SciPy, Pandas, Matplotlib, Scikit-Learn) entirely through common-sense code rather than Greek-symbol-laden equations. Each case study opens with a detailed problem statement, teaches the skills needed to solve it, and then challenges readers to produce their own solution before comparing it to the author's. The result is the open-ended problem-solving ability that employers actually want—and that no amount of reading alone can produce.
Business Intelligence Guidebook fills the gap between high-level BI concept books and vendor tool manuals by walking the reader through the entire lifecycle of creating a world-class BI environment: justifying the investment, defining requirements, building architectural blueprints (information, data, technology, and product), designing data models (entity-relationship and dimensional), engineering data integration processes, developing BI applications and advanced analytics, taming data shadow systems, and managing the organizational dimensions of people, process, politics, project management, and centers of excellence.
Drawing on decades of consulting and implementation experience, Rick Sherman argues that BI is not a one-and-done project but an evolving program that must be built incrementally and iteratively, grounded in the recognition that raw data must be transformed into clean, consistent, conformed, current, and comprehensive information before it delivers business value. The book is deliberately product-neutral so its concepts endure beyond vendor mergers and hype cycles, and it repeatedly stresses that the hardest part of BI is not technology but the human and organizational factors that determine whether solutions are actually adopted and trusted.
Business Intelligence and Big Data
Celina OlszakBusiness Intelligence and Big Data: Drivers of Organizational Success makes the case that in a turbulent, information-saturated economy, intangible resources—information and knowledge—are an organization's most strategic assets, and that the ability to intelligently process and analyze them is the key competence separating winners from losers.
Drawing on resource-based and dynamic-capabilities theory, knowledge management, and decades of decision-support research, Celina Olszak walks readers through the essence and architecture of BI systems, the techniques and technologies of Big Data, concrete application domains (marketing, CRM, insurance, banking, telecommunications, energy, logistics, health care, HR), and the maturity models and critical success factors that determine whether BI&BD investments actually create business value. It is at once a textbook for students, a research agenda for scholars, and a practical handbook for managers and ICT specialists who want to know not just what BI&BD can do but what determines its successful design, implementation, and value creation.
Competing on Analytics: The New Science of Winning
Thomas H. Davenport, Jeanne G. HarrisCompeting on Analytics, revised and updated, makes the case that in an era when products, geography, and technology are easily copied, the last durable source of advantage is executing business processes and decisions better than rivals through analytics.
Davenport and Harris draw on hundreds of company examples (Netflix, Capital One, UPS, Caesars, Marriott, Google, Amazon, Walmart) and sports teams to define what makes an analytical competitor, lay out the four pillars (distinctive capability, enterprise approach, senior management commitment, and large-scale ambition), and chart a five-stage maturity road map plus the DELTA model (Data, Enterprise, Leadership, Targets, Analysts) for building capability. The updated edition tracks the rapid evolution through four analytics eras—from descriptive 1.0 to big-data 2.0, mainstream 3.0, and autonomous/AI-driven 4.0—and shows how human, organizational, and cultural factors, not just technology, separate winners from also-rans.
Competing on Analytics: The New Science of Winning
Thomas H. Davenport, Jeanne G. HarrisCompeting on Analytics reveals how a small but growing set of organizations have made data analysis the centerpiece of their strategy, outthinking and outexecuting rivals in industries from gaming to logistics to professional sports.
Updated to cover big data, data science, machine learning, the Internet of Things, and cloud computing, Davenport and Harris lay out a five-stage maturity model, a four-pillar definition of analytical competitors, and the DELTA framework (Data, Enterprise, Leadership, Targets, Analysts) for building analytical capability. Through rich examples—Netflix, Capital One, Caesars, Marriott, UPS's ORION, Google, and the Oakland A's—the book demonstrates that extracting value from data is less about technology and more about leadership commitment, an enterprise-wide approach, a distinctive strategic focus, and the scarce human talent that makes analytics work. It is both a strategic argument and a practical road map for any executive seeking lasting advantage through fact-based decision making.
Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
Foster Provost, Tom FawcettData Science for Business is the definitive primer for understanding data science not as a grab-bag of algorithms but as a coherent set of fundamental principles that structure data-analytic thinking.
Provost and Fawcett—both seasoned practitioners and researchers—argue that beneath the dizzying array of data mining techniques lies a relatively small set of concepts (treating data as a strategic asset, framing problems with expected value, finding informative attributes, fitting models while controlling overfitting, measuring similarity) that unify the field. Organized around the CRISP data mining process and richly illustrated with real-world business cases—customer churn, targeted marketing, fraud detection, charity solicitation, whiskey recommendation, text mining of news—the book teaches readers to decompose business problems into solvable data science tasks, to evaluate solutions in business terms, and to communicate across the technical/business divide. It is the rare book that equips managers to evaluate data science proposals and equips data scientists to align their work with business value, making both better at extracting competitive advantage from data.
Data Science from Scratch teaches you data science by having you build the tools and algorithms yourself, from the ground up, in clear and readable Python.
Rather than treating libraries like NumPy, scikit-learn, and pandas as magic black boxes, Joel Grus walks you through implementing linear algebra, statistics, probability, gradient descent, machine learning models, neural networks, deep learning, clustering, NLP, network analysis, and recommender systems by hand. Framed around the fictional 'DataSciencester' social network, the book grounds abstract concepts in concrete problems while developing the hacking skills and mathematical intuition that are at the core of doing real data science. By the end you understand not just how to use data science tools, but how and why they work.
Data Smart strips away the hype, tools, and code that usually obscure data science and teaches the actual techniques—clustering, naive Bayes, optimization, network graphs, regression, ensemble models, forecasting, and outlier detection—by building each one by hand in a spreadsheet.
Written conversationally by MailChimp's Chief Data Scientist, the book targets marketers, analysts, and executives who feel pressure to 'do data science' but don't understand what these techniques are or how to choose the right one for a problem. By the time readers finish, they can identify data science opportunities in their own organizations, prototype solutions, correctly evaluate vendors and developers, and graduate into a programming language like R to scale their work. The book's philosophy is that understanding beats button-pushing: once you've implemented an algorithm from the barest of tools, you can implement it anywhere.
Designing Data-Intensive Applications
Martin KleppmannBehind the dizzying array of buzzwords—NoSQL, Big Data, eventual consistency, CAP theorem, MapReduce, stream processing—lie a small set of enduring principles that govern how data systems behave.
Martin Kleppmann's Designing Data-Intensive Applications strips away the marketing to give software engineers and architects a technically precise understanding of how databases store and retrieve data, how replication and partitioning work, what guarantees transactions and consensus can and cannot provide, and how batch and stream processing fit together. Rather than tutoring you on one tool, it teaches you to reason about the fundamental trade-offs—reliability vs. cost, consistency vs. availability, timeliness vs. integrity—so you can choose, combine, and operate the right tools for any data-intensive application and design systems that survive the messy realities of hardware faults, network failures, and human error.
This book takes a reader who knows close to nothing about Machine Learning and equips them to implement programs capable of learning from data.
Rather than dwelling on theory, it favors a hands-on approach—growing intuitive understanding through concrete working examples and just enough math. Part I covers the fundamentals using Scikit-Learn: framing problems, end-to-end project workflow, classification, training models, support vector machines, decision trees, ensemble methods, dimensionality reduction, and unsupervised learning. Part II dives into neural networks and deep learning with Keras and TensorFlow, covering CNNs for vision, RNNs and Transformers for sequences and language, autoencoders and GANs for generative learning, reinforcement learning, and deploying models at scale. With production-ready frameworks, runnable Jupyter notebooks, and practical guidance on the inevitable challenges of bad data and bad algorithms, it is a comprehensive on-ramp for anyone who wants to apply Machine Learning to real projects.
Introduction to Statistical and Machine Learning Methods for Data Science
Dr. Carlos Andre Reis Andre Reis Pinheiro etc.This book demystifies data science by walking readers through the full analytical lifecycle—from understanding the business question and preparing data, through supervised and unsupervised modeling, to model assessment, deployment, and operationalization—without burdening them with software or heavy mathematics.
Drawing on the authors' decades of real-world experience (especially in telecommunications), it pairs accessible explanations of techniques like regression, decision trees, forests, gradient boosting, neural networks, support vector machines, factorization machines, clustering, association rules, network analysis, and text analytics with concrete business use cases such as churn prediction, fraud detection, bad-debt avoidance, and recommendation. Ideal for citizen data scientists, analysts, and curious professionals, it teaches readers not just what each method does but when to apply it and how to translate model results into deployable business actions that generate real value.
Written for analysts, software developers, and researchers who want to move beyond spreadsheet-level analytics, this book casts machine learning as the scientific method applied to data.
Organized to mirror an actual data science project, it walks readers step-by-step from data access and munging, through exploratory data analysis, into supervised methods (regression and a broad battery of classifiers), model performance evaluation, and finally unsupervised learning. Every concept is grounded in runnable R code using base packages and well-known data sets, deliberately omitting heavy mathematics so newcomers can become productive quickly while still understanding the workflow, the pitfalls (overfitting, bias-variance, confounders, data leakage), and how to iterate toward better predictive power.
Written by the creator of pandas, this book teaches the foundational programming skills and library workflows needed to become an effective data analyst in Python.
Rather than focusing on statistical methodology, it concentrates on the data-oriented Python toolset—NumPy arrays for fast numerical computing, pandas Series and DataFrames for tabular data wrangling, matplotlib and seaborn for visualization, and IPython/Jupyter for interactive development. Through detailed, reproducible examples and real-world datasets (Bitly links, MovieLens ratings, US baby names, USDA food data, FEC contributions), readers learn to load, clean, transform, merge, reshape, group, aggregate, and visualize data, and to handle time series and feed cleaned data into modeling libraries like statsmodels and scikit-learn. It is ideal both for analysts new to Python and for Python programmers new to data work, serving as a durable foundation for moving on to more advanced data science and machine learning resources.
R for Data Science teaches you how to turn raw data into understanding, insight, and knowledge using R and the tidyverse collection of packages.
Rather than starting with the boring parts (data ingest and cleaning), the book begins with visualization and transformation of clean data so your motivation stays high, then progressively layers in programming skills, data wrangling, modeling, and communication. Written by Hadley Wickham (creator of much of the tidyverse) and Garrett Grolemund, the book unabashedly focuses on the most important 80% of data science tasks—hypothesis generation and exploratory data analysis on rectangular, in-memory datasets—giving you a coherent, opinionated toolkit (ggplot2, dplyr, tidyr, readr, purrr, and more) that share a common philosophy and work together naturally. By the end you'll have a reusable mental model of the data science process and the concrete R skills to execute it, plus pointers to deeper resources for the remaining 20%.
Drawing on a survey of 634 BI professionals and in-depth case studies of leading organizations like Netflix, Macy's, Medtronic, FlightStats, Dow Chemical, and Constant Contact, Cindi Howson argues that successful business intelligence is far less about technology than about people, culture, executive support, business-IT partnership, data quality, relevance, and organizational agility.
The book demystifies the technical architecture (data warehouses, ETL, Hadoop, analytic appliances, in-memory engines) and front-end tools (dashboards, visual data discovery, OLAP, mobile BI) just enough for business readers, then devotes its core to the human and organizational factors that catapult a BI initiative from moderate to wild success. With its 'LOFT effect' framework (Luck, Opportunity, Frustration, Threat) and ten secrets to success, the book offers both inspiration and practical lessons for anyone struggling to turn data into action and measurable business impact.
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Ralph Kimball, Margy RossThe Data Warehouse Toolkit, Third Edition, by Ralph Kimball and Margy Ross, is the industry's seminal reference for dimensional modeling.
Drawing on decades of real-world consulting experience, the authors present a comprehensive, technique-centric methodology for building data warehouse and business intelligence (DW/BI) systems that prioritize two simultaneous goals: business user understandability and fast query performance. Organized around vivid business vignettes spanning retail, inventory, procurement, order management, accounting, CRM, HR, finance, telecom, transportation, education, healthcare, e-commerce, and insurance, the book develops more than 75 dimensional modeling techniques—fact tables and dimension tables, the enterprise data warehouse bus matrix with conformed dimensions, slowly changing dimension techniques, bridge tables, and accumulating snapshots—while dispelling persistent myths about dimensional design. It then extends into the full Kimball Lifecycle, the 34 subsystems of ETL, and emerging big data analytics best practices. Whether you are a designer, modeler, ETL developer, or DW/BI manager, this toolkit equips you to marshal an organization's data and deliver it to business users for better, fact-based decision making.
Movement I
Orient
Practice Business Intelligence & Data Science, by design — business value, performance as a learnable capability, not a knack.
Why practice business intelligence & data science matters, and where mastering it takes you.
- — The one-line promise and the story behind it
- — Why we read the whole shelf, not one book
Practice Business Intelligence & Data Science
The need-to-know
The downstream economic and operational outcomes — revenue, cost savings, productivity, competitive advantage, ROI — attributable to applying analytics and BI to decisions and actions.
About this guide
The guide describes these challenges, steps and possible outcomes.
Who it is for
You are building a real capability: Practice Business Intelligence & Data Science.
Challenges
- In practice · Business Value, Performance & Competitive Advantage erodes when it is left to instinct instead of method.
- For the reader · You were taught the moves piecemeal, never the whole model.
Steps to consider
- 1Master data quality, cleaning & preparation.
- 2Master data architecture, storage & integration.
- 3Master feature engineering & attribute selection.
Risks
You stay dependent on instinct, and it fails you when the stakes are highest.
Intended result
Business Value, Performance & Competitive Advantage becomes something you produce by design, not by luck.
Set the record straight
What the field gets wrong
The misconceptions the books in this field converge on correcting.
Analytics and BI success is primarily about acquiring the most data and the best technology/tools.
Success depends far more on organizational, cultural, and human factors—leadership, culture, skilled analysts, business alignment, and process—than on technology; there is no silver-bullet tool and one only delivers value if people actually use it.
A model that fits the training data perfectly (high goodness-of-fit, low residuals) is the best model.
Perfect fit usually signals overfitting; what matters is generalization to unseen data, assessed on holdout/validation/test sets—test error follows a U-shape as complexity grows.
Overall classification accuracy is the right way to judge whether a classifier is good.
Accuracy is misleading with imbalanced classes or unequal misclassification costs; use precision, recall, F1, sensitivity, specificity, lift, ROC/AUC, and cost/expected-value measures instead.
More data, more variables, and more model complexity always produce better predictions.
More is not necessarily better; superfluous and correlated predictors invite overfitting, instability, spurious correlations, and the curse of dimensionality—parsimony, regularization, dimension reduction, and bias/variance balance matter.
Correlation implies causation.
Correlation does not establish causation; without randomized assignment a relationship may reflect reverse causation or a confounding third variable (e.g., Simpson's paradox), so additional controlled evidence is required.
A low p-value proves your result is real, important, or that the null hypothesis is probably false.
A p-value is the probability of observing data this extreme under the null; it doesn't measure effect size, importance, or the probability the hypothesis is true, and repeated testing guarantees occasional low p-values (data dredging), requiring FWER/FDR control.
Big data means sampling is obsolete and more data automatically yields more reliable conclusions.
Random sampling remains crucial; a biased large sample is worse than a small random one, data quality often matters more than quantity, and greater volume can generate spurious correlations—human interpretation and statistical judgment remain essential.
Intuition, experience, and the manager's 'golden gut' are the best basis for important decisions.
Analytical, fact-based, systematic reasoning produces better, more consistent decisions and should be the first resort; intuition is appropriate only in narrow circumstances, though the best decisions still combine analysis with sound human judgment.
Powerful software can mine data and produce insights on its own, replacing skilled analysts and decision makers.
Smart humans must frame questions, interpret patterns, and act on results; trust between analysts and decision makers is essential or nothing happens, and AI models are only as smart as the data and features behind them.
Simply collecting, storing, or having better access to data improves performance.
Stored data accomplishes nothing until it is integrated, analyzed, and converted to actionable knowledge; value comes from linking insight to action, not from access or accumulation.
You need a strong mathematical background or to master big libraries before you can do data science.
You can become productive applying algorithms first—using accessible tools like Python, R, or even spreadsheets—and circle back to mathematical foundations later; concepts matter more than equations.
Data science is primarily about mastering a large catalog of specific algorithms, tools, and sophisticated techniques.
A small set of fundamental concepts underlies most algorithms, and data quantity/quality plus well-conceived features usually matter more than a clever algorithm; master fundamentals before jumping to deep learning.
Simpler or less powerful methods are always inferior to the most complex/flexible model.
There is no free lunch—the best model depends on the data and business goals; by Occam's razor the simplest interpretable model that generalizes and deploys in time is often preferable, and all models are wrong but some are useful.
A data scientist is a single 'unicorn' who masters math, programming, and domain expertise.
Data science combines mathematics/statistics, computer science, domain knowledge, and communication—skills that rarely coexist in one person, so it is best delivered by a team of specialists.
The value and hard work of data science is in building the model.
Most value comes from data wrangling, feature selection, deployment, monitoring, and operationalization—models not put into production deliver no business value, and 80% of real work is cleaning/transforming data.
Data represents objective truth.
Data is the product of human decisions, beliefs, and biases in collection systems, and its meaning often shifts through analysis.
You must understand why something happens (causality) to act, and data's value is exhausted once its primary purpose is served.
Correlation is often good enough and faster/cheaper to act on, and most of data's value is latent in unanticipated secondary uses (option value).
Data must be exact, clean, and perfect before it can deliver value.
Accepting messiness in exchange for more data often yields superior macro insights, and BI can deliver value from a solid-but-imperfect foundation improved incrementally.
Big data analytics is just a large volume of data that replaces classical statistics.
Big data is defined by volume, variety, velocity, and veracity together and represents a paradigm shift that complements rather than replaces traditional statistics.
You target customers with the highest probability of an outcome (churn/response).
You should target where expected value is greatest, accounting for customer value and the actual influence of the intervention, not just probability.
Data science projects can be managed like software engineering with clear milestones.
Data science is exploratory and closer to R&D; outcomes are uncertain and the process iterates, so it must be managed accordingly.
An outlier is just an extreme value to be removed for cleaner analysis.
Outliers are often the most interesting points (fraud, exceptional cases) and can be local rather than merely extreme.
Analytical leadership is only for the CEO and senior-most executives.
Almost any manager or individual contributor at any level can move an organization toward being more analytical, and effective BI sponsorship depends on influence and business alignment more than title.
ROI is the single objective measure of BI success.
The most successful BI deployments don't rely on ROI as the primary measure; success should be gauged multiple ways, including benefits that cannot be readily quantified.
A data warehouse is just a large database, and real-time/operational access makes warehousing obsolete.
A data warehouse is a subject-oriented, integrated, time-variant, non-volatile repository optimized for analysis; operational and analytical data differ fundamentally and both are needed.
Advanced/predictive analytics frees you from the hard work of capturing and integrating historical data.
Predictive analytics requires analyzing historical data to build models, so the need for data integration increases rather than disappears.
BI projects fail because of technology shortcomings.
Most BI/DW projects fail from expectations shortfalls and people/process/politics issues; business acceptance and managing expectations are the load-bearing success factors.
Data shadow systems (spreadmarts) are technical abominations IT should rip out.
They contain valuable business knowledge and exist for good reasons; the fix is separating data integration from analytics, not confronting the business.
Movement II
Map
The main ideas and how they connect.
How the pieces fit together — the model, and what good looks like at each altitude.
- — 41 constructs and how they connect
- — The keystone: business value, performance
- — Foundations → Practitioner → Advanced
The constructs
How they connect (47)
- Data Quality, Cleaning & Preparation → enables → Model Generalization / Predictive Performance
- Data Quality, Cleaning & Preparation → enables → Fact-Based Decision Making
- Data Architecture, Storage & Integration → enables → Data Quality, Cleaning & Preparation
- Data Architecture, Storage & Integration → enables → Analytical & Knowledge Discovery Capability
- Feature Engineering & Attribute Selection → enables → Model Generalization / Predictive Performance
- Business Problem Framing & Definition → enables → Business Value, Performance & Competitive Advantage
- Model & Method Selection → enables → Model Generalization / Predictive Performance
- Model Complexity & Flexibility → produces → Overfitting Risk
- Regularization & Complexity Control → moderates → Overfitting Risk
- Overfitting Risk → produces → Model Generalization / Predictive Performance
- Validation, Resampling & Cross-Validation → moderates → Overfitting Risk
- Validation, Resampling & Cross-Validation → enables → Model Generalization / Predictive Performance
- Evaluation Metric Appropriateness → moderates → Model Generalization / Predictive Performance
- Model Generalization / Predictive Performance → produces → Business Value, Performance & Competitive Advantage
- Model Generalization / Predictive Performance → enables → Fact-Based Decision Making
- Statistical Inference & Uncertainty Quantification → enables → Model Generalization / Predictive Performance
- Sampling, Study Design & Causal Warrant → enables → Statistical Inference & Uncertainty Quantification
- Exploratory Data Analysis → enables → Feature Engineering & Attribute Selection
- Tool, Library & Coding Proficiency → enables → Practitioner Skill, Confidence & Competence
- Conceptual & Mathematical Foundation → enables → Practitioner Skill, Confidence & Competence
- Practitioner Skill, Confidence & Competence → enables → Analytical & Knowledge Discovery Capability
- Analytical Talent & Workforce Capability → enables → Analytical & Knowledge Discovery Capability
- Executive Sponsorship & Leadership Commitment → enables → Analytical, Fact-Based Culture
- Executive Sponsorship & Leadership Commitment → enables → Governance, Strategy & Enterprise Orientation
- Governance, Strategy & Enterprise Orientation → enables → Analytical & Knowledge Discovery Capability
- Analytical, Fact-Based Culture → enables → Fact-Based Decision Making
- Analytical & Knowledge Discovery Capability → enables → Fact-Based Decision Making
- Embedded Analytics in Processes → enables → Fact-Based Decision Making
- Fact-Based Decision Making → produces → Business Value, Performance & Competitive Advantage
- BI Adoption, Trust & Use → produces → Business Value, Performance & Competitive Advantage
- Data Quality, Cleaning & Preparation → enables → BI Adoption, Trust & Use
- Business-IT Partnership & Alignment → enables → BI Adoption, Trust & Use
- Agile / Incremental Development → enables → BI Adoption, Trust & Use
- Data & Application Silo Proliferation → moderates → Data Quality, Cleaning & Preparation
- Model Deployment, Monitoring & Operationalization → enables → Business Value, Performance & Competitive Advantage
- BI/Big-Data Technology Investment & Capability → enables → Analytical & Knowledge Discovery Capability
- Analytical Maturity Stage → moderates → Business Value, Performance & Competitive Advantage
- Datafication & Data Reuse → produces → Business Value, Performance & Competitive Advantage
- Datafication & Data Reuse → produces → Ethics, Privacy & Societal Risk
- Ethics, Privacy & Societal Risk → moderates → Business Value, Performance & Competitive Advantage
- Environmental Turbulence & Catalysts → moderates → Business Value, Performance & Competitive Advantage
- Correlation/Prediction Over Causation (Big-Data Mindset) → enables → Model Generalization / Predictive Performance
- Communication & Translation Skill → moderates → Business Value, Performance & Competitive Advantage
- Model Interpretability → moderates → Model Deployment, Monitoring & Operationalization
- Network, Diffusion & Market Dynamics → enables → Business Value, Performance & Competitive Advantage
- System Reliability, Scalability & Maintainability → requires → Data Architecture, Storage & Integration
- Sound Analytic Process & Prototyping → enables → Model Generalization / Predictive Performance
The model, read as a role
The Business Value, Performance Operator
Practice Business Intelligence & Data Science
How success is measured
- ✓Business Value, Performance & Competitive Advantage. The downstream economic and operational outcomes — revenue, cost savings, productivity, competitive advantage, ROI — attributable to applying analytics and BI to decisions and actions.
The reconciled model, rendered as a job description — a scanning device that makes the guide's ideas read as a role you could hold. A deterministic transform of the factor model; nothing added.
What good looks like · the climb from zero to great
The path from starting out to expert
Mastery isn't one leap — it's four stages, and the honest part is the move between them: what actually separates the next level, and what it takes to get there. Find where you are, then read what's above you.
Starting out
Wrangling data and running your first modelsnew to it — knows the words, not yet the work
What it looks like- Loads a dataset, cleans nulls and inconsistent encodings, and produces a working table before analyzing
- Writes runnable code in a notebook using core libraries but copies patterns without understanding the math
- Makes histograms, scatterplots, and summary stats to see distributions and spot obvious anomalies
- Trains a model and reports raw accuracy without questioning whether the metric fits the task
Moving from 'the model fits my data' to 'the model will generalize to unseen data' — internalizing the bias-variance tradeoff and validating honestly
- Why training error understates true error and how overfitting arises from fitting noise
- The mechanics of cross-validation, holdout splits, and resampling
- How regularization, pruning, and feature selection constrain model capacity
- Which evaluation metrics fit which prediction tasks and cost structures
- Constructing leakage-free train/validation/test pipelines
- Tuning hyperparameters against validation performance
- Engineering and selecting predictor variables that reduce target uncertainty
- Diagnosing overfitting from learning curves and train/holdout gaps
- Abstract reasoning about the tradeoff between flexibility and generalization
- Numerical intuition for capacity, variance, and signal versus noise
- Discipline to resist reporting inflated in-sample metrics
- Access to enough data and compute to run resampling procedures
Foundational
Building models that generalize honestlydoes the basics reliably, by the book
What it looks like- Splits data into train/validation/test and uses cross-validation instead of trusting training error
- Recognizes overfitting from the gap between training and holdout performance and dials model capacity accordingly
- Engineers and selects features deliberately rather than dumping every column into the model
- Chooses an algorithm and evaluation metric matched to the problem type and class balance
Shifting from 'a good model' to 'a solved business problem in production' — starting from the decision context and operationalizing models with uncertainty and monitoring
- Expected-value framing, requirements management, and stakeholder decision contexts
- Statistical inference: confidence intervals, power, multiplicity, error-rate control
- Sampling and study design that warrant generalization and causal claims
- Deployment patterns, drift detection, retraining, and data architecture for scale
- Eliciting and specifying business objectives before modeling
- Quantifying and communicating uncertainty rather than point predictions
- Building reliable data pipelines and putting models into monitored production
- Translating math and code into plain language that drives stakeholder action
- Systems thinking spanning data, model, deployment, and business workflow
- Communicative empathy for non-technical audiences
- Repeated project experience delivering end-to-end under real constraints
- Collaborative partnership with business and IT stakeholders
- Confidence and multidisciplinary self-efficacy in a data role
Proficient
Framing problems and shipping analytics that drive decisionsgood — adapts to context, gets consistent results
What it looks like- Starts from the business decision and expected value, not the dataset, and negotiates requirements with stakeholders
- Quantifies uncertainty with confidence intervals and controls error rates, accounting for study design and sampling
- Deploys models to production with monitoring, drift detection, and retraining rather than leaving them in notebooks
- Translates results into plain business language and explains model behavior to non-technical stakeholders
Elevating from 'I ship analytics projects' to 'I build an organization whose default is fact-based decision-making that creates competitive advantage'
- Analytical maturity models and how enterprises progress across stages
- Governance, data strategy, centers of excellence, and one-version-of-truth design
- How executive sponsorship, culture, and adoption behaviors reinforce each other
- Ethics, privacy, fairness risk, market dynamics, and diffusion/network effects
- Securing sponsorship, funding, and barrier-clearing from senior leaders
- Attributing economic outcomes and ROI to analytics investments
- Dismantling data silos and shadow systems while building trusted BI use
- Recruiting, organizing, and managing analytical talent and enterprise data literacy
- Strategic judgment reconciling analytics investment against turbulence and opportunity
- Organizational influence and change leadership across levels
- Positional authority or credibility to shape enterprise norms
- Long-horizon patience to shift culture toward experimentation and evidence
- Tolerance for ethical and societal-risk tradeoffs at scale
Expert
Building an enterprise analytics capability that creates advantagegreat — sets the standard, reconciles the hard trade-offs
What it looks like- Shapes governance, strategy, and centers of excellence so analytics aligns with business goals across the enterprise
- Secures executive sponsorship and cultivates a culture where fact-based decisions are the default over intuition
- Attributes measurable revenue, cost, and competitive-advantage outcomes to analytics investments
- Manages ethics, privacy, and societal risk while reading market and environmental dynamics to time analytics bets
Movement III
Master
Explore each idea, work through examples and find ways to apply it.
How to actually do it — section by section, with the playbook.
- — 41 sections in journey order
- — Frameworks, checklists, and worked cases
Starting out
Wrangling data and running your first modelsmoderate · 6 sources
- Data Science Bookcamp_ Ten case studies MEAP V01
- Data Science from Scratch: First Principles with Python
- Data Smart: Using Data Science to Transform Information into Insight
- Python for Data Analysis
- R for Data Science
- Business Intelligence Guidebook: From Data Integration to Analytics
This section defines the practical fluency—languages, libraries, vectorized operations, reproducible code—that removes friction between an idea and a result.
Tool, Library & Coding Proficiency
Competence in core data science tools, languages, libraries, vectorized operations, and reproducible/correct code that reduce friction and enable efficient analysis.
Why it matters. Low tool fluency means your analytical thinking gets throttled by mechanical struggle, and slow, error-prone code makes iteration too expensive to explore the questions that matter.
Myth
Once you know the syntax and can call the right library functions, you're a proficient data science coder.
Reality
Proficiency is measured by correctness and reproducibility under change, not by whether the code runs; knowing that a for-loop should be a vectorized operation, and that a result must reproduce on a clean run, is what separates fluent practitioners.
- From-Scratch Learning FrameworkFramework — A pedagogical framework for understanding data science by implementing fundamental algorithms and mathematical tools from first principles before using high-level libraries.
- Spreadsheet-First Data ScienceFramework — A pedagogical and practical framework for learning and applying data science techniques by starting with transparent spreadsheet implementations before graduating to more abstract, code-based tools.
- Vectorized, idiomatic code is a competence marker, not a style preference—it changes what you can afford to explore.
- Reproducibility is part of proficiency: if it doesn't rerun clean, it isn't done.
- The goal is to make the tool invisible so your attention stays on the problem.
The deep drill-down: 8 operational steps, a worked example from the source, 5 decision rules, 5 failure modes, and the “Reproducible Simulation Setup Checklist” tool. Included when you buy this guide.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 2 tools for this section. Included when you buy this guide.
Grounded in: Data Science Bookcamp_ Ten case studies MEAP V01; Data Science from Scratch: First Principles with Python; Data Smart: Using Data Science to Transform Information into Insight; Python for Data Analysis; R for Data Science; Business Intelligence Guidebook: From Data Integration to Analytics
moderate · 4 sources
- Data Science from Scratch: First Principles with Python
- Data Smart: Using Data Science to Transform Information into Insight
- Data Science Bookcamp_ Ten case studies MEAP V01
- Machine Learning and Data Science
This section addresses the statistical and mathematical understanding beneath the techniques—why a method works, when it breaks, and what its outputs actually mean.
Conceptual & Mathematical Foundation
A practitioner's internalized grasp of the mathematics, statistics, and mechanics underpinning data science techniques, beyond surface tool usage.
Why it matters. Without the underlying math you cannot tell when a model's assumptions are violated, so you ship confident results that are quietly invalid.
Myth
Modern libraries abstract away the math, so you can be an effective data scientist without understanding what's under the hood.
Reality
Abstractions hide the mechanics until something breaks; when a model behaves strangely, only the person who understands the estimator, the loss surface, or the distributional assumption can diagnose why.
- The math is what lets you debug a model that runs but is wrong.
- Every method carries assumptions; knowing them tells you where it will fail.
- Understanding what a metric optimizes prevents optimizing the wrong thing.
The deep drill-down: 7 operational steps, a worked example from the source, 5 decision rules, 5 failure modes, and the “Probability Problem Decomposition Worksheet” tool. Included when you buy this guide.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for. Included when you buy this guide.
Grounded in: Data Science from Scratch: First Principles with Python; Data Smart: Using Data Science to Transform Information into Insight; Data Science Bookcamp_ Ten case studies MEAP V01; Machine Learning and Data Science
Foundational
Building models that generalize honestlymoderate · 4 sources
- Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
- Data Smart: Using Data Science to Transform Information into Insight
- Analytics at Work: Smarter Decisions, Better Results
- Machine Learning and Data Science
This section lays out why a structured, iterative analytics process with early prototyping beats jumping straight to a clever model.
Sound Analytic Process & Prototyping
Following a structured, iterative analytics process (e.g., CRISP-DM) with prototyping and iteration rather than ad hoc work.
Why it matters. Ad hoc work skips the business-understanding and data-understanding phases where most project failures are seeded, so process discipline is what prevents building the wrong thing precisely.
Myth
A structured process like CRISP-DM is heavyweight bureaucracy that slows down skilled practitioners who already know what they're doing.
Reality
The process is iterative and cheap when done as prototyping—its value is forcing you to revisit the business question and data reality before over-investing, catching misframed problems early rather than after a polished model.
- The Cross Industry Standard Process for Data Mining (CRISP-DM)Process — To provide a structured and repeatable framework for data mining projects, breaking the process into well-understood stages and emphasizing iteration and exploration.
- Four-Step Dimensional Design ProcessProcess — To provide a structured, repeatable approach to creating a dimensional model that is business-driven and technically sound.
- Kimball DW/BI Lifecycle ProjectProcess — To provide a roadmap for planning, designing, developing, and deploying a DW/BI system in a structured, business-focused, and iterative manner.
- Fast end-to-end prototypes surface problems that phase-by-phase perfection hides.
- The process is a loop; returning to business understanding is a feature, not a failure.
- Most project failures originate in framing and data understanding, which the process protects.
The deep drill-down: 8 operational steps, a worked example from the source, 5 decision rules, 5 failure modes, and the “Analytic Process & Prototype Iteration Checklist” tool. Included when you buy this guide.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 3 tools for this section. Included when you buy this guide.
Grounded in: Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking; Data Smart: Using Data Science to Transform Information into Insight; Analytics at Work: Smarter Decisions, Better Results; Machine Learning and Data Science
Proficient
Framing problems and shipping analytics that drive decisionsmoderate · 9 sources
- Data Science Bookcamp_ Ten case studies MEAP V01
- Data Science from Scratch: First Principles with Python
- Data Smart: Using Data Science to Transform Information into Insight
- Python for Data Analysis
- R for Data Science
- Introduction to Statistical and Machine Learning Methods for Data Science
- Business Intelligence and Big Data
- Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
- Competing on Analytics: The New Science of Winning
This section is about the integrated capability—technical, conceptual, and affective—that turns discrete skills into someone who can actually do and land a data science role.
Practitioner Skill, Confidence & Competence
The integrated, multidisciplinary capability — plus the affective confidence and motivation — that enables a person to perform data science work and obtain/perform in a data role.
Why it matters. Skills that never consolidate into confidence leave you unable to start, defend, or finish real work, regardless of how much you've studied.
Myth
Competence is a checklist of skills; accumulate enough tutorials and certifications and you're a capable data scientist.
Reality
Capability is the integration of tools, math, and judgment applied to ambiguous real problems, plus the earned confidence to commit to an approach; it emerges from doing end-to-end projects, not from stacking isolated competencies.
- Scientific Method Applied to Data ScienceProcess — To illustrate how the core principles of the scientific method are applied in day-to-day data science work.
- End-to-end projects, not certifications, are what convert skills into capability.
- Confidence is a competence—it's what lets you commit and act under uncertainty.
- Integration across tools, math, and judgment is the thing being hired for, not any single skill.
The deep drill-down: 8 operational steps, a worked example from the source, 5 decision rules, 5 failure modes, and the “Data-Science Skill Gap & Confidence Audit” tool. Included when you buy this guide.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 1 tool for this section. Included when you buy this guide.
Grounded in: Data Science Bookcamp_ Ten case studies MEAP V01; Data Science from Scratch: First Principles with Python; Data Smart: Using Data Science to Transform Information into Insight; Python for Data Analysis; R for Data Science; Introduction to Statistical and Machine Learning Methods for Data Science; Business Intelligence and Big Data; Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking; Competing on Analytics: The New Science of Winning
moderate · 2 sources
- Successful Business Intelligence: Unlock the Value of BI & Big Data
- The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
This section explains how iterative, incremental delivery lets BI keep pace with a business whose questions change faster than any annual plan.
Agile / Incremental Development
The use of iterative, collaborative, agile delivery techniques to provide BI/analytics capabilities at the pace of business change, reusing components for velocity.
Why it matters. A twelve-month BI project frequently delivers answers to questions the business stopped asking, wasting the investment and eroding trust.
Myth
Agile just means shipping faster or working without documentation.
Reality
For BI, agility's real payoff is compressing the feedback loop so users can react to a working report and refine it — plus reusing data models and components so each increment costs less than the last.
- Hybrid BI Project MethodologyFramework — A project management framework that blends a waterfall approach for overall project structure with an iterative, agile-style approach for developing individual BI application components.
- BI Prototyping LifecycleProcess — To incrementally build a BI application component, engage business users for feedback, and refine the application to meet their needs, avoiding surprises at final delivery.
- BI Agile Development using ScrumProcess — To deliver valuable BI capabilities to the business quickly and iteratively, while remaining flexible to changing requirements.
- Ship a thin working slice early to get real user feedback before scaling.
- Reusable certified data components are what make later increments cheap.
- Agility in BI is about feedback velocity, not merely coding faster.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 3 tools for this section. Included when you buy this guide.
Grounded in: Successful Business Intelligence: Unlock the Value of BI & Big Data; The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
moderate · 2 sources
- Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow
- Introduction to Statistical and Machine Learning Methods for Data Science
This section covers getting models into production and keeping them healthy through monitoring, drift detection, and retraining — the ModelOps discipline.
Model Deployment, Monitoring & Operationalization
Putting models into production effectively and maintaining them through ongoing monitoring, drift detection, and retraining (ModelOps).
Why it matters. A model's accuracy decays silently in production as the world shifts, so unmonitored deployment turns a validated asset into a slow, unnoticed liability.
Myth
Deployment is the finish line — once the model is live and scoring, the data science work is done.
Reality
Deployment is the start of the longest phase; the world drifts away from the training data continuously, and a model without monitoring and retraining degrades from correct to wrong without anyone noticing.
- Churn Model for TelecommunicationsCase study — A telecommunications company with millions of customers exhibiting diverse behaviors, making it difficult for a single model to predict churn effectively.
- Knowledge Conversion Spiral (SECI Model)Process — To create new organizational knowledge through the dynamic interaction between implicit (tacit) and explicit knowledge.
- Model Operationalization (ModelOps)Process — To move analytical models from development to production quickly and reliably, while ensuring quality, scalability, and continuous monitoring.
- Model accuracy decays after deployment; assume drift and build detection for it.
- Define retraining and rollback triggers before go-live, not during an incident.
- Watch prediction and input distributions, not just infrastructure uptime.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 3 tools for this section. Included when you buy this guide.
Grounded in: Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow; Introduction to Statistical and Machine Learning Methods for Data Science
emerging · 1 source
- Designing Data-Intensive Applications
This section addresses keeping the data system correct under faults, performant under growing load, and easy to operate and evolve over time.
System Reliability, Scalability & Maintainability
The data system's continued correct functioning under faults, ability to sustain performance as load grows, and ease of operation and evolution, conditioned by complexity, consistency, and consensus mechanisms.
Why it matters. A data platform that fails, slows under load, or ossifies undermines every analytical output it feeds, and reliability problems surface at exactly the worst moments — peak demand.
Myth
Reliability, scalability, and maintainability are one property you buy by over-provisioning powerful hardware.
Reality
They are distinct and often in tension: designing for fault tolerance, for load growth, and for future change involve different trade-offs, and the hardest constraints are consistency and consensus, not raw capacity.
- Reliability-Scalability-Maintainability (RSM) Analysis FrameworkFramework — A mental model for evaluating and reasoning about the design of a data-intensive application.
- Reliability, scalability, and maintainability trade off against each other and must be prioritized deliberately.
- Consistency and consensus, not hardware, are usually the binding scalability constraints.
- Test against projected load, since capacity problems appear precisely at peak demand.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 1 tool for this section. Included when you buy this guide.
Grounded in: Designing Data-Intensive Applications
moderate · 3 sources
- Analytics at Work: Smarter Decisions, Better Results
- Competing on Analytics: The New Science of Winning
- Big Data: A Revolution That Will Transform How We Live, Work, and Think
This section shows you how to move analytics out of dashboards and into the operational systems where decisions actually happen — at machine speed and scale.
Embedded Analytics in Processes
The integration of analytical models and decisions directly into operational processes and workflow, including automation at scale.
Why it matters. Insight that a human must remember to look up rarely fires at the moment of decision, so embedding is what converts model accuracy into consistent action.
Myth
Practitioners believe that once a model is accurate, plugging its output into a workflow is a trivial engineering hand-off.
Reality
Embedding forces you to redesign the process itself — where the score enters, who can override it, what happens on failure — and that process redesign is harder and more consequential than the model.
- Decision Automation FrameworkFramework — A framework for classifying decisions to determine the appropriate level of automation and human involvement.
- Big Data Governance FrameworkFramework — A set of three core principles to govern the use of big data, balancing its benefits with its risks to society and individuals.
- Analytical Maturity FrameworkFramework — A framework describing the evolution of analytical tasks in terms of complexity and business value, moving from descriptive to prescriptive analytics.
- Data Science Problem Formulation ChecklistChecklist — 8 checkpoints
- McLaren F1 Racing AnalyticsCase study — A Formula One racing team needed to optimize car performance and make critical decisions in real-time during high-speed races.
- Ladder of Analytical ApplicationsTemplate — To assess the maturity of analytics within a specific business process and set ambitions for climbing to higher levels of sophistication and value.
- Analytics-Embedded Insurance Claims ProcessingProcess — To improve process efficiency and flexibility, automate routine decisions, detect fraud, and identify cross-selling opportunities by embedding analytical models at key decision points.
- Data Integration DesignProcess — To create the detailed specifications needed to build, test, and deploy the data integration processes for a given stage.
- The value of an embedded model is bounded by the process it sits inside, not by its offline accuracy.
- Design the human override and low-confidence fallback before you ship the happy path.
- Log every automated decision so you can trace outcomes back to model behavior.
The deep drill-down: 8 operational steps, a worked example from the source, 5 decision rules, 5 failure modes, and the “Embedded Analytics Decision-Point Spec Sheet” tool. Included when you buy this guide.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 8 tools for this section. Included when you buy this guide.
Grounded in: Analytics at Work: Smarter Decisions, Better Results; Competing on Analytics: The New Science of Winning; Big Data: A Revolution That Will Transform How We Live, Work, and Think
moderate · 2 sources
- Business Intelligence Guidebook: From Data Integration to Analytics
- Successful Business Intelligence: Unlock the Value of BI & Big Data
This section describes the working partnership between business and IT that determines whether BI solutions get built right — and used.
Business-IT Partnership & Alignment
The relational pattern of business and IT working as partners with open communication, shared accountability, and active business participation across the BI lifecycle.
Why it matters. When business and IT operate as vendor-and-customer rather than partners, requirements get lost in translation and delivered systems answer the wrong question.
Myth
Business defines requirements, IT builds to spec, and clean hand-offs make collaboration efficient.
Reality
BI requirements are discovered, not specified up front; shared accountability and continuous business participation throughout the build catch the misunderstandings that a spec document never surfaces.
- BI requirements emerge through iteration, so continuous business involvement beats an upfront spec.
- Shared accountability for use — not just delivery — changes both sides' behavior.
- Replace the intake-ticket model with embedded, working partnership.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for. Included when you buy this guide.
Grounded in: Business Intelligence Guidebook: From Data Integration to Analytics; Successful Business Intelligence: Unlock the Value of BI & Big Data
Expert
Building an enterprise analytics capability that creates advantagestrong · 5 sources
- Analytics at Work: Smarter Decisions, Better Results
- Competing on Analytics: The New Science of Winning
- Business Intelligence and Big Data
- Successful Business Intelligence: Unlock the Value of BI & Big Data
- Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
This section addresses the enterprise-level supply and organization of analytical people—both the specialists who build and the decision-makers who must consume their work.
Analytical Talent & Workforce Capability
The supply, quality, organization, and management of skilled analysts/data scientists plus the data literacy of decision makers across the enterprise.
Why it matters. A brilliant analytics team wired to a data-illiterate leadership produces sophisticated work that no one can act on, wasting the entire investment.
Myth
Building analytical capability means hiring more data scientists.
Reality
Workforce capability is a two-sided market: the analytical literacy of the decision-makers who commission and consume work matters as much as the head-count of specialists, and neglecting the demand side strands the supply side.
- The DELTA Framework for Analytical CapabilityFramework — A five-part framework that outlines the essential, interdependent success factors required for an organization to succeed with analytics: Data, Enterprise, Leadership, Targets, and Analysts.
- DELTA ModelFramework — A comprehensive framework outlining the five essential pillars an organization must build to successfully compete on analytics.
- The Five Cs of Data QualityChecklist — 5 checkpoints
- Signposts of Effective IT for Analytical CompetitionChecklist — 6 checkpoints
- Best Buy: Driving to an Analytical EnterpriseCase study — Around 2006, Best Buy's leadership, committed to a 'customer centricity' strategy, realized that while corporate had data, it wasn't being used for fact-based decisions at the store level where employees interact with customers.
- 'Do We Have a Good Target?' Decision ToolTemplate — To evaluate the quality and feasibility of a potential analytical project or target.
- Data Warehouse ImplementationProcess — To create a robust and effective data warehouse system for data analysis and decision-making.
- Analytical capability requires developing consumers of analysis, not just producers.
- How analysts are organized and connected to decisions matters as much as how many you have.
- Data literacy at the leadership level is the binding constraint more often than talent supply.
The deep drill-down: 7 operational steps, a worked example from the source, 5 decision rules, 5 failure modes, and the “Analytical Capability & Staffing Map” tool. Included when you buy this guide.
The rest of this section
the full written section · 3 how-to steps · 2 pitfalls to watch for · 7 tools for this section. Included when you buy this guide.
Grounded in: Analytics at Work: Smarter Decisions, Better Results; Competing on Analytics: The New Science of Winning; Business Intelligence and Big Data; Successful Business Intelligence: Unlock the Value of BI & Big Data; Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking
The playbook — the whole process
Beneath the model sits the practical spine — 73 named, end-to-end processes the source books lay out. Here they are, in sequence, each broken into the steps you actually run.
The sequence — high level first
Illumination of the parts
Process 1 · named in the source
Analytics-Embedded Insurance Claims Processing
To improve process efficiency and flexibility, automate routine decisions, detect fraud, and identify cross-selling opportunities by embedding analytical models at key decision points.
- 1
Register the initial claim notification from the customer.
- 2
Apply a predictive model to forecast the likely duration of the handling process and recommend the next best step.
- 3
Route the claim based on the skill level required for processing.
- 4
Score the claim for fraud likelihood; if high, route to a special investigations unit (SIU).
- 5
Fast-track low-risk, simple claims for immediate resolution and payment.
- 6
For complex claims, assess damage and liability, gathering additional information as recommended by an analytical model.
- 7
Determine the final payment amount.
- 8
Use a recommendation engine to identify and suggest cross-selling opportunities to the satisfied customer during or after payment.
Process 2 · named in the source
Metadecision Analysis for Important Decisions
To improve the quality of major decisions by explicitly and methodically planning how the decision will be made before making it.
- 1
Define the specific decision that needs to be made.
- 2
Determine the method for making the decision (e.g., unilateral, consultative, majority vote, consensus).
- 3
Establish the governance for the decision using RACI (define who is Responsible, Accountable, Consulted, and Informed).
- 4
Make the decision using the chosen method and governance structure.
- 5
Communicate and implement the decision.
Process 3 · named in the source
Closed-Loop Enterprise Analytics Process
To systematically build, test, and integrate new analytical capabilities throughout the organization, driving fact-based decisions from the corporate level down to individual stores.
- 1
Plan: Define metrics and priorities based on strategic questions like 'What happened?', 'Why did it happen?', and 'What should happen?'.
- 2
Build: Develop the analytical tools, models, and data infrastructure required.
- 3
Test: Pilot the new capabilities and metrics to validate their effectiveness.
- 4
Launch: Roll out the tools and training to business operators (e.g., store managers).
- 5
Learn: Gather feedback and measure outcomes to identify what's working and what's not.
- 6
Refine: Use the learnings to refine the models and plan the next iteration of improvements.
Process 4 · named in the source
Predicting Illegal Building Conversions
To identify buildings with illegal and hazardous conversions that pose the highest risk of fire, allowing for prioritized inspections with limited resources.
- 1
Create a master list of every property in the city.
- 2
Integrate datasets from various agencies, including tax delinquency, foreclosures, utility usage, crime rates, and ambulance visits.
- 3
Harmonize messy location data from different systems into a single coordinate-based identifier.
- 4
Compare the aggregated property data against five years of fire data to find correlations with severe incidents.
- 5
Build a predictive model to score and rank all incoming illegal-conversion complaints by fire risk.
- 6
Provide the top 5% of high-risk complaints to inspectors for immediate follow-up.
Process 5 · named in the source
Predicting Airfare Price Changes
To predict whether the price of a given airline ticket is likely to rise or fall in the near future, empowering consumers to buy at the optimal time.
- 1
Collect a massive dataset of historical ticket price observations for specific flight routes.
- 2
Analyze all price observations for a given route relative to the number of days before departure.
- 3
Calculate the probability of the price increasing or decreasing based on historical patterns.
- 4
Recommend 'buy now' if the price is likely to increase, or 'wait' if the price is likely to decrease.
- 5
Present a confidence score for the prediction to the user.
Process 6 · named in the source
Charting Ocean Currents (Maury's Method)
To create maps of winds and ocean currents to enable ships to sail more efficient and safer routes.
- 1
Collect a large repository of old, dusty ship logbooks previously considered rubbish.
- 2
Extract and tabulate key data points: wind, water, and weather at specific locations on specific dates.
- 3
Aggregate the data, dividing the ocean into five-degree blocks of longitude and latitude.
- 4
Analyze the aggregated data for each block by month to identify patterns in currents and winds.
- 5
Create standardized forms and incentivize merchant captains to log and submit new data in exchange for the new charts.
- 6
Incorporate new data streams, such as notes in bottles, to continually refine the charts.
Process 7 · named in the source
MapReduce Data Processing
To process vast amounts of data in parallel by breaking the job into smaller, independent tasks that can run on different machines simultaneously.
- 1
The user provides input files to be processed (e.g., several files containing disease case counts).
- 2
Run the 'Map' function, which reads each input file line-by-line and outputs intermediate key-value pairs (e.g., <Measles, 3>, <Zika, 2>).
- 3
Execute the 'Shuffle and Sort' step (part of the Hadoop framework), which automatically groups the intermediate key-value pairs by key (e.g., all 'Measles' records are sent to one file, all 'Zika' to another).
- 4
Run the 'Reduce' function, which processes each group of values for a given key and aggregates them to produce a final result (e.g., sums all values for 'Measles' to get a total count).
- 5
Write the final key-value pairs to an output file in the DFS (e.g., <Measles, 12>, <Zika, 8>).
Process 8 · named in the source
Huffman Lossless Data Compression
To encode data more efficiently by assigning shorter codes to more frequent characters and longer codes to less frequent characters.
- 1
Count the frequency of each unique character in the input string (e.g., for 'added', d=3, a=1, e=1).
- 2
Create a binary tree node for each character with its frequency.
- 3
Repeatedly select the two nodes with the lowest frequencies.
- 4
Create a new parent node for these two selected nodes, with a frequency equal to the sum of their frequencies.
- 5
Assign '0' to one branch and '1' to the other branch of the new parent node.
- 6
Continue combining nodes until a single root node remains, forming the complete Huffman tree.
- 7
Determine the code for each character by traversing the path from the root to the character's leaf node.
- 8
Replace each character in the original string with its new, variable-length Huffman code.
Process 9 · named in the source
Building and Using a Bloom Filter
To create a fast, memory-efficient probabilistic filter that can confirm an item is NOT in a set, or state that it PROBABLY is.
- 1
Create a bit array of a fixed size, with all bits initialized to '0'.
- 2
Select a number of independent hash functions (e.g., two functions for the example).
- 3
For each item in the list to be added (e.g., 'aaa@aaaa.com'):
- 4
Apply each hash function to the item. Each function will output an index position in the bit array.
- 5
Set the bit at each of these output index positions to '1'.
- 6
To check if a new item is in the list:
- 7
Apply the same hash functions to the new item to get a set of index positions.
- 8
Check the bit value at each of these positions in the array.
- 9
If ANY of the bits are '0', the item is definitely NOT in the list.
- 10
If ALL of the bits are '1', the item is PROBABLY in the list (it could be a false positive).
Process 10 · named in the source
Statistical Hypothesis Testing
To determine whether to reject the null hypothesis (that there is no real effect) in favor of an alternative hypothesis, based on a calculated p-value.
- 1
Formulate a null hypothesis (e.g., the mean click-rate of a new ad color is the same as blue) and an alternative hypothesis.
- 2
Choose a significance level (alpha), typically 0.05, as the threshold for rejecting the null hypothesis.
- 3
Calculate the p-value: the probability of observing data at least as extreme as what was collected, assuming the null hypothesis is true.
- 4
Compare the p-value to the significance level.
- 5
Reject the null hypothesis if the p-value is less than or equal to the significance level; otherwise, fail to reject it.
Process 11 · named in the source
Confidence Interval Estimation via Simulation
To create a range of values that likely contains the true parameter with a certain level of confidence (e.g., 95%).
- 1
Run a large number of simulations of the experiment (e.g., 100,000 sets of 1,000 coin flips).
- 2
For each simulation, calculate the sample statistic of interest (e.g., the frequency of heads).
- 3
Plot a histogram of all the calculated sample statistics.
- 4
Identify the central range of the histogram that contains the desired percentage of outcomes (e.g., 95%).
- 5
Define the boundaries of this range as the confidence interval for the true parameter.
Process 12 · named in the source
Defining BI Requirements
To create a documented foundation of what the BI solution is planned to build, which is then used by the development team to design, develop, and deploy the system.
- 1
Define high-level business requirements from sponsors and stakeholders through interviews.
- 2
Decompose business requirements into detailed data requirements, identifying necessary data sources and transformations.
- 3
Perform data profiling and source system analysis to assess data quality and consistency.
- 4
Define functional requirements, including use cases, analytical workflow, and user interactions.
- 5
Identify and document any regulatory, compliance, and technical requirements.
- 6
If necessary, reverse engineer existing undocumented reports or data shadow systems.
- 7
Consolidate all gathered requirements into a cohesive requirements document.
- 8
Review the consolidated requirements with stakeholders and get them to prioritize all items.
- 9
Revise the project plan and budget based on the prioritized requirements and obtain formal sign-off.
Process 13 · named in the source
Evaluating and Selecting Technology/Products
To objectively select the best-fit technology or product that meets the prioritized requirements of the organization.
- 1
Gather and prioritize technical and business requirements for the technology.
- 2
Establish success and value criteria for evaluation, classifying features as 'must-have' vs. 'nice-to-have'.
- 3
Survey the market and select a short list of 3-5 product candidates that fit the budget.
- 4
Conduct product reviews, including vendor demos and hands-on proofs of concept (POCs) if possible.
- 5
Score and rank the products against the established criteria.
- 6
Review the results with all stakeholders and select the winning product(s).
- 7
Negotiate pricing and contract terms with the selected vendor.
Process 14 · named in the source
Data Integration Design
To create the detailed specifications needed to build, test, and deploy the data integration processes for a given stage.
- 1
Confirm all prerequisite deliverables are available (data architecture, data requirements, source system analysis, target data models).
- 2
Create a conceptual data integration process model showing sources and targets at the application/database level.
- 3
Create a logical data integration process model showing sources and targets at the table/file level.
- 4
Design the source-to-target mappings, detailing every column transformation, join, filter, and aggregation.
- 5
Design the physical data integration process model using the specific components and workflow of the chosen data integration tool.
- 6
Integrate the stage-specific design into the overall data integration workflow, accounting for dependencies.
Process 15 · named in the source
BI Prototyping Lifecycle
To incrementally build a BI application component, engage business users for feedback, and refine the application to meet their needs, avoiding surprises at final delivery.
- 1
Define the scope of the prototype, including the component, participants, objectives, and timeline.
- 2
Create the BI application prototype component using the selected BI tool and available sample data.
- 3
Conduct developer-led unit tests to ensure the component functions correctly.
- 4
Have business users test the prototype to assess its functionality and provide feedback.
- 5
Gather and analyze user feedback on the prototype.
- 6
Revise the prototype based on feedback, repeating the cycle if necessary for major flaws.
- 7
Obtain a formal sign-off from the user, indicating the component is ready for integration or the next phase.
Process 16 · named in the source
Knowledge Conversion Spiral (SECI Model)
To create new organizational knowledge through the dynamic interaction between implicit (tacit) and explicit knowledge.
- 1
Convert implicit knowledge to new implicit knowledge through shared experience (Socialization).
- 2
Articulate implicit knowledge into explicit concepts, such as metaphors, analogies, or models (Externalization).
- 3
Systematize and combine different bodies of explicit knowledge into a new whole (Combination).
- 4
Embody explicit knowledge into implicit knowledge through action and practice, making it tacit again (Internalization).
Process 17 · named in the source
Big Data Management Lifecycle
To systematically derive value from Big Data initiatives.
- 1
Acquire and record data from various internal and external sources.
- 2
Extract relevant information, clean the data to remove errors, and add descriptive metadata (annotation).
- 3
Integrate and aggregate data from different sources into a uniform representation suitable for analysis.
- 4
Apply analytical models and data mining techniques to the prepared data to uncover patterns and insights.
- 5
Interpret the results, assess their reliability, and formulate descriptive conclusions and recommendations for the business.
Process 18 · named in the source
Extraction-Transformation-Load (ETL)
To create a clean, consistent, and integrated data set suitable for analysis in a data warehouse.
- 1
Extract data from various source systems, which can include relational databases, flat files, or legacy systems.
- 2
Transform the extracted data by cleaning it, applying business rules, checking for data integrity, and converting it to a common format.
- 3
Load the cleaned, transformed data into the target data warehouse for access by analytical tools.
Process 19 · named in the source
Revenue Management (Yield Management)
To optimize revenue and profitability by dynamically setting the best price for each unit of inventory (e.g., hotel room, airline seat).
- 1
Gather historical data on demand, booking patterns, and seasonality.
- 2
Use predictive models to forecast demand for different customer segments.
- 3
Set optimal prices in real-time based on forecasts and current capacity.
- 4
Monitor performance against revenue opportunity metrics and adjust strategies.
Process 20 · named in the source
Analytical Talent Acquisition
To systematically recruit and hire individuals who possess the quantitative and problem-solving skills needed in a data-driven culture.
- 1
Define non-traditional attributes of successful employees, such as intelligence and character.
- 2
Design quantitative and case-based tests to screen candidates' analytical abilities.
- 3
Conduct multiple rounds of interviews to assess both skills and cultural fit.
- 4
Analyze post-hire performance data to continuously refine selection criteria.
Process 21 · named in the source
Predictive Attrition Management
To identify employees at high risk of leaving the company and to design targeted interventions to retain them.
- 1
Gather data points on employees, such as tenure, performance history, compensation, and team dynamics.
- 2
Build a predictive model to generate an individual 'flight risk' score.
- 3
Identify the key drivers of attrition within the organization.
- 4
Alert managers of at-risk employees and provide suggestions for intervention.
- 5
Measure the impact of interventions on retention rates.
Process 22 · named in the source
Anticipatory Package Shipping
To reduce delivery times by shipping items to a geographic region before a specific customer order has been placed.
- 1
Analyze historical sales data and other factors to predict demand for specific items in a given area.
- 2
Proactively ship predicted items to a local distribution hub or a truck in the target region.
- 3
Wait for a customer in that region to place an order.
- 4
Complete the final leg of the delivery from the pre-positioned inventory.
Process 23 · named in the source
Road Map to Enhanced Analytical Capabilities
To provide a structured path for progressing through the five stages of analytical maturity.
- 1
Ensure foundational prerequisites are in place: some quality data and executives predisposed to fact-based decisions.
- 2
Assess the organization's current analytical capabilities across all dimensions (e.g., using the DELTA model) to determine its stage of maturity.
- 3
Choose a path based on leadership support: the 'full-steam-ahead' path for strong CEO sponsorship, or the 'prove-it' path for building momentum from the bottom-up.
- 4
If on the 'prove-it' path, execute a series of localized projects with measurable benefits, document successes, and build support until gaining executive commitment.
- 5
Secure enterprise-wide executive sponsorship and align resources to build a broad analytical capability focused on a distinctive capability.
- 6
Develop an enterprise-wide analytics plan and architecture, integrating data and standardizing tools.
- 7
Master analytics as a core capability, embedding it into key processes and products, and focus on continuous renewal and innovation.
Process 24 · named in the source
Information-Based Strategy (Test-and-Learn Cycle)
To use scientific experimentation to identify the most profitable product offerings and customer segments.
- 1
Formulate a hypothesis about a customer behavior or product feature (e.g., a balance-transfer offer for a credit card).
- 2
Design a controlled market experiment, creating thousands of variations of the product offering (e.g., different interest rates, marketing messages, customer segments).
- 3
Launch the test to a small, statistically valid segment of the market.
- 4
Collect and analyze response data to empirically determine which variations are most successful and profitable.
- 5
Roll out the winning product configuration to the broader market.
- 6
Continuously repeat the cycle to refine existing products and discover new ones.
Process 25 · named in the source
Analytics-Driven Talent Management
To apply data and analytics to people-related decisions to improve hiring, development, and retention.
- 1
Identify a critical people-related business question (e.g., 'What are the defining behaviors of our best managers?').
- 2
Gather diverse data sources, such as employee surveys, performance reviews, promotion history, and compensation data.
- 3
Use advanced analytics (e.g., regression analysis, clustering) to identify the key variables and behaviors that correlate with desired outcomes (e.g., high-performing teams).
- 4
Codify the findings into simple, actionable principles (e.g., Google's 'Eight Rules for Good Management').
- 5
Develop and deploy interventions based on the findings, such as targeted training programs for managers.
- 6
Measure the impact of the interventions on employee performance and satisfaction to close the loop.
Process 26 · named in the source
The Data Mining Process
To provide a structured workflow from business understanding to model deployment, ensuring a robust and well-evaluated outcome.
- 1
Develop an understanding of the purpose of the project and how the results will be used.
- 2
Obtain the dataset to be used, potentially sampling from a larger database.
- 3
Explore, clean, and preprocess the data, handling missing values and outliers.
- 4
Reduce the data dimension by eliminating or transforming variables if necessary.
- 5
Determine the specific data mining task (e.g., classification, prediction, clustering).
- 6
Partition the data into training, validation, and test sets for supervised tasks.
- 7
Choose the data mining techniques to be used (e.g., regression, trees, neural nets).
- 8
Use algorithms to perform the task, often iteratively trying multiple variants.
- 9
Interpret the results and select the best model based on validation performance.
- 10
Deploy the chosen model to score new records and integrate it into operational systems.
Process 27 · named in the source
The k-NN Algorithm
To make a prediction for a new record by finding similar records in the training data and using their outcomes.
- 1
Choose the number of neighbors, 'k'.
- 2
For a new record to be classified, calculate the distance to every record in the training data.
- 3
Identify the 'k' nearest neighbors (the training records with the smallest distances).
- 4
For classification, assign the new record to the class that is most frequent among its 'k' neighbors (majority vote).
- 5
For prediction, assign the new record the average outcome value of its 'k' neighbors.
Process 28 · named in the source
The Cross Industry Standard Process for Data Mining (CRISP-DM)
To provide a structured and repeatable framework for data mining projects, breaking the process into well-understood stages and emphasizing iteration and exploration.
- 1
Develop a thorough understanding of the business problem and objectives (Business Understanding).
- 2
Examine the available data, assessing its strengths, limitations, costs, and relevance to the business problem (Data Understanding).
- 3
Manipulate and convert raw data into a format suitable for modeling techniques, such as a feature vector representation (Data Preparation).
- 4
Apply data mining techniques to the prepared data to extract patterns and build models (Modeling).
- 5
Rigorously assess the models to ensure they are valid, reliable, and meet the business goals (Evaluation).
- 6
Put the results of data mining into real use to realize a return on investment, for example by integrating a model into an information system (Deployment).
Process 29 · named in the source
k-Means Clustering
To group similar data points together based on proximity, minimizing the total sum of squared distances from each point to the mean of its assigned cluster.
- 1
Start with a set of k initial means (cluster centers), often chosen randomly from the data points.
- 2
Assign each data point to the cluster whose mean it is closest to.
- 3
Check if any point's assignment has changed since the last iteration.
- 4
If no assignments have changed, stop.
- 5
If assignments have changed, recompute the mean for each cluster based on its newly assigned points and return to the assignment step.
Process 30 · named in the source
Building a Decision Tree (ID3 Algorithm)
To learn a set of hierarchical rules that can be used to predict the label of a new data point.
- 1
Start with a dataset and a list of attributes to consider.
- 2
If all data points have the same label, create a leaf node that predicts that label and stop.
- 3
If the list of attributes is empty, create a leaf node that predicts the most common label and stop.
- 4
For each attribute, calculate the entropy of partitioning the data by that attribute's values.
- 5
Choose the attribute that results in the lowest partition entropy (the 'best' attribute).
- 6
Add a decision node to the tree based on the chosen attribute.
- 7
For each value of the chosen attribute, recur on the subset of the data with that value, using the remaining attributes.
Process 31 · named in the source
Training a Model with Gradient Descent
To find the model parameters that minimize a given loss function (e.g., sum of squared errors).
- 1
Define a model with a set of parameters (e.g., `theta`).
- 2
Define a loss function that measures how well the model fits the data.
- 3
Start with a random or arbitrary initial value for the parameters.
- 4
Repeatedly compute the gradient of the loss function with respect to the parameters.
- 5
Take a small step in the direction opposite to the gradient to update the parameters.
- 6
Stop after a fixed number of iterations (epochs) or when the parameters stop changing significantly.
Process 32 · named in the source
K-Means Clustering via Spreadsheet
To partition a set of observations into 'k' distinct, non-overlapping subgroups (clusters) where each observation belongs to the cluster with the nearest mean.
- 1
Prepare the data into a matrix of observations (e.g., customers) by features (e.g., offers taken).
- 2
Choose a number of clusters, k, and create 'k' columns in the spreadsheet to represent the cluster centers (centroids).
- 3
Calculate the distance (e.g., Euclidean) from each observation to each of the k cluster centers using array formulas.
- 4
For each observation, determine its assigned cluster by finding the center with the minimum distance (using MIN and MATCH formulas).
- 5
Create an objective cell that sums the minimum distances for all observations.
- 6
Use Excel's Solver (with the Evolutionary algorithm for non-linear distances) to find the values for the cluster centers that minimize the objective cell.
- 7
Analyze the resulting clusters by examining the characteristics of the observations within each group.
Process 33 · named in the source
Naïve Bayes Text Classification
To classify text documents into predefined categories based on the statistical probability of the words they contain.
- 1
Gather a training set of documents pre-classified into categories (e.g., 'app' vs. 'other').
- 2
Pre-process the text by converting to lowercase, removing punctuation, and splitting into individual words (tokens).
- 3
For each class, create a frequency table of every token.
- 4
Apply additive (Laplace) smoothing by adding 1 to every token count to handle words not seen in the training data.
- 5
Calculate the conditional probability p(word|class) for every word in the vocabulary.
- 6
For a new document, calculate a score for each class by summing the natural logarithm of the probabilities of its words: `Score(class) = Σ ln(p(word|class))`.
- 7
Assign the document to the class with the highest score.
Process 34 · named in the source
Building a Linear Program for Blending
To find the best possible outcome in a mathematical model whose requirements are represented by linear relationships.
- 1
Define the objective function (e.g., minimize total cost) as a linear combination of decision variables.
- 2
Define the decision variables (e.g., quantity of juice to buy from each supplier each month).
- 3
Formulate constraints as linear equations or inequalities (e.g., total volume must meet demand, quality metrics must be within bounds, supplier capacity cannot be exceeded).
- 4
Build the model in a spreadsheet, with cells for decisions, an objective function cell, and cells calculating the left-hand side of each constraint.
- 5
Open Solver, set the objective cell to be minimized/maximized by changing the decision variable cells.
- 6
Add each constraint to Solver, linking the calculated constraint cells to their limits.
- 7
Select the 'Simplex LP' solving method and solve the model.
- 8
Analyze the resulting optimal decision values and the value of the objective function.
Process 35 · named in the source
Ensemble Modeling with Bagged Decision Stumps
To improve prediction accuracy by creating a multitude of simple models (weak learners) and having them vote on the outcome.
- 1
Start with a training dataset of features and outcomes.
- 2
Repeat for a large number of iterations (e.g., 200 times):
- 3
a. Create a random subsample of the data by shuffling and selecting a subset of rows and columns (e.g., 2/3 of rows, sqrt(columns)).
- 4
b. For each feature in the subsample, build a 'decision stump' (a one-level decision tree).
- 5
c. For each stump, calculate its impurity (e.g., Gini impurity) to measure its classification power.
- 6
d. Identify the 'best' stump for this subsample (the one with the lowest impurity).
- 7
e. Record the winning feature and its predictive value.
- 8
To make a prediction on a new data point, have each of the 200 recorded stumps 'vote' (1 if it predicts the outcome, 0 if not).
- 9
The final prediction score is the average of all votes (the percentage of stumps that voted for the outcome).
Process 36 · named in the source
Data Warehouse Implementation
To create a robust and effective data warehouse system for data analysis and decision-making.
- 1
Conduct a requirement analysis with stakeholders to define scope and objectives.
- 2
Design the data model (e.g., star schema) based on requirements.
- 3
Implement the ETL process to extract, transform, and load data from source systems.
- 4
Design and create the data warehouse database infrastructure.
- 5
Integrate and consolidate data from multiple sources, ensuring quality and consistency.
- 6
Implement metadata management to document data definitions and lineage.
- 7
Deploy analytical capabilities and tools (e.g., OLAP, reporting tools).
- 8
Conduct user training and provide ongoing support to drive adoption.
- 9
Perform ongoing maintenance, monitoring, and performance optimization.
Process 37 · named in the source
Knowledge Discovery in Databases (KDD)
To transform low-level data into shorter, abstract, and more practical forms of knowledge, such as predictive models or clear reports.
- 1
Understand the application domain and define the goals of the process.
- 2
Create a target dataset by selecting relevant data.
- 3
Perform data cleaning, reduction, and projection to preprocess the data.
- 4
Apply data mining techniques and algorithms to find patterns.
- 5
Consolidate the discovered knowledge using visualization and interpretation.
- 6
Evaluate the obtained models using metrics like predictive accuracy.
Process 38 · named in the source
Association Rule Mining
To identify recurring patterns, correlations, or associations, such as items frequently purchased together in market basket analysis.
- 1
Generate frequent itemsets by finding all collections of items with support above a specified minimum threshold.
- 2
Generate association rules from the frequent itemsets by calculating their confidence values.
- 3
Prune and filter redundant or uninteresting rules using additional metrics like lift.
Process 39 · named in the source
Automatic Leader Failover
To promote a follower to become the new leader so the system can continue accepting writes.
- 1
Determine the leader has failed, typically using timeouts on heartbeats.
- 2
Choose a new leader, often via an election among remaining replicas or appointment by a controller node.
- 3
Reconfigure client and follower nodes to send writes and fetch replication logs from the new leader.
- 4
Ensure the old leader, if it recovers, becomes a follower and recognizes the new leader's authority.
Process 40 · named in the source
Setting Up a New Follower
To bring a new node online with an accurate copy of the database and have it start replicating from the leader.
- 1
Take a consistent snapshot of the leader's database, noting the log position (LSN/binlog coordinates).
- 2
Copy this snapshot to the new follower node.
- 3
Connect the follower to the leader.
- 4
Request the replication log for all data changes that occurred since the snapshot was taken.
- 5
Apply the backlog of changes until the follower is fully caught up with the leader.
- 6
Continue processing the stream of new data changes from the leader as they happen.
Process 41 · named in the source
SSTable Compaction and Merging
To combine smaller, newer log segments into larger ones, reclaiming disk space by discarding overwritten and deleted values.
- 1
Open several sorted segment files (SSTables) for reading.
- 2
Read the files side-by-side, in a mergesort-like fashion.
- 3
Compare the first key in each input file.
- 4
Copy the lowest key to a new, merged output segment file.
- 5
If the same key appears in multiple input segments, keep the value from the most recent segment and discard older ones.
- 6
Repeat until all input files have been processed.
- 7
Atomically switch read requests to use the new merged segment and delete the old segment files.
Process 42 · named in the source
Two-Phase Commit (2PC) for Distributed Transactions
To ensure that the transaction commits on all nodes or aborts on all nodes, preserving atomicity.
- 1
Send a 'prepare' request from the coordinator to all participant nodes.
- 2
Wait for participants to vote 'yes' or 'no'. A 'yes' vote is a promise to commit if asked, and the participant must make the transaction's writes durable before voting.
- 3
If all participants vote 'yes', decide to 'commit'. If any participant votes 'no' or times out, decide to 'abort'.
- 4
Durably write the commit/abort decision to the coordinator's transaction log.
- 5
Send the decision to all participants, retrying forever until every participant acknowledges it.
Process 43 · named in the source
Partition Rebalancing (Adding a Node)
To move some partitions from existing nodes to the new node to distribute load evenly.
- 1
Tell the new node to steal partitions from existing nodes until load is balanced.
- 2
Copy the data for a partition from the current node to the new node over the network.
- 3
Continue serving read and write requests using the old partition assignment while the data transfer is in progress.
- 4
Once the data transfer is complete, atomically switch routing so that new requests for the moved partition go to the new node.
- 5
Delete the partition data from the old node.
Process 44 · named in the source
End-to-End Machine Learning Project Workflow
To provide a systematic and reproducible methodology for creating and managing a machine learning application.
- 1
Frame the problem and look at the big picture (define business objective, usage, performance metrics).
- 2
Get the data (list, find, check space/legality, authorize, create workspace, convert, anonymize).
- 3
Create a test set and set it aside to prevent data snooping.
- 4
Explore the data to gain insights (study attributes, visualize, find correlations).
- 5
Prepare the data for ML algorithms (data cleaning, feature engineering, feature scaling).
- 6
Shortlist and train many quick-and-dirty models from different categories.
- 7
Fine-tune the top 3-5 most promising models using techniques like cross-validation and automated hyperparameter search.
- 8
Combine the best models into a great solution using ensemble methods.
- 9
Present the solution, highlighting the business value and learnings.
- 10
Launch, monitor, and maintain the system in production.
Process 45 · named in the source
Hyperparameter Tuning with Cross-Validation
To systematically find the best combination of hyperparameter values for a given model to optimize its performance.
- 1
Define the hyperparameter space to search (e.g., a grid of values for `GridSearchCV` or a distribution for `RandomizedSearchCV`).
- 2
Instantiate the search object (e.g., `GridSearchCV`) with the model, parameter grid, cross-validation folds, and scoring metric.
- 3
Run the search by calling the `fit()` method on the training data.
- 4
Retrieve the best hyperparameter combination from the search object's `best_params_` attribute.
- 5
Retrain the model on the full training set using these optimal hyperparameters (this is done automatically if `refit=True`).
- 6
Evaluate the final model on the test set.
Process 46 · named in the source
Transfer Learning for Deep Neural Networks
To leverage knowledge from a model trained on a large, related task to improve performance and reduce training time on the target task.
- 1
Select and load a pretrained model (e.g., Xception trained on ImageNet) without its top layers (`include_top=False`).
- 2
Freeze the weights of all layers in the base pretrained model to prevent them from being modified during initial training.
- 3
Add new custom layers on top of the base model, including a final output layer suited for the new task (e.g., a Dense layer with softmax for classification).
- 4
Compile the new model and train it for a few epochs, which only trains the new top layers.
- 5
Unfreeze all or some of the base model's layers.
- 6
Re-compile the model, this time with a much smaller learning rate.
- 7
Continue training to fine-tune the entire network on the new task.
Process 47 · named in the source
Building a Regression Tree
To partition the feature space into a set of simple rectangular regions and fit a constant model (the mean) in each one, creating an interpretable, tree-like model for prediction.
- 1
Use recursive binary splitting to grow a large tree (T0) on the training data, stopping when nodes have a minimum number of observations.
- 2
Apply cost complexity pruning to T0 to obtain a sequence of best subtrees as a function of a tuning parameter α.
- 3
Use K-fold cross-validation to select the optimal value of α that minimizes the average prediction error.
- 4
Return the subtree corresponding to the chosen value of α.
Process 48 · named in the source
Holm's Step-Down Procedure
To control the Family-Wise Error Rate (FWER), the probability of making at least one Type I error, while being more powerful than the Bonferroni method.
- 1
Specify the desired FWER control level, α.
- 2
Compute p-values for all m null hypotheses.
- 3
Order the p-values from smallest to largest: p(1) ≤ p(2) ≤ ... ≤ p(m).
- 4
Find the largest index j (denoted L) for which p(j) > α / (m + 1 - j).
- 5
Reject all null hypotheses H0j for which pj < p(L).
Process 49 · named in the source
Data Science Project Lifecycle
To provide a structured, repeatable flow for solving business problems with data and analytics.
- 1
Understand the question by working with business departments to define project goals, feasibility, and planned actions.
- 2
Collect the relevant data from multiple internal and external sources.
- 3
Explore the data to find anomalies, assess quality, and perform transformations.
- 4
Model the data by training, validating, and testing multiple algorithms to find the best solution.
- 5
Provide an answer by communicating results, deploying the model, and enabling business decisions.
Process 50 · named in the source
K-means Clustering Algorithm
To partition a dataset into 'k' distinct, non-overlapping clusters where each observation belongs to the cluster with the nearest mean.
- 1
Choose 'k' initial means as starting 'seed' values for the cluster centers.
- 2
Assign each observation to the cluster center with the shortest Euclidean distance.
- 3
Compute a new mean for each cluster based on the observations assigned to it.
- 4
Repeat the assignment and computation steps until the k means stabilize (no more reassignments occur).
Process 51 · named in the source
Gradient Boosting Modeling
To create a highly accurate predictive model by sequentially fitting a series of weak learners (typically decision trees), where each new tree corrects the errors of the previous ones.
- 1
Start with an initial decision tree and generate the residuals (errors).
- 2
Fit a new decision tree on the residuals from the previous step.
- 3
Compute the accuracy of the new tree and adjust subsequent trees to accommodate its inaccuracies.
- 4
Repeat the process for a specified number of iterations.
- 5
Combine the predictions of all trees in a weighted linear combination to form the final model.
Process 52 · named in the source
Model Operationalization (ModelOps)
To move analytical models from development to production quickly and reliably, while ensuring quality, scalability, and continuous monitoring.
- 1
Register champion and challenger models in a central repository.
- 2
Publish the model's score code to the production environment where it will run.
- 3
Deploy the model to score data, either in batch or real-time.
- 4
Continuously monitor model performance using statistical and business metrics to detect degradation.
- 5
Retrain or replace the model with a challenger when its performance decays significantly.
Process 53 · named in the source
The Six-Step Hypothesis Testing Procedure
To provide a logical, repeatable framework for deciding whether to reject a null hypothesis, thereby learning from data in a structured manner.
- 1
Check the assumptions of the statistical procedure to ensure the test is valid for the given data and sampling method.
- 2
Generate a specific null hypothesis (H0) and a general alternative hypothesis (H1) that are mutually exclusive.
- 3
Identify the appropriate test statistic and its sampling distribution under the assumption that H0 is true.
- 4
Set a significance level (α) and formulate a decision rule that specifies the rejection region for the test statistic.
- 5
Collect a random sample from the population and compute the value of the test statistic.
- 6
Apply the decision rule to the computed test statistic to either reject or fail to reject H0, and draw conclusions about the population.
Process 54 · named in the source
Constructing a Grouped Frequency Distribution
To organize and summarize a large or wide-ranging set of scores into a more interpretable format without significant distortion of the data's characteristics.
- 1
Compute the range of the scores by subtracting the lowest score from the highest score.
- 2
Determine a convenient class interval width by dividing the range by 8 and 15 and choosing a convenient number between the two resulting values.
- 3
Select a convenient starting value for the first interval, typically at or just below the lowest score, often rounding down to a multiple of the interval width.
- 4
Construct a series of contiguous class intervals of the chosen width, starting from the selected value.
- 5
Count the number (frequency) of scores that fall into each class interval.
Process 55 · named in the source
Constructing a Confidence Interval for a Population Mean (σ Known)
To provide a range of plausible values for the population mean, along with a specified probability (confidence level) that the range contains the true mean.
- 1
Check that assumptions are met (e.g., normally distributed population or large sample, σ is known, random sample).
- 2
Set a confidence level (e.g., 95%), which determines the value of α (e.g., .05).
- 3
Obtain a random sample from the population and calculate the sample mean (M).
- 4
Construct the confidence interval using the formula: M ± z(α/2) * σM, where σM = σ/√n.
- 5
Interpret the interval as having a (1-α) probability of including the true population mean.
Process 56 · named in the source
The Data Science Process (Process of Machine Learning)
To provide a structured, step-by-step roadmap for taking a project from an initial business problem to a deployed production solution.
- 1
Understand the problem domain and project goals with the help of domain experts.
- 2
Acquire the necessary data set from various sources like data warehouses, production systems, or social media.
- 3
Mung the data to clean and transform it into a form suitable for machine learning.
- 4
Use exploratory data analysis (EDA) to discover patterns and characteristics in the data.
- 5
Perform feature engineering to determine the optimal variables for the model.
- 6
Select an appropriate machine learning model and split the data into training, validation, and test sets.
- 7
Validate the model to evaluate its performance, generalization, and bias-variance tradeoff.
- 8
Visualize the data to effectively communicate the results of the algorithm.
- 9
Communicate the results as a 'data storyteller' to organizational decision-makers.
- 10
Deploy the machine learning solution into a production environment.
Process 57 · named in the source
Scientific Method Applied to Data Science
To illustrate how the core principles of the scientific method are applied in day-to-day data science work.
- 1
Formulate a question about a specific observation and find relevant data sets.
- 2
Come up with a hypothesis, which is a conjecture that may explain the observed behavior.
- 3
Make a prediction by determining the logical consequences of the hypothesis, which involves selecting and training a machine learning algorithm.
- 4
Conduct testing by using a held-out data set to see if the real world behaves as predicted by the hypothesis.
- 5
Perform analysis to determine what the results of the experiment show and decide on the next actions, potentially iterating the process.
Process 58 · named in the source
Hierarchical Clustering Algorithm
To group data points into clusters using an agglomerative (bottom-up) approach.
- 1
Compute the distance between every pair of points/clusters using a defined distance metric (e.g., Euclidean distance).
- 2
Merge the two closest points/pairs into a new, single cluster (a 'super observation').
- 3
Repeat the process of computing distances and merging the closest pair, treating merged clusters as single points.
- 4
Continue until only one large cluster containing all original points remains.
- 5
Visualize the result as a dendrogram and use `cutree()` to cut the tree at a chosen height to define the final clusters.
Process 59 · named in the source
Breadth-First Search (BFS)
To systematically explore a network and calculate the minimum number of edges in a path from a start node to all other nodes.
- 1
Declare the starting node to be at distance 0, forming the first layer.
- 2
Find all neighbors of nodes in the first layer that have not yet been discovered; these form the second layer, at distance 1.
- 3
Continue this process, forming layer `i+1` from all undiscovered neighbors of nodes in layer `i`.
- 4
Stop when no new nodes can be discovered.
Process 60 · named in the source
Girvan-Newman Method for Graph Partitioning
To decompose a network into its constituent communities by progressively removing the edges that are most 'between' them.
- 1
Calculate the 'betweenness' of every edge in the graph, which measures how many shortest paths pass through it.
- 2
Remove the edge (or edges) with the highest betweenness.
- 3
Recalculate the betweenness for all remaining edges.
- 4
Repeat the removal and recalculation steps until the desired number of components is achieved or no edges remain.
Process 61 · named in the source
Bipartite Graph Auction for Market-Clearing Prices
To find a set of prices for the items that clears the market, meaning there is a perfect matching of buyers to their preferred items.
- 1
Start with all sellers setting their prices to 0.
- 2
Construct the 'preferred-seller graph' where each buyer has an edge to the seller(s) offering them the highest payoff (valuation minus price).
- 3
Check if a perfect matching exists. If so, stop; the current prices are market-clearing.
- 4
If no perfect matching exists, find a constricted set of buyers S (a group of buyers who collectively prefer a smaller set of sellers N(S)).
- 5
Have every seller in N(S) raise their price by one unit.
- 6
Repeat the process from step 2.
Process 63 · named in the source
Bootstrap Resampling for a Statistic
To quantify the sampling variability of an estimate without relying on theoretical distributions.
- 1
Create a 'box' containing all observed data points.
- 2
Draw one data point at random, record it, and replace it in the box.
- 3
Repeat the draw-with-replacement step n times, where n is the size of the original sample, to create one 'bootstrap resample'.
- 4
Calculate and record the desired statistic (e.g., mean) for this bootstrap resample.
- 5
Repeat the resampling and calculation process a large number of times (e.g., 1,000).
- 6
Use the distribution of the 1,000 calculated statistics to estimate the standard error (by taking its standard deviation) or a confidence interval (by finding the percentiles).
Process 64 · named in the source
Permutation Test for an A/B Test
To test the null hypothesis that the observed difference is due to random chance.
- 1
Combine the results from all groups (e.g., group A and B) into a single large dataset.
- 2
Shuffle the combined dataset to randomize the group assignments.
- 3
Randomly draw (without replacement) a resample of the same size as the original group A.
- 4
Assign the remaining data to a resample of the same size as the original group B.
- 5
Calculate the statistic of interest (e.g., difference in means) for the newly created resamples and record it.
- 6
Repeat the shuffling and calculation process a large number of times (e.g., 1,000) to create a permutation distribution.
- 7
Compare the originally observed statistic to the permutation distribution to calculate the p-value (the proportion of permuted results as extreme or more extreme than the observed result).
Process 65 · named in the source
k-Fold Cross-Validation
To get a more robust estimate of model performance and prevent overfitting, compared to a single train/test split.
- 1
Divide the dataset into 'k' equally sized, non-overlapping subsets or 'folds'.
- 2
Set aside one fold as the holdout (validation) set.
- 3
Train the predictive model on the remaining k-1 folds.
- 4
Apply the trained model to the holdout fold and record the performance metric (e.g., RMSE, accuracy).
- 5
Repeat this process k times, with each fold serving as the holdout set exactly once.
- 6
Average the performance metrics from the k iterations to get the final cross-validated performance estimate.
Process 66 · named in the source
General Data Wrangling Workflow
To clean, transform, combine, and reshape data into a tidy, structured format suitable for analysis.
- 1
Load data from a source (e.g., CSV, database, API) into a pandas DataFrame using functions like `pd.read_csv`.
- 2
Inspect the data using `.info()`, `.describe()`, `.head()` to understand its structure, types, and identify initial issues.
- 3
Handle missing data by either filtering it out using `.dropna()` or filling it in with appropriate values using `.fillna()`.
- 4
Identify and remove duplicate data using `.duplicated()` and `.drop_duplicates()`.
- 5
Transform data by applying functions or mappings using `.map()`, `.apply()`, or vectorized operations.
- 6
Combine datasets from different sources using database-style joins (`.merge()`) or concatenation (`pd.concat()`).
- 7
Reshape the data's layout using `pivot_table()`, `stack()`, or `unstack()` to convert between long and wide formats.
Process 67 · named in the source
Data Science Workflow
To turn raw data into understanding, insight, and knowledge in a systematic way.
- 1
Import data into R from a file, database, or web API.
- 2
Tidy the data by storing it in a consistent form where each column is a variable and each row is an observation.
- 3
Transform the data by narrowing in on observations of interest, creating new variables, and calculating summary statistics.
- 4
Generate knowledge by iterating between visualization to find unexpected patterns and modeling to make patterns precise.
- 5
Communicate your results to others, as understanding is useless unless it can be shared.
Process 68 · named in the source
Exploratory Data Analysis (EDA) Cycle
To generate many promising leads and a deep understanding of your data by using questions to guide investigation.
- 1
Generate questions about your data, such as what type of variation occurs within variables and what type of covariation occurs between them.
- 2
Search for answers by visualizing, transforming, and modeling your data.
- 3
Use what you learn to refine your questions and/or generate new questions, repeating the cycle.
Process 69 · named in the source
Getting Help and Creating a Reproducible Example
To efficiently find a solution to a problem and make it easy for others to help.
- 1
Start by searching Google for the error message or problem description, adding 'R' to the query.
- 2
If Google is not helpful, search Stack Overflow for an existing answer.
- 3
If no answer is found, prepare a minimal reproducible example (reprex).
- 4
Include required packages, data (using `dput()`), and the minimal code that reproduces the problem in your reprex.
- 5
Post the reprex to a forum like Stack Overflow to ask for help.
Process 70 · named in the source
BI Agile Development using Scrum
To deliver valuable BI capabilities to the business quickly and iteratively, while remaining flexible to changing requirements.
- 1
The Product Owner (a business leader) defines a prioritized list of desired capabilities in the 'Product Backlog'.
- 2
The team plans a 'Sprint,' a short, time-boxed period (e.g., 2-4 weeks) to deliver a small set of the highest-priority capabilities.
- 3
Hold daily 'Scrum' meetings where the team discusses progress and removes impediments.
- 4
Collaborate in a 'war room' or co-located space to rapidly prototype, build, and test the BI components (e.g., reports, dashboard widgets).
- 5
Demonstrate the working software to the Product Owner at the end of the sprint for feedback and approval.
- 6
Hold a sprint retrospective to discuss what went well and what can be improved.
- 7
Repeat the cycle with the next set of priorities from the backlog.
Process 71 · named in the source
Four-Step Dimensional Design Process
To provide a structured, repeatable approach to creating a dimensional model that is business-driven and technically sound.
- 1
Select the business process to be modeled, corresponding to a source of measurement data like orders or invoices.
- 2
Declare the grain, which is a precise statement of what a single fact table row represents (e.g., 'an individual line item on an order').
- 3
Identify the dimensions that describe the 'who, what, where, when, why, and how' context for the measurement event, ensuring each dimension is single-valued at the declared grain.
- 4
Identify the numeric, measurable facts that are true to the declared grain.
Process 72 · named in the source
Handling a Type 2 Slowly Changing Dimension (SCD) Update
To accurately preserve the history of dimension attributes by creating a new version of the dimension member, partitioning fact history without changing old fact rows.
- 1
Detect a change in a source attribute designated as Type 2 (e.g., a customer's address).
- 2
Locate the currently active row for that dimension member (e.g., using the natural key).
- 3
Update the 'Row Expiration Date' and 'Current Row Indicator' on the current row to mark it as expired.
- 4
Insert a new row into the dimension table for the same member.
- 5
Generate a new, unique surrogate key and assign it as the primary key of the new row.
- 6
Populate the new row with the updated attribute value(s) and set its 'Row Effective Date' and a far-future 'Row Expiration Date'.
Process 73 · named in the source
Kimball DW/BI Lifecycle Project
To provide a roadmap for planning, designing, developing, and deploying a DW/BI system in a structured, business-focused, and iterative manner.
- 1
Plan the program and project, assessing readiness, defining scope, and securing sponsorship.
- 2
Define the business requirements through interviews and workshops with stakeholders.
- 3
Execute three parallel design and development tracks: Technology (architecture, product selection), Data (dimensional modeling, physical design, ETL), and BI Applications (reporting, analytics).
- 4
Deploy the system, including data, tools, and applications, along with user training and support.
- 5
Manage ongoing maintenance and growth of the system.
- 6
Initiate the next iteration of the lifecycle for a new business process.
What's underneath
What the field takes for granted
Every field runs on assumptions it rarely says out loud — the beliefs its advice quietly depends on. We surface the load-bearing ones, where they hide, and when they break. Most guides never tell you this.
Placing the idea
How it compares — and where else it applies
We don't just explain the idea in isolation. We place it: against the alternative it replaces, and beyond the domain it was born in. That's the difference between knowing a method and knowing when to reach for it.
How it compares
vs The authors' previous book, 'Competing on Analytics'
Both books argue for the strategic importance of analytics and fact-based decision-making.Both use many of the same companies as examples of analytical leaders (e.g., Harrah's, Capital One, Progressive).Both utilize the five-stage model of analytical maturity.
'Competing on Analytics' focused on the 'what' and 'why'—describing firms that build their entire strategy around analytics.'Analytics at Work' is a 'how-to' book focused on implementation for a broader audience of companies that simply want to become *more* analytical, not necessarily full competitors.'Analytics at Work' is more structured, introducing the DELTA framework as a memorable, actionable model ('a compass rather than a detailed map').'Analytics at Work' provides more granular guidance on building specific capabilities like managing data, organizing analysts, and sustaining momentum.
This book is a practical implementation guide designed for all managers, not just senior strategists. It provides frameworks (DELTA), assessment tools (maturity model stages), and pragmatic suggestions for making an organization more analytical one decision at a time.
vs Traditional Sampling-Based Analysis ('Small Data')
Both approaches use data to gain insights about the world and make decisions. Both rely on statistical principles to interpret information.
Big data uses 'N=all' (the entire dataset) while small data uses a sample. Big data embraces messiness and imprecision, while sampling requires cleanliness and exactitude. Big data prioritizes correlation, while small data analysis often searched for causation within a hypothesis.
This book champions the paradigm shift from the small data world to the big data one, arguing that the quantitative change in data volume has led to a qualitative change in how we should approach analysis.
vs Hypothesis-Driven Scientific Method
Both are methodologies for understanding the world and making discoveries.
The traditional method starts with a hypothesis, then collects data to test it. The big data approach can start with the data itself, discovering unexpected correlations without a pre-defined hypothesis ('data-driven discovery').
The book argues that while the scientific method is not obsolete (challenging Chris Anderson's 'end of theory' claim), big data's correlational, data-driven approach is a powerful, efficient, and often superior alternative for many questions.
vs Small Data
Both are forms of data used for analysis to gain insights. Early historical examples of data collection, like Thucydides' counting of bricks, share the goal of using data to solve a problem, even if the scale is small.
Small data, as exemplified by the work of R.A. Fisher, is typically small in volume, highly structured, and collected through carefully designed experiments or surveys to answer a specific question. Big data is characterized by massive volume, variety (often unstructured), and velocity, and is often collected without a specific question in mind. Small data uses traditional statistical methods on samples, while big data uses new algorithmic techniques (like machine learning) often on the entire population (N=all).
The book uses this comparison centrally to define big data, positioning it not just as 'more data' but as a fundamentally different paradigm that requires new tools, techniques, and a different mindset regarding concepts like veracity and correlation.
vs ACID vs. BASE Database Models
Both are sets of properties that describe the guarantees provided by a database system during transactions.
ACID (Atomicity, Consistency, Isolation, Durability) is the model for traditional relational databases (RDBMS), prioritizing strong consistency and reliability. BASE (Basically Available, Soft state, Eventually consistent) is the model for many NoSQL databases. It sacrifices immediate consistency in favor of high availability and scalability, which is essential for distributed big data systems where network partitions are inevitable (as per the CAP theorem).
The book explains this technical trade-off as a core reason why new database technologies (NoSQL) were necessary for the big data era, showing that the shift was driven by fundamental architectural needs.
vs Snowden's Leaks vs. WikiLeaks' Publications
Both involve the unauthorized mass disclosure of classified or secret documents to the public, driven by a stated goal of transparency and exposing wrongdoing.
Snowden curated his leaks by giving the documents to trusted journalists who then worked with government officials to redact information that could pose a direct threat to national security before publication. WikiLeaks, particularly in later years, has been criticized for publishing vast, unredacted dumps of data with little curation, potentially exposing personal information of innocent individuals.
The book draws this contrast to explore the ethics of whistleblowing in the digital age, highlighting the difference between curated disclosure aimed at specific policy debates versus indiscriminate data dumps.
vs Big Data Analytics vs. Traditional Scientific Method
Both seek to generate new knowledge about the world.
The traditional scientific method starts with a human-formulated hypothesis, which is then tested with carefully collected data. Big data analytics often inverts this: the machine finds patterns and correlations in massive, pre-existing datasets, and these findings may or may not be guided by a prior hypothesis. The book argues this is a 'paradigm shift.'
The book frames this as a central tension, celebrating the power of machine-driven discovery while cautioning that abandoning the hypothesis-driven model entirely can lead to finding meaningless, spurious correlations.
vs Kimball's Enterprise Data Bus Architecture
Both aim to provide a structured approach to BI. Both ultimately use data marts and dimensional models for end-user analysis.
Inmon's proposed Corporate Information Factory (CIF) is a top-down, centralized approach with a normalized (3NF) EDW at the core acting as the single source of integrated data. Kimball's approach is a bottom-up, decentralized approach focused on conformed dimensions and facts across business-process-oriented data marts, potentially without a central EDW.
The book recommends a hybrid model, the Analytical Data Architecture (ADA), which is a hub-and-spoke model leveraging the best of both. It uses a central EDW (like Inmon) but designs it with a hybrid dimensional-normalized model and uses conformed dimensions for the spokes (like Kimball).
vs Entity-Relationship (ER) Modeling
Both are logical data design techniques that use entities/tables, attributes/columns, and relationships to represent business data.
ER modeling is optimized for transactional systems (OLTP) and prioritizes normalization to reduce data redundancy, resulting in many complex tables. Dimensional modeling is optimized for analytical systems (BI/OLAP) and prioritizes understandability and query performance, using denormalized dimensions and centralized facts in a star schema.
The book positions ER modeling as appropriate for source systems and the foundational analysis of them, but strongly advocates for dimensional modeling as the standard for all BI-facing data stores, including data marts and the BI-facing schemas of the EDW.
vs Agile Project Methodology
Both waterfall and agile are structured approaches to software development. The book's recommended hybrid approach incorporates the iterative, feedback-driven nature of agile.
Waterfall is a sequential, top-down approach where requirements and design are finalized before development begins. Agile uses short, iterative cycles ('sprints') where requirements evolve and cross-functional teams build and test features incrementally.
The book argues that a pure waterfall is too rigid for BI projects (due to uncertain requirements) and pure agile is insufficient for the architectural needs of an enterprise system. It proposes a hybrid: a waterfall approach for the overall project framework and architecture, with agile-style iterative development for building the individual BI application components.
vs Manual Coding for Data Integration
Both tool-based development and manual coding (e.g., with SQL scripts) can be used to move data from source to target systems.
Tool-based approaches provide pre-built functionality for common DI tasks (SCDs, error handling), are self-documenting, support data governance through metadata, and improve developer productivity in the long run. Manual coding is often perceived as faster for simple tasks and has no initial software cost, but it leads to undocumented, unmanageable, and inconsistent processes.
The book strongly advocates for tool-based data integration as a best practice, arguing that the long-term TCO is lower and the resulting processes are more robust, manageable, and consistent. It frames hand-coding as a key cause of data silos and integration chaos.
vs Practical 'How-To' Guides and Cookbooks
Both this book and practical guides discuss BI & Big Data tools and technologies like Hadoop, OLAP, and data mining techniques.
This book focuses on the 'what' and 'why,' providing a theoretical and conceptual overview with extensive literature citations. A how-to guide focuses on the 'how,' providing specific code examples and hands-on implementation steps.
Its primary distinction is its academic synthesis of management theory (RBV, Dynamic Capabilities), maturity models, and technological concepts into a cohesive framework for understanding the field's strategic implications.
vs Focused Research Monographs (e.g., on a single algorithm)
Both may discuss specific analytical techniques such as neural networks or genetic algorithms.
This book provides a broad survey of dozens of techniques and models, giving a high-level summary of each. In contrast, a research monograph would provide a deep, mathematical, and experimental dive into a single technique or a narrow problem domain.
The book's strength is its breadth, offering a comprehensive compendium of the entire BI&BD landscape, from management theory to a catalog of tools and industry application areas, making it a suitable university textbook or executive overview.
vs Narrative-driven case study books on analytics (e.g., 'Moneyball')
Both champion the power of data-driven decisions over traditional intuition and use compelling stories of organizations that gained a competitive advantage through analytics.
While books like 'Moneyball' are deep-dive narratives into a single context (like baseball), this book provides a broad, cross-industry survey and a generalized business framework.
It abstracts the principles from the stories to create a replicable roadmap (the five stages, DELTA model) for business leaders, making analytics a manageable and strategic business imperative rather than just an interesting tale.
vs Traditional Decision Support Systems (DSS) and Business Intelligence (BI)
Both approaches use data, computer systems, and quantitative analysis to support and inform business decisions. Both can involve activities like reporting, querying, and creating visualizations.
Traditional DSS/BI is often tactical, siloed within a department, back-office oriented, and focused on descriptive analytics ('what happened?'). 'Competing on Analytics' elevates analytics to be strategic, enterprise-wide, championed by the CEO, and focused on building a distinctive competitive capability. It emphasizes predictive and prescriptive analytics ('what will happen?' and 'what should we do?').
This book was the first to frame analytics not merely as a decision support tool, but as a central, strategic basis for corporate competition. It shifted the focus from generating reports to creating a sustained competitive advantage through a deeply ingrained, enterprise-wide analytical culture and capability.
vs Explanatory Modeling (Classical Statistics)
Both use data to fit models (e.g., linear regression).Both involve estimating coefficients and assessing model validity.
**Goal**: Explanatory modeling seeks to quantify average effects and understand 'why'. Predictive modeling seeks to accurately predict outcomes for new, individual records.**Data Usage**: Explanatory modeling uses the entire dataset to get the best fit. Predictive modeling partitions data into training and validation sets to assess performance on unseen data.**Focus**: Explanatory modeling focuses on coefficients (the betas) and their statistical significance. Predictive modeling focuses on the predictions (the y-hats).**Evaluation**: Explanatory models are judged by goodness-of-fit stats (e.g., R-squared, p-values). Predictive models are judged by predictive accuracy metrics on a validation set (e.g., RMSE, classification accuracy, lift).
This book explicitly defines and distinguishes the two approaches, and its primary focus is on the methods and evaluation criteria for predictive modeling.
vs Statistics vs. Machine Learning
Both fields contribute methods for exploring data and building models.Both use mathematical principles to extract insights from data.
**Focus**: The book characterizes classical statistics as focusing on inference from a sample to a population regarding an 'average effect'. Machine learning is framed as focusing on predicting outcomes for individual records and learning local patterns.**Data/Compute Environment**: Statistics is described as coming from a history where data and computing power were scarce. Machine learning is presented as thriving in an environment where both are plentiful.**Inference**: Statistical inference (e.g., determining if a result could be due to chance) is central to statistics but is largely absent from data mining, which instead focuses on mitigating overfitting through validation.
The book situates data mining at the confluence of these two fields, quoting Daryl Pregibon's description of it as 'statistics at scale and speed,' but clearly adopts the machine learning emphasis on predictive performance.
vs Association Rules vs. Collaborative Filtering
Both are unsupervised methods used for discovering relationships between items.Both are commonly used for generating recommendations in marketing and e-commerce.
**Goal**: Association rules find general, population-wide rules (e.g., 'IF beer THEN diapers'). Collaborative filtering generates personalized recommendations based on similar users' tastes.**Data Level**: Association rules operate on transaction-level data ('baskets'). Collaborative filtering operates on user-level data (a user's entire purchase/rating history).**Data Type**: Association rules primarily use binary purchase data. Collaborative filtering can use either binary data or numerical ratings.**Scope**: Association rules can discover multi-item recommendations (e.g., recommend cookies AND cornflakes with milk). Collaborative filtering typically recommends single items that are popular among similar users.
The book clearly distinguishes the two methods, highlighting their different data requirements and the crucial difference between generic, population-level rules and personalized, user-specific recommendations.
vs Decision Trees vs. Linear Models (e.g., Logistic Regression)
Both are supervised learning methods used for classification and regression.Both partition the instance space into regions corresponding to different predicted values.The performance of both can be evaluated using the same metrics and tools like ROC curves and profit curves.Both are susceptible to overfitting and benefit from complexity control.
Decision trees create decision boundaries that are 'axis-parallel' (testing one feature at a time), while linear models create a single linear boundary (hyperplane) that can be of any orientation.Decision trees are 'piecewise' models, recursively partitioning regions into smaller sub-regions. Linear models are 'global,' applying a single function across the entire instance space.Linear models learn explicit weights for each feature, providing one form of feature importance. Trees select features at each node, providing a different perspective on importance.Decision trees (if small) are often considered more intelligible to non-technical audiences, whereas linear models are more intelligible to audiences with a statistical background.
The book presents both as different instances of 'supervised segmentation,' focusing on the conceptual difference in how they partition the instance space rather than just discussing their underlying algorithms. It uses this comparison to highlight the trade-offs between model flexibility and intelligibility.
vs Generative vs. Discriminative Models
Both are families of supervised learning methods used for classification and class probability estimation.Both use features of an instance to make a prediction about its target variable.Both ultimately can produce a probability estimate p(c|E) for a class 'c' given evidence 'E'.
Discriminative models (like Decision Trees, SVMs, Logistic Regression) directly model the decision boundary between classes. They try to learn a function that maps inputs directly to a class label or probability.Generative models (like Naive Bayes) model the underlying probability distributions of the data. They try to learn how each class would 'generate' the data/evidence, i.e., p(E|c). They then use Bayes' rule to invert this to find p(c|E).Generative models often make strong independence assumptions about features (e.g., conditional independence in Naive Bayes) to make modeling p(E|c) tractable. Discriminative models may be better at handling complex feature interactions.Generative models can more naturally handle missing data or generate new synthetic data points.
The book explains this fundamental distinction by framing the approaches as asking different questions: Discriminative models ask 'What is the best way to distinguish between classes?' while Generative models ask 'Which class most likely generated this data?' This conceptual framing makes the difference clear without getting lost in deep probabilistic theory.
vs Clustering vs. Classification
Both techniques result in the grouping of instances.Both rely on a notion of similarity between instances in a feature space.The resulting groups (clusters or classes) can be described by their common characteristics.
Classification is a supervised task; it requires a pre-defined target variable with labeled training data. The goal is to build a model to predict this target for new instances.Clustering is an unsupervised task; there is no target variable. The goal is to find 'natural' groupings of instances based on their similarity, without a specific purpose defined in advance.The output of classification is a model that can assign a class to an unseen instance. The output of clustering is the set of groupings themselves (the clusters).Evaluating a classification model is straightforward (e.g., accuracy, profit). Evaluating a clustering is often subjective and qualitative, as there is no pre-defined 'right' answer.
The book clearly defines this as the difference between supervised and unsupervised segmentation. It further explains that the choice between them involves a trade-off in the data mining process: supervised problems require more upfront work in business/data understanding to define the target, while unsupervised problems require more downstream work in evaluation to understand and use the results.
vs Using standard data science libraries (NumPy, pandas, scikit-learn).
Both approaches aim to solve the same fundamental data science problems, such as classification, regression, clustering, and data manipulation.
This book implements algorithms from first principles in pure Python to maximize understanding. Libraries provide optimized, production-ready, and often black-box implementations for efficiency and ease of use. The book's code is for learning, not for production.
The primary goal is pedagogical: to demystify data science by building everything from scratch. This gives the reader a deep intuition for how the algorithms work, what their limitations are, and how they connect to underlying mathematical concepts.
vs The R programming language ecosystem.
Both Python and R are powerful, free languages with extensive libraries for statistical analysis, machine learning, and data visualization.
The author holds a stated preference for Python, citing its simplicity, general-purpose nature, and what he considers to be a cleaner design. The book jokingly refers to R users as 'wrong' but acknowledges its wide use in the field.
This book is unapologetically Python-centric, using it as the sole tool to teach data science concepts from the ground up.
vs Coding-heavy data science books
Both cover core data science algorithms like regression, clustering, and classification.
This book uses Microsoft Excel as the primary teaching tool, abstracting away the complexities of programming environments, libraries, and syntax. It focuses on building algorithms from first principles in a visual, cell-by-cell manner.
Its 'no code guarantee' (for the first 9 chapters) makes advanced analytical techniques accessible to a broad business audience that is comfortable in spreadsheets but may be intimidated by programming.
vs K-Means Clustering vs. Network Graph Community Detection
Both are unsupervised learning techniques used on the same wine purchase dataset to segment customers into meaningful groups.
K-means is a geometric method that partitions data based on distance to a pre-defined number of centroids. Graph modularity is a relational method that finds communities by maximizing the density of connections within groups compared to a random graph.
The book presents both techniques as valid but different ways to approach the same problem, highlighting that the graph-based method has the advantage of not requiring the user to specify the number of clusters 'k' in advance.
vs Linear Regression vs. Logistic Regression
Both are presented as supervised learning models (General Linear Models) that predict an outcome based on a weighted combination of input features.
Linear regression produces a continuous output that can be outside the 0-1 range, making it non-ideal for probability prediction. Logistic regression uses a specific 'link function' to constrain its output to be a valid probability between 0 and 1.
The book builds both models from scratch, showing logistic regression as a simple but crucial modification of the linear model. It demonstrates that while their predictive power can be nearly identical (per ROC curves), logistic regression provides more intuitive, probabilistic outputs.
vs Bagging vs. Boosting (Ensemble Models)
Both are ensemble techniques that combine many 'weak learners' (simple decision stumps) to create a single, powerful predictive model.
Bagging builds stumps in parallel on random subsamples of the data. Boosting builds stumps sequentially, with each new stump focusing on the mistakes made by the previous ones by re-weighting the data.
The book uses the analogy of 'a lot of bad pizza' to explain the ensemble concept, and builds both models to show their different approaches to the same goal. It notes that boosting often achieves higher accuracy but can't be parallelized and has a higher risk of overfitting.
vs Traditional Database Management System (DBMS)
Both systems deal with the management and organization of data, providing functions for data storage and retrieval.
DBMS is optimized for real-time transactional processing (OLTP) with a normalized structure for current data. A data warehouse is optimized for analytical processing (OLAP) with a denormalized structure for large volumes of historical data.
The book clearly positions the data warehouse as a specialized system for business intelligence that complements, rather than replaces, the operational role of a DBMS.
vs Online Transaction Processing (OLTP)
Both are data processing systems that interact with databases.
OLTP manages day-to-day transactional operations (e.g., inserts, updates) with a focus on speed and data integrity for current data. OLAP is designed for complex analytical queries on large volumes of historical, aggregated data to support decision-making.
The book explains that the fundamental architectural and data modeling differences between OLTP and OLAP systems necessitate separate environments, leading to the creation of data warehouses for OLAP.
vs Snowflake Schema
Both Star and Snowflake schemas are dimensional models used in data warehousing, featuring a central fact table and surrounding dimension tables.
The Star schema uses denormalized dimension tables, leading to simpler queries and faster performance but with data redundancy. The Snowflake schema normalizes the dimension tables into multiple related tables, reducing redundancy and improving data integrity but increasing query complexity due to more joins.
The book presents this as a classic design trade-off between query performance/simplicity (Star) and storage efficiency/data integrity (Snowflake).
vs Data Analysis
Both data mining and data analysis involve examining data to find insights.
Data analysis typically involves testing pre-defined statistical models and hypotheses to understand a dataset. Data mining uses machine learning and statistical models to automatically discover previously unknown patterns and insights from large datasets.
The book positions data mining as a more exploratory, pattern-discovery-focused process within the broader Knowledge Discovery in Databases (KDD) framework, distinguishing it from the hypothesis-testing nature of traditional data analysis.
vs LSM-Trees vs. B-Trees
Both are key-value indexing structures.Both keep keys sorted, allowing for efficient range queries.
LSM-Trees are append-only, merging sorted files (SSTables) in the background. B-Trees update fixed-size pages in place.LSM-Trees are optimized for high write throughput. B-Trees are generally optimized for faster read performance.LSM-Trees can have higher write amplification due to compaction, but are often more compressible. B-Trees can suffer from internal fragmentation.
The choice is a trade-off dependent on the workload. LSM-Trees are good for write-heavy loads, while B-trees offer more predictable read latencies as they don't have compaction processes that can interfere with queries.
vs Document vs. Relational Data Models
Both are general-purpose models for storing structured data.Both can represent one-to-many and many-to-many relationships, though via different mechanisms (nesting vs. foreign keys).
Relational model enforces a schema-on-write and uses normalization. Document model is typically schema-on-read and encourages denormalization.Document model has better data locality for entire documents. Relational model requires joins to reconstruct document-like structures.Relational model has strong, mature support for joins. Join support in document databases is often weak or non-existent.
The book argues that neither model is superior and they are converging. The choice depends on the application's data structure: document models are good for self-contained tree-like data, while the relational model is better for highly interconnected data.
vs Single-Leader vs. Multi-Leader vs. Leaderless Replication
All are strategies for keeping copies of data on multiple nodes to provide fault tolerance and scalability.
Single-leader funnels all writes through one node, offering a simple consistency model but creating a single point of failure.Multi-leader allows writes on multiple nodes, improving write latency and datacenter failure tolerance, but requires complex conflict resolution.Leaderless replication (Dynamo-style) allows any replica to accept writes, prioritizing high availability but providing only weak eventual consistency and requiring quorums.
Each model represents a different point in the design space of distributed systems trade-offs. The book analyzes the failure modes and consistency guarantees of each in detail to help the reader make an informed choice.
vs MapReduce vs. MPP Databases
Both are capable of parallel query execution on large datasets distributed across a cluster.
MPP databases are monolithic, integrated systems with a SQL interface, optimized for structured analytics. MapReduce is a general-purpose programming framework on top of a distributed filesystem (HDFS).MPP databases require data to be loaded into their specific storage format and schema. The Hadoop ecosystem supports arbitrary data formats.MapReduce is designed to tolerate frequent task termination by materializing intermediate state to disk. MPP databases typically abort the entire query on node failure.
The Hadoop ecosystem is framed as a distributed 'operating system' that offers flexibility and supports diverse processing models, while MPP databases are specialized, high-performance appliances. The two are converging as dataflow engines add SQL interfaces and optimizers.
vs Distributed Transactions vs. Asynchronous Dataflow with Idempotence
Both are approaches to achieve correctness and data integrity when an operation must make changes across several systems or partitions.
Distributed transactions (like 2PC) use synchronous coordination to provide atomic commit and strong consistency (linearizability). They are brittle, operationally complex, and have high performance overhead.Asynchronous dataflow uses an event log as the source of truth, with idempotent consumers applying changes. This approach is loosely coupled, more fault-tolerant, and has better performance, but provides weaker timeliness guarantees.
The book advocates for the asynchronous dataflow approach, arguing that it provides sufficient integrity guarantees for many applications with better performance and operational characteristics than traditional distributed transactions. It separates the problem into 'integrity' (which must be strong) and 'timeliness' (which can often be relaxed).
vs K-Nearest Neighbors (KNN)
Both are supervised learning methods that can be used for regression and classification.
Linear regression is a parametric method that assumes a linear relationship between predictors and the response. KNN is a non-parametric method that makes no assumptions about the functional form, making predictions based on the 'K' nearest training observations.
Linear regression is superior when the true relationship is linear due to its low variance and high interpretability. KNN is more flexible and can outperform linear regression when the relationship is highly non-linear, but it suffers from the curse of dimensionality and is less interpretable.
vs Ridge Regression
Both are shrinkage methods that add a penalty to the RSS to reduce model variance and prevent overfitting. Both require selecting a tuning parameter λ via cross-validation.
The Lasso uses an L1 penalty (sum of absolute values of coefficients), which can shrink some coefficients to exactly zero, thus performing variable selection. Ridge regression uses an L2 penalty (sum of squared coefficients), which shrinks all coefficients towards zero but does not set any to exactly zero.
The Lasso is preferred for creating sparse, more interpretable models or when many predictors are irrelevant. Ridge regression may perform better when the response is a function of many predictors with roughly equal-sized coefficients.
vs Quadratic Discriminant Analysis (QDA)
Both are generative classification models that assume observations from each class are drawn from a Gaussian distribution and use Bayes' theorem to make predictions.
LDA assumes a common covariance matrix for all classes, resulting in a linear decision boundary. QDA allows each class to have its own covariance matrix, resulting in a quadratic decision boundary.
LDA is less flexible, having lower variance but potentially higher bias. QDA is more flexible. LDA tends to be better with few training observations, while QDA is better when the training set is very large or the common covariance assumption is clearly false.
vs Bagging
Both are ensemble tree methods that build a large number of decision trees on bootstrapped training samples.
Random forests adds a step of random feature selection at each split in the tree-building process. This decorrelates the trees, which can lead to a greater reduction in variance compared to bagging.
Random forests generally outperform bagging, especially when there are a few very strong predictors, because it prevents all trees from being dominated by those same predictors, leading to a more diverse and robust ensemble.
vs Machine Learning Models
Both statistical models (like linear/logistic regression) and machine learning models (like neural networks) are used for supervised prediction, using past data to predict future outcomes.
Statistical models are generally simpler, more interpretable, and rely on assumptions about data distributions. Machine learning models can be more complex ('black boxes'), more accurate by capturing unusual relationships, but are difficult to interpret.
The book presents both approaches as valid tools in the data scientist's toolkit, with the choice depending on the business problem, specifically the trade-off between the need for accuracy and the requirement for interpretability.
vs Gradient Boosting Models
Both Random Forest and Gradient Boosting are powerful ensemble methods based on decision trees that typically offer higher accuracy and stability than a single tree.
In Random Forests, trees are built independently and in parallel. In Gradient Boosting, trees are built sequentially, with each new tree trying to correct the errors of the previous one. This makes Forests faster to train, while Boosting can sometimes be more accurate but is also more prone to overfitting.
The book clearly explains the algorithmic difference in how the ensemble is constructed, giving the reader practical guidance on when one might be preferred over the other based on training time and accuracy needs.
vs Association Rules Analysis
Both Sequence Analysis and Association Rules Analysis are unsupervised methods used to find relationships between items in transactional data.
Association Rules Analysis identifies items that occur together in a transaction, regardless of order (e.g., {bread, butter}). Sequence Analysis incorporates a time dimension, identifying items purchased in a specific order (e.g., item A is purchased, then item B is purchased 3 weeks later).
The book distinguishes them by the presence of a timestamp, highlighting that Sequence Analysis can inform not just *what* to offer, but *when* to offer it in a 'Next Best Offer' campaign.
vs Multiple t-tests for comparing more than two groups
Both can be used to compare the means of different groups.
Performing multiple t-tests inflates the overall Type I error rate well beyond the chosen α for each individual test. ANOVA tests a single null hypothesis that all means are equal, keeping the overall Type I error rate at α. ANOVA is also less work.
The book presents ANOVA as the solution to the problem of error rate inflation caused by multiple comparisons, a key step up from two-sample tests.
vs Parametric vs. Nonparametric Tests (e.g., t-test vs. Rank-Sum test)
Both are families of inferential tests used to evaluate hypotheses about populations based on sample data.
Parametric tests (like t-tests and ANOVA) have more restrictive assumptions (e.g., normal populations, interval/ratio data). When assumptions are met, they are more powerful. Nonparametric tests (like Rank-sum, Wilcoxon, Kruskal-Wallis) have fewer assumptions and can be used on ordinal data, but are generally less powerful.
The book integrates nonparametric analogues into the chapters where their parametric counterparts are discussed, rather than relegating them to a final, separate chapter. This organization helps students better appreciate the situations in which each test applies (Preface).
vs Hypothesis Testing vs. Interval Estimation
Both are major types of statistical inference. For a given dataset and α, they are informationally equivalent; a confidence interval contains all the values of μ0 that would NOT be rejected by a corresponding two-tailed hypothesis test.
Hypothesis testing provides a categorical decision: reject or fail to reject a specific null hypothesis. Interval estimation provides a range of plausible values for the population parameter, giving a sense of precision.
The book presents these as two sides of the same inferential coin, explicitly explaining their deep connection and the conditions under which one might be preferred for stylistic or practical reasons (Chapter 10).
vs Random Sampling vs. Random Assignment
Both involve the use of random processes in research design.
Random sampling is a procedure for selecting observations from a population to ensure the sample is representative and to allow for generalization of results to that population. Random assignment is a procedure used in experiments to assign subjects to different conditions to eliminate confounds and allow for causal conclusions.
Chapter 14 is dedicated to explicitly differentiating these two concepts and, crucially, developing a rationale for how random assignment can substitute for random sampling in experimental psychology, a central tension in the field.
vs SAS and SPSS
They are all tools used for data analysis and statistical modeling.
R is free and open-source, while SAS and SPSS are commercial products. R's dominance is attributed to its extensive use in academia and its large, active user community.
The book standardizes on R as the tool of choice, citing its popularity and power among data scientists.
vs Python
Both R and Python are programming languages used by data scientists.
The book notes a spirited debate between the R and Python communities as to which is the best tool for data scientists, but presents R as having compelling justifications like its ~7,000 packages and superior visualization.
This book is exclusively focused on R.
vs ggplot2 graphics package
Both base R graphics and ggplot2 are used to create plots in R.
The author finds base R graphics functions to be more straightforward for an introductory text.
The book makes a conscious choice to use only base R graphics functions to keep the code examples simple and avoid the learning curve of an additional complex package.
vs Theorist vs. Experimentalist Data Scientist
Both roles fall under the umbrella of 'data science' and contribute to solving problems with data.
Theorists focus on formal data analysis, modeling, and mathematical principles, often using modest-sized datasets. Experimentalists are more like software engineers, focused on building and deploying scalable production systems (e.g., using Hadoop, managing hardware).
The book proposes this division as a realistic alternative to the unrealistic 'unicorn' data scientist, helping readers frame their own career path.
vs Bagging vs. Boosting (Ensemble Methods)
Both are ensemble methods that combine multiple weak classifiers (like decision trees) to create a single strong predictive model.
Bagging creates models in parallel on bootstrapped subsets of the data (e.g., Random Forest). Boosting builds models sequentially, with each new model focusing on correcting the errors of the previous ones.
The book explains both concepts and provides examples of popular algorithms derived from each (Random Forest for bagging, GBM for boosting).
vs Open Source R vs. Enterprise R (Revolution R, TIBCO TERR)
Both are based on the R language and can run R code.
Open source R is not a good option for production due to performance and memory limitations. Commercial/Enterprise versions are optimized to handle very large datasets quickly.
The book uses open source R for teaching but makes the reader aware that for 'Big Data' production systems, a commercial alternative is necessary.
vs Traditional single-discipline textbooks (e.g., in economics, computer science, or sociology).
The book uses foundational models and concepts originating from these fields, such as graph theory from computer science, game theory from economics, and social network analysis from sociology.
Single-discipline texts treat these topics in isolation. For example, economics focuses on game theory without deep network structure, while sociology focuses on network structure often without formal game-theoretic models of behavior.
The book's primary contribution is its synthesis of these disparate fields into a single, unified framework to analyze phenomena that arise at the interface of networks, crowds, and markets, making these advanced ideas accessible at an introductory level.
vs Traditional statistics textbooks
Covers many foundational topics from classical statistics, including probability distributions, sampling, hypothesis testing, and linear regression.
De-emphasizes mathematical theory and formal inference (e.g., p-values) in favor of practical application and predictive accuracy. It focuses on modern, computationally-intensive methods (e.g., bootstrap, permutation tests) and integrates statistical machine learning techniques (e.g., trees, boosting) not found in most classical texts. Provides code in both R and Python.
Its primary distinction is its pragmatic focus on curating and explaining only those statistical concepts that are most relevant and useful for a practicing data scientist, acting as a bridge between the worlds of classical statistics and modern machine learning.
vs R, MATLAB, SAS, Stata
These tools, like Python's data stack, are used for data analysis, interactive computing, and data visualization. The pandas DataFrame was specifically inspired by and named after R's `data.frame` object.
Python is a strong general-purpose programming language, which makes it easier to build and integrate data analysis tasks into larger production applications. This helps solve the 'two-language problem,' whereas languages like R are more specialized for statistics.
This book provides a practical, modern introduction to the core data science tools in Python (pandas, NumPy), written by the creator of the pandas library. Its focus is foundational data wrangling and preparation, as opposed to advanced statistical methodology.
vs Base R
Both provide tools for data manipulation, visualization, and programming within the R environment. Base R functions are often the foundation upon which tidyverse functions are built.
The tidyverse functions (e.g., in `readr`, `dplyr`, `tibble`) are generally faster, more consistent in their syntax and return types, and produce tibbles instead of standard data frames. Base R functions can be less consistent and have defaults (like converting strings to factors) that are often sources of frustration.
This book is unapologetically focused on the tidyverse, presenting it as the primary and most effective toolset for modern data science in R, in contrast to more traditional texts that start with base R.
vs Python, Julia, and other data science languages
These languages are also powerful tools for data science, and most data science teams use a mix of languages.
The book argues that R is a great place to start because it is an interactive environment designed from the ground up for data science, with mini-languages (like dplyr and ggplot2) tailored for specific parts of the process.
It advocates for mastering one tool at a time, and chooses to dive deep into R and the tidyverse rather than spreading thinly across multiple languages.
vs Other coding styles (intermediate variables, overwriting, function composition)
All styles can achieve the same result for a sequence of operations.
The book compares the `%>%` pipe to other styles, noting that saving intermediate steps clutters code, overwriting makes debugging hard, and function composition is hard to read. The pipe is presented as more readable because it focuses on the sequence of actions (verbs).
The pipe is a central tool in the book's workflow, used in nearly every example to chain operations together clearly.
vs SQL
The concepts of relational data and joins in `dplyr` are inspired by and directly map to SQL concepts (e.g., `inner_join` is `INNER JOIN`).
`dplyr` syntax is presented as easier to use for data analysis because it is specialized for that purpose and integrated within the R language, whereas SQL is a more general-purpose language for database interaction.
It teaches relational data concepts using `dplyr` verbs, making them accessible within a cohesive R-based workflow.
vs Traditional Waterfall Development Methodology
Both are structured project management approaches used for software development, involving phases for requirements, design, development, and testing.
Waterfall is a linear, sequential process where each phase must be completed before the next begins, requiring all requirements to be defined upfront. Agile, as advocated in the book, is an iterative process that works in short cycles ('sprints') with continuous collaboration between business and IT, allowing requirements to evolve.
The book strongly advocates for agile development as superior for BI projects. It argues that the exploratory nature of BI and the rapid pace of business change make the rigid, slow waterfall approach ineffective and a common cause of BI project failure.
vs Independent Data Mart Architecture
Both approaches often use dimensional models to make data accessible to specific groups of users.
Independent data marts are built in isolation for specific departments, leading to data silos and inconsistency. The Kimball architecture is an enterprise approach that uses a shared 'bus' of conformed dimensions to ensure that all data marts can be integrated.
This book's approach is fundamentally about integration and enterprise consistency, directly opposing the un-architected, siloed nature of independent data marts.
vs Hub-and-Spoke Corporate Information Factory (CIF) / Inmon Architecture
Both are enterprise-scale architectures aiming for data integration. Both extract data from source systems into a central repository.
The CIF's central repository is a normalized (3NF) Enterprise Data Warehouse (EDW) that is intended to be the single source of truth, from which departmental data marts are then built. The Kimball architecture's presentation area IS the integrated, dimensional EDW, built from a series of business-process-focused dimensional models sharing conformed dimensions. The Kimball approach avoids the mandatory physical 3NF repository for user access.
This book advocates for making the dimensionally modeled presentation area the direct, primary interface for all BI and user queries, arguing that a normalized EDW is too complex and slow for this purpose and introduces an unnecessary layer of ETL and data redundancy.
Where else it applies
The model, taken beyond its home domain
Personal Health and Wellness
Individuals can apply the principles to their own lives by using data from sources like pedometers (as in the Silver Sneakers example), smart scales, and calorie-tracking apps. They can run personal 'A/B tests' on diets or exercise routines, identify patterns in their energy levels or sleep quality, and make fact-based decisions to improve their well-being, moving from simply reporting data to gaining insights.
Higher Education Administration
Universities can use analytics to move beyond simple reporting of enrollment numbers. They could build predictive models to identify students at high risk of dropping out and intervene with targeted support (Target). They could analyze performance data to identify which teaching methods are most effective for different subjects (Insight). This would require an enterprise view of student data, leadership from deans, and skilled analysts.
Municipal Government
A city government could embed analytics into its processes. For example, sanitation departments could use predictive models based on historical data and public events to optimize trash collection routes in real-time (similar to UPS). Police departments could use analytics to predict crime hotspots and deploy resources more effectively. This goes beyond simple reporting and moves into predictive and prescriptive action.
Personal Finance Management
An individual could use analytical principles to manage their finances. Instead of just tracking spending (reporting), they could analyze patterns to understand the root causes of overspending (insight), build a predictive model of their future cash flow, and run 'what-if' scenarios to optimize their savings strategy for retirement or a large purchase.
Non-Profit Fundraising
A non-profit could apply the 'ladder of marketing analytics'. Instead of just having a donor database (data in order), they could segment donors by giving history and capacity (segmentation), send different appeals to different segments (differentiated action), and build predictive models to identify which donors are most likely to respond to a major gift campaign (predictive action).
Personal Health and Fitness
An individual could apply the principles of 'N=all' and 'datafication' by tracking all their own biometric data, diet, and exercise (like the Quantified Self movement). They could then use correlational analysis, rather than just causal medical advice, to discover non-obvious personal drivers of well-being, fatigue, or athletic performance.
Urban Planning and Local Governance
Beyond the book's example of predicting fires, a city could apply the full big data paradigm by combining 'messy' 'N=all' datasets on traffic, waste collection, public transit usage, and 311 calls to find correlations that inform zoning laws, infrastructure investment, and public service optimization.
Creative Arts (e.g., Writing or Music Composition)
A creator could use big data principles to augment their intuition. For example, an author could analyze the entirety of a literary genre ('N=all') using text mining to find non-obvious correlations ('what, not why') in plot structure, pacing, or vocabulary that are associated with commercial success, using the insights to inform their own work.
Agritech / Precision Farming
The principles of using messy sensor data and correlation can be applied beyond industrial settings to agriculture. By datafying soil content, weather patterns, and crop yields across thousands of 'N=all' plots, farmers can find correlations between inputs and outcomes to optimize fertilizer and water use at a granular level without needing to fully understand the complex biological causation.
Legal and Judicial Systems
The natural language processing (NLP) and evidence-scoring techniques used by IBM's Watson could be applied to legal research. The system could analyze vast repositories of case law to find relevant precedents, assess the strength of legal arguments, and assist in e-discovery by identifying key documents in massive document dumps, significantly speeding up legal work.
Personalized Education
The collaborative filtering and profiling methods used by Netflix and Amazon could be adapted for education. A learning platform could track a student's performance, what types of content they engage with most, and where they struggle. It could then recommend personalized learning paths, supplementary materials, or different teaching approaches, similar to how Netflix recommends the next movie to watch.
Precision Agriculture
While the book briefly mentions drone crop spraying, the broader analytics toolset could be applied more deeply. Data from soil sensors, weather satellites, and drone imagery could be aggregated and analyzed using MapReduce to create micro-climate models for a farm. This would enable predictive modeling for crop yields and allow for the precise application of water and fertilizer only where needed, optimizing resource use.
Political Campaigning and Governance
The clustering and sentiment analysis techniques used for market research could be used to micro-target voters with specific messages based on their online behavior and demographic profiles. Post-election, sentiment analysis of social media could provide governments with real-time feedback on public policy initiatives, functioning as a continuous, massive focus group.
Urban Planning and Infrastructure Maintenance
Beyond 'smart cities,' data from GPS, traffic sensors, and public transit usage could be used to model and simulate the effects of new infrastructure projects before they are built. Real-time sensor data from bridges and roads could be used to predict maintenance needs, shifting from a scheduled to a predictive maintenance model, saving costs and preventing failures.
Quantitative Finance
The probabilistic modeling, Monte Carlo simulations (Ch. 3), and statistical testing (Ch. 7) used in the book are directly applicable to modeling asset prices, backtesting trading strategies, and calculating financial risk.
Logistics and Supply Chain Management
The clustering algorithms, like K-Means and DBSCAN (Ch. 10), used for grouping disease outbreaks can be used to optimize warehouse layouts, group delivery points into efficient routes, or identify geographic patterns in supply chain disruptions.
Manufacturing and Quality Control
The hypothesis testing framework used to compare ad-click rates (Ch. 7) is a standard method for A/B testing in manufacturing to determine if a process change resulted in a statistically significant improvement in product quality.
Market Research
The NLP and text clustering techniques for analyzing job postings (Ch. 13-16) can be used to analyze customer reviews, survey responses, or social media posts to identify key themes, product complaints, or emerging market trends.
Scientific Research
A large research lab or project can apply the book's architectural framework to manage massive volumes of experimental data. The Data Integration Framework (DIF) could be used to ingest, clean, and conform data from various instruments and labs (SORs) into a central scientific data warehouse (an EDW). Data marts could then be created for specific research teams, and data scientists could use 'analytical hubs' to perform advanced statistical analysis and modeling.
Government Intelligence / National Security
The principles of integrating disparate data sources are directly applicable. An intelligence agency could use the Analytical Data Architecture (ADA) to create a 'System of Integration' for a wide variety of data types (e.g., SIGINT, HUMINT, OSINT). The use of advanced analytics, predictive modeling, and data visualization tools described in Chapter 15 would be critical for identifying patterns and potential threats from this integrated data set.
Public Health Management
Public health organizations can use the BI project lifecycle to develop systems for tracking disease outbreaks. Data from hospitals, clinics, and labs (SORs) across a region could be integrated into a central data store. BI dashboards could provide officials with near-real-time visualizations (e.g., geographic maps) of outbreak hotspots, while predictive analytics could be used to forecast spread and allocate resources like vaccines and medical staff.
Personal Knowledge Management (PKM)
On a much smaller, individual scale, a person can apply the core concepts. They can treat their various sources of information (books, articles, notes, web clips) as 'source systems.' Using PKM tools, they can 'integrate' this data into a central repository (a personal 'data warehouse'). They can then use tags and links to create 'dimensions' and 'facts,' and use BI-like query and visualization tools to analyze connections and discover insights in their personal knowledge base.
Sustainable Development and Environmental Management
BI&BD principles can be used to model and optimize resource usage, monitor environmental indicators like carbon emissions in real-time from IoT sensors, and analyze complex ecological systems to predict the impacts of climate change.
Public Health and Epidemiology
Inspired by the mention of Google Flu Trends, Big Data from sources like search queries, social media, and wearables can be analyzed to predict disease outbreaks, track pandemics in real time, and optimize the allocation of healthcare resources.
Smart Cities and Urban Planning
By analyzing data from traffic sensors, public transit usage, and utility grids, city planners can use BI&BD to optimize public transport routes, manage energy distribution, improve emergency response times, and analyze labor market dynamics.
Government and Public Policy
Use analytics to optimize resource allocation (e.g., police deployment via CompStat), improve tax fraud detection, manage public health crises, and enhance the effectiveness of social programs.
Non-Profit Sector
Optimize fundraising campaigns by segmenting donors based on giving history, measure program effectiveness with hard data to secure grants, and improve logistics for delivering humanitarian aid.
Education
Personalize student learning paths by analyzing performance data, identify at-risk students for early intervention, and allocate budgets within a school district based on evidence of what works.
Personal Productivity and Health
Individuals can apply the principles to their own lives, using data from apps and wearables to optimize fitness, finances, and time management, in effect 'competing on personal analytics'.
Legal Practice
Law firms can use predictive analytics to forecast case outcomes, optimize litigation strategies based on judicial precedent data, and set more effective pricing for legal services.
Public Education (K-12)
School districts could compete on 'student success analytics'. They could use data on attendance, grades, disciplinary incidents, and engagement with online platforms to create predictive models that identify at-risk students far earlier. Prescriptive analytics, mirroring 'next best offer' in marketing, could then recommend specific interventions like tutoring, counseling, or pedagogical changes for teachers. This would shift the system from being reactive to being proactive in student support.
Philanthropy and Non-Profits
Large foundations could move beyond intuitive grant-making to an 'analytical philanthropy' model. They could analyze historical data from thousands of past grants to identify the organizational characteristics and programmatic approaches that produce the highest social return on investment (SROI). This parallels the book's discussion of M&A and R&D portfolio optimization, allowing the foundation to build a data-driven 'portfolio of social change.'
Medicine / Healthcare
The book mentions classifying accident severity to dispatch emergency services (discriminant analysis, Ch 12), finding symptom co-occurrence (association rules, Ch 14), and uniform sizing for the army based on body measurements (clustering, Ch 15).
Law
Examples include using text mining to classify documents in legal discovery as relevant or irrelevant (Ch 20) and detecting plagiarism by finding unusual word combinations (association rules, Ch 14).
Government / Public Sector
The book gives the explicit example of the IRS using predictive models to find tax evasion with 25 times more accuracy (Ch 1), and political campaigns using uplift modeling to target persuadable voters (Ch 13 and Ch 21).
Engineering / Technology
Cites ALVINN, an autonomous vehicle, which used a neural network to learn steering direction from camera data (Ch 11). Also mentions classifying network data packets as benign or threatening (classification, Ch 2).
Social Sciences
The social network analytics chapter (Ch 19) discusses tracking terrorist networks and entity resolution. The book also notes that discriminant analysis is very popular in social sciences for classification tasks.
Identifying the same user across different mobile devices
The book proposes applying concepts from text mining to this non-text domain. A user's device can be represented as a 'bag of locations' it has visited, analogous to a document's 'bag of words'. The TFIDF concept can then be applied, where the 'TF' is the frequency of visiting a location and the 'IDF' weights locations by their rarity (e.g., a home WiFi network is rare and thus more informative than a popular coffee shop). Devices with similar TFIDF-weighted location vectors are likely to belong to the same person.
Medical Diagnosis
The concept of using Bayes' Rule to combine evidence is illustrated with a medical diagnosis example. A doctor wanting to know p(measles|red spots) can use Bayes' Rule to reframe the problem into estimating p(red spots|measles), p(measles), and p(red spots), which are more tractable quantities based on medical knowledge and population statistics.
Recommender Systems (e.g., for movies)
Concepts of similarity, data reduction, and latent information are applied. Users and movies are represented in a lower-dimensional 'taste space' (e.g., with axes for 'quirkiness' or 'drama'). A user's position is determined by their past ratings. Recommendations are made by finding movies that are most similar (closest) to the user in this latent space.
Legal Reasoning
The book explains that the legal practice of citing precedents is a form of nearest-neighbor or case-based reasoning. A lawyer argues a new case by finding similar historical cases (precedents) and using their outcomes to support a desired judgment for the new case.
Computational Finance
The linear and multiple regression techniques could be used to model asset prices based on various economic factors. Clustering could be used to group stocks with similar trading behavior. Gradient descent is a core part of optimizing many financial models.
Bioinformatics
Clustering algorithms (k-means, hierarchical) can be used to group genes with similar expression patterns from microarray data. Classification models like Naive Bayes or decision trees could predict protein function or disease presence based on genetic markers.
Operations and Logistics
Gradient descent can be used to solve optimization problems for route planning or inventory management. Network analysis could model and optimize supply chains by identifying bottlenecks (betweenness centrality) or key distribution hubs.
Marketing Analytics
Clustering can be used for customer segmentation. Recommender systems (collaborative filtering, matrix factorization) can be applied to suggest products to customers. A/B testing frameworks are used to optimize website design and marketing campaigns.
Sociology and Political Science
Network analysis can be used to study social structures and the spread of information. NLP techniques like topic modeling can analyze political speeches or social media content to identify key themes and sentiment.
Healthcare and Medicine
Supervised AI (Chapter 6) can be used to predict patient risk for conditions like heart disease. Clustering (Chapter 2) can group patients with similar profiles for treatment analysis. Outlier detection (Chapter 9) can identify fraudulent billing or anomalous patient data in electronic health records.
Intelligence and National Security
Network graph analysis (Chapter 5) can map and find communities within terrorist or criminal networks. Naïve Bayes (Chapter 3) can be used to automatically classify intercepted communications by topic or urgency. Optimization (Chapter 4) is used for military logistics and resource allocation.
Finance and Investing
Optimization (Chapter 4) can be used for portfolio management to maximize returns for a given level of risk. Supervised AI (Chapter 6) is used extensively for credit scoring and fraud detection. Clustering (Chapter 2) can be used to group stocks by volatility and return profiles.
Airline Industry
Optimization (Chapter 4) is core to revenue management, setting ticket prices to maximize profit. Forecasting (Chapter 8) is used to predict passenger demand on various routes.
Human Resources
Outlier Detection (Chapter 9) can be used to identify both top-performing and under-performing employees based on a variety of performance metrics, as demonstrated in the call center example.
Banking
Data warehouses are used for risk management by consolidating customer transaction data, market trends, and regulatory information. Data mining helps analyze customer behavior for personalized marketing and identifying cross-selling opportunities.
Healthcare
A data warehouse can consolidate patient records, treatment outcomes, and medical histories to provide a comprehensive view for patient analytics. This supports clinical decision-making and helps streamline hospital operations like staff scheduling and resource utilization.
Telecommunications
Telecom companies use data warehouses to analyze customer call records and service usage patterns. Data mining techniques like classification are applied to predict customer churn and implement targeted retention strategies.
Manufacturing
Data is gathered from procurement, production, and distribution stages into a data warehouse to optimize the supply chain. Data mining can be used to monitor product quality, analyze defects, and support continuous improvement initiatives.
Organizational Structure & Team Management
The principles of loose coupling and well-defined interfaces, discussed in the context of microservices and dataflow systems, can be applied to structuring engineering teams. By giving teams clear ownership of services or data products and defining how they interact (e.g., via an event log), organizations can reduce coordination overhead and scale development efforts more effectively.
Urban Planning and Smart Cities
A city can be modeled as a data-intensive system. Sensor data from traffic, public transit, and utilities can be treated as event streams. Stream processors can maintain materialized views of the city's state (e.g., traffic congestion maps). This allows for low-latency responses, like dynamic traffic signal timing, while batch processing on historical data can inform long-term planning.
Scientific Research (e.g., Genomics, Particle Physics)
The book mentions these domains as examples of large-scale data processing. The 'unbundling' approach is relevant: raw experimental data is the system of record (stored in a distributed filesystem). Various batch and stream processing jobs are run to transform, filter, and analyze this data, creating derived datasets for specific research questions, without altering the original raw data.
Software Development Toolchains
A version control system like Git is a perfect example of an immutable, append-only log (the commit history). The current state of the code is a materialized view of that log. Continuous Integration (CI) systems are essentially stream processors that are triggered by new events (commits) and produce derived data (test results, build artifacts).
Bioinformatics & Genomics
Sequence processing models like RNNs, LSTMs, and Transformers (Chapters 15 & 16) can be applied to analyze DNA, RNA, or protein sequences. They can be used for tasks like predicting protein structure, identifying gene function from a sequence, or finding active promoter regions in a genome.
Financial Markets & Algorithmic Trading
The time series forecasting techniques using RNNs or WaveNets (Chapter 15) can be applied to predict stock prices, volatility, or other financial indicators. Reinforcement Learning agents (Chapter 18) can be trained to develop optimal trading strategies that maximize returns while managing risk.
Industrial IoT & Predictive Maintenance
Anomaly detection techniques, as discussed with Gaussian Mixtures or Autoencoders (Chapters 9 & 17), can be used on sensor data from machinery to detect early signs of failure. This allows for predictive maintenance, reducing downtime and operational costs.
Cheminformatics & Drug Discovery
Generative models like Variational Autoencoders and GANs (Chapter 17) can be used to generate novel molecular structures with specific desired chemical properties. This can significantly accelerate the expensive and time-consuming process of discovering new drugs.
Robotics
Reinforcement Learning (Chapter 18) is directly used to train robots to perform tasks like walking, grasping objects, or navigating complex environments through trial and error in a simulated or real-world setting.
Marketing
Linear regression can predict product sales based on advertising budgets (Advertising data). Logistic regression can identify customers likely to respond to a mailing campaign. Clustering can be used for market segmentation to find distinct groups of customers.
Finance
Classification methods like logistic regression, LDA, and QDA are used to predict stock market direction (Smarket data) or credit card default (Default data). Time series models like RNNs can be used to forecast trading volume (NYSE data).
Medicine & Genomics
Classification methods (e.g., SVMs, Random Forests) are used to classify tumors based on gene expression data (Khan, NCI60 data). Survival analysis (Kaplan-Meier, Cox model) is used to analyze patient survival times (BrainCancer data) or time to publication for clinical trials (Publication data).
Image Recognition
Deep learning, specifically Convolutional Neural Networks (CNNs), are used to classify images, such as identifying handwritten digits (MNIST data) or objects in photographs (CIFAR100, ImageNet).
Natural Language Processing (NLP)
Recurrent Neural Networks (RNNs) and other deep learning models are applied to document classification tasks, such as determining the sentiment (positive/negative) of movie reviews (IMDb data) based on the sequence of words.
Public Sector / Urban Planning
The discussion of using network optimization for traffic flows (as seen in the 'Smart Cities' use case) can be applied to urban planning, public transport design, and emergency service routing.
Criminal Justice
Link analysis, described for understanding customer relationships, can be used by police departments for criminal investigations to map connections between suspects, locations, and activities.
E-commerce and Digital Media
Factorization Machines, explained for retail ratings, are directly applicable to any recommendation system challenge, such as recommending movies (Netflix), music (Spotify), or news articles.
Manufacturing and Logistics
The 'Traveling Salesman Problem' discussed under network optimization is a classic problem in logistics and supply chain management for optimizing delivery routes and fleet management.
Economics and Finance
The book features a media clip (Chapter 20) discussing an economist's use of regression analysis to create a formula predicting changes in 30-year Treasury bond interest rates based on deviations in monthly job creation numbers from forecasts.
Politics and Public Policy
Examples throughout the book use statistical procedures to analyze polling data, such as using a chi-square goodness-of-fit test to determine if voter preferences are equally distributed among four candidates (Chapter 22) or using interval estimation to find the margin of error in a poll on a policy issue (Chapter 11).
Public Health
The 'Smoking Study' dataset, used throughout the book, is from public health research. It illustrates how statistical tests (like chi-square or ANOVA) can be used to compare the effectiveness of different interventions (e.g., drug therapy vs. placebo) for health-related behaviors like smoking cessation.
Supply Chain
Regression techniques discussed in the book can be applied to 'demand forecasting' to determine optimal inventory levels for different distribution centers, preventing stock-outs while maintaining a lean inventory.
Customer Support
Regression models can be used for 'call center volume forecasting' to predict call volumes for staffing purposes. Classification models could be used for 'call routing' to prioritize certain customers based on their churn risk or lifetime value.
Risk Management (non-financial)
Classification algorithms for 'fraud detection' are not limited to credit cards. They could be applied to detect fraudulent Medicare claims by identifying anomalous patterns in billing data.
Marketing Automation
Classification algorithms can power 'discount targeting' by predicting the probability that a specific offer will encourage a desired customer behavior, ensuring marketing spend is used effectively.
Epidemiology and Public Health
Network models are used to understand and predict the spread of infectious diseases. Concepts like the basic reproductive number (R0) and the structure of contact networks (e.g., small-world properties, concurrency) are critical for modeling epidemic trajectories and evaluating interventions.
Law and Legal Studies
Link analysis algorithms developed for the Web, such as hubs and authorities, can be applied to citation networks of legal precedents (e.g., Supreme Court decisions) to quantify the influence and authority of specific cases over time.
Evolutionary Biology
Game theory provides a framework for understanding evolution. Traits are treated as 'strategies,' and reproductive fitness is the 'payoff.' This helps explain which behaviors (like aggression levels in animal conflict) are 'evolutionarily stable strategies' that can persist in a population.
Marketing and Business Strategy
Models of diffusion, cascades, and network effects are used to understand 'viral marketing.' The goal is to identify influential initial adopters in a social network who can trigger a cascade of product adoption through a population.
Public Policy and Social Program Evaluation
The principles of A/B testing can be applied to test the efficacy of different policy interventions or social programs, where a control group receives the standard service and a treatment group receives a new one to measure impact on outcomes.
Manufacturing and Industrial IoT
Regression diagnostics for identifying outliers and influential points can be repurposed for anomaly detection. A sensor reading that is a major outlier in a model predicting equipment failure could signal an impending mechanical problem.
Healthcare and Epidemiology
Classification models, especially those designed for rare events (imbalanced data), can be used to predict disease outbreaks or identify patients at high risk for a rare condition, helping to target preventative measures more effectively.
Financial Modeling & Quantitative Finance
The author created pandas while working in quantitative finance. The book's extensive time series analysis capabilities (Chapter 11), including date range generation, frequency conversion, resampling, and moving window functions, are directly applicable to analyzing financial market data.
Web Scraping and API Integration
The book demonstrates using `pandas.read_html` and `pandas.read_xml` to parse tabular data from web pages. It also shows how to interact with web APIs using the `requests` library and parse the resulting JSON into a DataFrame for analysis, a common task in backend applications and data engineering.
General Software Engineering
The data structures taught, particularly the pandas DataFrame, can serve as powerful in-memory data containers in general applications. They can be used for tasks like processing batch data, generating reports, or managing complex configuration data within a larger software system.
Business Analytics
The data wrangling (`dplyr`, `tidyr`) and visualization (`ggplot2`) techniques can be used to analyze sales data, customer behavior, or marketing campaign results. For example, `dplyr::group_by()` and `summarize()` can segment customers and calculate key metrics, while `ggplot2` can create dashboards showing sales trends.
Social Sciences and Public Health
The methods for modeling and visualization can be applied to survey or administrative data to explore societal trends. For example, the techniques used on the `gss_cat` and `who` datasets in the book can be used to study relationships between demographics and opinions, or to track disease prevalence over time.
Personal Finance and Health Management
The principles of creating a 'single version of the truth' can be applied to an individual's life. A person could consolidate data from bank accounts, credit cards, fitness trackers, and medical records into a personal 'data mart' and use visual discovery tools to analyze spending patterns, health trends, or progress toward personal goals.
Non-Profit Program Management
A non-profit could apply the BICC model to manage data across different programs (e.g., fundraising, community outreach, service delivery). By creating a central data warehouse of donor and beneficiary information, they can better measure program effectiveness, optimize fundraising campaigns, and report impact to stakeholders, similar to how a business measures performance.
Academic and Scientific Research
The agile development and business-IT partnership concepts can be applied to collaborations between research scientists ('the business') and a university's data science or high-performance computing core ('IT'). Using agile sprints to iteratively analyze complex datasets could accelerate discovery compared to a traditional, rigid research plan.
Personal Analytics / Quantified Self
An individual could model their personal data using these techniques. For example, a workout log could be a fact table, with dimensions for Date, Exercise Type, Location, and Weather. The facts would be duration, repetitions, and weight lifted. This would allow for easy slicing and dicing of personal performance.
Scientific Research Data Management
Experimental results can be modeled as a fact table. The dimensions would be the experimental conditions, such as Subject Demographics, Treatment Group, Lab Equipment, and Date. The facts would be the measured outcomes. This structure facilitates the exploration of results across various conditions.
Logistics and Supply Chain Monitoring
While the book covers inventory, the concepts apply broadly. A global shipping company could have a fact table for container movements. Dimensions would include Vessel, Route, Port of Origin, Port of Destination, and Container Type. Facts would include transit time, cost, and weight, allowing for analysis of shipping lane efficiency.
Movement III · The run-it-now depth
The Playbook
Practical tools and examples from this guide.
Frameworks
The DELTA Framework for Analytical Capability
A five-part framework that outlines the essential, interdependent success factors required for an organization to succeed with analytics: Data, Enterprise, Leadership, Targets, and Analysts.
Start hereAssessing an organization's current state against each of the five DELTA elements to identify strengths and weaknesses.
PathSystematically improving each of the five elements in rough proportion to move the organization through the five stages of analytical maturity, from 'Analytically Impaired' to 'Analytical Competitor'.
- 1Develop accessible, high-quality Data (Chapter 2).
- 2Promote an Enterprise orientation to manage resources and break down silos (Chapter 3).
- 3Cultivate passionate, fact-based Leadership (Chapter 4).
- 4Choose strategic Targets where analytics will make a substantial difference (Chapter 5).
- 5Build a team of skilled Analysts to do the work (Chapter 6).
Five-Stage Analytical Maturity Model
A maturity model that allows an organization to assess its current analytical capability and map a path toward greater sophistication. The stages are (1) Analytically Impaired, (2) Localized Analytics, (3) Analytical Aspirations, (4) Analytical Companies, and (5) Analytical Competitors.
Start hereUsing the DELTA Transitions table (Appendix) to diagnose the organization's current stage based on its characteristics across data, enterprise, leadership, targets, and analysts.
◆ The full 5-step framework — included with this guide purchase
Decision Automation Framework
A framework for classifying decisions to determine the appropriate level of automation and human involvement. Decisions can be fully automated, automated with human overrides for exceptions, or human-assisted with analytical support.
Start hereAnalyzing a key business decision to be improved or embedded in a process.
◆ The full 4-step framework — included with this guide purchase
Big Data Governance Framework
A set of three core principles to govern the use of big data, balancing its benefits with its risks to society and individuals.
Start hereAn organization planning to use big data, especially with personal information, for secondary purposes.
◆ The full 3-step framework — included with this guide purchase
Big Data Value Chain Model
A model for understanding the three key roles in creating value from big data, helping organizations identify their position and strategy.
Start hereA company seeking to understand how to participate in the big data economy.
◆ The full 3-step framework — included with this guide purchase
Project-Based Data Science Skill Acquisition
A structured framework for progressing from a basic Python coder to a job-ready data scientist by completing a series of increasingly complex, real-world projects.
Start hereA basic knowledge of Python, with no advanced math or algorithm experience required.
◆ The full 5-step framework — included with this guide purchase
BI Architectural Framework
A four-layer framework of blueprints that guides the development of a cohesive, cost-effective BI solution. The layers are Information, Data, Technical, and Product architecture.
Start hereStart with the Information Architecture by defining the business context: the 'what, who, where, and why' of the BI solution. This involves identifying business processes, analytical needs, and user requirements.
◆ The full 4-step framework — included with this guide purchase
Analytical Data Architecture (ADA)
An evolved hub-and-spoke data architecture that separates data systems into three logical roles: Systems of Record (SOR), Systems of Integration (SOI), and Systems of Analytics (SOA). It is the book's recommended approach.
Start hereGather data from authoritative Systems of Record (SOR), which are the transactional applications where data is created.
◆ The full 4-step framework — included with this guide purchase
Hybrid BI Project Methodology
A project management framework that blends a waterfall approach for overall project structure with an iterative, agile-style approach for developing individual BI application components.
Start hereStart with a high-level, waterfall-style 'Scope and Plan' phase to define the overall project, its major phases, and interdependencies.
◆ The full 6-step framework — included with this guide purchase
Data Integration Framework (DIF)
A holistic blueprint for transforming enterprise data into business information. It is composed of an information architecture, processes, standards, tools, and people.
Start hereStart at the Data Preparation stage by gathering data from diverse source systems.
◆ The full 4-step framework — included with this guide purchase
TDWI Big Data Maturity Model
A framework describing the evolutionary stages an organization follows when adopting and utilizing Big Data, helping to assess current state and plan future steps.
Start hereThe 'Nascent' stage, where the organization has low awareness of Big Data and its potential value, with little to no executive support.
◆ The full 4-step framework — included with this guide purchase
Dynamic Capabilities Framework
A strategic management framework explaining how firms achieve and sustain competitive advantage in rapidly changing environments by building capabilities to reconfigure their resource base.
Start here'Sensing': The initial phase of identifying and assessing an opportunity or threat in the market, such as a new technology or a shift in customer behavior.
◆ The full 3-step framework — included with this guide purchase
The Five Stages of Analytical Competition
A maturity model outlining the progression of an organization's analytical capabilities, from being 'Analytically Impaired' to becoming a full 'Analytical Competitor'.
Start hereStage 1, where the organization lacks quality data and management has little interest in fact-based decisions.
◆ The full 5-step framework — included with this guide purchase
The 'Prove-It' vs. 'Full-Steam-Ahead' Paths
A strategic framework for deciding on the pace and scale of an analytics transformation, based on the level of CEO commitment.
Start hereAssess the level of passion for analytics within the senior executive team, particularly the CEO.
◆ The full 3-step framework — included with this guide purchase
DELTA Model
A comprehensive framework outlining the five essential pillars an organization must build to successfully compete on analytics.
Start hereAssessing the organization's current state against each of the five pillars: Data, Enterprise, Leadership, Targets, and Analysts.
◆ The full 5-step framework — included with this guide purchase
Five-Stage Road Map to Analytical Competition
A maturity model that serves as a framework for action, describing the typical path organizations follow to become analytical competitors.
Start hereAn organization must first assess where it currently falls within the five stages by evaluating its attributes related to analytics, leadership, and strategy.
◆ The full 4-step framework — included with this guide purchase
Expected Value Problem Decomposition Framework
A framework that uses the structure of an expected value calculation to break down a complex, high-level business problem (e.g., 'maximize profit from a campaign') into smaller, concrete data science sub-problems (e.g., 'model probability of response' and 'model value of response').
Start hereA business decision that involves uncertainty and various outcomes with different values.
◆ The full 8-step framework — included with this guide purchase
Model Complexity Control via Nested Holdout
A general method for selecting the optimal complexity of a model (e.g., the number of nodes in a tree, the regularization parameter λ) to avoid overfitting, without 'contaminating' the final test set.
Start hereA modeling procedure with a tunable complexity parameter and a labeled dataset.
◆ The full 8-step framework — included with this guide purchase
From-Scratch Learning Framework
A pedagogical framework for understanding data science by implementing fundamental algorithms and mathematical tools from first principles before using high-level libraries.
Start hereStart with a basic understanding of Python.
◆ The full 6-step framework — included with this guide purchase
Sequential Layer-Based Neural Network Framework
An object-oriented framework for constructing neural networks by composing different types of 'Layers' in a sequence. Each layer handles its own forward pass and backward pass (gradient) calculations.
Start hereDefine individual layer types (e.g., `Linear`, `Sigmoid`, `Tanh`) that conform to a common `Layer` interface.
◆ The full 6-step framework — included with this guide purchase
Spreadsheet-First Data Science
A pedagogical and practical framework for learning and applying data science techniques by starting with transparent spreadsheet implementations before graduating to more abstract, code-based tools.
Start hereA business problem with an associated dataset that is manageable in size.
◆ The full 5-step framework — included with this guide purchase
Unbundling the Database
A design philosophy for building data systems by composing specialized, loosely coupled components (event logs, stream processors, storage systems) rather than using a single monolithic database. Data flows between components via event streams, with transformations applied at each stage.
Start hereIdentify a derived data system, such as a search index or cache, that needs to be kept in sync with a primary database (system of record).
◆ The full 4-step framework — included with this guide purchase
Reliability-Scalability-Maintainability (RSM) Analysis Framework
A mental model for evaluating and reasoning about the design of a data-intensive application. It encourages a structured approach to analyzing trade-offs by focusing on three key non-functional requirements.
Start hereFor any new system or feature, explicitly define expectations in terms of reliability (tolerating faults), scalability (coping with load), and maintainability (ease of operations, simplicity, and evolvability).
◆ The full 3-step framework — included with this guide purchase
Event Sourcing
An application design pattern where all changes to application state are modeled and stored as a sequence of immutable events. The current state is derived by replaying these events.
Start hereIdentify a core business entity and its state changes. Instead of designing a mutable database table for it, design a log to store events representing user actions.
◆ The full 4-step framework — included with this guide purchase
Foundational ML to Deep Learning Progression Path
A structured learning path for mastering machine learning, starting with fundamental algorithms and concepts before advancing to complex deep learning architectures.
Start hereBasic Python programming experience and familiarity with scientific libraries (NumPy, pandas, Matplotlib). College-level math is recommended for a deeper understanding.
◆ The full 6-step framework — included with this guide purchase
Analytical Maturity Framework
A framework describing the evolution of analytical tasks in terms of complexity and business value, moving from descriptive to prescriptive analytics.
Start hereSimple query reports that show what happened in the past (descriptive analytics).
◆ The full 4-step framework — included with this guide purchase
Bias-Variance Tradeoff
A conceptual framework for model selection that involves balancing two sources of error: bias (underfitting) and variance (overfitting).
Start hereDuring model selection, when comparing models of varying complexity.
◆ The full 4-step framework — included with this guide purchase
Feature Engineering and Selection Framework
A framework for managing the input variables for a model, involving the creation of new features and the elimination of irrelevant or redundant ones.
Start hereDuring the data preparation and exploration phase, after initial data collection.
◆ The full 4-step framework — included with this guide purchase
Feature Engineering via Stepwise Selection
An experimental framework for identifying the optimal subset of feature variables to use in a predictive model to improve performance and avoid using noisy or redundant data.
Start hereHaving a raw dataset with a large number of potential features after the initial data munging process.
◆ The full 2-step framework — included with this guide purchase
Polynomial Regression Degree Selection
A structured framework for determining the appropriate degree of polynomial to use in a regression model to capture non-linear relationships without overfitting the data.
Start hereAn exploratory scatterplot reveals a non-linear or curvilinear relationship between a predictor and the response variable.
◆ The full 4-step framework — included with this guide purchase
Training/Validation/Test Set Split Strategy
A framework for splitting a dataset to facilitate robust model selection and obtain an unbiased estimate of the model's generalization error on new data.
Start hereHaving a clean, labeled dataset ready for model building.
◆ The full 4-step framework — included with this guide purchase
Split-Apply-Combine for Group Operations
A powerful mental model for performing group-wise data analysis. Data is split into groups based on keys, a function is applied to each group independently, and the results are combined into a final data structure.
Start hereA pandas DataFrame or Series that needs to be summarized or transformed based on one or more categorical variables.
◆ The full 3-step framework — included with this guide purchase
The Layered Grammar of Graphics
A formal system for building plots by combining independent components. It asserts that any plot can be described as a combination of a dataset, a geom, a set of mappings, a stat, a position adjustment, a coordinate system, and a faceting scheme.
Start hereBegin with a dataset and use the `ggplot()` function.
◆ The full 6-step framework — included with this guide purchase
BI Maturity Model
A framework to assess an organization's current BI capabilities and chart a path for evolution across four key dimensions: People/Culture, Data, Processes, and Technology.
Start hereInitial Stage: Characterized by gut-feel decision-making, siloed data in spreadsheets, and BI capabilities limited to reports within operational systems.
◆ The full 3-step framework — included with this guide purchase
Enterprise Data Warehouse Bus Architecture
An architectural framework for building an enterprise-wide data warehouse in an incremental, decentralized manner while ensuring data integration.
Start hereSelect a high-impact, high-feasibility business process from the enterprise data warehouse bus matrix to implement as the first project.
◆ The full 4-step framework — included with this guide purchase
Checklists
Roadblocks to an Analytical Culture
- Analyses are performed, but the business does not change anything as a result.
- Organizational structure (e.g., by product category) encourages siloed decisions that harm overall profitability.
- The organization persists with traditional activities (e.g., newspaper circulars) despite little evidence of their effectiveness.
- Decision-making is driven by power and politics, not objective analysis.
- There is 'analytical overconfidence' where the organization thinks it's better at analytics than it is.
- Analysts are treated as a specialty 'black box' function, not embedded in the business.
- Managers are not open to hearing analytical results they don't expect or believe.
Checklist for a Good Analytical Target
◆ All 5 checkpoints — included with this guide purchase
Attributes of an Analytical Leader
◆ All 10 checkpoints — included with this guide purchase
The Five Cs of Data Quality
◆ All 5 checkpoints — included with this guide purchase
BI Readiness Assessment Checklist
◆ All 5 checkpoints — included with this guide purchase
BI Design Layout Best Practices
◆ All 8 checkpoints — included with this guide purchase
Common BI Justification Pitfalls (to Avoid)
◆ All 4 checkpoints — included with this guide purchase
Common Requirements Definition Mistakes (to Avoid)
◆ All 5 checkpoints — included with this guide purchase
BI System Core Properties Checklist
◆ All 4 checkpoints — included with this guide purchase
Characteristics of Analytical Leaders
◆ All 4 checkpoints — included with this guide purchase
Questions to Ask When Evaluating New Analytical Initiatives
◆ All 5 checkpoints — included with this guide purchase
Signposts of Effective IT for Analytical Competition
◆ All 6 checkpoints — included with this guide purchase
Checklist for Analytical Leadership
◆ All 6 checkpoints — included with this guide purchase
Evaluation Checklist for New Analytical Initiatives
◆ All 7 checkpoints — included with this guide purchase
Proposal Review Guide
◆ All 11 checkpoints — included with this guide purchase
Data Science Problem Formulation Checklist
◆ All 8 checkpoints — included with this guide purchase
Machine Learning Project Checklist
◆ All 26 checkpoints — included with this guide purchase
Data Science Project Initiation Checklist
◆ All 4 checkpoints — included with this guide purchase
Data Exploration Checklist
◆ All 5 checkpoints — included with this guide purchase
Model Selection Checklist
◆ All 5 checkpoints — included with this guide purchase
Data Munging Best Practice Guidelines
◆ All 7 checkpoints — included with this guide purchase
A 'Well-Behaved' Residuals vs. Fitted Values Plot
◆ All 3 checkpoints — included with this guide purchase
Goals for Expository Plots
◆ All 4 checkpoints — included with this guide purchase
Initial Data Cleaning Checklist
◆ All 8 checkpoints — included with this guide purchase
Components of a Reproducible Example (reprex)
◆ All 6 checkpoints — included with this guide purchase
Data Foundation Health Checklist
◆ All 8 checkpoints — included with this guide purchase
Common Dimensional Modeling Mistakes to Avoid
◆ All 10 checkpoints — included with this guide purchase
Case studies — including what didn't work
Hotels.com: Voice of the Customer
In 2006, online travel site Hotels.com wanted to shift its culture from low-cost provider to one focused on customer experience. Standard web analytics showed growth but masked a range of site problems.
The company implemented a 'voice of the customer' program combined with web analytics. This allowed customers to report problems in-session and used software to record user screens and mouse clicks. They even used hundreds of unique phone numbers on different site pages to pinpoint where users ran into trouble.
An early 'big find' revealed a high percentage of customers abandoned the final checkout page due to bugs and unclear messaging. Fixing these issues led to immediate revenue gains and demonstrated the power of deep analytics. The cross-functional team continued to meet and discovered hundreds of additional opportunities, substantially improving the site's conversion rate and customer goodwill.
Best Buy: Driving to an Analytical Enterprise
Around 2006, Best Buy's leadership, committed to a 'customer centricity' strategy, realized that while corporate had data, it wasn't being used for fact-based decisions at the store level where employees interact with customers.
◆ What happened, and the outcome — included with this guide purchase
Progressive Insurance: Staying Ahead of the Competition
Progressive has a long history of being an analytical competitor, pioneering the use of credit scores for underwriting. However, in the insurance industry, innovations are easily copied by competitors.
◆ What happened, and the outcome — included with this guide purchase
Will Smith, Analytical Amateur
Actor Will Smith has an unusually successful track record at the box office.
◆ What happened, and the outcome — included with this guide purchase
Capital One: Adapting an Analytical Strategy
Capital One built its success on a highly analytical 'information-based strategy' in the credit card business. By 2005, it realized this single business was not sufficient for continued growth.
◆ What happened, and the outcome — included with this guide purchase
Google Flu Trends
Public health surveillance in the United States during the 2009 H1N1 flu outbreak.
◆ What happened, and the outcome — included with this guide purchase
Target's Pregnancy Prediction
Customer analytics at a major U.S. discount retailer.
◆ What happened, and the outcome — included with this guide purchase
Farecast Airline Ticket Prediction
Consumer e-commerce for travel.
◆ What happened, and the outcome — included with this guide purchase
Matthew Maury and Ocean Charts
19th-century naval and commercial shipping.
◆ What happened, and the outcome — included with this guide purchase
Moneyball and Baseball Analytics
Professional baseball team management in the early 2000s.
◆ What happened, and the outcome — included with this guide purchase
Robert McNamara and the Vietnam 'Body Count'
U.S. military strategy during the Vietnam War.
◆ What happened, and the outcome — included with this guide purchase
Case Study 1: Finding the Winning Strategy in a Card Game
A card game where a 52-card deck (half red, half black) is flipped one by one. The player can halt the game at any time, and wins if the *next* card flipped is red.
◆ What happened, and the outcome — included with this guide purchase
Case Study 2: Assessing Online Ad-Clicks for Significance
A bistro owner, Fred, tests 30 different ad text colors to see if any generate significantly more clicks than the default blue color. Each color is shown 100 times per day for 20 days.
◆ What happened, and the outcome — included with this guide purchase
Case Study 3: Tracking Disease Outbreaks Using News Headlines
An analyst at the American Institute of Health must process hundreds of daily news headlines to identify and cluster disease outbreaks by geographic location.
◆ What happened, and the outcome — included with this guide purchase
Presidential Campaign Data Mining
A recent presidential campaign aiming to persuade undecided voters in swing states.
◆ What happened, and the outcome — included with this guide purchase
Client Budgeting Spreadsheet Error
A consulting project to replace a spreadsheet-based budgeting system at a multi-billion dollar company.
◆ What happened, and the outcome — included with this guide purchase
Amazon's Recommender System
Amazon.com sought to increase sales by suggesting relevant products to customers browsing its online store.
◆ What happened, and the outcome — included with this guide purchase
Netflix's Content Recommendation
The online video streaming service needed to keep users engaged and subscribed by helping them discover content they would enjoy from a vast library.
◆ What happened, and the outcome — included with this guide purchase
McLaren F1 Racing Analytics
A Formula One racing team needed to optimize car performance and make critical decisions in real-time during high-speed races.
◆ What happened, and the outcome — included with this guide purchase
US Xpress Fleet Optimization
A large US trucking company aimed to reduce operational costs and improve the efficiency of its fleet of trucks.
◆ What happened, and the outcome — included with this guide purchase
Netflix's Recommendation and Content Strategy
The online streaming and movie rental industry in the 2000s and 2010s.
◆ What happened, and the outcome — included with this guide purchase
Caesars Entertainment's Customer Loyalty Program
The highly competitive US casino and gaming industry.
◆ What happened, and the outcome — included with this guide purchase
Capital One's 'Information-Based Strategy'
The US credit card industry of the 1990s and 2000s.
◆ What happened, and the outcome — included with this guide purchase
UPS and the ORION Project
Global logistics and package delivery operations.
◆ What happened, and the outcome — included with this guide purchase
The 'Moneyball' Revolution in Baseball
Major League Baseball in the early 2000s.
◆ What happened, and the outcome — included with this guide purchase
Progressive's Analytical Underwriting
The US auto insurance industry, a largely commoditized market.
◆ What happened, and the outcome — included with this guide purchase
Netflix: From DVD Rentals to Content Producer
An online DVD rental company evolving into a global streaming and content production powerhouse in the early 2000s and 2010s.
◆ What happened, and the outcome — included with this guide purchase
Caesars Entertainment: Data-Driven Hospitality
The US casino and gaming industry in the late 1990s and 2000s, which was transitioning from building new properties to growing revenue from existing ones.
◆ What happened, and the outcome — included with this guide purchase
Google's People Operations
The human resources function within a hyper-growth, data-centric technology company.
◆ What happened, and the outcome — included with this guide purchase
Capital One's Data-Driven Strategy
The consumer credit card industry in the 1980s and 1990s, when credit terms were largely uniform.
◆ What happened, and the outcome — included with this guide purchase
Walmart's Hurricane Frances Preparation
Retail logistics and sales forecasting at Walmart in anticipation of Hurricane Frances in 2004.
◆ What happened, and the outcome — included with this guide purchase
Mining News Stories to Predict Stock Price Movement
Predicting significant daily price changes (surge or plunge) for NYSE and NASDAQ stocks based on the text of financial news stories from 1999.
◆ What happened, and the outcome — included with this guide purchase
Targeted Charity Mailing
A fundraising organization wants to solicit donations from a list of prospects, balancing solicitation costs against expected donation amounts.
◆ What happened, and the outcome — included with this guide purchase
Finding Key Connectors at DataSciencester
The book's framing narrative of a fictional social network for data scientists. The VP of Networking wants to identify influential users.
◆ What happened, and the outcome — included with this guide purchase
Iris Dataset Classification
A classic machine learning dataset containing sepal/petal measurements for three species of iris flowers is used to test a classification algorithm.
◆ What happened, and the outcome — included with this guide purchase
SpamAssassin Spam Filtering
Using the SpamAssassin public corpus to build a model that can distinguish spam emails from non-spam ('ham') emails based on their subject lines.
◆ What happened, and the outcome — included with this guide purchase
MovieLens 100k Recommender System
Using the MovieLens dataset, which contains user ratings for various movies, to build a model that can predict a user's rating for a movie they haven't seen.
◆ What happened, and the outcome — included with this guide purchase
Solving FizzBuzz with a Neural Network
A classic, simple programming problem is used to test if a neural network can learn rules of divisibility without being explicitly programmed for them.
◆ What happened, and the outcome — included with this guide purchase
Joey Bag O' Donuts Wholesale Wine Emporium
An e-mail marketer for a wholesale wine business sought to segment customers to improve marketing targeting.
◆ What happened, and the outcome — included with this guide purchase
Predicting Pregnant Customers at RetailMart
A marketing manager at a large retail store ('RetailMart,' an analogue for Target) aimed to identify pregnant customers to target them with relevant marketing before their baby arrived.
◆ What happened, and the outcome — included with this guide purchase
Mandrill Tweet Classification
The author's company, MailChimp, had a product named 'Mandrill,' and tweets about it were being lost in a stream of unrelated tweets about an animal, a video game character, and a band with the same name.
◆ What happened, and the outcome — included with this guide purchase
Handcrafting and Selling Swords
An artisan who makes and sells replica swords from 'The Lord of the Rings' online needs to forecast future demand to better manage materials and production.
◆ What happened, and the outcome — included with this guide purchase
Scaling Twitter's Home Timeline
Twitter's service for generating a user's home timeline (a feed of tweets from people they follow) was struggling with high read load.
◆ What happened, and the outcome — included with this guide purchase
GitHub Replication Lag Incident
A primary MySQL database replica failed during a period of high load.
◆ What happened, and the outcome — included with this guide purchase
Amazon Dynamo's Shopping Cart
Amazon's shopping cart service needs to be highly available, allowing users to add items even if some database nodes are down or there are network issues.
◆ What happened, and the outcome — included with this guide purchase
Leap Second Outages
Coordinated Universal Time (UTC) occasionally adds a 'leap second' to stay in sync with Earth's rotation, resulting in a minute that has 61 seconds.
◆ What happened, and the outcome — included with this guide purchase
California Housing Price Prediction Project
The book presents a fictional scenario where a data scientist is hired by a real estate company to build a model that predicts median housing prices in California districts using census data.
◆ What happened, and the outcome — included with this guide purchase
Spam Classification Project
Exercise 4 in Chapter 3 challenges the reader to build a spam classifier from scratch.
◆ What happened, and the outcome — included with this guide purchase
Subscription Fraud Detection
A telecommunications company where fraudsters use stolen or synthetic identities to acquire devices and services with no intention of paying.
◆ What happened, and the outcome — included with this guide purchase
Churn Model for Telecommunications
A telecommunications company with millions of customers exhibiting diverse behaviors, making it difficult for a single model to predict churn effectively.
◆ What happened, and the outcome — included with this guide purchase
Bad Debt Tax Savings
In some markets, telecommunications companies must pay sales tax when a bill is issued, not when it is paid. If a customer defaults, the company loses both the revenue and the tax paid.
◆ What happened, and the outcome — included with this guide purchase
Smart Cities Commuting Route Optimization
The city of Rio de Janeiro needed to understand and improve daily commuting routes for its large population.
◆ What happened, and the outcome — included with this guide purchase
Netflix Prize
A celebrated data science competition sponsored by Netflix to improve the accuracy of its movie recommendation engine.
◆ What happened, and the outcome — included with this guide purchase
Google Flu Trends (GFT) Failure
A highly publicized project by Google that attempted to predict flu outbreaks faster than the CDC by using Google search query data.
◆ What happened, and the outcome — included with this guide purchase
Heritage Health Prize
A major Kaggle competition with a $500,000 prize, sponsored by Heritage Provider Network, to develop an algorithm to predict and prevent unnecessary hospitalizations.
◆ What happened, and the outcome — included with this guide purchase
Acquire Valued Shoppers Challenge
A Kaggle competition that asked participants to predict which shoppers, when given a discount offer, would become loyal, repeat customers.
◆ What happened, and the outcome — included with this guide purchase
Bitly 1.USA.gov URL Shortening Data Analysis
Analysis of a 2011 dataset containing anonymous data from users shortening .gov or .mil URLs, stored in JSON format.
◆ What happened, and the outcome — included with this guide purchase
MovieLens 1M Dataset Analysis
Analyzing a dataset of 1 million movie ratings from 6,000 users on 4,000 movies, spread across three separate files (ratings, users, movies).
◆ What happened, and the outcome — included with this guide purchase
US Baby Names 1880–2010 Analysis
Analyzing trends in the frequency of baby names from 1880 to 2010, using yearly data files from the US Social Security Administration.
◆ What happened, and the outcome — included with this guide purchase
USDA Food Database Wrangling
Processing a JSON database of food nutrient information from the US Department of Agriculture, where each food item contains a nested list of nutrient data.
◆ What happened, and the outcome — included with this guide purchase
Tidying WHO Tuberculosis Data
The `who` dataset from the `tidyr` package contains messy tuberculosis case data from the World Health Organization, where variables are encoded in column names.
◆ What happened, and the outcome — included with this guide purchase
Why are low-quality diamonds more expensive?
An exploratory analysis of the `diamonds` dataset revealed a surprising inverse relationship between diamond quality and price.
◆ What happened, and the outcome — included with this guide purchase
What Affects the Number of Daily Flights?
An analysis of the number of flights departing NYC per day from the `nycflights13` dataset to understand its patterns.
◆ What happened, and the outcome — included with this guide purchase
Analyzing Gapminder Data with Many Models
Exploring the relationship between life expectancy and year across all countries in the `gapminder` dataset.
◆ What happened, and the outcome — included with this guide purchase
Netflix: Analytics as Corporate DNA
A DVD-by-mail and streaming video company operating in a highly competitive entertainment market.
◆ What happened, and the outcome — included with this guide purchase
1-800 CONTACTS: Making BI Relevant to Front-line Workers
An online contact lens retailer with a large call center, facing high employee turnover and frustration.
◆ What happened, and the outcome — included with this guide purchase
Dow Chemical: The Power of a Data Foundation and a Little Luck
A large, global chemical company with disparate regional systems in the early 1990s.
◆ What happened, and the outcome — included with this guide purchase
Emergency Medical Associates (EMA): Using BI to Improve Patient Care
A physician group managing emergency departments (EDs) in several hospitals, facing pressures from rising healthcare costs and declining reimbursement rates.
◆ What happened, and the outcome — included with this guide purchase
Continental vs. United Airlines Merger
The 2010 merger of Continental Airlines, known for its agile BI approach, and United Airlines, which used a more traditional waterfall method.
◆ What happened, and the outcome — included with this guide purchase
Retail Sales (Chapter 3)
A grocery store chain analyzing point-of-sale (POS) data.
◆ What happened, and the outcome — included with this guide purchase
Inventory (Chapter 4)
The same grocery store chain now needs to analyze inventory levels.
◆ What happened, and the outcome — included with this guide purchase
Procurement (Chapter 5)
An organization purchasing products or services for use or resale.
◆ What happened, and the outcome — included with this guide purchase
Insurance (Chapter 16)
A property and casualty insurance company modeling its policy and claims processes.
◆ What happened, and the outcome — included with this guide purchase
Templates
Analytical Questions Matrix
To inventory current analytical activities and identify new opportunities for creating insight by mapping questions against time frame and level of innovation.
Create a 2x3 table. Rows: 'Information', 'Insight'. Columns: 'Past', 'Present', 'Future'. Cells: - Information/Past: What happened? (Reporting) - Information/Present: What is happening now? (Alerts) - Information/Future: What will happen? (Extrapolation) - Insight/Past: How and why did it happen? (Modeling, experimental design) - Insight/Present: What's the next best action? (Recommendation) - Insight/Future: What's the best/worst that can happen? (Prediction, optimization, simulation)
Ladder of Analytical Applications
To assess the maturity of analytics within a specific business process and set ambitions for climbing to higher levels of sophistication and value.
◆ The fillable template — included with this guide purchase
'Do We Have a Good Target?' Decision Tool
To evaluate the quality and feasibility of a potential analytical project or target.
◆ The fillable template — included with this guide purchase
Competitive Analytics Capability Model
To systematically assess competitors' analytical capabilities and strategic direction relative to your own.
◆ The fillable template — included with this guide purchase
BI Justification Document Template
To document the business and technical case for a BI project in order to obtain funding, resource commitments, and stakeholder agreement.
◆ The fillable template — included with this guide purchase
BI Program Road Map Template
To provide a living, high-level vision for the BI program over several years, listing planned projects and their attributes.
◆ The fillable template — included with this guide purchase
BI Requirements Document Template
To document in sufficient detail what a BI solution is supposed to do, serving as a 'contract' between business and IT and the input for system design.
◆ The fillable template — included with this guide purchase
Data Shadow System Triage Decision Tree
To categorize existing data shadow systems (e.g., spreadmarts) in order to prioritize which ones require renovation or replacement.
◆ The fillable template — included with this guide purchase
BI Application Content Specification Template
To design and document the specific contents of a single BI deliverable, like a dashboard or report.
◆ The fillable template — included with this guide purchase
Cost-Benefit Matrix
To systematically specify the value (positive for benefit, negative for cost) associated with each of the four possible outcomes of a binary classification model's decision (True Positive, False Positive, True Negative, False Negative).
◆ The fillable template — included with this guide purchase
K-Means Clustering Solver Template
To find 'k' clusters in a dataset of observations against features.
◆ The fillable template — included with this guide purchase
Holt-Winters Forecasting Template
To create a forecast for a time series with trend and seasonality.
◆ The fillable template — included with this guide purchase
Quorum Write/Read Formula
To configure the trade-off between consistency, availability, and latency in leaderless replication systems by ensuring an overlap between nodes that accept a write and nodes that are contacted for a read.
◆ The fillable template — included with this guide purchase
Isolation Level Anomaly Decision Tree
A mental tool to decide if a weaker transaction isolation level is sufficient, or if serializability is required, by identifying potential race conditions.
◆ The fillable template — included with this guide purchase
Activation Function Selection Heuristic
To guide the choice of activation functions for hidden and output layers in a deep neural network.
◆ The fillable template — included with this guide purchase
Dimensionality Reduction Algorithm Selection Heuristic
To choose an appropriate dimensionality reduction technique based on dataset size and characteristics.
◆ The fillable template — included with this guide purchase
Optimizer and Learning Rate Schedule Selection Heuristic
To choose an effective optimizer and learning rate schedule for training a DNN.
◆ The fillable template — included with this guide purchase
Decision Tool for Selecting Polynomial Degree
To determine the simplest polynomial regression model that sufficiently explains the relationship between a predictor and response, avoiding unnecessary complexity.
◆ The fillable template — included with this guide purchase
Data Discretization with pandas.cut
To segment continuous data into discrete bins or categories, which can then be used for summary statistics or as a categorical feature in modeling.
◆ The fillable template — included with this guide purchase
Basic ggplot2 Graphing Template
To provide a reusable structure for creating basic plots with ggplot2.
◆ The fillable template — included with this guide purchase
Expanded Grammar of Graphics Template
A comprehensive template for building plots with ggplot2, explicitly showing all seven parameters of the grammar.
◆ The fillable template — included with this guide purchase
BI Technology Evaluation Framework (MVP Framework)
To help a BI team evaluate and prioritize investments in new and emerging BI technologies based on their maturity, value, and potential to make BI more pervasive.
◆ The fillable template — included with this guide purchase
Enterprise Data Warehouse Bus Matrix Template
To plan and visualize the data architecture of an enterprise data warehouse, showing how different business processes relate to a shared set of standardized dimensions.
◆ The fillable template — included with this guide purchase
Fact Table Type Decision Tree
To determine which of the three fundamental fact table types (Transaction, Periodic Snapshot, or Accumulating Snapshot) is most appropriate for a given business process.
◆ The fillable template — included with this guide purchase
Items marked Paid are included when you buy this guide.
Movement IV
Reflect
Compare the evidence, disagreements and limits of the advice.
How good is it — the evidence, where the field disagrees, and how far to trust the advice.
- — What the research substantiates (and doesn't)
- — 6 tensions the canon hasn't settled
Tensions — choices to make, not settled answers
The model's constructs are drawn from the source element(s); load-bearing constructs are corroborated across the shelf, emerging ones are flagged.
Ideas covered by the source notes
- Data Quality, Cleaning & Preparation
- Data Architecture, Storage & Integration
- Feature Engineering & Attribute Selection
- Business Problem Framing & Definition
- Model & Method Selection
- Model Complexity & Flexibility
Movement IV · Measure · The evidence
The evidence behind the advice
We don’t just assert — we show the research the ideas rest on: the study, its key finding, what it means for you, and the citation to chase it yourself. Then a curated path to go deeper. Grounded, not hand-waved.
The studies
The empirical backing, with findings and citations — trace any claim to its source.
Market efficiency and the valuation of skills in professional sports.
The Moneyball Anomaly and Payroll Efficiency: A Further Investigation
The analysis provided econometric support for the claim of mis-pricing in the baseball labor market's valuation of batting skills (specifically, undervaluing on-base percentage). It also found evidence that this mis-pricing decreased sharply as statistical knowledge spread throughout baseball.
A competitive advantage derived from a novel analytical insight is often temporary. Once competitors adopt the same analytics, the advantage dissipates.
This study provides empirical evidence for a core theme of the book: to sustain a competitive advantage from analytics, an organization must continuously review its approach and innovate, because competitors will eventually catch up.
Jahn K. Hakes and Raymond D. Sauer, 'The Moneyball Anomaly and Payroll Efficiency: A Further Investigation,' Clemson University working paper, September 2007. (Note 7, Chapter 9)
Using large-scale search query data as a real-time proxy for disease surveillance.
Detecting Influenza Epidemics Using Search Engine Query Data
A combination of 45 specific search terms, when used in a mathematical model, showed a strong correlation with official CDC flu figures nationwide and by region.
Big data from internet searches can provide a faster, near real-time public health surveillance tool compared to traditional, lagging methods.
Prime example of N=all, messiness, and correlation, showing how big data provides new insights and value without needing to establish causality.
Ginsburg, Jeremy, et al. 'Detecting Influenza Epidemics Using Search Engine Query Data,' Nature 457 (2009).
Investigating the link between long-term cellphone use and the risk of brain tumors.
Danish Cohort Study on Mobile Phones and Brain Tumors
The study did not detect any increase in the risk of cancer associated with the use of mobile phones, even for long-term users.
Large-scale, combined datasets can provide more robust answers to public health questions than smaller, sample-based studies which are prone to error and bias.
Demonstrates the power of combining multiple N=all datasets ('recombinant data') to conduct large-scale, robust analysis that would be impossible with traditional methods.
Frei, Patrizia, et al. 'Use of Mobile Phones and Risk of Brain Tumours: Update of Danish Cohort Study,' BMJ 343 (2011).
The effect of data volume on the performance of machine learning algorithms.
Microsoft's Scaling of Natural Language Disambiguation
The performance of all four algorithms improved dramatically with more data. A simple algorithm that performed worst on a small dataset became the best performer when given a billion words of data. This suggests data volume can be more important than algorithm sophistication.
The performance of many AI systems is fundamentally limited by data availability. More, 'messy' data often trumps better, more elaborate algorithms on less data.
A key piece of evidence for the book's theses that 'more trumps better' (more data over better algorithms) and that accepting messiness can be beneficial.
Banko, Michele, and Eric Brill, 'Scaling to Very Very Large Corpora for Natural Language Disambiguation,' (2001).
Using big data from search queries for real-time epidemic surveillance.
Detecting influenza epidemics using search engine query data (Google Flu Trends)
The initial paper in *Nature* (2009) claimed a high correlation (0.977) between their predictions and CDC data, and that their system could 'nowcast' flu activity 1-2 weeks faster. However, it later famously over-predicted the peak of the 2012-2013 flu season by over 50%.
Demonstrated the potential of using big data for public health but also highlighted significant pitfalls like 'big data hubris,' spurious correlations, and model decay as behavior changes over time.
A core case study used in the book to illustrate both the promise and the perils of big data analytics, especially the problem of correlation vs. causation.
Ginsberg J, Mohebbi MH, Patel RS, Brammer L, Smolinski MS, Brilliant L. (2009). Detecting influenza epidemics using search engine query data. Nature, 457(7232), 1012-4. (Citation inferred from context).
Using mobile phone data (CDRs) for rapid disaster response and population movement tracking.
Rapid and Near Real-Time Assessments of Population Displacement Using Mobile Phone Data Following Disasters: The 2015 Nepal Earthquake
The team was able to start analyzing data immediately and provide information to disaster relief organizations within nine days of the earthquake. This was possible due to a pre-existing agreement and technical setup with the mobile provider.
Shows that with proper preparation (data sharing agreements, technical infrastructure), big data from mobile phones can be a powerful tool for humanitarian response, helping to direct aid and resources to where they are most needed.
A key example of big data being used for social good, demonstrating the power of real-time analytics and the importance of data access in a crisis.
Wilson, R., et al. (2016). PLOS Currents Disasters. (The book provides this level of detail, allowing for a more specific, though still inferred, citation).
The relationship between an organization's analytical orientation and its business performance.
Enterprise Systems and Analytics Value Survey (2006)
A strong, statistically significant positive correlation was found between a company's analytical orientation and its financial performance. High-performing companies were dramatically more likely than low performers to have significant analytical capabilities (65% vs 23%), to value analytical insights (36% vs 8%), and to use analytics broadly (40% vs 23%).
The study provides empirical evidence that investing in and developing an enterprise-wide analytical capability is not just a technological exercise but a key driver of high business performance. It justifies treating analytics as a strategic imperative.
This study is central to the book's thesis. It provides the quantitative evidence for the claim in the book's subtitle ('The New Science of Winning'), demonstrating that competing on analytics is not just a theory but a practice strongly associated with superior business results.
Described in Chapter 3 of the book, citing 'Jeanne G. Harris and Thomas H. Davenport, New Growth from Enterprise Systems (Wellesley, MA: Accenture Institute for High Performance Business, May 2006)'.
A method for constructing decision trees for classification (categorical outcome) and regression (numerical outcome) tasks.
Classification and Regression Trees
The paper laid out a robust, non-parametric method for prediction and classification that is highly interpretable.
Provided a powerful and transparent alternative to linear models, which became a foundational technique in machine learning and data mining.
This paper is the primary source for the methods described in Chapter 9, 'Classification and Regression Trees'.
Breiman, L., Friedman, J., Olshen, R., and Stone, C. (1984). Classification and Regression Trees. Boca Raton, FL: Chapman Hall/CRC.
The impact of Data-Driven Decision-making (DDD) on firm productivity.
Strength in Numbers: How Does Data-Driven Decision Making Affect Firm Performance?
The more data-driven a firm is, the more productive it is. A one standard deviation increase on the DDD scale is associated with a 4-6% increase in productivity. DDD is also correlated with higher ROA, ROE, asset utilization, and market value. The relationship appears to be causal.
Provides strong quantitative evidence for the business value of investing in data and analytics capabilities.
It provides foundational, empirical evidence for the book's central claim that data is a strategic asset and improving data-driven decision-making improves business performance.
Brynjolfsson, Hitt, & Kim, 2011
Predictability of personal attributes from Facebook 'Likes'.
Private traits and attributes are predictable from digital records of human behavior
A wide range of personal attributes can be predicted with surprisingly high accuracy from Facebook Likes alone. This includes sexual orientation (88% accuracy for males), political party (85%), religion (82%), and personality traits. The book specifically uses it to show evidence lifts of certain Likes for predicting high IQ.
Raises significant privacy concerns, as predicting sensitive information is possible from publicly available digital records. Also demonstrates the power of using simple, abundant data for powerful predictive modeling.
Serves as a modern, compelling case study for the power of evidence lifts, Naive Bayes classification, and the broader idea that digital traces of behavior are rich sources for data mining.
Kosinski, Stillwell, & Graepel, 2013
Disentangling social influence from homophily in social networks.
Distinguishing influence-based contagion from homophily-driven diffusion in dynamic networks
Traditional methods for calculating influence in viral marketing can overestimate the effect by 700% or more. Much of what appears to be influence is actually just homophily (people are similar to their friends).
Critically important for viral marketing strategies. A campaign based on a flawed assumption of high influence will likely fail. One must measure true influence to accurately forecast the spread of a product or idea through a network.
Used as the primary example of why causal explanation is a distinct and important data science task that goes beyond simple predictive modeling based on correlation.
Aral, Muchnik, & Sundararajan, 2009
The fundamental limits of fault-tolerant consensus in an asynchronous system.
Impossibility of Distributed Consensus with One Faulty Process (FLP Result)
No such always-terminating consensus algorithm exists. Any consensus algorithm in this model must either risk never reaching a decision (violating termination) or risk nodes deciding on different outcomes if it doesn't wait for a reply (violating agreement).
Consensus is only solvable in practice by relaxing the assumptions of the asynchronous model, for instance by using timeouts to detect suspected crashed nodes (moving to a partially synchronous model).
Provides the theoretical foundation for why consensus is a hard problem and why many systems opt for weaker consistency models or use specific algorithms (like Paxos/Raft) that make certain timing assumptions.
Fischer, M. J., Lynch, N., & Paterson, M. S. (1985). Impossibility of distributed consensus with one faulty process. Journal of the ACM, 32(2), 374-382.
Implementing externally consistent (linearizable) distributed transactions at global scale.
Spanner: Google’s Globally-Distributed Database
By having transactions wait for the duration of the clock uncertainty interval before committing, Spanner can guarantee that transaction timestamps are consistent with causality. This allows it to use timestamps for concurrency control and provide linearizable transactions and consistent reads across datacenters.
Provides a new model for implementing strongly consistent distributed databases by making clock uncertainty a first-class citizen, challenging the idea that global consistency must be slow.
A key case study showing that strong consistency at global scale is achievable, and illustrating the deep connection between time, clocks, and consistency models. It provides a counterpoint to the idea that all large-scale systems must be eventually consistent.
Corbett, J. C., et al. (2012). Spanner: Google's globally-distributed database. In 10th USENIX Symposium on Operating System Design and Implementation (OSDI).
The ambiguity and insufficiency of the standard SQL transaction isolation levels.
A Critique of ANSI SQL Isolation Levels
The standard's definitions are ambiguous and based on informal English descriptions of phenomena (dirty reads, non-repeatable reads, phantoms) rather than a formal model. This has led to different database systems implementing the same named isolation level with wildly different guarantees.
The name of an isolation level is not enough; developers must understand the specific implementation and guarantees of their chosen database to avoid subtle concurrency bugs.
Central to the book's argument in Chapter 7 that weak isolation levels are complex and dangerous, and that 'ACID' is often just a marketing term. It justifies the need for a deep dive into concurrency control mechanisms.
Berenson, H., et al. (1995). A critique of ANSI SQL isolation levels. In ACM International Conference on Management of Data (SIGMOD).
The problem of unstable gradients (vanishing and exploding) in deep neural networks and a proposed solution via a novel weight initialization strategy.
Understanding the Difficulty of Training Deep Feedforward Neural Networks
The combination of the logistic sigmoid activation function and standard random weight initialization causes the variance of layer outputs to be much greater than the inputs, leading to saturation and vanishing gradients. The proposed initialization strategy, where weights are drawn from a distribution with variance `1 / fan_avg`, significantly alleviates this problem and allows for much deeper networks to be trained successfully.
Introduced a new standard for weight initialization that became a critical component in enabling the successful training of deep neural networks, thus contributing significantly to the Deep Learning revolution.
This study is central to Chapter 11, which explains why training deep nets is hard and presents Glorot initialization as a primary solution to the vanishing/exploding gradients problem.
Xavier Glorot and Yoshua Bengio, “Understanding the Difficulty of Training Deep Feedforward Neural Networks,” Proceedings of the 13th International Conference on Artificial Intelligence and Statistics (2010): 249–256.
Enabling the training of extremely deep neural networks (100+ layers) through the use of residual connections (skip connections).
Deep Residual Learning for Image Recognition
Deeper 'plain' networks showed higher training and test error (degradation problem), while ResNets did not. An 8-layer-deeper ResNet was easier to optimize and had lower training error. A 152-layer ResNet won the ILSVRC 2015 challenge with a 3.57% top-5 error rate.
ResNets demonstrated that training networks of unprecedented depth was possible and effective, setting a new standard for deep network architecture design.
ResNet is presented in Chapter 14 as a key, state-of-the-art CNN architecture, and its core concept—the residual unit—is explained in detail.
Kaiming He et al., “Deep Residual Learning for Image Recognition,” arXiv preprint arXiv:1512:03385 (2015).
A novel framework for training generative models through an adversarial process.
Generative Adversarial Nets
The GAN framework allows for the training of a generative model that produces sharp, realistic-looking samples. The generator learns to produce samples that are indistinguishable from real data to the discriminator. The framework provides a way to train generative models without needing an explicit definition of the probability density function.
GANs introduced a powerful new paradigm for generative modeling, leading to major breakthroughs in image generation, super-resolution, style transfer, and more.
GANs are a major topic in Chapter 17. The book explains the adversarial training process and implements both a simple GAN and a DCGAN.
Ian Goodfellow et al., “Generative Adversarial Nets,” Proceedings of the 27th International Conference on Neural Information Processing Systems 2 (2014): 2672–2680.
Investigating factors associated with the time until publication for clinical trials.
Publication of trials funded by the National Heart, Lung, and Blood Institute.
After adjusting for other covariates, studies with a positive result were 1.74 times more likely to be published at any point in time. Study impact and having a clinical endpoint were also significant predictors.
Highlights the presence of publication bias in clinical research, where the results of a study influence its likelihood and speed of publication.
Serves as a real-world example of applying Cox's proportional hazards model to censored data and demonstrates how multiple regression can uncover relationships masked in simple univariate analyses (log-rank test).
Gordon et al. (2013) Publication of trials funded by the National Heart, Lung, and Blood Institute. New England Journal of Medicine, 369(20):1926–1934.
Network structure predicts group schism.
An information flow model for conflict and fission in small groups
The club split into two factions. The membership of these factions was almost perfectly predicted by a minimum cut partitioning of the friendship graph that separated the two leaders.
Social network analysis can reveal underlying fault lines in a social group before a conflict becomes overt.
A core illustrative example for graph theory, social network analysis, and the principle of structural balance.
Wayne Zachary. An information flow model for conflict and fission in small groups. Journal of Anthropological Research, 33(4):452-473, 1977.
Weak social ties are a crucial source of novel information.
The strength of weak ties
A large fraction of individuals found their jobs through personal contacts. Surprisingly, these contacts were more likely to be 'weak ties' (acquaintances) than 'strong ties' (close friends).
The structure of social networks, particularly the role of acquaintances, is critical for the spread of information and opportunity.
A central theory explained in the book, linking local network properties (tie strength) to global network phenomena (information diffusion).
Mark Granovetter. The strength of weak ties. American Journal of Sociology, 78:1360-1380, 1973.
People are connected by short chains of acquaintances.
An experimental study of the small world problem
Of the chains that completed, the median length was six steps. This provides evidence for the 'six degrees of separation' phenomenon.
Large social networks not only contain short paths, but their structure enables individuals with only local information to collectively find them.
A foundational case study for understanding path lengths, decentralized search, and the global structure of social networks.
Jeffrey Travers and Stanley Milgram. An experimental study of the small world problem. Sociometry, 32(4):425-443, 1969.
Test it yourself
Field experiments this shelf implies — designed so you can put the claim to the test.
Hypothesis
A targeted, analytically-driven promotion strategy will yield a higher return on investment (ROI) for a retailer than a traditional, mass-market newspaper circular, even if total sales lift is comparable.
A/B test across two matched geographic markets. In Market A (Control), the retailer continues its standard weekly advertising circular in the Sunday newspaper. In Market B (Treatment), the budget for the circular is reallocated to a direct mail and email campaign. The campaign targets different customer segments (identified from loyalty program data) with personalized offers based on predictive models of past purchase behavior and propensity to buy.
1. Marketing ROI (Incremental Profit / Marketing Cost) for each market. 2. Total sales lift in key product categories. 3. Customer response rate (coupon redemption, clicks). 4. Cost per customer contact.
Market B (Treatment) will demonstrate a significantly higher Marketing ROI. While total sales lift might be similar to or even slightly lower than Market A, the cost of the targeted campaign will be substantially lower due to the elimination of wasted mass-media spending, leading to greater profitability. This would provide evidence to overcome cultural inertia and shift away from ineffective traditional advertising.
Hypothesis
The 'ultramarine' ad color generates a statistically significant higher click-through rate than the 'blue' ad color.
Run a controlled A/B test where half the ads displayed are blue and the other half are ultramarine. All other variables (ad text, target audience, time of day) should be held constant.
The number of views and the number of clicks for each color group would be recorded daily over a fixed period (e.g., 20 days).
A permutation test on the click rates of the two groups would be conducted. If the resulting p-value is below the pre-determined significance level (e.g., 0.05), the hypothesis is confirmed, providing strong evidence to switch the ad color to ultramarine.
Hypothesis
Sending a promotional flyer to a voter will increase their propensity to move their opinion in favor of the Democratic candidate.
An A-B test design described as the basis for the Political Persuasion case study (Chapter 21.4). A sample of 10,000 voters is randomly split. The 'treatment' group (5,000 voters) is sent a flyer. The 'control' group (5,000 voters) is not. Opinion is measured for both groups via pre- and post-surveys.
The outcome variable is 'Moved_AD', a binary indicator of a positive shift in opinion. A 'Flyer' variable indicates treatment status. Other predictors include voter demographics, registration data, and past voting behavior.
While the overall effect of the flyer might be modest, an uplift model built on this data will identify specific voter segments for which the flyer has a large positive causal effect. The campaign can then target its resources to these 'persuadable' voters for maximum impact.
Hypothesis
Targeting customers with a special retention offer increases their probability of staying with the company compared to not targeting them.
Randomized Controlled Trial (RCT). A set of customers nearing contract expiration is randomly divided into two groups. The 'treatment' group receives the special retention offer. The 'control' group receives no offer. This design isolates the effect of the offer from other factors.
The primary measure is the churn rate (or its inverse, the retention rate) for each group, measured over a defined period (e.g., 90 days post-contract-expiration). A secondary measure could be the total profit/loss from each group, accounting for customer value and incentive costs.
The retention rate in the treatment group will be statistically significantly higher than in the control group. The magnitude of this difference, Δp = p(Stay|Offer) - p(Stay|No Offer), provides an estimate of the offer's influence, which can then be used to build a more sophisticated targeting model based on expected value lift.
Hypothesis
Modeling profitability based on experimental data on different credit terms will lead to more profitable customer acquisition than modeling default risk on existing data.
The book describes Signet Bank's historical experiment. They offered a wide variety of different credit terms (pricing, limits, etc.) at random to different segments of the consumer population, including those who would have been rejected by their old default model. This was an investment in creating a data asset.
Short-term: charge-off rates (unpaid balances), which were expected to increase. Long-term: profitability of different customer segments under different credit term offers.
Initial losses are expected due to offering credit to high-risk customers. However, the data gathered will allow the creation of superior models that predict customer profitability under various terms. These new models will enable the company to make more profitable offers, 'skim the cream' of customers, and ultimately achieve a lower charge-off rate and higher overall profit than competitors.
Go deeper
A curated reading ladder — not a dump. Each with why it’s worth your time.
- Competing on Analytics: The New Science of Winning · Thomas H. Davenport and Jeanne G. Harris
The authors' previous book, which provides the strategic context by describing the earliest and most aggressive adopters of analytics. This book builds on it by providing a 'how-to' guide for all organizations.
- Sources of Power: How People Make Decisions · Gary Klein
Discusses decision-making in high-pressure situations where there is no time for systematic data gathering, providing a contrast to the analytical approach and showing when intuition is necessary.
- The Black Swan: The Impact of the Highly Improbable · Nassim Nicholas Taleb
Argues that statistical analysis is limited because it cannot predict rare, high-impact 'black swan' events, serving as a cautionary note on the limits of analytics.
- Moneyball: The Art of Winning an Unfair Game · Michael Lewis
A popular case study of how the Oakland A's baseball team used an analytical approach to player selection to compete with richer teams, illustrating the power of competing on analytics.
- Why Great Leaders Don't Take Yes for an Answer · Michael Roberto
Describes how to foster a culture of constructive conflict and debate in decision-making processes, which is essential for an analytical culture where assumptions are tested and merit triumphs over politics.
- The Visual Display of Quantitative Information · Edward Tufte
A foundational work on how to create clear visual representations of data, a key skill for communicating analytical findings effectively.
- Super Crunchers: Why Thinking-By-Numbers Is the New Way to Be Smart · Ian Ayres
The book discusses how statistical analyses are replacing human intuition and expert judgment in decision-making, a core theme related to the discussion of 'Moneyball' and the demise of the expert.
- Seeing Like a State: How Certain Schemes to Improve the Human Condition Have Failed · James Scott
Documents how governments' fetish for quantification and data can lead to misguided and harmful policies, providing a deep historical context for the book's warnings about the 'dictatorship of data'.
- The War Managers · Douglas Kinnard
A survey of U.S. generals' views on the Vietnam War, revealing that the 'body count' metric was seen as a worthless and inflated measure of progress, illustrating the dangers of relying on flawed data.
- Thinking, Fast and Slow · Daniel Kahneman
Explains the cognitive biases that lead humans to see illusory causal links, which the author's argue big data correlations can challenge and disprove.
- Delete: The Virtue of Forgetting in the Digital Age · Viktor Mayer-Schönberger
Written by one of the co-authors, this book explores the societal implications of perfect digital memory, a theme connected to big data's challenges for privacy and the risk of being a 'prisoner of our past'.
- Big Data: A Revolution That Will Transform How We Live, Work, and Think · Viktor Mayer-Schönberger and Kenneth Cukier
Recommended by the author for Chapter 2, 'Why is big data special?'. This book provides a broader, non-technical exploration of the societal shifts and core concepts of the big data revolution, complementing the introduction's technical explanations.
- The Structure of Scientific Revolutions · Thomas S. Kuhn
Recommended for Chapter 4, 'Big data analytics'. The author uses Kuhn's concept of 'paradigm shift' to frame the move from traditional statistics to big data analytics, suggesting this book provides the theoretical background for that argument.
- Data Science for Business · Foster Provost and Tom Fawcett
Recommended for Chapter 6, 'Big data, big business'. This book likely offers a more in-depth, practical look at how the data analytics techniques introduced in the chapter are applied in a commercial context to solve business problems.
- No Place to Hide: Edward Snowden, the NSA, and the U.S. Surveillance State · Glenn Greenwald
Recommended for Chapter 7, 'Big data security and the Snowden case'. This book is a first-hand account from one of the journalists Snowden worked with, providing a detailed narrative of the leaks and their implications for privacy and security.
- The Internet of Things · Samuel Greengard
Recommended for Chapter 8, 'Big data and society'. This book would expand on the concepts of smart homes, smart cities, and the vast sensor network (IoT) that the author introduces as a key driver of big data's future societal impact.
- Building the Data Warehouse · Bill Inmon
Referenced as the source of the classic definition of a data warehouse (integrated, subject-oriented, time-variant, nonvolatile) and the originator of the Corporate Information Factory (CIF) architecture, a foundational but contrasting approach to the one proposed by Kimball.
- The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling · Ralph Kimball, Margy Ross
Referenced as the source for the enterprise data bus architecture and dimensional modeling principles. The book's approach to dimensional modeling is heavily influenced by Kimball's work.
- The Knowledge Creating Company · I. Nonaka and H. Takeuchi
This book provides the seminal theory on explicit vs. implicit knowledge and the 'spiral of knowledge' (SECI) model, which the author uses in Chapter 1 to frame the discipline of knowledge management.
- Design Science in Information Systems Research · A.R. Hevner, S. T. March, J. Park, & S. Ram
This academic paper provides the theoretical underpinning for how information systems should be designed and evaluated, which the author uses to ground the discussion of designing decision support systems in Chapter 1.
- Big Data: The Management Revolution · A. McAfee and E. Brynjolfsson
A frequently cited HBR article that frames Big Data not as a technology shift but as a fundamental shift in management, influencing the author's discussions on value creation and organizational transformation.
- Blink: The Power of Thinking Without Thinking · Malcolm Gladwell
Presented as a counterpoint to the book's thesis, exploring the value of intuitive decision-making in situations where analytics may not be feasible or appropriate.
- Good to Great: Why Some Companies Make the Leap . . . and Others Don't · Jim Collins
Supports the book's premise by independently finding that high-performing companies infuse their process with the 'brutal facts of reality,' aligning with a fact-based culture.
- Analytics at Work: Smarter Decisions, Better Results · Thomas H. Davenport, Jeanne G. Harris, and Robert Morison
The authors' own follow-up book which provides a more detailed explanation of the DELTA model, a key framework for building analytical capabilities mentioned in this text.
- The Long Tail: Why the Future of Business Is Selling Less of More · Chris Anderson
Cited to explain the strategy of analytical competitors like Netflix, who use recommendation engines to profit from a vast inventory of niche products ('the long tail') rather than just popular bestsellers.
- Classification and Regression Trees · Breiman, L., Friedman, J., Olshen, R., and Stone, C.
The book explicitly states this is the foundational text for the CART methodology, which is a central topic covered in Chapter 9.
- Predictive Analytics · Eric Siegel
Cited in Chapter 1 for providing several key real-world examples of predictive analytics applications, such as the IRS using models to find tax evasion and Telenor reducing customer churn.
- Analyzing the Social Web · Jennifer Golbeck
Explicitly credited in a footnote in Chapter 19 as having inspired the presentation of that chapter on social network analytics.
- Applied Logistic Regression · Hosmer, D. W., and Lemeshow, S.
Cited in Chapter 10 as a key reference for technical details on maximum likelihood estimation in logistic regression, a core statistical concept for that method.
- Now You See It / Show Me the Numbers · Stephen Few
Cited in Chapter 3 as an excellent resource for using graphs to report business data and for understanding the principles of visual perception in data visualization.
- The Elements of Statistical Learning: Data Mining, Inference, and Prediction · Hastie, T., Tibshirani, R., & Friedman, J.
The book refers to this as an excellent technical discussion for readers interested in the details of regularization techniques like ridge regression and the lasso.
- To explain or to predict? · Shmueli, G.
The book recommends this paper for readers interested in the deep-felt debate around the different goals of explanatory modeling versus predictive modeling.
- An introduction to ROC analysis · Fawcett, T.
Cited as a key reference for the Receiver Operating Characteristics (ROC) graph, a critical tool for model evaluation discussed in detail in the book.
- Privacy in Context · Nissenbaum, H.
Recommended as a book that delves deeply into the relationship between privacy and massive databases, for readers who want to think more seriously about the privacy and ethical implications of data science.
- Matrix factorization techniques for recommender systems · Koren, Y., Bell, R., & Volinsky, C.
Cited as a key paper written by members of the winning Netflix Challenge team, explaining the latent dimension approach (matrix factorization) for building recommender systems.
- Python for Data Analysis · Wes McKinney
Recommended as the best way to learn the pandas library, which is the primary Python tool for cleaning, munging, and manipulating data in real-world applications.
- The Elements of Statistical Learning · Jerome H. Friedman, Robert Tibshirani, and Trevor Hastie
Cited as a canonical (though math-heavy) textbook for gaining a deeper understanding of machine learning concepts.
- Introduction to Probability · Charles M. Grinstead and J. Laurie Snell
Recommended as a good, freely available textbook for readers who want to build a stronger foundation in probability theory.
- scikit-learn documentation · N/A
The book positions scikit-learn as the go-to library for production machine learning in Python, and its documentation is highlighted as a key resource for practical application.
- Deep Learning · Ian Goodfellow, Yoshua Bengio, and Aaron Courville
Presented as the canonical textbook on deep learning, for readers who want a mathematically rigorous and comprehensive understanding of the field.
- pandas documentation · N/A
The book repeatedly contrasts its from-scratch data manipulation with the more efficient and powerful methods available in the pandas library, making its documentation essential for practical work.
- The AIMMS optimization modeling book · AIMMS
Recommended as an 'incredible resource' for readers who want to learn more about linear and integer programming, with particularly useful 'Tips and Tricks' chapters.
- Data Mining with R: Learning with Case Studies · Luis Torgo
Presented as a 'great next step' for learning how to implement machine learning models in the R programming language, moving beyond the spreadsheet-based prototypes in the book.
- Forecasting, Time Series, and Regression · Bowerman et al.
A recommended textbook for those wishing to dive deeper into forecasting techniques beyond the exponential smoothing methods covered in the book.
- Free online forecasting textbook (otexts.com/fpp/) · Rob J. Hyndman
Highlighted as a key free resource from a leading expert whose work and R packages are foundational to modern time series analysis.
- Beginning R: The Statistical Programming Language · Mark Gardener
Recommended as an introductory text for readers looking to learn the R programming language after the brief tour in Chapter 10.
- Readings in Database Systems · Joseph M. Hellerstein and Michael Stonebraker
Provides historical context and original research papers for many of the foundational database concepts discussed in the book, such as B-trees, relational models, and query optimization.
- Concurrency Control and Recovery in Database Systems · Philip A. Bernstein, Vassos Hadzilacos, and Nathan Goodman
A classic textbook that provides the formal, theoretical underpinnings for the topics of transactions, concurrency control, and crash recovery discussed in Chapter 7 and 9.
- The Art of UNIX Programming · Eric S. Raymond
Explains the philosophy of composing small, single-purpose tools, which the book uses as a powerful analogy for designing dataflow systems and 'unbundling' databases.
- Weapons of Math Destruction · Cathy O'Neil
Directly cited in the final chapter, this book explores the ethical challenges and societal dangers of using algorithms and Big Data for decision-making, which is a key part of the book's closing argument.
- The Log: What Every Software Engineer Should Know About Real-Time Data's Unifying Abstraction · Jay Kreps
This influential blog post is a direct inspiration for the book's data integration and dataflow chapters, articulating the vision of the immutable log as the central component of a modern data architecture.
- Time, Clocks, and the Ordering of Events in a Distributed System · Leslie Lamport
This is the seminal paper that introduced logical clocks (Lamport timestamps) and the 'happens-before' relationship, which are foundational concepts for reasoning about causality and ordering in distributed systems, as discussed in Chapters 9 and 11.
- Data Science from Scratch · Joel Grus
Recommended for readers who want to understand ML fundamentals by implementing algorithms in pure Python, providing a from-the-ground-up perspective.
- Python Machine Learning · Sebastian Raschka
Cited as another great introductory book that leverages Python's open-source libraries to teach machine learning.
- Deep Learning with Python · François Chollet
Highly recommended as a practical guide to deep learning by the author of the Keras library, focusing on code examples over mathematical theory.
- The Hundred-Page Machine Learning Book · Andriy Burkov
Presented as an impressively concise book that covers a wide range of topics in approachable terms, including the math equations.
- Artificial Intelligence: A Modern Approach, 3rd Edition · Stuart Russell and Peter Norvig
A comprehensive book that helps put Machine Learning into the broader perspective of Artificial Intelligence.
- Hands-On Unsupervised Learning Using Python · Ankur Patel
Recommended as a deep dive into unsupervised learning techniques, written by one of the book's reviewers.
- Deep Learning with R · F. Chollet and J.J. Allaire
Referenced in the deep learning lab section as a resource for more details on applications using packages like Keras, particularly for using pretrained models.
- Learning Multiple Layers of Features from Tiny Images · A. Krizhevsky
Cited as the source for the CIFAR100 image database, a key dataset used to illustrate the application of Convolutional Neural Networks (CNNs).
- Deep residual learning for image recognition · He, Zhang, Ren, and Sun (2015)
Cited as the source for the resnet50 classifier, a powerful pre-trained CNN used in the book to demonstrate state-of-the-art image classification performance.
- Spectral regularization algorithms for learning large incomplete matrices · Mazumder, Hastie, and Tibshirani (2010)
This paper is referenced as the source for the 'Hard-Impute' algorithm (Algorithm 12.1) used for matrix completion with missing values via PCA.
- Data Scientist: The Sexiest Job of the 21st Century · T.H. Davenport and D.J. Patil
Provides context for the importance and demand for the data scientist role, which is the audience of the book.
- Factorization Machines: A New Tool for Sparse Data · J. Silva and R. E. Wright
Cited in the chapter on advanced supervised models as a resource for understanding Factorization Machines, a key topic in that chapter.
- Stacked Ensemble Models for Improved Prediction Accuracy · F. Gunes, R. Wolfinger and P. Tan
Referenced in the chapter on advanced supervised models to support the section on Ensemble Models, a core concept discussed.
- Customer Segmentation and Clustering Using SAS Enterprise Miner, Third Edition · R.S. Collica
Listed as additional reading for the chapter on unsupervised clustering, providing a deeper dive into the practical application of the chapter's techniques.
- Practical Web Analytics for User Experience · M. Beasley
Recommended in the chapter covering path analysis, suggesting its relevance for understanding web usage patterns, a key application of path analysis.
- Silent Scourge · C. F. Moore
Cited in Chapter 1 as an excellent discussion on the societal dangers of not collecting sufficient data on specific populations, such as children, when setting standards for environmental pollutants.
- Psychological Testing · A. Anastasi
Referenced in Chapter 1 as a classic text that discusses the concepts of validity and reliability in psychological measurement in detail.
- Randomization Tests · S. E. Eddington
Mentioned in Chapter 5 as a resource for inferential procedures specifically designed for situations where random sampling is not used, which is common in psychology experiments.
- Introductory Statistics for the Behavioral Sciences · J. Welkowitz, R. B. Ewen, and J. Cohen
Cited in Chapter 9 for providing a suggested compromise for setting levels of alpha and beta in research (α = .05 and power = .80) balancing scientific caution with the need to make new discoveries.
- Foundation trilogy · Isaac Asimov
Served as the author's childhood inspiration for the concept of prediction, likening the fictional science of 'psychohistory' to the work of a data scientist.
- Exploratory Data Analysis · John Tukey
Cited as a seminal 1977 book in statistics. The author quotes Tukey's maxim that data plus desire for an answer doesn't guarantee a reasonable answer can be found.
- Coursera and edX · N/A
Recommended as favorite MOOC (Massive Open Online Course) platforms for finding excellent free courses on machine learning and its mathematical foundations.
- www.r-bloggers.com · N/A
A recommended website that aggregates content from many popular R blogs, allowing readers to keep up with the quickly evolving field.
- Netflix Prize Winning Papers · Various
The book suggests downloading and reviewing papers from the top finishers of the Netflix Prize competition to learn about the advanced machine learning techniques they used.
- Heritage Health Prize Milestone Winner Papers · Various
The book suggests downloading papers describing the solutions of the milestone winners to learn from their successful approaches, which often involved ensembles of random forests.
- An Introduction to Statistical Learning · Gareth James, Daniela Witten, Trevor Hastie, and Robert Tibshirani
Referenced throughout the book as an excellent, more in-depth resource for topics like cross-validation, logistic regression, and spline models, using R.
- Data Mining for Business Analytics · Galit Shmueli, Peter Bruce, et al.
Co-authored by one of the book's authors, it's recommended for fuller treatments of topics like logistic regression, discriminant analysis, and handling holdout samples.
- Bandit Algorithms for Website Optimization · John Myles White
Recommended for a short, practical treatment of multi-arm bandit algorithms, which are presented as a modern alternative to traditional A/B testing.
- The Lady Tasting Tea: How Statistics Revolutionized Science in the Twentieth Century · David Salsburg
Cited for providing historical context on the development of foundational statistical tests like the chi-square test and the figures behind them.
- Python Cookbook, Third Edition · David Beazley and Brian K. Jones
Recommended for readers who want to deepen their general Python language knowledge beyond the scope of data analysis.
- Fluent Python · Luciano Ramalho
Suggested for those wanting to explore more advanced, idiomatic Python programming concepts.
- Effective Python, Second Edition · Brett Slatkin
Another recommendation for improving general-purpose Python programming skills.
- Introduction to Machine Learning with Python · Andreas Müller and Sarah Guido
A suggested next step for applying the data wrangling skills from this book to build machine learning models with scikit-learn.
- Python Data Science Handbook · Jake VanderPlas
Mentioned as another excellent resource covering a similar set of tools for data science in Python.
- Hands-On Programming with R · Garrett Grolemund
Recommended as a useful adjunct for readers with no prior programming experience, as it provides a gentler introduction to R as a programming language.
- ggplot2: Elegant graphics for data analysis · Hadley Wickham
The definitive guide for learning more about the mechanics and underlying theory of ggplot2, going into much greater depth than this book.
- Advanced R · Hadley Wickham
Recommended as a next step for those who want to deepen their programming skills and study R as a programming language.
- R Graphics Cookbook · Winston Chang
A useful resource for finding practical recipes and solutions for common graphing challenges in ggplot2.
- The Truthful Art · Albert Cairo
A general data visualization book recommended for learning the principles of creating effective graphics, to be paired with the technical skills taught in this book.
- Style: Lessons in Clarity and Grace · Joseph M. Williams and Joseph Bizup
Recommended for improving general writing and communication skills, which are critical for explaining analysis results.
- The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling · Ralph Kimball and Margy Ross
Provides a foundational guide to dimensional modeling (star schemas), a core concept for designing data warehouses that are understandable and performant for business users.
- Information Dashboard Design: The Effective Visual Communication of Data · Stephen Few
Offers practical advice on how to design dashboards that effectively and clearly communicate information, aligning with the book's principle that a 'picture is worth a thousand numbers'.
- Performance Dashboards: Measuring, Monitoring, and Managing Your Business · Wayne Eckerson
Provides a comprehensive overview of dashboards and scorecards, expanding on the definitions and use cases for these critical BI front-end tools.
- Agile Data Warehousing Project Management: Business Intelligence Systems Using Scrum · Ralph Hughes
Offers a detailed guide on applying agile methodologies specifically to BI and data warehousing projects, which the book identifies as a key success factor.
- The Data Warehouse Lifecycle Toolkit, Second Edition · Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, and Bob Becker
This book is repeatedly referenced as the definitive source for a more detailed, in-depth explanation of the Kimball Lifecycle project management methodology, which is only summarized in the current book.
- Kimball Group Website (www.kimballgroup.com) · Kimball Group
The introduction explicitly cites the website as a key resource for hundreds of supplementary design tips, articles, and educational materials that complement the book's content.
Movement V
Measure
Use available assessments and measures to review your progress.
A way to assess yourself, the instruments the field gives you, and what we'd measure next.
- — Your feedback loop: rate → find your weakest lever → act
- — Measures the books give you
Learning curriculum
After mastering this field, you can…
The field's learning objectives, reconciled across the books, classified by Bloom's taxonomy and ordered so each builds on the ones before it.
- explainAfter mastering this field you can explain why information and knowledge are strategic VRIN resources and why analytical capability is a durable source of competitive advantage.Check: Write an essay arguing why data and analytical capability constitute strategic assets and sources of lasting competitive advantage, citing the VRIN framework.
- distinguishAfter mastering this field you can define and distinguish the core disciplines—business analytics, data mining, data science, BI, and machine learning—and describe how they unify and interrelate.Check: Produce a concept map distinguishing business analytics, data mining, data science, BI, and machine learning, explaining the fundamental principles that unify them.
- describeAfter mastering this field you can describe the architecture and evolution of Business Intelligence systems and characterize Big Data using the 7V model along with its required techniques and technologies.Check: Diagram a BI system architecture, trace its evolution from decision-support systems, and characterize a Big Data scenario against the 7V model.
- describeAfter mastering this field you can describe the repeatable data science / data-mining process (CRISP-DM, KDD, analytical lifecycle) from problem definition through deployment and monitoring.Check: Map a business project onto the CRISP-DM / analytical-lifecycle phases, explaining the iterative connections from business understanding to deployment.
- traceAfter mastering this field you can trace the four eras/forms of analytics (descriptive, predictive, prescriptive, autonomous/AI) and situate current practice within them.Check: Create a timeline distinguishing descriptive, predictive, prescriptive, and autonomous analytics and place example applications within each era.
- categorizeAfter mastering this field you can explain machine learning, categorize ML systems (supervised/unsupervised, batch/online, instance/model-based), and decide when to use ML instead of rule-based programming.Check: Categorize a set of real ML systems along the standard dimensions and justify when ML is preferable to explicit rules.
- explainAfter mastering this field you can explain overfitting, model complexity, and the bias-variance tradeoff and why discovered patterns may fail to generalize.Check: Explain the bias-variance tradeoff with a demonstration showing how flexibility affects training vs. test error and generalization.
- explainAfter mastering this field you can explain why behavioral data are variable, distinguish sampling methods, and describe how sampling distributions and the Central Limit Theorem enable inference from samples.Check: Explain, with a simulation demonstration, how the CLM and sample size affect the standard error and validity of inference under different sampling schemes.
- formulateAfter mastering this field you can frame a business question into a well-defined analytical problem statement specifying target, stakeholders, decision context, and success criteria.Check: Given a business scenario, produce a problem statement decomposing it into concrete data-mining tasks with defined targets and success metrics.
- partitionAfter mastering this field you can partition data into train/validation/test sets and apply resampling (cross-validation, bootstrap) to honestly estimate generalization error and select tuning parameters.Check: Set up stratified train/validation/test splits and cross-validation for a dataset and use them to estimate out-of-sample error.
- buildAfter mastering this field you can build supervised predictive models—linear/logistic regression, k-NN, naive Bayes, decision trees, SVMs, neural nets, discriminant analysis—using Scikit-Learn and R.Check: Train and compare several supervised classifiers/regressors on a dataset using Scikit-Learn and R, interpreting coefficients and outputs.
- optimizeAfter mastering this field you can apply regularization (ridge, lasso, elastic net, dropout, early stopping) and tune hyperparameters via grid/randomized search to control complexity and balance bias and variance.Check: Tune a model's hyperparameters and regularization strength via cross-validated search, showing the effect on bias-variance and generalization.
- fitAfter mastering this field you can fit flexible nonlinear models such as splines and generalized additive models to capture nonlinear relationships.Check: Fit splines and a GAM to a dataset with nonlinear structure and interpret the resulting relationships.
- writeAfter mastering this field you can write clear, readable Pythonic code and set up an interactive analysis environment to execute, inspect, and iterate on data tasks.Check: Write annotated, assertion-checked Python in a Jupyter notebook that loads and inspects a dataset iteratively.
- computeAfter mastering this field you can compute probabilities and reason about uncertainty by analyzing sample spaces and running simulations, and implement core probability, linear algebra, and statistics primitives from scratch.Check: Implement, from scratch, simulations of sample spaces plus vector/matrix and descriptive-statistics primitives, then verify results against analytic answers.
- constructAfter mastering this field you can estimate population parameters and construct/interpret confidence and prediction intervals using bootstrap and simulation to quantify uncertainty.Check: Estimate an unknown parameter from sample data and report bootstrap-based confidence and prediction intervals with honest uncertainty statements.
- implementAfter mastering this field you can implement gradient descent and core algorithms from first principles to understand how and why data science methods work rather than merely invoking libraries.Check: Implement gradient descent and a k-means/naive-Bayes/regression algorithm from scratch (in Python and/or spreadsheet) and explain its optimization mechanics.
- manipulateAfter mastering this field you can load, clean, tidy, reshape, merge, and manipulate tabular, time-series, and text data using Pandas/NumPy and the R tidyverse.Check: Take a messy multi-source dataset and produce a tidy, merged, reshaped dataset in both pandas and the tidyverse, handling missing values and type conversions.
- acquireAfter mastering this field you can acquire data from diverse sources—files, databases, web scraping, and APIs—into analysis-ready structures.Check: Import data from CSV/Excel/JSON/SQL/API and web scraping into pandas/tibbles ready for analysis.
- visualizeAfter mastering this field you can explore and visualize data—including summaries, distributions, relationships, and geographic maps—using Matplotlib, Seaborn, ggplot2, and Basemap to detect patterns, errors, and outliers.Check: Produce an exploratory visual analysis of a dataset, including distributions, relationships, and a geographic map, identifying anomalies that guide modeling.
- prepareAfter mastering this field you can prepare and preprocess data by handling missing values and outliers, scaling/standardizing, encoding categoricals, balancing classes, and building reusable transformation pipelines.Check: Build a reusable preprocessing pipeline that imputes, scales, encodes, and balances a raw dataset, justifying each robust-estimate choice.
- reduceAfter mastering this field you can engineer and select informative features and reduce data dimension using domain knowledge, correlation, category consolidation, and PCA/PLS while preserving predictive information.Check: Engineer new features and apply PCA/correlation-based reduction to a high-dimensional dataset, demonstrating retained predictive value.
- applyAfter mastering this field you can select an appropriate similarity/distance measure for a given data structure to support recommendation, clustering, and nearest-neighbor reasoning.Check: Given sparse and dense datasets, choose and justify Euclidean vs. cosine (or other) measures and apply them to a nearest-neighbor task.
- clusterAfter mastering this field you can build unsupervised models—clustering, association rules, collaborative filtering, and dimensionality reduction—to discover structure and patterns.Check: Apply clustering, association rules, and PCA to an unlabeled dataset and interpret the discovered structure, including social-circle detection in networks.
- correctAfter mastering this field you can control error rates in multiple testing using FWER (Bonferroni, Holm) and FDR (Benjamini-Hochberg) procedures.Check: Given a multiple-comparison scenario, apply and compare Bonferroni, Holm, and Benjamini-Hochberg corrections and justify threshold choices.
- differentiateAfter mastering this field you can distinguish prediction from inference and supervised from unsupervised learning, and select an appropriate method for a given data structure and goal.Check: For several business problems, determine whether an outcome variable exists and select supervised vs. unsupervised methods, justifying the choice.
- selectAfter mastering this field you can select and compute performance metrics matched to the task (RMSE/MAE/MAPE, accuracy/precision/recall/F1, ROC-AUC, lift/decile) accounting for class imbalance and misclassification costs.Check: For a prediction, a classification, and a ranking task, select and compute appropriate metrics, justifying choices given class imbalance and costs.
- buildAfter mastering this field you can build and train deep neural networks with Keras/TensorFlow (and from scratch) for perception, sequence, language, and generative tasks.Check: Construct and train a deep neural network for a perception or sequence task, comparing framework-based and from-scratch implementations.
- combineAfter mastering this field you can combine methods using ensembles (bagging, boosting, random forests, BART, uplift modeling) to improve predictive power and decision targeting.Check: Build and tune ensemble models combining weak learners and compare their predictive performance against single models.
- evaluateAfter mastering this field you can compare competing models on validation data using appropriate metrics and baselines, and select the simplest model that generalizes well.Check: Compare multiple models on holdout data against a baseline and select the most parsimonious well-generalizing model, guided by Occam's razor.
- judgeAfter mastering this field you can perform hypothesis tests and designed experiments (p-values, z-tests, A/B tests, bootstrapping, permutation) and judge statistical significance while controlling Type I/II errors.Check: Design and run an A/B test using permutation/bootstrap methods, report significance and power, and apply multiple-testing corrections.
Validated instruments — where the research already has a measure
Talent Engagement, Attitudes and Motivations Survey
validated“Feel like going to work when I get up in the morning”
How to measure it
Turning each idea into a measure
For each construct: how to operationalize it, the observable signals to look for, and how well it holds up.
Assessed by the presence and quality of data warehouses/marts, master data management, data integration across silos, governance roles (stewards, BICC), and the existence of proprietary data, combined with users' perceived ability to find and trust data.
- existence of enterprise data warehouse
- unique identifiers maintained across organization
- proprietary/unique data sources exploited
- number of duplicate/conflicting data sources
- presence of data stewards and information management group
Use stage-based ordinal classification (poor→usable→consolidated→integrated→innovative) plus audit checklists; no scored survey items provided.
Map to the data row of the DELTA transitions table for content validity. · Archival/audit measures should be reliable; perceptual access ratings need consistency across respondents.
Assessed by presence of an enterprise analytics strategy/road map, shared IT infrastructure, common data definitions, consolidated analyst groups, and the absence of duplicated silos.
- number of redundant data marts/tools
- existence of enterprise BI strategy
- cross-functional analytical projects
- one-version-of-the-truth initiatives
Ordinal stage mapping plus inventory counts of redundant resources; no Likert items provided.
Anchored to the six analytical questions test of who shares data. · Inventory-based measures reliable; perceptions of 'fractured vs holistic' require calibrated raters.
Assessed by observed/perceived leader behaviors: pushing for data, hiring smart analysts, setting hands-on example, teaching, setting strategy/performance expectations, building an analytical ecosystem, persisting over time, and knowing analytics' limits.
- frequency of 'did you use data?' pushbacks
- leaders presenting fact-based recommendations
- investment decisions for analytics
- visible communication about analytics
Leadership-behavior checklist (presence/strength of each trait); progression none→local→aware→supportive→passionate.
Case-study traits provide content validity; risk of social desirability in self-ratings. · Multi-rater (360) assessment improves reliability over self-report.
Assessed by an inventory of analytical projects classified by business impact, alignment to distinctive capabilities, executive sponsorship, and position on the ladder of analytical applications.
- projects mapped to strategic priorities
- number of high-impact vs low-value targets
- use of questions matrix and ladder
- program management office for targeting
Qualitative target-quality checklist ('Do We Have a Good Target?') plus ladder rung position; no numeric scale.
Anchored to value-type analysis and the targeting questions. · Requires consistent criteria for 'high value' across raters.
Assessed by counts and mix of analyst types (champions, professionals, semipros, amateurs), skill proficiency across quantitative/business/relationship/coaching dimensions, organizational model (centralized to decentralized), and self-reported engagement/satisfaction.
- headcount by analyst type
- skill assessment ratings
- engagement/satisfaction scores
- center of excellence vs decentralized structure
- recruiting sources and rotation programs
Skill proficiency levels (basic→foundational→intermediate→advanced→expert) and engagement comparisons from the talent research; no item-level scale reproduced.
Backed by the Accenture analytical talent research survey design. · Engagement survey constructs are established; mix counts are objective and reliable.
Assessed via process maps showing automated, exceptions/overrides, and assisted decision points; integration of models into systems; and process performance monitoring.
- share of decisions automated/assisted
- analytics built into ERP/workflow tools
- gap between insight and action
- number of standalone vs embedded applications
Craft-vs-industrial classification and decision-type mix; ladder top rungs (institutional action, real-time optimization).
Anchored to claims-process and UPS/Avis examples. · Process audits are reasonably objective and repeatable.
Assessed via perceptions of truth-seeking, data-over-stories, granularity, valuing negative results, pushbacks/obligation to dissent, acting on analysis, and pragmatism about trade-offs.
- managers asked to back claims with data
- decisions changed based on analysis
- tolerance for disconfirming results
- stories vs data in meetings
Culture/climate perceptual survey aggregated to organization; no specific items provided.
Trait list provides content domain; risk of aspirational over-rating ('analytical overconfidence'). · Climate surveys typically reliable when aggregated.
Assessed by existence of model-management/model-validation functions, documented review cadences, monitoring of model decay, and periodic competitor/customer/technology reviews.
- centralized model libraries
- model decay alerts
- champion/challenger tracking
- annual technology reviews
Presence/maturity checklist of review practices; largely binary/ordinal.
Anchored to Progressive, Capital One, financial-crisis examples. · Archival evidence of review processes is reliable.
Assessed by the proportion of key decisions supported by data/analysis (vs. gut), decision-process meta-analysis, and tracking of decision quality over time.
- percent of major decisions based on facts
- documented decision processes
- decision management groups
- assessment of managers on decisions made
Reference benchmark from book: ~40% of major decisions based on gut; track share of fact-based decisions.
Definition explicitly provided in Chapter 11. · Decision-process audits more reliable than self-reported decision style.
Determined by mapping each DELTA element onto the five-stage transitions table to derive a composite stage (1 Analytically Impaired to 5 Analytical Competitor).
- balance and depth of DELTA elements
- presence/absence of roadblock elements
- enterprise vs local scope of analytics
Five-point ordinal stage scale used as a high-level assessment/map, not a survey.
Carried over from Competing on Analytics maturity model; content valid via appendix table. · Composite staging requires calibrated assessment to be consistent.
Measured by archival financial and operational metrics such as margins, cost savings, market share, growth, risk reduction, and decision speed/consistency/accuracy.
- margin and profit changes
- cost and waste reduction
- market share gains
- forecast accuracy
- industry-leading performance
Continuous archival metrics; benefits enumerated in 'Some Benefits of Being Analytical' and Chapter 11.
Authors note correlation with analytics use; causality argued but not proven. · Archival financial metrics are highly reliable.
Measured by the proportion of available data analyzed and the ability to drill into subcategories and outliers without sampling error.
- ratio of analyzed to total data
- number of subgroups analyzable
- absence of sampling-based extrapolation
Continuous proportion (0 to 1) of dataset coverage; categorical sample-vs-N=all classification.
Valid where 'all' is well-defined; in practice N=all is often near-all rather than literally complete. · Reliable via archival audit of data pipelines.
Measured by the share of unstructured or imprecise data incorporated and the error tolerance thresholds adopted.
- use of noSQL/Hadoop-style tools
- incorporation of unstructured content
- stated acceptance of approximate results
Ordinal tolerance levels; proportion of unstructured data used.
Distinguishable from negligence; messiness must serve a larger analytic purpose. · Assessable through documented data-quality standards.
Measured by the predominance of correlational/predictive methods over controlled causal experiments in analysis and decision rationale.
- use of correlation analysis
- absence of causal claims in decisions
- reliance on predictive proxies
Categorical (correlation-led vs. causation-led); proportion of correlational analyses.
Valid for operational decisions; causal methods remain appropriate for critical contexts. · Reliable through method documentation.
Measured by the count and variety of previously non-data phenomena rendered into quantified formats.
- sensor deployments
- datafied behaviors/sentiments/locations
- structured datasets created from analog phenomena
Count of datafied domains; volume of quantified records.
Must distinguish datafication (quantified/analyzable) from mere digitization (image/copy). · Reliable via archival inventory.
Measured by the novelty, frequency, and diversity of data-reuse ideas and the recognition of option value.
- generation of new data applications
- identification of secondary uses
- creative repurposing of existing data
Counts of novel data applications; qualitative ideation assessments.
Partly self-reportable but prone to social-desirability bias; better inferred from behavior. · Moderate; idea novelty is subjectively judged.
Measured by the number of distinct uses, dataset merges, and downstream products derived from a data source.
- secondary services launched
- dataset combinations
- feedback loops from user interactions
Count of uses per dataset; revenue attributed to reuse.
Valid where uses are distinguishable from the primary purpose. · Reliable through archival tracking of data lineage.
Measured by the share of decisions informed or made by predictive models versus intuition or expert judgment.
- use of recommendation systems
- algorithmic ranking
- predictive maintenance/scoring adoption
Proportion of decisions model-driven; degree of automation.
Valid across operational and managerial contexts. · Reliable through process documentation.
Measured by revenue from data-derived products, productivity differentials, cost savings, and market valuations of data assets.
- data-product income
- 6% productivity gains (Brynjolfsson)
- market vs. book value gaps
Monetary metrics; productivity percentages.
Valid but data assets remain hard to formally value on balance sheets. · Reliable via financial records, though intangible-value estimation is imprecise.
Measured by prediction hit rates, error margins, and lead-time against realized outcomes.
- Farecast 75% accuracy
- flu spread prediction in near real time
- infection detection 24 hours early
Accuracy percentages; time-to-detection.
Predictions are probabilistic and inherently fallible. · Reliable via benchmarking predictions against actuals.
Measured by re-identification incidents, breadth of personal data aggregated, and perceived privacy loss.
- AOL/Netflix re-identification cases
- NSA data collection scale
- defeat of anonymization
Incident counts; data-aggregation volume; survey-based perceived privacy.
Applies only to personal or personally-traceable data. · Mixed; perceptual components carry response bias.
Measured by the presence of policies that impose sanctions or interventions based on predicted rather than actual behavior.
- parole prediction use
- predictive policing of individuals
- pre-crime interventions
Categorical presence/absence; prevalence of propensity-based decisions.
Valid when correlational predictions are misused for causal culpability. · Reliable via policy and practice review.
Measured by over-reliance on flawed or incomplete metrics and absence of critical scrutiny of data meaning.
- McNamara body counts
- Google's SAT-score obsession
- decisions despite reasonable doubt about data
Qualitative assessment of metric over-reliance.
Inferred construct; difficult to measure directly. · Low to moderate; depends on interpretive judgment.
Measured by the presence and enforcement of accountability rules, human-agency protections, algorithmist oversight, and antitrust-style regulation.
- accountability-based privacy frameworks
- openness/certification/disprovability requirements
- presence of algorithmists
- differential privacy adoption
Categorical presence and enforcement strength.
Largely prospective/normative in the book; partially realized. · Reliable via documentation of policies and institutions.
Quantified by total bytes stored, data generation rates per unit time, and the proportion and types of structured, semi-structured, and unstructured data.
- exabytes generated per day
- tweets per day
- sensor data streams
- share of unstructured data (~80%)
Continuous archival metrics; no fixed size threshold defines 'big'.
Captures the book's core V-based characterization of big data. · Archival counts are reproducible though definitions of 'big' shift over time.
Assessed through consistency, duplication, error, and bias checks performed during pre-processing and validation.
- error rates
- duplicate records
- agreement with trusted sources
- presence of false postings
Quality indices derived from data audits; partly judgmental.
Reflects the fourth V emphasized as fundamental to medical and other applications. · Dependent on audit methodology consistency.
Classified by architecture type (Hadoop DFS, NoSQL, Cloud), replication factor, scalability mode, and CAP trade-off configuration.
- NameNode/DataNode structure
- block replication
- horizontal scalability
- Heartbeat monitoring
Categorical and configurational descriptors from system documentation.
Directly grounded in Chapter 3 storage discussion. · Architectural attributes are objectively verifiable.
Identified by technique used (clustering, classification, MapReduce, Bloom filter, PageRank, collaborative filtering) and whether supervised or unsupervised.
- decision trees
- cluster diagrams
- map/shuffle/reduce stages
- Jaccard and cosine similarity
Categorical technique inventory with mixed performance metrics.
Faithful to Chapter 4 examples. · Technique identification is unambiguous; performance varies by dataset.
Evaluated by the relevance and usefulness of patterns extracted relative to the questions of interest.
- detected fraud patterns
- customer preference profiles
- epidemic spread indicators
Mixed perceptual and behavioral assessment of output usefulness.
Central mediating concept linking data to value per Chapters 1 and 4. · Usefulness judgments require human interpretation, introducing some subjectivity.
Measured by comparing model predictions against actual recorded outcomes and assessing over-fitting and bias.
- Google Flu Trends 50% over-prediction
- Ebola forecast deviation
- CDC comparison
Archival error metrics comparing predictions to ground truth.
Grounded in documented Flu Trends and Ebola case analyses. · Outcome-based and reproducible where ground truth exists.
Assessed by presence and strength of encryption (e.g., AES), firewalls, authentication, anonymization, and access governance.
- AES key length
- point-to-point encryption presence
- two-person validation
- USB port controls
Categorical and configurational, with breach-audit evidence.
Reflects security discussions across Chapters 5 and 7. · Verifiable through system audits and incident reports.
Captured by profit, sales lift, recommendation accuracy, health outcomes, cost reductions, and efficiency improvements.
- targeted marketing revenue
- recommender-driven sales
- reduced healthcare costs
- smart city efficiency gains
Mixed financial, clinical, and operational metrics.
Anchored in Chapters 5, 6, and 8 applications. · Outcome metrics measurable but application-specific.
Evidenced by number and severity of breaches, records compromised, and instances of individual re-identification.
- Home Depot 56 million cards stolen
- Anthem 70 million records
- Snowden leak scale
- re-identified medical records
Archival breach metrics and incident counts.
Documented through major case studies in Chapters 5 and 7. · Incident data is verifiable though underreporting may occur.
Operationalized as the number of case studies attempted independently and the proportion of problems the learner works through before reading the answer.
- learner submits own solution before viewing book solution
- time logged on a problem
- completion of all five case studies
Count and ratio measures; can be aggregated across case studies.
Self-report of independent attempting may be inflated; behavioral logs improve validity. · Repeated tracking across case studies provides stable estimates.
Operationalized as the proportion of mathematical concepts presented and illustrated via code examples versus symbolic equations.
- concepts accompanied by runnable code listings
- no Greek-symbol equations present
Largely a fixed property of the book; ratio measure.
Clear textual evidence; low ambiguity. · Stable across readers since it is a design feature.
Operationalized as the frequency with which a learner computes confidence intervals, applies corrections (e.g., Bonferroni), and tests intuitions before drawing conclusions.
- code that computes 95% confidence intervals
- application of Bonferroni correction
- permutation or bootstrap tests run before claims
Count/frequency measure of rigorous practices applied.
Behavioral observation of code is more valid than self-report. · Consistent across analytical tasks once skill acquired.
Operationalized via self-reported persistence and effort plus behavioral indicators such as sustained time-on-task and retry behavior.
- continued attempts after initial failure
- high time-on-task
- self-reported engagement
Likert-style self-report combined with behavioral logs (no scoring rules specified).
Self-report subject to social desirability; triangulate with behavior. · Moderately stable across sessions.
Operationalized as self-reported perceived competence in handling probability, statistics, and coding tasks.
- self-rated confidence
- voluntary attempting of harder problems
Perceptual self-report measure.
Confidence may diverge from actual competence; pair with performance. · Reasonably stable trait-state hybrid.
Operationalized as performance on coding tasks requiring NumPy, SciPy, Pandas, Matplotlib, Seaborn, and Scikit-Learn.
- correct use of library methods
- efficient vectorized code
- successful data visualizations
Behavioral assessment scores.
Directly observable through code execution. · High when assessed via consistent coding tasks.
Operationalized through portfolio quality, performance on comprehensive data science tasks, and ultimately job acquisition.
- completed case-study solutions
- portfolio projects
- job offers received
Mixed archival and behavioral outcome measure.
Job acquisition is influenced by external factors beyond skill. · Skill assessments more reliable than employment outcomes.
Assessed by the existence and currency of documented architecture blueprints for each layer, the degree of project adherence to them, and the inverse of the number of unplanned data/technology silos.
- documented blueprints exist and are current
- products selected after defining information/data/technology needs
- low count of overlapping data stores and BI tools
- ability to produce data models and ETL workflows on demand
Could be rated on an ordinal maturity scale from accidental (none) to fully planned and adhered.
Risk of documentation existing on paper but not followed; validate adherence in actual projects. · Multiple assessors reviewing artifacts improve reliability.
Measured by the proportion of integration implemented with tools versus hand coding, presence and use of standards and reusable components, and availability of data lineage, impact analysis, and documentation.
- use of data integration suite for downstream loads, not just EDW
- reusable SCD/CDC/error-handling components
- auditable data lineage and impact analysis
- documented source-to-target mappings
Ordinal or percentage-based for tool adoption; checklist for standards presence.
Using a tool merely to execute SQL scripts does not equal rigor; assess actual use of tool capabilities. · Artifact review and developer interviews increase reliability.
Assessed via review of logical and physical data models for conformed dimensions, surrogate key usage, appropriate SCD types, date/time dimensions, and absence of anti-patterns.
- conformed dimensions shared across facts
- surrogate keys as primary keys with natural keys retained
- correct SCD type per business need
- date dimension present and standardized
Best evaluated by expert review checklist rather than self-report.
Requires modeling expertise to assess; superficial review may miss design flaws. · Expert reviewers with shared criteria improve consistency.
Measured by the share of development performed with tools, evidence of best-fit product selection processes, and resulting productivity, documentation, and governance capabilities.
- product evaluations conducted with success criteria
- low reliance on hand-coded extracts
- tool-generated documentation and lineage
Percentage of processes built with tools; presence/absence of selection process.
Distinguish tool ownership from effective tool use. · Developer surveys plus artifact inspection.
Assessed by completeness of documented requirements across categories, presence of business case and BI roadmap, signed-off requirements, and stakeholder-reported expectation alignment.
- documented and signed-off requirements
- business case with tangible benefits
- ongoing status communication
- managed scope creep
Checklist for documentation presence plus perceptual survey for expectation alignment.
Documentation presence does not guarantee expectation alignment; corroborate with stakeholder perception. · Combine artifact review with multi-stakeholder surveys.
Measured by training hours delivered, coverage across audiences, degree of customization to real data and use cases, and learner-reported competence gains.
- training sessions using company's own data
- both business and IT trained
- train-the-trainer or mentoring programs
Quantitative (hours, coverage) plus perceptual (competence gain).
Generic vendor training may not translate to job competence; measure use-case relevance. · Pre/post competence assessments improve reliability.
Assessed by existence of governance boards/task forces, BI and DI centers of excellence, named business sponsors with budget authority, documented processes, and stakeholder-rated effectiveness.
- active data governance board and stewards
- funded BI/DI COEs
- designated business sponsor
- documented program roadmap and processes
Presence/absence plus perceptual effectiveness rating.
Committees may exist nominally; assess genuine resource commitment and ownership. · Triangulate artifacts with stakeholder perceptions.
Measured via data profiling results, data quality metrics, incidence of reconciliation/number debates, and user-reported confidence that the data meets the five Cs.
- low error rates in profiling
- consistent metrics across reports
- conformed dimensions across business groups
- data current to required frequency
- required data available for analysis
Per-C metrics aggregated; partly behavioral (reconciliation incidence) and partly perceptual.
Each C should be assessed separately; comprehensive and current are partly business-defined. · Profiling tools provide objective structural/attribute metrics; consistency requires cross-source comparison.
Measured by inventory counts of data shadow systems, overlapping data stores, multiple uncoordinated BI tools, and the reconciliation effort they generate.
- multiple data shadow systems in use
- many overlapping/redundant data stores
- numerous uncoordinated BI tools
- frequent reconciliation of conflicting numbers
Counts and effort estimates; higher values indicate worse condition.
Many shadow systems are undocumented and hard to find; inventory may undercount. · Triage and discovery processes improve completeness of inventory.
Measured by self-reported confidence in BI outputs and corroborated by reduced reconciliation activity and number disputes in meetings.
- reduced reconciliation and number debates
- reliance on BI outputs for decisions
- positive perception of data reliability
Perceptual self-report scale corroborated by behavioral reconciliation metrics.
Self-reported trust may diverge from actual data quality; corroborate with behavior. · Repeated measures over time improve reliability.
Measured behaviorally via BI usage logs (BI on BI), frequency and breadth of access, and the inverse of data shadow system reliance.
- high BI tool usage logs
- broad cross-group adoption
- declining data shadow system creation
Behavioral usage metrics plus self-reported usage.
Usage volume does not equal value; pair with value measures. · System logs provide objective, reliable usage data.
Measured by reported communication quality and relationship health, business participation rates in requirements/testing/feedback, and presence of shared accountability mechanisms.
- business resources committed and engaged
- two-way feedback loops in use
- blame-sharing rather than blame-shifting
Perceptual relationship survey plus participation rate metrics.
Stated intent to participate often exceeds actual participation; track actuals. · Multi-respondent surveys across business and IT improve reliability.
Measured via archival financial and operational metrics attributable to BI-enabled decisions, with ROI estimated against the cost of BI investment.
- quantified tangible benefits tied to BI use
- reduced reporting cycle times
- measurable decision improvements
Monetary and operational metrics; ROI ratio.
Attribution is difficult since BI is an enabler; isolate BI's contribution within data-enabled solutions. · Requires consistent baselines and measurement frameworks.
Measured by schedule and budget adherence (archival) combined with stakeholder-perceived fulfillment of expectations (perceptual).
- on-time, on-budget delivery
- stakeholder satisfaction with deliverables
- low defect/rework rates
Combination of objective project metrics and perceptual satisfaction scores.
Expectation fulfillment is the decisive criterion per the book and is inherently perceptual. · Combine project management data with multi-stakeholder satisfaction surveys.
Measured via time-allocation studies showing reduced data gathering/reconciliation time and increased analysis time, plus reduced IT maintenance burden.
- less time spent reconciling numbers
- more time on analysis and action
- IT freed for value-adding work
Time-allocation percentages and effort estimates.
Self-reported time allocation may be imprecise; corroborate where possible. · Repeated time studies improve reliability.
Measured by spend on BI&BD tools, breadth of deployed components (data warehouse, ETL, OLAP, mining, NoSQL/Hadoop), and managerial ratings of technical capability.
- Number of deployed BI&BD components
- IT budget allocated to analytics
- Presence of data warehouses and Hadoop/NoSQL platforms
Combine archival counts with perceptual capability ratings; avoid scoring rules.
Risk of conflating presence of tools with effective use. · Archival inventories improve reliability over single self-report.
Assessed via perceptual measures of market change, competitive intensity, and information complexity, supplemented by market indicators.
- Rate of market/technology change
- Number of competitors and stakeholder demands
- Volume and dispersion of information sources
Perceptual environmental scanning items at organizational level.
Perceptions may differ across managers. · Multiple respondents recommended.
Captured through perceptual culture/climate assessment of fact-based decision-making, knowledge sharing, and openness to change.
- Frequency of data use in decisions
- Knowledge-sharing practices
- Leadership endorsement of analytics
Perceptual organizational culture instrument.
Social desirability bias possible. · Aggregate multiple respondents.
Measured by skill inventories, certifications, and self/manager ratings of analytical, statistical, and communication skills.
- Data scientist headcount
- Skill assessments
- Training completion
Mix of self-report and archival; aggregate to unit.
Self-rating may overstate competence. · Triangulate with objective task performance.
Assessed via perceptual ratings of management support, vision clarity, strategy alignment, and existence of a data-exploration strategy.
- Documented BI&BD strategy
- Existence of BI competence center
- Executive sponsorship
Perceptual managerial assessment.
May reflect espoused rather than enacted governance. · Corroborate with documentation.
Assessed via BI maturity capability scales (sensing, seizing, transforming; exploration vs exploitation) and behavioral indicators of analytic activity.
- Use of advanced mining/predictive techniques
- Frequency of new insights generated
- Maturity-level placement
Maturity-model dimensions; feasibility only, no scoring rules.
Maturity self-placement can be inflated. · Use multiple capability dimensions.
Measured by perceptual decision-quality ratings plus archival decision-cycle times and outcome accuracy.
- Decision cycle time
- Forecast accuracy
- Reduction in errors
Mixed perceptual and archival.
Attribution to BI&BD can be difficult. · Use archival cycle metrics where possible.
Measured by archival financial/operational metrics (profit, cost savings, new products) and perceptual innovation/relationship gains.
- Revenue from new offerings
- Cost reductions
- Customer retention gains
Prefer archival outcome metrics.
Multi-causal attribution risk. · Use longitudinal financial data.
Measured via archival performance indicators: profitability, market share, growth, and efficiency ratios.
- Profit margins
- Market share
- Growth rate
Archival financial and market data preferred.
Many external drivers beyond BI&BD. · Use multi-year audited data.
Assessed through executive interviews, public references to analytics in annual reports and analyst calls, observed investment decisions, and the presence of executives who personally demand evidence for decisions.
- CEO/exec statements about analytics
- Analytics mentioned in strategy/annual reports
- Hiring of analytical leaders
- Demanding data before action
Could be rated on a maturity-style ordinal scale (1-5) by assessors.
Risk of socially desirable responses; triangulate with archival evidence. · Multiple raters and document analysis improve reliability.
Measured by governance structures (CDAO, analytics hub), degree of data centralization and standardized definitions, and enterprise-wide vs departmental needs assessment.
- Presence of chief data/analytics officer
- Central customer information files
- Enterprise analytics hub
- Standardized metrics across units
Ordinal maturity scale or checklist of enterprise practices.
Distinguish stated intent from actual integration. · Document and system audits enhance reliability.
Captured via headcounts and qualifications of analysts/data scientists, training and certification programs, and assessments of workforce numeracy and experimental skill.
- Number of data scientists
- Internal analytics training programs
- Numeracy hiring tests
- Embedded analysts in business units
Combination of counts and ordinal capability ratings.
Headcounts may not reflect skill quality; combine with skill assessments. · HR records provide consistent counts.
Evaluated through audits of data quality (correct, complete, current, consistent), repository types (warehouse, data lake), analytical tool portfolios, visualization tools, and deployment processes.
- Integrated data warehouse/data lake
- Data quality metrics
- Tool suite breadth
- Security/privacy/audit controls
Architecture maturity stages (1-5) as described in Chapter 8.
Technology presence does not equal effective use. · System audits yield objective measures.
Measured via employee perception surveys on fact-based decision norms and observed rates of experimentation and evidence use.
- Number of experiments run
- Managers requesting data before decisions
- Test-and-learn practices
- Self-reported fact-based culture
Likert-style perceptual survey (feasibility only; no items specified here).
Perceptions may diverge from practice; triangulate with experiment counts. · Aggregating multiple respondents improves reliability.
Identified through strategy documents and benchmarking the focal capability (e.g., revenue management, loyalty) against competitors.
- Stated distinctive capability
- Proprietary algorithms/metrics
- Performance lead in focal process
Conditional aggregation; capability is firm-specific.
Capability must be both distinctive and analytics-supported. · Benchmarking data improve objectivity.
Measured by share of decisions informed by analytics, extent of embedded/automated decision systems, use of experiments, and real-time analytics adoption.
- Automated decision applications
- Real-time routing/pricing systems
- Documented experiments
- Override policies
Mix of behavioral counts and system audits.
Distinguish genuine use from decorative analytics. · System logs provide reliable behavioral data.
Captured from financial statements and market data; book correlates analytical orientation with profit, revenue growth, and shareholder return.
- CAGR
- Profit margins
- Total shareholder return
- Same-store sales growth
- Documented savings (e.g., ORION ~$400M/yr)
Continuous archival metrics.
Attribution to analytics is correlational, not strictly causal. · Audited financials are highly reliable.
Extent of central coordination of data, technology, and analysts, common data definitions, and presence of enterprise governance roles.
- Presence of a chief data/analytics officer
- Enterprise data warehouse/lake
- Common metadata and definitions
- Analytics hub
Survey items on scope of BI/analytics use plus organizational audit; staged maturity descriptors.
Good construct clarity; boundary with technology infrastructure can blur. · Organizational documentation enhances reliability.
Assessment of data correctness, completeness, currency, consistency, context, and control plus architecture maturity across the six architectural elements.
- Percent of IT working on data issues
- Error rates
- Integration level
- Latency of data access
- Architecture sophistication
Primarily archival/system audits; staged capability descriptors (Stage 1–5).
High validity when measured technically; self-report tends to overstate quality. · System-level metrics yield high reliability.
Counts and qualifications of analytical professionals, hiring/testing practices, workforce analytical skill levels, and organizational placement.
- Number of data scientists/analysts
- Quantitative hiring tests
- Training programs
- Hub-and-spoke structure
Headcount and skill inventories combined with perceptual ratings of capability.
Counts are concrete; skill quality harder to assess. · HR records improve reliability of headcount measures.
Degree of alignment between analytics initiatives and strategy and the scale/ambition of intended outcomes.
- Targets tied to strategic capabilities
- Large-scale expected outcomes (e.g., revenue/cost in hundreds of millions)
- Few vs. many strategic targets
Qualitative assessment plus staged descriptors of target focus.
Validity depends on accurate strategy mapping. · Initiative documentation supports reliability.
Identification of a process/decision domain in which the firm outperforms competitors and applies analytics extensively.
- Recognized competitive edge (e.g., loyalty, pricing, routing)
- Proprietary metrics/algorithms
- Superior process performance vs. rivals
Mixed: archival process metrics and perceptual competitive comparison.
Strong strategic validity; some subjectivity in 'distinctiveness'. · Competitor benchmarking improves reliability.
Frequency and extent to which decisions across levels rely on data, models, and experimentation rather than intuition.
- Number of experiments run
- Decisions requiring evidence
- Cultural norms valuing analytics
- Overrides handled with rationale
Perceptual survey ratings of analytical orientation; behavioral counts of experiments.
Good face validity; susceptible to social desirability bias. · Behavioral indicators (e.g., experiment counts) enhance reliability.
Rated via review of project documentation/charters for explicit statement of purpose, intended decisions, success criteria, and stakeholders; can be scored by independent reviewers.
- Existence of a written purpose statement
- Stated decision use of model outputs
- Defined target variable and task type
Ordinal rating (e.g., low/medium/high) by expert reviewers.
Face-valid; risk of subjectivity in reviewer ratings. · Improve with multiple raters and a rubric.
Quantified through a data-quality audit: proportion of missing values handled, outliers reviewed, categorical variables correctly encoded as dummies, variables typed correctly, and normalization applied where required.
- Missing-value rate post-cleaning
- Number of detected/handled outliers
- Presence of normalized predictors for distance-based methods
Composite index from archival data audits.
Strong content validity given explicit preprocessing checklist in the text. · Reproducible via documented preprocessing scripts.
Measured as percentage reduction in number of predictors and/or proportion of variance retained by selected principal components; presence of correlation-based variable removal.
- Number of predictors before vs. after
- Cumulative variance explained by retained components
- Number of categories collapsed
Ratio (counts/percentages).
Objective and directly observable. · High; computed from analysis artifacts.
Binary/ordinal indicator of whether partitioning was performed and how (two-way, three-way, k-fold), recorded from the analysis workflow.
- Documented partition proportions
- Number of cross-validation folds
- Separation of tuning data from final evaluation data
Categorical/ordinal.
Directly observable from workflow. · High.
Assessed by comparing candidate methods on validation performance and by checking match between method assumptions and data characteristics (per Table 1.1 mapping).
- Number of methods tried
- Validation metric of chosen vs. alternatives
- Alignment with data structure
Mixed: counts plus relative performance.
Reasonably valid when multiple methods are benchmarked. · Depends on consistent benchmarking protocol.
Measured by parameter count, tree size/number of terminal nodes, number of hidden nodes, number of components/interaction terms, or model-selection criteria (AIC, BIC, Mallows Cp).
- AIC/BIC/Cp values
- Count of model parameters
- Tree size
Ratio/interval.
Objective; multiple complementary indicators. · High; computed from model objects.
Operationalized as the discrepancy (gap) between training-set and validation-set error metrics (e.g., RMSE or error rate), with a large positive gap indicating overfitting.
- Near-zero training error with high validation error
- Increasing validation error as complexity grows
Derived ratio/difference of error metrics.
Standard operationalization in the text. · High when partitions are stable.
Inferred from validation/test performance metrics relative to training, with small gap and good holdout performance indicating strong generalization.
- Validation/test metric values
- Consistency of performance across folds
Derived from holdout metrics.
Valid as conceptual inverse of overfitting. · Improves with cross-validation.
Measured by class proportions in the data and by a domain-supplied cost matrix or cost ratio (e.g., cost of false negative relative to false positive).
- Class frequency table
- Documented misclassification cost matrix
Proportions and cost ratios.
Cost ratio is often easier to estimate than absolute costs (noted in text). · Depends on quality of domain cost estimates.
Assessed by checking alignment of chosen metric (RMSE/MAE/MAPE for prediction; accuracy/sensitivity/specificity/AUC for classification; lift/decile for ranking; cost-weighted for asymmetric costs) with stated task and cost context.
- Reported metrics matching task
- Use of lift/ROC when ranking or rare class is the goal
- Inclusion of cost in evaluation
Categorical alignment judgment.
Face-valid per Chapter 5 guidance. · Improves with explicit task-metric rubric.
Computed from validation/test data: RMSE, MAE, MAPE, ME for numerical prediction; confusion-matrix-based accuracy, error rate, sensitivity, specificity, FDR/FOR, ROC/AUC for classification; lift and decile-lift for ranking.
- Confusion matrix counts
- Error/accuracy values
- ROC curve and AUC
- Lift/decile chart values
Ratio/interval metrics depending on measure.
Standard, well-established metrics. · High when computed on adequately sized holdout data.
Measured via deployment outcomes such as net profit, revenue lift, cost savings, fraud caught, or decision-accuracy improvements, often derived from cost/benefit and lift analyses.
- Estimated net profit from lift chart
- Reduction in misclassification cost
- Improved targeting response rates
Monetary or rate-based.
Strong when tied to explicit cost/benefit tables (as in cases). · Depends on accuracy of cost/benefit inputs and post-deployment monitoring.
Operationalized as expenditures and resource commitments to data acquisition, the presence of deliberate data-generating experiments, and the breadth/depth of curated data assets relative to needs.
- Budget lines for data purchases/feeds
- Existence of randomized data-gathering campaigns
- Number and uniqueness of integrated data sources
- Investments accepting short-term losses for data (e.g., Signet Bank)
Best captured via archival financial and project records; can be expressed in monetary terms or as a maturity rating.
Risk of conflating general IT spending with genuine data-asset investment; must focus on data acquisition/curation specifically. · Archival records provide reliable measurement if accounting categories are consistent.
Operationalized through measures of demonstrated ability (competition results, project success history), apprenticeship lineage with master data scientists, and strength of professional networks.
- Track record in data mining competitions (e.g., KDD Cup, Netflix)
- History of successful deployed projects
- Quality of mentors/training
- Depth of contacts across the data science community
Difficult to measure objectively; requires expert assessment and is partly behavioral/archival.
Self-report unreliable since anyone can claim to be a data scientist; evaluation requires a top-notch data scientist. · Competition and project records are reliable but may not capture all relevant ability.
Operationalized via assessments of management's analytic literacy, the quality of their interactions with data science teams, and organizational maturity indicators.
- Quality and depth of questions asked of data scientists
- Track record of selecting successful projects
- Presence of supportive data-science culture
- Maturity-model self-assessment results
Combination of perceptual survey and behavioral/archival evidence; maturity rating useful.
Self-report may overstate capability; triangulate with team perceptions and outcomes. · Maturity assessments improve reliability if anchored to concrete behaviors.
Operationalized via documented process adherence, iteration patterns, presence of evaluation gates, and the alignment of solutions with business problems.
- Documented problem formulations and target definitions
- Evidence of iterative refinement
- Use of pilot studies and prototypes
- Stage-gate or review checkpoints
Process maturity rating combined with archival evidence of practices.
Documentation may not reflect actual practice; observe real workflows. · Mixed-method assessment improves reliability.
Operationalized by computing the information gain (or variance reduction) of selected attributes and the degree to which the chosen feature set concentrates predictive signal.
- Computed information gain values per attribute
- Ranking of attributes by informativeness
- Reduction in dataset entropy after splits
- Improvement in model accuracy from selected features
Directly computable from data; continuous numeric scale (e.g., bits of information gain).
Attributes with very many values can inflate information gain without being predictive (overfitting concern). · Highly reliable as it is computed deterministically from data.
Operationalized by the presence and quality of expected value decompositions in problem formulations, including cost-benefit matrices and probability estimates tied to decisions.
- Documented expected value calculations
- Cost-benefit matrices accompanying models
- Decision rules derived from expected value (e.g., target if expected benefit > 0)
- Decomposition of complex problems into subproblems
Assessed perceptually/behaviorally via analysis artifacts; can be rated for completeness.
Framing may be present nominally but lack rigor; check whether values and probabilities are credibly sourced. · Inter-rater agreement on presence/quality of EV framing should be checked.
Operationalized by the use of complexity-control techniques and the resulting position on the fitting graph relative to the overfitting sweet spot.
- Hyperparameter settings (e.g., regularization lambda, tree size)
- Use of nested cross-validation for parameter selection
- Fitting graphs showing chosen complexity near the sweet spot
- Gap between training and holdout performance
Reflected in modeling artifacts; assessable archivally from code/configuration.
Presence of techniques does not guarantee correct application; examine resulting generalization gap. · Reliable when modeling pipelines are documented and reproducible.
Operationalized by the evaluation protocols employed: whether holdout data is used, whether metrics reflect business costs/benefits, and whether appropriate baselines are compared.
- Use of separate test sets / cross-validation
- Reporting of expected profit, AUC, lift rather than only accuracy
- Cost-benefit matrices in evaluation
- Comparison against majority classifier or domain baselines
Assessed via mixed methods from evaluation reports and protocols; can be rated for rigor.
Beware reporting of metrics misaligned with the goal (e.g., MSE without justification). · Reliable when evaluation procedures are documented.
Operationalized through the demonstrated ability to frame problems data-analytically, ask probing questions, evaluate proposals, and connect data science to business value.
- Quality of questions asked about data and methods
- Ability to spot flaws in proposals
- Connecting analytics to business goals
- Application of expected value and other frameworks
Partly self-reportable but better demonstrated via behavioral assessments (e.g., proposal critiques).
Self-report may not align with actual demonstrated ability; use performance tasks. · Behavioral assessments (e.g., scored proposal reviews) improve reliability.
Operationalized as performance on holdout/test data measured by task-appropriate metrics (accuracy, AUC, expected profit, lift), and revealed by the training-vs-holdout gap on fitting and learning curves.
- Cross-validation performance estimates and variance
- Position relative to overfitting sweet spot on fitting graph
- Learning curve trajectory
- Stability of performance across folds
Continuous metric measured archivally on test data; must use the original population distribution.
Selection bias and distribution shift between training and deployment populations threaten validity. · Cross-validation provides reliability estimates (mean and variance across folds).
Operationalized via decision outcomes such as productivity gains, profit per decision, return on assets, reduced churn, or improved targeting effectiveness attributable to data-driven decisions.
- Productivity differences correlated with DDD (e.g., 4-6% per Brynjolfsson)
- Profit improvements from targeted actions
- Reduced losses (churn, fraud)
- Return on assets/equity and market value
Best measured archivally via business performance metrics; controlled experiments strengthen causal attribution.
Attributing outcomes to data-driven decisions specifically requires controlling for confounds. · Archival business metrics are reliable; attribution requires careful design.
Operationalized via market position, profitability relative to competitors, switching costs created, and the uniqueness/inimitability of data assets and capabilities.
- Superior profitability vs. competitors (e.g., Capital One charge-off rates)
- Customer switching costs (e.g., Amazon recommendations)
- Unique data assets (e.g., Facebook social graph)
- Sustained market leadership
Assessed archivally via market and financial data; partly qualitative regarding inimitability.
Advantage is context- and strategy-dependent; the same asset may not confer advantage to competitors with different strategies. · Financial indicators reliable; inimitability assessments more subjective.
Operationalized as whether and to what extent a learner manually implements an algorithm (e.g., gradient descent, k-means) versus calling an equivalent library function.
- learner writes their own implementation
- code does not import scikit-learn/NumPy for core logic
- presence of explanatory comments
Could be coded as a binary or ordinal scale per algorithm (fully from scratch, partially, library-based).
Strong face validity since it directly reflects the book's pedagogy; risk of conflating effort with understanding. · Reliably observable through code inspection.
Operationalized via demonstrated ability to apply linear algebra, statistics, and probability concepts in problem-solving, or via self-reported familiarity.
- correct computation of dot products and means
- understanding of distributions and inference
- ability to interpret correlation
Could use test scores per topic or a composite proficiency index.
High content validity given the book's explicit treatment of these topics. · Reliable when assessed through standardized problem sets.
Operationalized as the steps, time, and care devoted to getting (files, scraping, APIs) and cleaning/munging/exploring/rescaling data.
- use of parsing functions with error handling
- checks for outliers and missing values
- rescaling vectors to common units
Could be measured by time spent or by a checklist of cleaning steps performed.
Captures the book's claim that this consumes a large fraction of a data scientist's time. · Behaviorally observable but effort intensity is harder to standardize.
Operationalized via the optimization procedure used (batch, minibatch, stochastic), learning rate, number of epochs, and observed loss reduction.
- decreasing loss across epochs
- convergence of parameters
- chosen learning rate
Tracked via loss curves and convergence metrics.
Valid representation of the unifying optimization technique used throughout the book. · Reliable when training logs are recorded.
Operationalized via the ability to explain, derive, or reimplement methods, and to choose appropriate techniques for problems.
- can explain why an algorithm works
- can reimplement a method independently
- selects correct method for a task
Best measured by performance assessments rather than self-report alone.
Central to the book's purpose; risk that self-report overstates understanding. · Reliability improves with task-based assessment.
Operationalized as the proportion of assertions and tests passed, and absence of type errors flagged by tools like mypy.
- assert statements pass
- unit tests succeed
- no type errors reported
Can be expressed as a pass rate or pass/fail per component.
Valid as a proxy for whether code does the right thing, as emphasized in Chapter 2. · Highly reliable via automated tooling.
Operationalized via goodness-of-fit metrics such as R-squared, mean squared error, or training loss.
- R-squared value
- sum of squared errors
- loss after training
Numeric; interpretation depends on metric (higher R-squared better, lower loss better).
Valid for in-sample fit but must be paired with generalization metrics. · Reliably computed from data.
Operationalized via the ability to complete real projects, select and apply methods, and effectively use production libraries.
- completion of independent data projects
- appropriate method selection
- effective use of NumPy/scikit-learn/pandas
Best captured by a portfolio or rubric-based assessment.
Aligns with the book's stated aspiration for the reader. · Reliability depends on consistent rubric application.
Operationalized via stated commitments, processes for auditing models and data, and decisions that weigh ethical tradeoffs.
- explicit ethical review steps
- checks for biased or nonrepresentative data
- preference for interpretable models when warranted
Largely attitudinal; can be supplemented by process audits.
Reflects Chapter 26's framing of ethics as a commitment to consider consequences. · Self-reported attitudes may be subject to social desirability bias.
Operationalized as the count and depth of techniques the learner implements by hand using the companion workbooks, including replicating starting data and reproducing the worked steps.
- completed Solver setups
- filled-in formula columns
- reproduced charts (ROC, correlogram, fan chart)
- exercises attempted
Count-based and ordinal (read-along < follow-along < reproduce from scratch).
Behavioral evidence is strong; risk that completion does not equal comprehension. · Consistent if completion is logged; self-report of 'I did it' is less reliable.
Operationalized as the presence and correctness of preparation steps such as dummy coding, standardization (subtract mean, divide by SD), class rebalancing, missing-value imputation, and matrix orientation in the prepared dataset.
- standardized columns with mean 0
- dummy variable columns
- balanced training set
- no NA holes in data
- correctly transposed/oriented matrices
Composite quality score combining binary presence checks and continuous quality of standardization.
Largely archival (inspect the dataset); high construct validity. · Reliable when assessed against a checklist of preparation steps.
Operationalized as evidence of stakeholder engagement, process learning, and re-specification of the handed-over problem before modeling begins.
- documented requirements gathering
- evidence of challenging the initial problem statement
- alignment between solved problem and true objective
Ordinal: passive acceptance to active reframing.
Self-report risks self-serving bias; behavioral evidence (meeting notes, problem statements) is preferable. · Moderate; depends on documentation quality.
Operationalized via ability to explain a technique's mechanics and trade-offs and to justify technique/distance choices, assessed by knowledge tests or structured explanations.
- correct explanations of algorithm steps
- ability to anticipate when a technique fails
- articulation of distance-measure rationale
Test-scored or rubric-scored continuous scale.
Self-report alone risks overconfidence; knowledge tests improve validity. · Reliable with standardized assessment items.
Operationalized via self-reported confidence/anxiety attitudes regarding approaching data problems before vs. after working through the material.
- self-reported comfort approaching new data problems
- willingness to volunteer for data tasks
- reduced avoidance
Attitudinal scale (affect/self-efficacy).
Subject to social desirability bias. · Good test-retest reliability typical for affect/self-efficacy constructs.
Operationalized as the documented match between problem characteristics and the chosen technique/distance/threshold, scored for appropriateness by review.
- choosing optimization vs. AI appropriately
- using cosine for sparse data
- setting cutoffs to business needs
Ordinal appropriateness rating per decision.
Reviewable against problem context for high validity. · Reliable with a clear appropriateness rubric.
Operationalized via counts of model variants tried, parameters tuned, and comparative evaluations performed during exploration.
- trying multiple k values
- comparing models with ROC curves
- experiment logs
Count-based behavioral measure.
High behavioral validity from logs/artifacts. · Reliable when iterations are recorded.
Operationalized through computed statistics: R-squared, F/t test p-values, AUC/ROC, precision, recall, specificity, false positive rate, and standard error on holdout data.
- R-squared
- p-values
- ROC/AUC
- precision/recall/specificity
- prediction interval coverage
Continuous metric values; archival/computed.
High validity; computed from data, not self-reported. · Highly reliable given fixed data and method.
Operationalized via downstream business KPIs attributable to the analytic solution (e.g., revenue lift, cost reduction, conversion improvement, fewer errors).
- KPI changes post-deployment
- model adoption/usage rates
- documented decisions influenced
Continuous monetary or KPI scale; requires attribution.
Attribution is challenging; confounds from other initiatives. · Depends on stable KPI measurement and controlled comparison.
Operationalized via peer/manager ratings of clarity and translation ability and observed embeddedness in business planning discussions.
- participation in early planning
- clear non-technical explanations
- stakeholder ratings
Rating scale plus behavioral participation counts.
Best triangulated across self, peer, and manager ratings. · Moderate; rater agreement should be checked.
Operationalized via project post-mortem indicators: unnecessary model complexity, premature tool purchase, performance optimization where unneeded, and resulting non-adoption.
- unmaintainable models
- tools bought before problem defined
- effort on speed that doesn't matter
- low adoption due to complexity
Ordinal severity rating per project.
Self-report unreliable due to rationalization; observe via outcomes/post-mortems. · Moderate; depends on honest post-mortem review.
The documented tier structure (single, two, or three-tier), presence of staging/reconciliation layers, and server configuration as recorded in design specifications.
- number of architectural tiers
- presence of staging/reconciled layer
- scalability and fault tolerance mechanisms
Categorical (tier type) plus capability checklist; not a continuous self-report scale.
Validity ensured by mapping documentation to recognized architecture types described in the book. · High inter-rater reliability achievable through standardized architecture audit checklists.
Classification of the implemented schema as star, snowflake, or fact constellation based on inspection of the logical/physical data model.
- degree of normalization
- join count required for queries
- redundancy level in dimension tables
Categorical schema type plus structural metrics; no Likert scaling.
Construct maps directly to schema definitions in the text. · Reliable via schema model inspection by database experts.
Composite of ETL error rates, transformation completeness, reconciliation success, and load timeliness from process logs supplemented by practitioner assessment.
- data load error counts
- reconciliation mismatch rates
- transformation rule coverage
Mixed archival metrics with possible practitioner rating; avoid pure self-report.
Aligned with ETL stages described across Chapters 1 and 3. · Log-based metrics offer high reliability; practitioner ratings need calibration.
Assessment of metadata repository completeness across descriptive, structural, technical, administrative, provenance, rights, and preservation categories, plus user understandability ratings.
- metadata coverage percentage
- lineage traceability
- presence of metadata repository
Coverage checklist combined with perceptual ratings of metadata usefulness.
Maps to the metadata types and roles enumerated in Chapter 1. · Coverage metrics are reliable; perception measures require validated items.
Documented mapping of selected techniques (e.g., classification, clustering, association) to defined business problems and data characteristics, evaluated for fit.
- technique-to-problem mapping documentation
- model evaluation metrics
- technique fit justification
Categorical technique selection plus fit-justification assessment.
Grounded in technique taxonomy of Chapters 4 and 6. · Reliable when assessed against documented selection rationale.
Composite index of data profiling results (accuracy, completeness, consistency, duplication) and user trust ratings.
- error/defect rates
- duplicate record counts
- consistency violations
- user trust in data
Mixed: objective profiling metrics plus perceptual trust ratings.
Aligns with data quality characteristics described in Chapters 1 and 3. · Profiling metrics highly reliable; trust ratings need internal consistency validation.
Measured query response times, throughput, and resource utilization captured from system performance logs.
- average query latency
- queries per second
- CPU/memory usage during queries
Continuous archival metrics; not self-reported.
Directly tied to tuning and performance discussions in Chapter 3. · System-logged metrics provide high reliability.
Combination of perceived analytical functionality from user surveys and usage logs of OLAP/mining tools and operations performed.
- number of analytical queries/reports
- diversity of mining tasks performed
- user-rated analytical empowerment
Perceptual survey items combined with behavioral usage logs.
Supported by analytical functions described across Chapters 1, 4, and 7. · Usage logs reliable; survey items require validation.
Decision-maker assessments of confidence and informedness combined with traceable business decision outcomes attributed to warehouse/mining insights.
- self-reported decision confidence
- realized outcome alignment
- speed of decision cycles
Primarily perceptual self-report supplemented by outcome tracking.
Reflects 'improved decision-making' benefit emphasized in Chapter 1. · Self-report subject to bias; triangulate with outcome data.
Composite of market and efficiency indicators (operational efficiency gains, responsiveness, benchmarking) and managerial perception of competitive positioning.
- efficiency improvement metrics
- market share or performance trends
- perceived competitive standing
Mixed archival performance metrics and managerial perception.
Aligns with competitive advantage claims in Chapter 1. · Archival metrics reliable; perception measures need validated scales.
Classify the dominant data model and encoding format used by a system, and document its schema evolution mechanism (e.g., schema-on-read vs schema-on-write).
- Use of relational tables, JSON/document stores, or graph databases
- Encoding formats such as Avro, Thrift, Protocol Buffers, JSON
- Presence of schema migration tooling
Categorical classification with supplementary documentation of evolution approach.
Valid as long as the dominant model reflects actual access patterns; hybrid systems require care. · Reliable when assessed from architecture documentation and code inspection.
Identify the storage engine type (log-structured, B-tree, column-oriented) and characterize its read/write performance via benchmarking.
- LSM-tree vs B-tree configuration
- Write amplification metrics
- Sequential vs random I/O patterns
- Compression and column layout
Categorical type plus continuous performance metrics.
Performance metrics must be measured under representative workloads. · Engine type is reliably determinable; benchmark results depend on test setup.
Categorize as single-leader, multi-leader, or leaderless, and record whether replication is synchronous or asynchronous, plus replication lag.
- Configured replication topology
- Failover behavior
- Measured replication lag
- Conflict resolution logic present
Categorical for model and synchrony; continuous for lag.
Valid from configuration and runtime metrics. · Replication topology is reliably observable; lag varies with conditions.
Identify the partitioning scheme (key-range, hash) and secondary index partitioning, and measure load distribution across partitions.
- Partition key assignment metadata
- Per-partition request and storage distribution
- Presence of hot spots or skew
- Rebalancing configuration
Categorical scheme plus continuous distribution metrics.
Skew measurement validly indicates partitioning effectiveness. · Reliably observable from partition metadata and monitoring.
Record the configured isolation level and atomic-commit mechanism, and verify via fault-injection tests for concurrency anomalies.
- Configured isolation level (read committed, snapshot, serializable)
- Presence of distributed transaction coordinators
- Observed concurrency anomalies under testing
Ordinal from weak to strong isolation plus categorical commit mechanism.
Configured level may differ from actual guarantees; testing improves validity. · Anomaly testing (e.g., Jepsen-style) provides reliable verification.
Aggregate observed network fault rates, clock skew measurements, and process pause durations into an environment unreliability profile.
- Network partition and packet loss events
- NTP-measured clock offset
- Garbage collection and scheduling pause logs
- Timeout-triggered failovers
Composite of continuous metrics; profile rather than single scalar.
Valid as a contextual moderator; difficult to fully capture all failure modes. · Individual metrics reliably measurable; composite requires consistent instrumentation.
Quantify via load parameters such as requests per second, dataset size, fan-out, and read/write mix.
- Requests per second metrics
- Total stored data size
- Concurrency levels
- Distribution of query types
Continuous metrics, multi-dimensional.
Choice of load parameters must match the system's bottleneck. · Reliably measured through system monitoring.
Document the consensus/ordering mechanism in use and verify its guarantees through linearizability and ordering tests under fault conditions.
- Use of consensus systems (ZooKeeper, etcd, Raft, Paxos)
- Linearizability test results
- Observed agreement under partition
- Ordering guarantees in logs
Categorical mechanism plus pass/fail verification of properties.
Linearizability testing provides strong validity evidence. · Behavioral testing is reliable but computationally expensive.
Characterize the integration architecture (dual writes vs log-based derivation) and measure derived-data freshness and consistency.
- Presence of log-based messaging (e.g., Kafka)
- Use of change data capture pipelines
- Derived view freshness / lag
- Reprocessing capability
Categorical architecture plus continuous freshness metrics.
Valid as indicator of integration robustness and evolvability. · Architecture reliably observable; freshness varies with load.
Assess through developer ratings of understandability and structural metrics such as coupling, dependency tangling, and change effort.
- Developer-reported difficulty understanding the system
- Coupling and dependency metrics
- Frequency of unexpected interactions/bugs
- Effort estimates for changes
Likert-style perceptual ratings combined with structural metrics.
Perceived complexity is a valid proxy for maintenance burden. · Self-report aggregated across developers improves reliability.
Measure via uptime, error and fault rates, mean time to failure, and incidence of data loss or corruption.
- Uptime percentage
- Error rates
- Incidents of data loss or corruption
- Successful recovery from faults
Continuous metrics aggregated over time periods.
Composite reliability requires capturing multiple fault types. · Archival operational metrics provide high reliability.
Measure throughput and response-time percentiles as load and resources are scaled.
- Requests handled per second at scale
- p95/p99 latency under increasing load
- Linear vs sublinear scaling with added nodes
Continuous performance metrics across load levels.
Must measure percentiles, not just averages, for validity. · Load testing provides reliable measurement.
Assess via operability metrics and team perceptions of ease of change, supplemented by change-effort tracking.
- Effort required to make changes
- Team-reported ease of operation
- Time to onboard new engineers
- Frequency of operational surprises
Combination of perceptual ratings and effort metrics.
Multi-dimensional construct; partial measures may understate it. · Aggregated team self-report and change tracking improve reliability.
Count of training instances (rows) in the dataset used to fit the model.
- dataset row count
- learning curve plateau behavior
Ratio scale (non-negative integer count).
Quantity alone is insufficient if data is nonrepresentative. · Highly reliable as a direct count.
Composite of missing-value rate, outlier rate, sampling-bias measures, and proportion of irrelevant features.
- percent missing per feature
- outlier counts
- distribution comparison between training and production data
Mixed: ratios for missing/outlier rates; categorical flags for bias.
Representativeness is difficult to verify; sampling bias may be hidden. · Depends on quality of audit procedures.
Set of preprocessing and transformation steps applied (selection, extraction, scaling, attribute combinations) and their effect on feature importance.
- number and type of transformations in pipeline
- feature importance scores
- correlation of engineered features with target
Mostly categorical/ordinal documentation of steps plus continuous importance scores.
Effectiveness depends on domain knowledge and is task-specific. · Reproducible when codified in pipelines.
Value of regularization hyperparameters (e.g., alpha for Ridge/Lasso, l1_ratio for Elastic Net, dropout rate, early-stopping point).
- alpha value
- penalty type
- dropout rate
Ratio scale for continuous hyperparameters; categorical for penalty type.
Strength must be tuned; too high causes underfitting. · Exactly specified and reproducible.
Method (grid/randomized search), search space size, number of candidate models evaluated, and selected configuration.
- number of combinations tried
- best validation score
- selected hyperparameters
Mixed ratio and categorical.
Validity depends on not overfitting the validation set. · Reproducible with fixed random seeds.
Presence and correctness of test, validation, and train-dev sets; use of cross-validation; avoidance of data snooping.
- existence of held-out test set
- cross-validation usage
- representativeness of validation/test sets
Largely categorical/ordinal checklist of practices.
Subjective in assessing representativeness. · Reliable if procedures are documented.
Gap between training error and validation error; learning curve shapes.
- train-validation error gap
- learning curve convergence
- training error near zero with high validation error
Continuous error gap; interpreted ordinally.
Requires reliable validation error estimate. · Reproducible given fixed splits.
Task-appropriate metric on held-out test set and in production (RMSE/MAE for regression; accuracy, precision, recall, F1, ROC AUC for classification).
- test set RMSE
- precision/recall/F1
- ROC AUC
- generalization error
Ratio/interval depending on metric.
Metric choice must match the task and data skew. · Reliable with sufficiently large, representative test sets.
Presence of live performance monitoring, input data quality checks, alerting, retraining automation, and rollback capability.
- monitoring alerts
- retraining frequency
- data quality metrics over time
- model version backups
Mixed categorical practice flags and continuous frequency/quality metrics.
Some performance can only be inferred via downstream metrics or human raters. · Depends on robustness of monitoring infrastructure.
Operationalized through tuning settings such as polynomial degree, spline degrees of freedom, tree depth, number of neighbors K, or neural network size.
- count of model parameters
- degrees of freedom
- knot or neighbor count
Continuous or ordinal proxy via degrees of freedom.
Degrees of freedom approximate flexibility but may not capture true model capacity in nonlinear settings. · Reproducible given a fixed model specification.
Indicated by whether cross-validation, validation-set, or bootstrap procedures were applied to choose tuning parameters.
- number of folds used
- presence of held-out validation
- bootstrap replications
Categorical (procedure type) plus numeric settings (folds, replications).
Improper resampling (e.g., selecting features before CV) invalidates error estimates. · Estimates vary with random splits but stabilize with more folds/replications.
Computed as p (number of features) and n (number of observations), and especially the ratio p/n.
- dataset shape
- feature count
- sample count
Counts and ratios.
Directly observable and unambiguous. · Fully reproducible.
Estimated in simulation as variance of f(X) divided by error variance; approximated by R-squared in practice.
- R-squared on held-out data
- residual variance estimates
Non-negative ratio.
Unobservable directly in real data; only estimable. · Estimates depend on model adequacy.
In simulation, measured as the difference between average model prediction and the true function value.
- deviation of average prediction from truth
Continuous, on the scale of the squared response.
Only measurable when the true function is known (simulation). · Estimable via repeated simulation.
In simulation, measured as the variance of predictions across models fit on resampled training sets.
- spread of fitted curves across training sets
Continuous, non-negative.
Best estimated through resampling or simulation. · Stabilizes with many resamples.
Computed as MSE (regression) or misclassification rate (classification) on the training set.
- residual sum of squares on training data
- training accuracy
Continuous (MSE) or proportion (error rate).
Underestimates test error and should not be used for model selection. · Deterministic given model and data.
Inferred from the gap between training and test (or cross-validated) error.
- large difference between training and test error
Continuous gap measure.
Requires a valid test-error estimate to assess. · Depends on quality of test-error estimate.
Estimated as MSE or misclassification rate on a held-out test set or via cross-validation.
- held-out loss
- cross-validated error
Continuous (MSE) or proportion (error rate).
Valid only if the test set is independent of training. · Varies with test-set choice; CV reduces variability.
Judged qualitatively, e.g., by number of nonzero coefficients or simplicity of structure.
- count of active predictors
- presence of interpretable coefficients
Largely qualitative or ordinal.
Subjective and context-dependent. · Lower reliability due to subjective judgment.
Quantified by family-wise error rate (FWER) or false discovery rate (FDR) across tests.
- proportion of false discoveries among rejections
- probability of at least one false rejection
Proportions between 0 and 1.
Depends on validity of the null distribution assumptions. · Estimable via theoretical or resampling-based procedures.
Inventory of team skill coverage across the four pillars plus soft skills like curiosity, collaboration, and storytelling.
- skill certifications
- range of techniques mastered
- cross-disciplinary collaboration on projects
Categorical/ordinal skill coverage ratings; not a formal scale in the book.
Self-reported skill may overstate competence. · Skill inventories can vary by assessor.
Degree to which sampling, partitioning, imputation, transformation, and feature engineering/selection are performed appropriately.
- missing value rates after imputation
- number and relevance of selected features
- presence of train/validation/test splits
Archival/process metrics rather than a scored scale.
Process completion does not guarantee quality. · Depends on consistent documentation.
Comparative judgment of candidate models against business requirements and data characteristics.
- rationale documented for technique selection
- comparison of multiple candidate models
Qualitative assessment.
Subject to analyst judgment. · May vary across analysts.
Measures of deployment success including time-to-deployment, scoring latency, and whether models reach production.
- percent of models deployed
- time from development to production
- scoring response time
Archival operational metrics.
Deployment alone does not ensure value. · System logs provide reliable measures.
Presence and frequency of monitoring, drift detection, and retraining/challenger deployment.
- monitoring dashboards
- retraining frequency
- detection of performance decay
Archival/process metrics.
Monitoring quality depends on chosen metrics. · Automated monitoring is reliable.
Business KPIs affected by model-informed actions.
- campaign response/lift
- loss avoided in dollars
- churn rate change
- loan approval/denial rates
Continuous business metrics.
Attribution to the model can be confounded by other factors. · Archival KPIs are reliable but need controls (e.g., control groups).
Categorical classification of the data-collection protocol as independent (within-sample) random sampling, dependent random sampling, or biased sampling, determined by inspecting how the sample was obtained.
- use of a random number table or computer randomization
- exclusion of subgroups from the sampling frame
- matching or repeated measurement across samples
Nominal classification.
Validity depends on whether the stated procedure actually achieves equal probability of inclusion; hidden biases (e.g., nonresponse) threaten validity. · Reliably coded if the protocol is documented.
Present/absent coding based on whether a documented random procedure (e.g., random number table) determined each subject's experimental condition.
- documented randomization of condition assignment
- balance of subject characteristics across groups
Nominal (present/absent).
Valid only if randomization was genuinely independent of subject characteristics. · Reliably determined from the experimental protocol.
A count of the observations in the sample(s) used in the analysis.
- recorded number of cases in the dataset
Ratio scale (count).
Unambiguous count; validity high. · Perfectly reliable when records are accurate.
The numeric alpha value chosen before data analysis (e.g., .05, .01, .10).
- stated alpha in the analysis
- critical value selected from a table
Ratio (probability between 0 and 1).
Valid index of Type I error probability only when assumptions are met. · Set deterministically by the analyst.
Categorical coding of the stated alternative hypothesis as directional or nondirectional.
- form of the stated H1
- one- vs. two-tailed rejection region
Nominal.
Must be set before examining data; switching after viewing data invalidates the test. · Reliably coded from the stated hypotheses.
Assessed via reliability coefficients, validity evidence, scale type, and the degree of standardization of data-collection conditions.
- test-retest consistency
- construct validity evidence
- uniformity of testing conditions
Composite; underlying indices range from ordinal to ratio.
Higher measurement quality reduces measurement-induced variability. · Indexed by reliability coefficients per psychometric texts.
Judged by comparing observed distributional features (skew, sample variances, scale type, sampling independence) against the procedure's stated assumptions.
- sample skewness
- ratio of sample variances
- measurement scale
- sampling protocol
Composite judgment, often categorical (met/violated) by assumption.
Robustness of statistics means mild violations have little effect; gross violations require nonparametric alternatives. · Depends on consistent application of diagnostic checks.
Estimated via standardized indices such as Cohen's d (difference between means divided by standard deviation) or the magnitude of a correlation; computed from sample statistics as d-hat.
- Cohen's d estimate
- r-squared
- difference between sample mean and hypothesized value
Ratio (standardized units).
Sample-based estimates approximate the unknown population effect size. · Estimate stability increases with sample size.
Computed as the standard error (e.g., sigma divided by the square root of n for the sample mean, or the estimated standard error using s).
- computed standard error value
- width of the sampling distribution
Ratio.
Exact for the sample mean via Amazing Fact Number 2; estimated when sigma is unknown. · Deterministically computed from data and n.
Computed from the effect size (d), sample size, alpha, and alternative-hypothesis type using delta and power tables (Table B).
- power value from tables
- delta computed as d times square root of n
Ratio (probability between 0 and 1).
Valid given accurate effect-size estimates and met assumptions. · Deterministically computed once inputs are fixed.
Conceptually defined by the four-cell outcome table; in practice indexed by the error probabilities alpha and beta since the truth is unknown.
- decision to reject or retain
- alpha and beta values
Conceptual/categorical outcome.
Cannot be directly observed because the true state of the null is unknown. · Indexed indirectly through error probabilities.
Judged by whether random sampling was used and how broad the sampled population was, with overgeneralization flagged when claims exceed the sampled population.
- match between conclusion scope and sampled population
Conceptual/categorical.
Valid generalization requires random sampling from the target population. · Judged consistently by comparing claims to the sampling frame.
Judged by the presence of random assignment and the elimination of confounds, not by the form of the statistical test.
- documented random assignment
- absence of systematic group differences
Conceptual/categorical.
Causal claims unwarranted without random assignment; correlation/regression alone cannot establish causation. · Judged from the design documentation.
Captured by archival measures such as number of observations, number of feature variables, missing-value proportions, and error rates in the raw data set.
- row count
- feature count
- percent NA values
- documented data errors
Counts and ratios; continuous and ordinal.
More data improves accuracy only if informative; redundant data adds little. · Archival counts are highly reliable.
Measured by the number of distinct source types successfully imported (CSV, Excel, JSON, HTML, SQL, API) and the time required.
- count of source connectors used
- successful data frame loads
- pipeline scripts
Counts and time; partly perceptual skill rating.
Skill self-reports may be biased; behavioral logs more valid. · Behavioral logs reliable; self-reports less so.
Quantified by number of transformation steps in the pipeline, time logged, and types of munging operations applied.
- pipeline script length
- hours on munging
- operations applied
Counts, time; mixed behavioral and perceptual.
Effort does not guarantee quality; pair with tidiness outcome. · Script-based counts reliable.
Assessed by structural checks: one variable per column, one observation per row, consistent formats, informative names, minimal missing values.
- NA count
- format compliance
- naming convention adherence
Compliance ratios and counts; archival.
Strong content validity against tidy-data guidelines. · Automated checks highly reliable.
Measured by the count and variety of summaries and plots produced (histograms, boxplots, scatterplots, correlation matrices, etc.).
- number of plots
- summary statistics computed
- documented insights
Counts; partly perceptual regarding insight.
Quantity of plots imperfectly proxies insight quality. · Counts reliable; insight judgments less so.
Indexed by predictor importance measures, incremental model improvement from forward/backward selection, and number of engineered features retained.
- variable importance scores
- change in error from feature changes
- correlation reduction
Continuous importance and error-delta metrics.
Domain knowledge improves validity of engineered features. · Importance metrics reliable across resamples if model stable.
Recorded as the algorithm chosen and the comparative cross-validation errors across candidate algorithms.
- selected algorithm
- CV error per candidate
- tradeoff documentation
Categorical choice plus continuous comparative error.
Selection valid only if comparison uses unbiased error estimates. · CV-based comparisons reliable if seeded and repeated.
Captured as parameter settings (lambda, ntree, hidden layers, gamma, cost) and the resulting error-versus-parameter curves.
- parameter values
- validation error curves
Continuous and discrete parameter values.
Best parameter depends on problem; tuned on validation set. · Reproducible with fixed seeds.
Detected as the gap between in-sample training error and out-of-sample test error (training low, test high).
- small training error with large test error
- unstable predictions across samples
Continuous error-gap metric.
Requires a true held-out test set to detect validly. · Reliable when test set is independent.
Estimated by decomposing reducible error into squared bias and variance over repeated resampled training sets.
- bias estimate
- variance estimate
- test error minimum
Continuous, nonnegative components.
Decomposition requires multiple resamples and a known target conceptually. · Stable with sufficient resampling repetitions.
Identified via EDA surprises, implausibly high performance, and divergence between estimated and field out-of-sample performance.
- too-good performance
- leaky feature correlations
- estimated vs realized error divergence
Largely categorical/diagnostic.
Subtle and often inadvertent; hard to fully detect. · Field testing most reliable but costly.
Assessed via demographic/complementary measures and multivariate analysis revealing systematic between-condition differences.
- sign/slope changes when confounder included
- systematic group differences
Continuous correlations; categorical detection.
Best controlled by design and random assignment. · Detection depends on collecting candidate confounder data.
Recorded as the resampling method used (random subsampling, K-fold, LOOCV), number of folds/repeats, and reported CV error.
- CV error estimate
- CV procedure documentation
Continuous error estimate plus categorical method.
Valid generalization estimate requires independent final test set. · Repeated CV reduces estimate variance.
Assessed via deployment status, decision-maker adoption, and downstream business KPIs influenced by model outputs.
- production deployment
- report adoption
- KPI movement (revenue, churn, cost)
Mixed: categorical deployment, continuous KPIs, perceptual stakeholder ratings.
Value depends on factors beyond model accuracy (interpretability, scalability). · KPI archival measures reliable; perceptual judgments less so.
Computed from observed link data as a graph; characterized by metrics such as clustering coefficient, average path length, betweenness, component sizes, and presence of local bridges.
- number and pattern of edges
- clustering coefficient values
- shortest-path distances between node pairs
- betweenness scores
- size of giant component
Mixture of continuous metrics (clustering coefficient 0-1, path lengths) and categorical structural features (bridge/not-bridge).
Validity depends on accurate, complete link data; sampled or partial networks (e.g., only frequent contacts) can bias structural measures. · Structural metrics are reproducible given the same graph data; reliability degrades with noisy or incomplete edge observations.
Operationalized as total communication time/frequency between two nodes over an observation period, or by neighborhood overlap; categorized into strong vs. weak for analysis.
- minutes of phone/communication contact
- neighborhood overlap ratio
- self-reported closeness
- number of shared friends
Can be continuous (communication minutes, overlap percentile) or dichotomized (strong/weak).
Communication-frequency proxies may not perfectly capture relational closeness; the book notes simplifying a continuum into two categories. · Archival communication measures are highly reliable; self-reported strength is more variable.
Specified by the rules of a game, auction, or market (payoff matrices, bidding rules, clickthrough rates and revenues per click) or estimated from observed bids/prices/valuations.
- bids submitted
- prices paid
- valuations revealed through choices
- reported willingness to pay
Payoffs are typically numerical (monetary or utility units); valuations may be continuous and private.
Payoffs must reflect everything the agent values (including emotional/fairness components, as in the Ultimatum Game) to be valid. · Experimentally controlled payoffs are reliable; inferred valuations from market data are noisier.
Measured by comparing the observed fraction of cross-attribute edges to the fraction expected under random mixing (the homophily test); inverse homophily when cross-attribute edges exceed baseline.
- fraction of heterogeneous (cross-attribute) edges
- attribute distributions of linked pairs
- longitudinal alignment of behaviors among neighbors
Expressed as a comparison of proportions; deviation from 2pq baseline indicates homophily or inverse homophily.
Requires both attribute and link data; distinguishing selection from social influence requires longitudinal data. · The homophily test is reproducible given the same data and attribute definitions.
Elicited as stated probability estimates or revealed through choices (bids, votes, adoption); modeled via conditional probabilities and Bayesian updating.
- stated probability judgments
- bidding/pricing behavior
- adoption or rejection decisions
- prediction-market prices
Probabilities on a 0-1 scale; choices as discrete indicators of underlying beliefs.
Self-reported beliefs may deviate from Bayes-optimal estimates (e.g., overweighting observations vs. priors); revealed beliefs partly confounded with strategy. · Repeated elicitation can be inconsistent; market-revealed beliefs are more stable in aggregate.
Observed as the propensity to adopt/choose what neighbors or predecessors have chosen, measured by adoption decisions conditioned on prior actions of others.
- matching of choices to predecessors/neighbors
- sequential adoption patterns
- probability of linking to already-popular items
Often a probability or rate of conforming choices; can be a binary adoption indicator per decision.
Distinguishing informational from direct-benefit imitation, and imitation from homophily, requires careful experimental or longitudinal design. · Behavioral traces of imitation are reliably observed in online data; mechanism attribution is less certain.
Computed as q = b/(a+b) from the payoffs a (coordinating on new behavior) and b (coordinating on old behavior); inferred from observed switching conditioned on neighbor adoption fractions.
- fraction of adopting neighbors at the moment of switching
- payoff ratios between behaviors
A fraction between 0 and 1.
Derived from a stylized coordination model; real thresholds may be more complex and heterogeneous. · Theoretically determined; empirical estimation depends on observing switching behavior accurately.
Specified as parameter p in branching/SIR/SIS models; combined with contacts k to form the basic reproductive number R0 = pk; estimated from transmission data.
- observed secondary infections per case
- transmission events in contact-tracing data
Probability on 0-1 scale; R0 is a derived nonnegative number.
Real transmission probabilities vary by pair and stage; the basic model uses uniform p. · Epidemiological estimates depend on data quality and assumptions about contact structure.
Detected by fitting power-law distributions (straight line on log-log plot) to popularity/adoption data and by observing growth proportional to current size (preferential attachment).
- power-law exponent of the popularity distribution
- linear log-log plot of frequency vs. value
- proportional growth of popular items
Characterized by a power-law exponent (typically slightly above 2) and goodness of log-log fit.
A power-law fit alone does not confirm a specific mechanism; the same distribution can arise from different processes. · Distributional measures are reproducible across snapshots, though tail estimation is sensitive to sample size.
Inferred from market structure (which side knows quality) and outcomes (quality distribution of traded goods, prices below high-quality value); modeled via self-fulfilling expectations over average quality.
- proportion of low-quality goods traded
- prices that fail to support high-quality trade
- withdrawal of high-quality sellers
Often modeled categorically (quality types) with associated probabilities and valuations.
Directly unobservable; inferred from market behavior and theoretical conditions for failure. · Inference depends on accurate knowledge of value distributions and who holds information.
Assessed by comparing private equilibrium payoffs to total social welfare; quantified as the harm/benefit imposed on others not reflected in prices.
- gap between equilibrium and socially optimal outcomes
- Braess-type efficiency loss
- commons overuse beyond optimal level
Measured in welfare/payoff units; difference between social optimum and equilibrium.
Requires a model of social welfare and of harm/benefit not captured by market prices. · Estimates depend on the assumed welfare model and value parameters.
Measured as the fraction of nodes that adopt/are infected over time, whether a complete cascade occurs, and the timing/synchronization of spread.
- adoption time-series
- infection prevalence curves
- reach of the spread across the network
Fractions (0-1) and time-series counts; binary indicator for complete cascade.
Directly observable in trace/epidemiological data; attributing spread to mechanism requires modeling. · Highly reliable from observed adoption/infection records.
Observed directly as transaction prices, market-clearing prices, auction outcomes (who wins, what they pay), and allocations of items to buyers.
- transaction prices
- bid/ask spreads
- allocation of items to agents
- total surplus realized
Monetary units for prices/revenue; categorical assignments for matchings.
Observed prices reflect equilibrium under stated behavioral assumptions; may deviate with status effects or non-equilibrium play. · Directly recorded in markets and experiments; highly reliable.
Measured via division of resources in exchange-network experiments, distribution of popularity/wealth shares, or trader profits in trading networks.
- share of resources captured in negotiations
- power-law popularity distributions
- wealth-share evolution over time
- profit margins of intermediaries
Shares/proportions and distributional shape (e.g., power-law exponent); experimental payoff splits.
Experimental splits validly capture power in stylized settings; mapping to real-world power is approximate. · Experimental outcomes are reproducible; field distributions are stable across snapshots.
Operationalized through data audits measuring missing-value rates, duplication, format consistency, error rates, and comparison of key sample statistics against known population benchmarks or external sources.
- percent missing
- duplicate record counts
- deviation of sample demographics from population
- presence of selection-bias mechanisms
Composite of ratio-scaled quality metrics and qualitative bias assessment.
Bias is often invisible; representativeness can only be confirmed against external benchmarks. · Quality metrics are reproducible given a fixed dataset; bias judgments are more subjective.
Operationalized by counting and classifying EDA artifacts produced (estimates of location/variability, histograms, boxplots, density plots, scatterplots, correlation analyses) and anomalies identified.
- number of plots created
- summary statistics computed
- outliers flagged
- relationships visualized
Ordinal/count measure of analytic activity.
Effort count is a proxy; quality of insight is harder to capture. · Artifact counts are reproducible from notebooks/logs.
Operationalized by inspecting the preprocessing pipeline for use of z-score standardization/normalization, one-hot/dummy encoding, and suitable distance metrics (e.g., Gower's) relative to the method's requirements.
- presence of scaler transforms
- encoding scheme used
- whether scaling matches method requirements
Categorical/binary appropriateness judgment per variable and method.
Appropriateness depends on the downstream algorithm; not universally required. · Pipeline inspection yields consistent assessments.
Operationalized by detecting bootstrap resampling, permutation tests, number of iterations, and whether resampled distributions inform reported intervals or p-values.
- presence of resample loops/functions
- reported bootstrap standard errors/intervals
- permutation-based p-values
Binary presence plus ordinal intensity (iteration count).
Use does not guarantee correctness; representativeness of source sample still required. · Detectable consistently from code.
Operationalized by checking whether reported metrics (RMSE, R-squared, precision, recall, specificity, AUC, lift, cost-based return) suit the problem type and class balance.
- metrics reported
- use of AUC/lift/cost for rare classes
- avoidance of accuracy as sole metric on imbalanced data
Categorical appropriateness rating per analysis.
Appropriateness judged relative to stated objective; objectives may be implicit. · Consistent given documented objectives and reported metrics.
Operationalized via empirical coverage of confidence/prediction intervals on held-out data and consistency between reported standard errors and resampled variability.
- interval coverage rates
- agreement of formula-based and bootstrap SEs
- calibration plots
Ratio-scaled coverage/calibration metrics.
Distinguishing prediction from confidence intervals is essential; conflating them underestimates uncertainty. · Coverage estimates stabilize with sufficient holdout data.
Operationalized by out-of-sample error or skill metrics computed via holdout or cross-validation: RMSE for regression; accuracy, AUC, recall, or lift for classification.
- holdout RMSE
- cross-validated AUC/accuracy
- lift in top deciles
Ratio-scaled performance metrics.
Validity hinges on a genuinely independent holdout and an appropriate metric. · Reproducible with fixed partitions; averaged over folds for stability.
Operationalized by replicability of findings, robustness to holdout validation and target shuffling, and adherence to multiplicity adjustments where appropriate.
- successful replication on new data
- use of holdout/permutation checks
- adjusted p-values where many tests run
Largely categorical/ordinal judgment supported by replication evidence.
p-values do not directly measure validity; replication is the stronger signal. · Replication-based assessment is robust but resource-intensive.
Measured by demonstrated ability to use NumPy, pandas, and IPython/Jupyter features correctly across representative tasks, or by self-reported familiarity ratings.
- Correct use of library functions
- Completion of exercises
- Range of features used
Could use ordinal proficiency levels or counts of mastered features.
Self-report may overestimate; behavioral assessment is more valid. · Skill tests should be standardized for reliability.
Measured by the proportion of data operations implemented via vectorized constructs versus explicit loops in code artifacts.
- Code patterns using broadcasting and ufuncs
- Absence of element-wise loops
Ratio of vectorized to total operations.
Requires code inspection; not amenable to self-report. · Automated code analysis improves reliability.
Measured by quality and tidiness of produced DataFrames (correct types, meaningful indexes, no malformed structure).
- Well-formed DataFrames
- Consistent column types
- Resolved missing data
Quality checklist scoring.
Best assessed by examining data artifacts. · Checklist criteria should be clearly defined.
Measured by task completion time and/or perceived ease of completing data tasks.
- Shorter time-to-result
- Fewer manual steps
- Faster iteration cycles
Time in minutes; ease as Likert-like perception (feasibility only).
Time is objective; perceived ease subject to bias. · Repeated timing tasks improve reliability.
Measured via self-reported confidence in handling data analysis tasks.
- Self-reported confidence
- Willingness to undertake complex tasks
Perceptual self-report (feasibility only).
Subject to self-report bias. · Consistent items needed for reliability.
Measured by completeness, correctness of types, consistency, and absence of structural problems in the resulting dataset.
- No unresolved missing data where expected
- Correct dtypes
- Properly merged/reshaped tables
Data-quality metrics.
Objectively assessable via the dataset itself. · Automated quality checks improve reliability.
Measured by the correctness, relevance, and usefulness of analyses, plots, and models produced from the data.
- Correct aggregations
- Informative plots
- Successfully fitted models
Mixed objective and expert-rated assessment.
Some components objective (correct outputs), others rated. · Rubrics improve rating reliability.
Assessed by inspecting datasets/code for tidy structure (one variable per column, one observation per row) and by self-reported consistency of tidying practice.
- datasets stored as tibbles with tidy layout
- frequency of using gather()/spread()/separate()
- absence of values embedded in column names
Could be scored as a proportion of datasets in a workflow that meet tidy criteria; feasibility only, no scoring rules prescribed.
Archival code inspection gives objective evidence; self-report risks social desirability about 'good practice'. · High inter-rater reliability expected given clear tidy criteria.
Measured by the proportion of analysis tasks performed with tidyverse packages (ggplot2, dplyr, tidyr, readr, purrr) versus inconsistent alternatives, observable in scripts and self-report.
- library(tidyverse) calls
- use of %>% pipelines
- consistent verb-based function usage
Feasible to count tidyverse function calls relative to total; self-report of toolkit preference also feasible.
Code-based measurement is objective and valid; self-report adequate for preference. · High reliability from automated code parsing.
Assessed by analyzing code for repeated blocks versus abstracted functions and map/loop usage that consolidate repetition.
- defined custom functions
- absence of near-duplicate code blocks
- use of purrr map functions
Feasible via static code analysis counting duplicated lines and function definitions; no scoring rules prescribed.
Archival code analysis is the most valid mode; self-report is weaker. · Reasonably reliable with consistent code-analysis criteria.
Captured via self-reported engagement, persistence intentions, and frustration levels during analysis tasks.
- self-rated motivation
- continued practice over time
- completion of exercises
Perceptual self-report feasible; behavioral proxies like session continuation possible.
Self-report valid for subjective motivation but prone to recall and desirability bias. · Moderate; motivation fluctuates over time.
Measured by self-reported ease of focusing on questions and, indirectly, by ratio of time spent on analysis versus wrangling.
- self-rated clarity/focus
- proportion of session time on substantive analysis
- fewer reported tool-related interruptions
Perceptual self-report plus time-allocation proxies feasible.
Subjective construct; triangulation with time-tracking improves validity. · Moderate; depends on task and individual.
Observed via the count and cadence of plots, transformations, and model fits performed in an analysis session.
- number of distinct plots produced
- number of data transformations
- number of candidate models fit
Behavioral logs of analysis actions feasible; no scoring rules prescribed.
Behavioral measurement objective but may not capture quality of exploration. · Reliable if action logging is consistent.
Assessed by existence and completeness of R Markdown notebooks/reports and accompanying documentation of reasoning.
- .Rmd files that knit successfully
- narrative explanations alongside code
- version tracking of dependencies
Archival artifact analysis feasible; self-report of documentation habits possible.
Artifact-based measurement valid; quality of communication harder to quantify. · Reliable for presence/absence; less so for quality.
Proxied by the number and validity of hypotheses generated and patterns identified, judged by domain experts.
- documented findings/hypotheses
- expert-rated quality of insights
- patterns confirmed in independent data
Mixed-mode; expert judgment plus counts of validated hypotheses feasible.
Hard to measure directly; expert ratings improve validity but introduce subjectivity. · Lower; insight quality is judgment-dependent.
Proxied by time-to-completion, error rates, and breadth of problems solved per unit effort, plus self-report.
- time per analysis task
- number of debugging incidents
- range of project types handled
Mixed-mode; behavioral timing and error logs plus self-report feasible.
Productivity proxies valid but context-dependent. · Moderate; depends on consistent task definition.
Measured by dataset size (e.g., MB/GB), proportion of missing/inconsistent values, and degree of non-rectangular structure.
- file size and row count
- percent missing values
- presence of images/text/trees vs. tables
Archival measurement of dataset properties feasible.
Objective archival metrics give high validity for size and missingness. · High for size; moderate for structural irregularity classification.
Identify the sponsoring executive's role and seniority, whether sponsorship exists, and rate perceived commitment and use of BI by the sponsor.
- Presence and identity of executive sponsor
- Sponsor membership on operating committee
- Budget allocations
- Sponsor participation in BI governance
Perceptual ratings of commitment plus categorical sponsor role; avoid scoring rules.
Sponsor title alone is a weak proxy; business influence is the key construct. · Reasonably stable but can shift with personnel changes.
Assess perceptions of partnership quality, presence of hybrid business-IT roles, and degree of BI-business goal alignment.
- Hybrid business-IT staff counts
- Joint requirements and design sessions
- Alignment of BI roadmap with business strategy
Perceptual partnership ratings; categorical presence of hybrid roles.
Self-report from one side may be biased; multi-source assessment improves validity. · Moderately stable.
Combine archival data quality and update-frequency metrics with perceptions of trust and breadth of data sources.
- Number of source systems integrated
- Update frequency (real-time to monthly)
- Data quality error rates
- Presence of MDM
Mixed archival metrics plus perceptual trust ratings.
Perfection not required; threshold trust is what matters. · Archival metrics stable; perceptions vary by user.
Measure perceived relevance of BI to one's work and breadth of user segments served.
- Usage across diverse job types
- Personalized content delivery
- Self-reported relevance
Perceptual relevance ratings; behavioral adoption by segment.
Adoption may understate relevance if access is restricted. · Stable within roles.
Assess adoption of agile/scrum practices and cycle time to deliver BI capabilities.
- Use of scrum/sprints
- Time from request to delivery
- Frequency of releases
Mixed process descriptions and archival cycle-time metrics.
Self-labeled agile may differ from actual practice. · Moderate.
Identify governance bodies (BICC, steering committee) and assess team skills and structure.
- Presence of BICC/steering committee
- Team skill profiles
- Reporting structure of analytics function
Mixed categorical presence and perceptual effectiveness.
Structure presence does not guarantee effectiveness. · Stable.
Assess perceived ease of use and fit by user segment and tool adoption rates.
- Adoption per tool by segment
- User satisfaction ratings
- Number of supported standards
Perceptual fit/ease ratings plus archival adoption.
Tool blamed for underlying data/performance issues. · Moderate.
Identify through case narratives or SWOT analysis the presence of luck, opportunity, frustration, or threat affecting the BI effort.
- Documented catalyzing events
- SWOT opportunity/threat items
- Narratives of pain or boiling-point frustration
Largely qualitative; not amenable to numeric scoring.
Hindsight bias may attribute success to luck vs insight. · Low—context-specific and episodic.
Survey perceptions of fact-based decision norms, data openness, and support for challenging the status quo.
- Decisions cite data
- Open sharing of poor performance
- Reward for fact-based challenges
Perceptual culture survey items.
Social desirability bias possible. · Moderate to high.
Combine system usage logs (active users, report access, adoption rate) with self-report of acting on insights.
- Percentage active users
- Report/dashboard access frequency
- Documented decisions/actions from insights
Behavioral logs preferred; self-report supplements.
Defining a 'user' is contested (static vs interactive). · Behavioral logs reliable; self-report less so.
Self-rated success category by stakeholders.
- Success rating
- Stakeholder endorsements
Categorical self-report; avoid composite scoring.
Gap between vision and achievement; responder self-selection. · Moderate.
Mix archival outcome metrics (revenue, cost savings, wait times, test scores, ROI) with self-report of contribution.
- Revenue/cost changes
- Process time reductions
- Outcome improvements
- ROI estimates
Mixed archival and perceptual; ROI derived from imprecise inputs.
Attribution of impact to BI vs other factors is debatable. · Archival metrics reliable; attribution uncertain.
An audit score reflecting whether each fact table follows business process selection, explicit grain declaration, true-to-grain dimensions and facts, and conformance to documented Kimball techniques.
- Explicit grain statements in design documentation
- Single-grain fact tables
- Surrogate key usage
- Absence of text/aggregate facts violating grain
Best captured as an ordinal compliance rating against a technique checklist (e.g., Chapter 2).
High content validity due to the book's explicit technique catalog; risk of subjective auditor interpretation. · Inter-rater reliability improves with a standardized checklist.
A binary or ordinal indicator of whether each fact table's declared grain equals the lowest atomic level captured by its source process.
- One row per atomic measurement event
- Presence of full dimensionality
- Ability to drill to detail
Archival inspection of grain declarations versus source event granularity.
High validity; the book repeatedly stresses atomic grain as foundational. · Reliable when source granularity is documented.
Count and proportion of dimensions that are identical or conformed (matching keys, names, definitions, values) across fact tables, plus presence of a maintained bus matrix.
- Matching attribute names and domain values across schemas
- Bus matrix shaded cells
- Successful drill-across reports
Archival audit of dimension definitions and bus matrix.
Strong validity given the book's emphasis on conformance. · Reliable with documented dimension definitions.
A composite of attribute count per dimension, decode coverage of operational codes, and data quality completeness of attribute values.
- Real-word values instead of codes
- 50-100+ attributes in major dimensions
- Populated, spell-checked domain values
Archival inspection plus metadata review.
High validity; book states analytic power is directly proportional to attribute quality and depth. · Reliable with metadata documentation.
A per-attribute specification indicating the assigned SCD type (0-7) and verification that fact-to-dimension historical associations are accurate.
- Effective/expiration date stamps
- Current row indicators
- Change reason codes
- New surrogate keys on type 2 changes
Archival audit of dimension change-tracking metadata.
High validity; the book provides the canonical SCD vocabulary. · Reliable when change rules are documented by data stewards.
A coverage and effectiveness score across the four ETL categories (extract, clean/conform, deliver, manage) and their constituent subsystems.
- Data quality screens and error event schema
- Audit dimensions
- Surrogate key pipeline
- Job scheduling, monitoring, recovery
Mixed: archival subsystem inventory plus process performance metrics.
High validity due to the explicit 34-subsystem framework. · Reliable with subsystem-by-subsystem assessment.
A perceptual and archival assessment of traceability between design decisions and documented business requirements gathered through interviews/facilitation.
- Consolidated findings document
- Prioritization grid
- Process-focused bus matrix rows
Perceptual via stakeholder agreement plus archival documentation.
High validity; book stresses business-driven design. · Moderate; depends on quality of requirements documentation.
A readiness-assessment rating of sponsor influence, accessibility, track record, and the strength of business motivation.
- Active executive advocacy
- Cross-peer persuasion
- Sustained funding
Perceptual ratings from readiness assessment.
High face validity; identified as the most critical readiness factor. · Moderate; subjective but assessable via track record.
Perceptual survey scores plus observed metrics such as training time required and self-service navigation success rates.
- Users agreeing the model is their business
- Low training requirements
- Few support requests for navigation
Primarily perceptual; supplement with behavioral support-ticket data.
High validity as a core stated objective. · Reliable with validated survey instruments.
Time-to-market per new fact table and the proportion of reused versus newly built conformed dimensions per increment.
- Faster delivery cycles over time
- ETL effort focused on fact tables
- Reused dimensions on the shelf
Mixed: project timeline metrics plus archival reuse counts.
Moderate validity; inferred from book's agile claims. · Moderate; depends on project tracking.
Ability to reconcile metrics across processes via drill-across and the absence of incompatible stovepipe definitions.
- Matching numbers across departmental reports
- Single version of common reference data
- Successful cross-process analyses
Archival reconciliation tests.
High validity as a central integration goal. · Reliable with reconciliation procedures.
Usage metrics (active users, query volume), adoption rates, and perceptual satisfaction scores monitored proactively.
- Growing user counts
- High query/report usage
- Positive satisfaction monitoring
Mixed: behavioral usage logs plus perceptual satisfaction surveys.
High validity; the book names acceptance the ultimate success measure. · Reliable from usage instrumentation; perceptual portion needs validated surveys.
Business impact metrics (revenue/profit improvements, decision quality) attributable to DW/BI-enabled analysis.
- Decisions citing analytic evidence
- Quantifiable payback
- Strategic and operational improvements
Mixed: archival financial metrics plus perceptual attribution.
Moderate validity; attribution to DW/BI is challenging. · Moderate; benefit estimation is inherently approximate.
Self-assessment
Where would you like to improve?
This is a structured self-diagnostic built from the model — a mirror for reflection, not a validated psychometric scale. For validated measurement, see the instruments below.
1 = Strongly Disagree · 7 = Strongly Agree
Proposed measures — starter instruments where no validated one was found
Data Quality & Readiness Index
proposed · not validatedRate each observable statement on the scale below.
- Every incoming dataset passes a documented validation suite (schema, range, null checks) before being released for analysis.
- Data lineage and transformation steps from raw source to analysis-ready table are recorded and retrievable for any given dataset.
- Discrepancies between source and processed data (missing values, duplicates, outliers) are logged and reconciled on a defined schedule.
Scale: 1–7 (Strongly Disagree → Strongly Agree). Average the item ratings. This proposed index has no validated cutoff.
Business Impact Realization Index
proposed · not validatedRate each observable statement on the scale below.
- Each deployed analytics or ML initiative has a documented baseline metric and post-deployment measurement showing change in revenue, cost, or productivity.
- Financial or operational impact estimates for completed projects are reviewed and signed off by a business stakeholder outside the analytics team.
- A running portfolio log tracks realized ROI versus projected ROI for all initiatives past their first review cycle.
Scale: 1–7 (Strongly Disagree → Strongly Agree). Average the item ratings. This proposed index has no validated cutoff.
Model Generalization Assurance Index
proposed · not validatedRate each observable statement on the scale below.
- Every model is evaluated on a held-out or out-of-time test set that was not used during training or hyperparameter tuning.
- Performance metrics on validation and production data are compared on a recurring schedule to detect drift or overfitting.
- Model retraining or rollback decisions are triggered by predefined generalization-performance thresholds documented in advance.
Scale: 1–7 (Strongly Disagree → Strongly Agree). Average the item ratings. This proposed index has no validated cutoff.
Sources
- Analytics at Work: Smarter Decisions, Better Results — Thomas H. Davenport, Jeanne G. Harris, Robert Morison
- Big Data: A Revolution That Will Transform How We Live, Work, and Think — Viktor Mayer-Schönberger, Kenneth Cukier
- Data Science Bookcamp_ Ten case studies MEAP V01
- Business Intelligence Guidebook: From Data Integration to Analytics — Rick Sherman
- Business Intelligence and Big Data — Celina Olszak
- Competing on Analytics: The New Science of Winning — Thomas H. Davenport, Jeanne G. Harris
- Competing on Analytics: The New Science of Winning — Thomas H. Davenport, Jeanne G. Harris
- Data Science for Business: What You Need to Know about Data Mining and Data-Analytic Thinking — Foster Provost, Tom Fawcett
- Data Science from Scratch: First Principles with Python — Joel Grus
- Data Smart: Using Data Science to Transform Information into Insight — John W. Foreman
- Designing Data-Intensive Applications — Martin Kleppmann
- Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow — Aurélien Géron
- Introduction to Statistical and Machine Learning Methods for Data Science — Dr. Carlos Andre Reis Andre Reis Pinheiro etc.
- Machine Learning and Data Science
- Python for Data Analysis — Wes McKinney
- R for Data Science — Hadley Wickham
- Successful Business Intelligence: Unlock the Value of BI & Big Data — Cindi Howson
- The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling — Ralph Kimball, Margy Ross
- Data Mining for Business Analytics: Concepts, Techniques, and Applications — Galit Shmueli, Peter C. Bruce, Inbal Yahav, Nitin R. Patel, Kenneth C. Lichtendahl Jr.
- An Introduction to Statistical Learning: with Applications in R — Gareth James, Daniela Witten, Trevor Hastie, Robert Tibshirani
- Practical Statistics for Data Scientists — Peter Bruce
- Big Data_ A Very Short Introduction (Very Short Introductions)
- Data Warehouse and Data Mining — Jugnesh Kumar
- Learning from Data: A Short Course — Yaser S. Abu-Mostafa, Malik Magdon-Ismail, Hsuan-Tien Lin
- Networks, Crowds, and Markets: Reasoning About a Highly Connected World — David Easley, Jon Kleinberg
The cheat sheet
Everything, on one page
One key takeaway from each section, with links to read more.
- Tool, Library & Coding ProficiencyVectorized, idiomatic code is a competence marker, not a style preference—it changes what you can afford to explore.
- Conceptual & Mathematical FoundationThe math is what lets you debug a model that runs but is wrong.
- Practitioner Skill, Confidence & CompetenceEnd-to-end projects, not certifications, are what convert skills into capability.
- Analytical Talent & Workforce CapabilityAnalytical capability requires developing consumers of analysis, not just producers.
- Sound Analytic Process & PrototypingFast end-to-end prototypes surface problems that phase-by-phase perfection hides.
- Embedded Analytics in ProcessesThe value of an embedded model is bounded by the process it sits inside, not by its offline accuracy.
- Business-IT Partnership & AlignmentBI requirements emerge through iteration, so continuous business involvement beats an upfront spec.
- Agile / Incremental DevelopmentShip a thin working slice early to get real user feedback before scaling.
- Model Deployment, Monitoring & OperationalizationModel accuracy decays after deployment; assume drift and build detection for it.
- System Reliability, Scalability & MaintainabilityReliability, scalability, and maintainability trade off against each other and must be prioritized deliberately.
Publication details
Consult the sources listed in this guide for further reading. Edition 1 · Updated 2026-07-22.
Explore related books and profiles in the library.