theanalyst.in

Your roadmap

The 90-day curriculum

New lessons are generated and published automatically at 7:00 AM India Standard Time.

Beginner

  1. Day 1 · 2026-10-18What Data Analytics Really Is

    Learn to apply what data analytics really is to a realistic business question, work through a small example, and explain the result and its limitations.

  2. Day 2 · 2026-10-19Ask Better Business Questions

    Learn to apply ask better business questions to a realistic business question, work through a small example, and explain the result and its limitations.

  3. Day 3 · 2026-10-20Data Types and Measurement Scales

    Learn to apply data types and measurement scales to a realistic business question, work through a small example, and explain the result and its limitations.

  4. Day 4 · 2026-10-21Meet Your Dataset: Rows and Columns

    Learn to apply meet your dataset: rows and columns to a realistic business question, work through a small example, and explain the result and its limitations.

  5. Day 5 · 2026-10-22Collecting Data Responsibly

    Learn to apply collecting data responsibly to a realistic business question, work through a small example, and explain the result and its limitations.

  6. Day 6 · 2026-10-23Spreadsheet Basics for Analysts

    Learn to apply spreadsheet basics for analysts to a realistic business question, work through a small example, and explain the result and its limitations.

  7. Day 7 · 2026-10-24Clean Messy Data

    Learn to apply clean messy data to a realistic business question, work through a small example, and explain the result and its limitations.

  8. Day 8 · 2026-10-25Sort, Filter, and Freeze Panes

    Learn to apply sort, filter, and freeze panes to a realistic business question, work through a small example, and explain the result and its limitations.

  9. Day 9 · 2026-10-26Formulas: SUM, AVERAGE, MIN, MAX

    Learn to apply formulas: sum, average, min, max to a realistic business question, work through a small example, and explain the result and its limitations.

  10. Day 10 · 2026-10-27Percentages and Percentage Change

    Learn to apply percentages and percentage change to a realistic business question, work through a small example, and explain the result and its limitations.

  11. Day 11 · 2026-10-28COUNT, COUNTA, and COUNTIF

    Learn to apply count, counta, and countif to a realistic business question, work through a small example, and explain the result and its limitations.

  12. Day 12 · 2026-10-29IF Logic and Categories

    Learn to apply if logic and categories to a realistic business question, work through a small example, and explain the result and its limitations.

  13. Day 13 · 2026-10-30Lookups and Joining Tables

    Learn to apply lookups and joining tables to a realistic business question, work through a small example, and explain the result and its limitations.

  14. Day 14 · 2026-10-31Dates and Time Periods

    Learn to apply dates and time periods to a realistic business question, work through a small example, and explain the result and its limitations.

  15. Day 15 · 2026-11-01Pivot Tables for Quick Answers

    Learn to apply pivot tables for quick answers to a realistic business question, work through a small example, and explain the result and its limitations.

  16. Day 16 · 2026-11-02Charts That Tell the Truth

    Learn to apply charts that tell the truth to a realistic business question, work through a small example, and explain the result and its limitations.

  17. Day 17 · 2026-11-03Mean, Median, and Mode

    Learn to apply mean, median, and mode to a realistic business question, work through a small example, and explain the result and its limitations.

  18. Day 18 · 2026-11-04Range, Quartiles, and IQR

    Learn to apply range, quartiles, and iqr to a realistic business question, work through a small example, and explain the result and its limitations.

  19. Day 19 · 2026-11-05Spot Outliers Carefully

    Learn to apply spot outliers carefully to a realistic business question, work through a small example, and explain the result and its limitations.

  20. Day 20 · 2026-11-06Correlation Is Not Causation

    Learn to apply correlation is not causation to a realistic business question, work through a small example, and explain the result and its limitations.

  21. Day 21 · 2026-11-07Sampling and Representativeness

    Learn to apply sampling and representativeness to a realistic business question, work through a small example, and explain the result and its limitations.

  22. Day 22 · 2026-11-08Ask Useful Questions of Data

    Learn to apply ask useful questions of data to a realistic business question, work through a small example, and explain the result and its limitations.

  23. Day 23 · 2026-11-09SQL: Tables and SELECT

    Learn to apply sql: tables and select to a realistic business question, work through a small example, and explain the result and its limitations.

  24. Day 24 · 2026-11-10SQL: WHERE and ORDER BY

    Learn to apply sql: where and order by to a realistic business question, work through a small example, and explain the result and its limitations.

  25. Day 25 · 2026-11-11SQL: Aggregations and GROUP BY

    Learn to apply sql: aggregations and group by to a realistic business question, work through a small example, and explain the result and its limitations.

  26. Day 26 · 2026-11-12SQL: CASE WHEN

    Learn to apply sql: case when to a realistic business question, work through a small example, and explain the result and its limitations.

  27. Day 27 · 2026-11-13SQL: NULL Values

    Learn to apply sql: null values to a realistic business question, work through a small example, and explain the result and its limitations.

  28. Day 28 · 2026-11-14SQL: JOIN Fundamentals

    Learn to apply sql: join fundamentals to a realistic business question, work through a small example, and explain the result and its limitations.

  29. Day 29 · 2026-11-15Build Your First KPI Report

    Learn to apply build your first kpi report to a realistic business question, work through a small example, and explain the result and its limitations.

  30. Day 30 · 2026-11-16Beginner Capstone: Retail Sales Story

    Learn to apply beginner capstone: retail sales story to a realistic business question, work through a small example, and explain the result and its limitations.

Intermediate

  1. Day 31 · 2026-11-17Analytical Thinking and Problem Framing

    Learn to apply analytical thinking and problem framing to a realistic business question, work through a small example, and explain the result and its limitations.

  2. Day 32 · 2026-11-18Advanced Spreadsheet Functions

    Learn to apply advanced spreadsheet functions to a realistic business question, work through a small example, and explain the result and its limitations.

  3. Day 33 · 2026-11-19Power Query: Repeatable Cleaning

    Learn to apply power query: repeatable cleaning to a realistic business question, work through a small example, and explain the result and its limitations.

  4. Day 34 · 2026-11-20Data Modelling Basics

    Learn to apply data modelling basics to a realistic business question, work through a small example, and explain the result and its limitations.

  5. Day 35 · 2026-11-21SQL: Subqueries and CTEs

    Learn to apply sql: subqueries and ctes to a realistic business question, work through a small example, and explain the result and its limitations.

  6. Day 36 · 2026-11-22SQL: Window Functions

    Learn to apply sql: window functions to a realistic business question, work through a small example, and explain the result and its limitations.

  7. Day 37 · 2026-11-23SQL: Date and Time Analysis

    Learn to apply sql: date and time analysis to a realistic business question, work through a small example, and explain the result and its limitations.

  8. Day 38 · 2026-11-24SQL: Conditional Aggregation

    Learn to apply sql: conditional aggregation to a realistic business question, work through a small example, and explain the result and its limitations.

  9. Day 39 · 2026-11-25SQL Query Performance Basics

    Learn to apply sql query performance basics to a realistic business question, work through a small example, and explain the result and its limitations.

  10. Day 40 · 2026-11-26Dashboard Design Principles

    Learn to apply dashboard design principles to a realistic business question, work through a small example, and explain the result and its limitations.

  11. Day 41 · 2026-11-27Choose Metrics and KPI Definitions

    Learn to apply choose metrics and kpi definitions to a realistic business question, work through a small example, and explain the result and its limitations.

  12. Day 42 · 2026-11-28Build an Interactive Dashboard

    Learn to apply build an interactive dashboard to a realistic business question, work through a small example, and explain the result and its limitations.

  13. Day 43 · 2026-11-29Data Storytelling with a Narrative

    Learn to apply data storytelling with a narrative to a realistic business question, work through a small example, and explain the result and its limitations.

  14. Day 44 · 2026-11-30Segmentation and Cohort Analysis

    Learn to apply segmentation and cohort analysis to a realistic business question, work through a small example, and explain the result and its limitations.

  15. Day 45 · 2026-12-01Funnel Analysis

    Learn to apply funnel analysis to a realistic business question, work through a small example, and explain the result and its limitations.

  16. Day 46 · 2026-12-02Retention and Churn

    Learn to apply retention and churn to a realistic business question, work through a small example, and explain the result and its limitations.

  17. Day 47 · 2026-12-03Customer Lifetime Value Basics

    Learn to apply customer lifetime value basics to a realistic business question, work through a small example, and explain the result and its limitations.

  18. Day 48 · 2026-12-04A/B Testing: The Core Idea

    Learn to apply a/b testing: the core idea to a realistic business question, work through a small example, and explain the result and its limitations.

  19. Day 49 · 2026-12-05Statistical Significance and Confidence

    Learn to apply statistical significance and confidence to a realistic business question, work through a small example, and explain the result and its limitations.

  20. Day 50 · 2026-12-06Confidence Intervals in Practice

    Learn to apply confidence intervals in practice to a realistic business question, work through a small example, and explain the result and its limitations.

  21. Day 51 · 2026-12-07Hypothesis Testing Workflow

    Learn to apply hypothesis testing workflow to a realistic business question, work through a small example, and explain the result and its limitations.

  22. Day 52 · 2026-12-08Regression to the Mean

    Learn to apply regression to the mean to a realistic business question, work through a small example, and explain the result and its limitations.

  23. Day 53 · 2026-12-09Linear Regression Intuition

    Learn to apply linear regression intuition to a realistic business question, work through a small example, and explain the result and its limitations.

  24. Day 54 · 2026-12-10Multiple Regression and Confounding

    Learn to apply multiple regression and confounding to a realistic business question, work through a small example, and explain the result and its limitations.

  25. Day 55 · 2026-12-11Forecasting and Seasonality

    Learn to apply forecasting and seasonality to a realistic business question, work through a small example, and explain the result and its limitations.

  26. Day 56 · 2026-12-12Missing Data Strategies

    Learn to apply missing data strategies to a realistic business question, work through a small example, and explain the result and its limitations.

  27. Day 57 · 2026-12-13Data Quality Tests

    Learn to apply data quality tests to a realistic business question, work through a small example, and explain the result and its limitations.

  28. Day 58 · 2026-12-14Reproducible Analysis

    Learn to apply reproducible analysis to a realistic business question, work through a small example, and explain the result and its limitations.

  29. Day 59 · 2026-12-15Intermediate Capstone: Product Growth

    Learn to apply intermediate capstone: product growth to a realistic business question, work through a small example, and explain the result and its limitations.

  30. Day 60 · 2026-12-16Causal Inference: Beyond Correlation

    Learn to apply causal inference: beyond correlation to a realistic business question, work through a small example, and explain the result and its limitations.

Advanced

  1. Day 61 · 2026-12-17Difference-in-Differences

    Learn to apply difference-in-differences to a realistic business question, work through a small example, and explain the result and its limitations.

  2. Day 62 · 2026-12-18Propensity Scores and Matching

    Learn to apply propensity scores and matching to a realistic business question, work through a small example, and explain the result and its limitations.

  3. Day 63 · 2026-12-19Experiment Design and Power

    Learn to apply experiment design and power to a realistic business question, work through a small example, and explain the result and its limitations.

  4. Day 64 · 2026-12-20Sequential Testing Pitfalls

    Learn to apply sequential testing pitfalls to a realistic business question, work through a small example, and explain the result and its limitations.

  5. Day 65 · 2026-12-21Bayesian Thinking for Analysts

    Learn to apply bayesian thinking for analysts to a realistic business question, work through a small example, and explain the result and its limitations.

  6. Day 66 · 2026-12-22Time-Series Decomposition

    Learn to apply time-series decomposition to a realistic business question, work through a small example, and explain the result and its limitations.

  7. Day 67 · 2026-12-23Forecast Evaluation and Backtesting

    Learn to apply forecast evaluation and backtesting to a realistic business question, work through a small example, and explain the result and its limitations.

  8. Day 68 · 2026-12-24Anomaly Detection

    Learn to apply anomaly detection to a realistic business question, work through a small example, and explain the result and its limitations.

  9. Day 69 · 2026-12-25Optimisation and Decision Analysis

    Learn to apply optimisation and decision analysis to a realistic business question, work through a small example, and explain the result and its limitations.

  10. Day 70 · 2026-12-26Pricing and Elasticity Analysis

    Learn to apply pricing and elasticity analysis to a realistic business question, work through a small example, and explain the result and its limitations.

  11. Day 71 · 2026-12-27Marketing Mix and Attribution

    Learn to apply marketing mix and attribution to a realistic business question, work through a small example, and explain the result and its limitations.

  12. Day 72 · 2026-12-28Advanced SQL: Recursive CTEs

    Learn to apply advanced sql: recursive ctes to a realistic business question, work through a small example, and explain the result and its limitations.

  13. Day 73 · 2026-12-29Advanced SQL: Query Plans

    Learn to apply advanced sql: query plans to a realistic business question, work through a small example, and explain the result and its limitations.

  14. Day 74 · 2026-12-30Large-Scale Data Processing

    Learn to apply large-scale data processing to a realistic business question, work through a small example, and explain the result and its limitations.

  15. Day 75 · 2026-12-31Dimensional Modelling and SCDs

    Learn to apply dimensional modelling and scds to a realistic business question, work through a small example, and explain the result and its limitations.

  16. Day 76 · 2027-01-01Data Warehouse Architecture

    Learn to apply data warehouse architecture to a realistic business question, work through a small example, and explain the result and its limitations.

  17. Day 77 · 2027-01-02Analytics Engineering and dbt Concepts

    Learn to apply analytics engineering and dbt concepts to a realistic business question, work through a small example, and explain the result and its limitations.

  18. Day 78 · 2027-01-03Orchestration and Data Pipelines

    Learn to apply orchestration and data pipelines to a realistic business question, work through a small example, and explain the result and its limitations.

  19. Day 79 · 2027-01-04Data Contracts and Schema Changes

    Learn to apply data contracts and schema changes to a realistic business question, work through a small example, and explain the result and its limitations.

  20. Day 80 · 2027-01-05Privacy, Governance, and Access

    Learn to apply privacy, governance, and access to a realistic business question, work through a small example, and explain the result and its limitations.

  21. Day 81 · 2027-01-06Fairness and Bias Audits

    Learn to apply fairness and bias audits to a realistic business question, work through a small example, and explain the result and its limitations.

  22. Day 82 · 2027-01-07Communicating Uncertainty to Leaders

    Learn to apply communicating uncertainty to leaders to a realistic business question, work through a small example, and explain the result and its limitations.

  23. Day 83 · 2027-01-08Build an Analytics Portfolio Project

    Learn to apply build an analytics portfolio project to a realistic business question, work through a small example, and explain the result and its limitations.

  24. Day 84 · 2027-01-09Peer Review and Analytical QA

    Learn to apply peer review and analytical qa to a realistic business question, work through a small example, and explain the result and its limitations.

  25. Day 85 · 2027-01-10Monitoring Metrics in Production

    Learn to apply monitoring metrics in production to a realistic business question, work through a small example, and explain the result and its limitations.

  26. Day 86 · 2027-01-11Advanced Capstone: End-to-End Decision

    Learn to apply advanced capstone: end-to-end decision to a realistic business question, work through a small example, and explain the result and its limitations.

  27. Day 87 · 2027-01-12Present Your Findings Like a Consultant

    Learn to apply present your findings like a consultant to a realistic business question, work through a small example, and explain the result and its limitations.

  28. Day 88 · 2027-01-13Your 90-Day Learning Review

    Learn to apply your 90-day learning review to a realistic business question, work through a small example, and explain the result and its limitations.

  29. Day 89 · 2027-01-14Ethics, Accessibility, and Inclusive Analytics

    Learn to apply ethics, accessibility, and inclusive analytics to a realistic business question, work through a small example, and explain the result and its limitations.

  30. Day 90 · 2027-01-15Build a Personal Analytics Development Plan

    Learn to apply build a personal analytics development plan to a realistic business question, work through a small example, and explain the result and its limitations.