Business Analytics 101: Data Visualization and Storytelling Data Storytelling Narrative Structure Visual Narrative Scenes Annotation

What This Is

Data storytelling is the process of presenting insights and findings from data analysis in a clear, concise, and engaging manner. It involves using narrative structures, visual narratives, scenes, and annotations to communicate complex information to various stakeholders. Effective data storytelling is crucial in business analytics as it enables organizations to make informed decisions, drive business outcomes, and communicate insights to different audiences. For instance, a retail company might use data storytelling to analyze customer purchase behavior, identify trends, and develop targeted marketing campaigns to increase sales.

Key Formulas & Metrics

• Mean Absolute Error (MAE) = (1/n) Σ|yᵢ − ŷᵢ|: The average absolute difference between actual and predicted values. It measures the average magnitude of the errors.
• R² = 1 − (SS_res / SS_tot): The proportion of variance in the dependent variable that is predictable from the independent variable(s). It measures the goodness of fit of the regression model.
• Coefficient of Determination (R²) = 1 − (Σ(yᵢ − ŷᵢ)² / Σ(yᵢ − ȳ)²): The proportion of variance in the dependent variable that is predictable from the independent variable(s).
• Mean Squared Error (MSE) = (1/n) Σ(yᵢ − ŷᵢ)²: The average squared difference between actual and predicted values. It measures the average magnitude of the squared errors.
• Root Mean Squared Error (RMSE) = √(1/n) Σ(yᵢ − ŷᵢ)²: The square root of the average squared difference between actual and predicted values. It measures the average magnitude of the errors.
• Adjusted R² = 1 − ((n-1)/(n-k-1)) * (1-R²): The proportion of variance in the dependent variable that is predictable from the independent variable(s), adjusted for the number of predictors.
• Akaike Information Criterion (AIC) = n * ln(σ²) + 2k: A measure of the relative quality of a model for a given set of data.
• Bayesian Information Criterion (BIC) = n * ln(σ²) + k * ln(n): A measure of the relative quality of a model for a given set of data.

Step-by-Step Procedure

1. Define the narrative structure: Identify the key message, audience, and purpose of the data story.
2. Develop a visual narrative: Create a clear and concise visual representation of the data, using charts, graphs, and tables.
3. Create scenes: Break down the data story into smaller scenes, each with a clear message and visual representation.
4. Annotate the scenes: Add context, explanations, and insights to each scene to enhance understanding.
5. Refine and iterate: Refine the data story based on feedback and iteration.

Common Mistakes

• Mistake: Confusing correlation with causation.
• Correction: Establish a clear cause-and-effect relationship between variables before drawing conclusions.
• Mistake: Misinterpreting p-values.
• Correction: Understand that p-values indicate the probability of observing the data (or more extreme) if the null hypothesis is true, not the probability that the null hypothesis is true.
• Mistake: Using the wrong error metric for a business problem.
• Correction: Choose the error metric that aligns with the business objective, such as MAE for forecasting or RMSE for regression.

Software / Tool Tips

• Python with pandas/scikit-learn: Use the pandas library for data manipulation and the scikit-learn library for machine learning and data visualization.
• R: Use the ggplot2 library for data visualization and the caret library for machine learning.
• Excel: Use the Power BI add-in for data visualization and the Solver add-in for optimization.
• Tableau: Use the Story Points feature to create interactive data stories.

Quick Practice Problem

Problem: Compute the moving average forecast for period 4 given data: 100, 110, 105, 120.

Answer: The moving average forecast for period 4 is (100 + 110 + 105 + 120) / 4 = 110.

Explanation: The moving average forecast is calculated by taking the average of the last four data points.

Last-Minute Cram Sheet

• Data storytelling is the process of presenting insights and findings from data analysis in a clear, concise, and engaging manner.
• Mean Absolute Error (MAE) measures the average magnitude of the errors.
• R² measures the proportion of variance in the dependent variable that is predictable from the independent variable(s).
• Coefficient of Determination (R²) is the proportion of variance in the dependent variable that is predictable from the independent variable(s).
• Mean Squared Error (MSE) measures the average squared difference between actual and predicted values.
• Root Mean Squared Error (RMSE) is the square root of the average squared difference between actual and predicted values.
• Adjusted R² is the proportion of variance in the dependent variable that is predictable from the independent variable(s), adjusted for the number of predictors.
• Akaike Information Criterion (AIC) is a measure of the relative quality of a model for a given set of data.
• Bayesian Information Criterion (BIC) is a measure of the relative quality of a model for a given set of data.
• ⚠️ p-value is NOT the probability that H₀ is true – it’s the probability of observing the data (or more extreme) if H₀ is true.
• ⚠️ Correlation does NOT imply causation.
• ⚠️ Use the right error metric for a business problem.