Learning Path Open Access

The Complete Data Science Roadmap 2025–2026

Complete data science roadmap from statistics and SQL to machine learning, experimentation, and analytics engineering

Abstract

Data science sits at the intersection of statistics, programming, and business judgement, which makes the learning path unusually easy to get wrong - too many guides jump straight to scikit-learn and skip the statistical reasoning that makes a data scientist trustworthy. This roadmap synthesises what practising data scientists, hiring managers, and academic statisticians actually rely on day to day. It is realistic, treating 10–14 months of consistent effort as the honest timeline rather than a marketing number. It is structured, moving through eight phases from statistical foundations through portfolio and career positioning. And it is actionable, with specific resources, exercises, and checkpoints at every stage.

Why This Roadmap?

Data science sits at the intersection of statistics, programming, and business judgement, and that intersection is exactly where most learning guides go wrong. Some resources teach statistics with no data in sight; others jump straight to model.fit() and skip the reasoning that lets you trust - or challenge - a result. This roadmap synthesises what practising data scientists, hiring managers, and academic statisticians actually rely on day to day.

Unlike generic "become a data scientist in 8 weeks" guides, this roadmap is realistic. It treats 10–14 months of consistent effort as the honest timeline, not a marketing number. It is structured, moving through eight phases from statistical foundations to portfolio and career positioning. And it is actionable, with specific resources, exercises, and checkpoints at every stage.

Who is this for? Analysts and business intelligence professionals moving into data science. STEM and social-science graduates building a first career in analytics. Self-taught learners who want statistics taken seriously, not skipped. Anyone willing to trade a few months of discomfort with probability and SQL for a durable, high-leverage skill set. Once you have worked through this roadmap, our ML Interview Guide covers the technical interview process shared across data science and ML roles.

Phase 0: Prerequisites & Assessment (1–2 weeks)

Before touching statistics or modelling, confirm you have baseline programming comfort and are not intimidated by numbers. This phase is brief but worth doing honestly.

Programming Fundamentals

You need basic Python: variables, control flow, functions, and working with lists and dictionaries. You do not need object-oriented programming mastery yet - that comes later. If you have never programmed:

Assessment: Write a short script that reads a list of numbers from a file and prints the mean, median, and maximum. This should take under an hour.

Comfort with Numbers

You should be at ease with percentages, ratios, basic algebra, and reading a chart. If your last math course was years ago, spend a week refreshing:

Do not overthink this phase. You are confirming you can follow quantitative reasoning comfortably, not proving you are a mathematician.

Phase 1: Statistics & Mathematics Foundations (2–3 months)

This is the phase most guides underinvest in, and it is the single biggest differentiator between a data scientist who can be trusted with a decision and one who cannot. Statistical reasoning, not library fluency, is the core skill of this profession.

Descriptive Statistics & Probability (3–4 weeks)

What you need: Mean, median, mode, variance, standard deviation, percentiles; probability distributions (normal, binomial, Poisson, exponential); conditional probability; Bayes' theorem; expectation and variance of random variables.

Why: Every metric you will ever report is a summary of a distribution, and every model prediction is implicitly probabilistic. Without this, dashboards and models are numbers you cannot interpret.

Figure 1. Interactive probability distributions - visualising how randomness and sampling behave. Embedded from Seeing Theory, Brown University's visual statistics project.

Statistical Inference (4–5 weeks)

What you need: Sampling distributions, the Central Limit Theorem, confidence intervals, hypothesis testing (t-tests, chi-squared tests, ANOVA), p-values and their common misinterpretations, statistical power, and multiple comparisons.

Why: Inference is how you go from a sample to a defensible claim about a population - the exact task behind every "is this change actually working?" question you will be asked.

Linear Algebra & Calculus Essentials (3–4 weeks)

What you need: Vectors, matrices, matrix multiplication, and the geometric intuition behind them; derivatives, partial derivatives, and gradients; enough to understand what a loss function is and why gradient descent minimises it.

Why: You do not need research-level mathematical depth for most data science roles, but every regression coefficient, every gradient-boosted tree split, and every optimisation routine rests on this foundation.

Checkpoint: At the end of Phase 1, you should be able to: (1) Explain what a p-value actually means, and does not mean, without notes. (2) Compute and correctly interpret a confidence interval. (3) Choose the right hypothesis test for a given question. (4) Explain why the Central Limit Theorem matters for sampling.

Phase 2: Python, SQL & Data Wrangling (5–7 weeks)

With statistical reasoning in place, now build the tooling to apply it to real data. This phase covers the two languages a working data scientist touches every single day.

SQL - Non-Negotiable

Master SELECT, WHERE, GROUP BY, JOINs (inner, left, right, full), subqueries, common table expressions (CTEs), window functions (RANK, ROW_NUMBER, LAG/LEAD), and query optimisation basics.

Exercise: Write a query that computes month-over-month retention using window functions, against a public dataset (e.g. a Kaggle e-commerce transactions dataset). This is one of the most commonly asked SQL interview problems.

NumPy & Pandas Mastery

NumPy for array operations and vectorisation. Pandas for loading, cleaning, filtering, grouping, merging, and reshaping tabular data - the tool you will use more than any other.

Data Cleaning in Practice

Handling missing values (deletion vs. imputation, and when each is defensible), detecting and treating outliers, fixing inconsistent categorical encodings, deduplication, and type coercion. Real data is never clean - treat this as a core skill, not a chore before the "real work."

Checkpoint: You should be able to: (1) Write a multi-table SQL query with joins and window functions from scratch. (2) Load, clean, and reshape a genuinely messy dataset in Pandas. (3) Justify every data-cleaning decision you make rather than applying defaults blindly.

Phase 3: Exploratory Data Analysis & Visualisation (4–5 weeks)

Before modelling anything, a data scientist must be able to look at data and form well-calibrated hypotheses about what it contains and where it lies.

Exploratory Data Analysis (EDA)

Univariate and bivariate analysis, correlation vs. causation traps, distribution shape and skew, detecting data leakage and sampling bias early, and forming and writing down hypotheses before modelling.

Data Visualisation

Matplotlib for granular control, Seaborn for fast statistical plots, and Plotly or a BI tool for interactive, stakeholder-facing dashboards. Learn to choose the right chart type for the question - a skill more often botched than people expect.

BI Tools

Basic fluency with at least one business intelligence tool - Tableau or Power BI - is expected at most companies for sharing analysis with non-technical stakeholders who will never open a notebook.

Checkpoint: You should be able to: (1) Take an unfamiliar dataset and produce a well-reasoned set of hypotheses within an hour. (2) Choose visualisations that communicate rather than decorate. (3) Build a simple dashboard a non-technical stakeholder could use unassisted.

Phase 4: Experimentation & A/B Testing (4–6 weeks)

This is the phase most aspiring data scientists skip, and the one that most reliably separates junior from senior in interviews and on the job. Experimentation is how data science actually influences decisions.

Designing a Valid Experiment

Randomisation and why it matters, choosing a primary metric versus guardrail metrics, computing minimum detectable effect and required sample size, avoiding peeking and the multiple-testing trap, and pre-registering an analysis plan.

When Randomised Experiments Are Not Possible

Introduction to causal inference for observational data: confounding, the difference between correlation and causation, difference-in-differences, instrumental variables, propensity score matching, and regression discontinuity - at a conceptual level, with implementation as time allows.

Critical: Run a full mock A/B test analysis end-to-end - from sample size calculation through to a written recommendation with caveats - using a public dataset before considering this phase complete. Reading about experimentation and being able to defend a result under skeptical questioning are very different skills.
Checkpoint: You should be able to: (1) Design a valid A/B test end-to-end, including sample size. (2) Explain why early stopping inflates false positives. (3) Identify when an observational, not experimental, causal method is required. (4) Write a recommendation to a stakeholder that honestly states its limitations.

Phase 5: Machine Learning for Data Science (6–8 weeks)

With statistics and experimentation solid, machine learning becomes another tool for prediction, not the whole job. This phase emphasises the interpretable, widely used methods that dominate real data science work.

Supervised Learning

Regression: Linear regression, regularisation (Ridge, Lasso, Elastic Net), and diagnosing violations of regression assumptions.

Classification: Logistic regression, decision trees, random forests, and gradient boosting (XGBoost, LightGBM) - the workhorse of tabular data science.

Unsupervised Learning & Segmentation

Clustering (K-Means, hierarchical, DBSCAN) for customer and behavioural segmentation, and dimensionality reduction (PCA) for both modelling and visualisation.

Model Evaluation & Interpretability

Train/test split and cross-validation, the metrics that matter for a given business problem (precision/recall tradeoffs, ROC-AUC, calibration), and model interpretability tools (SHAP, feature importance, partial dependence plots) - essential when a stakeholder asks "why did the model predict that?"

Best Courses for Applied ML

If your interests pull toward deep learning, transformers, or a research-heavy specialisation, our Machine Learning Roadmap picks up from here in far greater depth.

Checkpoint: You should be able to: (1) Build, tune, and evaluate a complete classical ML pipeline. (2) Explain a model's predictions to a non-technical stakeholder using interpretability tools. (3) Choose the right metric for a given business tradeoff, not just accuracy.

Phase 6: Analytics Engineering & Production (4–5 weeks)

Analysis that lives only in a notebook rarely survives contact with a real organisation. This phase covers making your work reproducible, automated, and reliable at scale.

Data Pipelines & the Modern Data Stack

Version Control & Reproducibility

Git fundamentals for code and notebook version control, writing modular and testable analysis code instead of monolithic notebooks, and basic unit testing for data transformation logic.

Lightweight Model Deployment

Not every data scientist ships models to production, but most benefit from knowing the basics: wrapping a model behind a simple FastAPI endpoint, containerising with Docker, and monitoring for data drift once a model is live.

Checkpoint: You should be able to: (1) Build a scheduled data transformation pipeline with dbt or Airflow. (2) Version-control an analysis project properly with Git. (3) Explain, at a conceptual level, how a model you built would be deployed and monitored.

Phase 7: Portfolio, Storytelling & Career (Ongoing)

A strong portfolio is what gets you hired. Coursework signals you can follow instructions; a portfolio signals you can think.

What Makes a Strong Data Science Project?

  • Answers a real question - Not "predict housing prices," but a question with a defensible business or scientific motivation
  • Genuinely messy data - Cleaning decisions that required judgement, not a pre-cleaned Kaggle CSV
  • At least one experimental or causal component - Not only predictive modelling
  • Honest limitations - Stating what the analysis cannot tell you is as important as what it can
  • Clear communication - A written summary a non-technical stakeholder could act on

Project Ideas by Domain

DomainProject Ideas
Product AnalyticsFunnel and retention analysis, feature adoption A/B test, churn prediction with interpretable drivers
Marketing AnalyticsCustomer lifetime value modelling, attribution analysis, customer segmentation with clustering
Finance & RiskCredit default prediction with fairness and interpretability checks, fraud detection, time series forecasting
Healthcare & Public DataCausal analysis of a public health intervention, disease outcome prediction from open datasets
OperationsDemand forecasting, supply chain anomaly detection, experiment analysis for process changes

Building Your Presence

  • GitHub: Clean, documented, reproducible project repositories
  • Blog Posts: Write up your analyses - Medium or a personal site - practising the communication muscle interviewers test directly
  • Kaggle: Competitions and public notebooks build both skill and visible track record

Career Pathways

RoleFocusTypical Path
Data AnalystReporting, dashboards, descriptive analysisSQL + BI tool fluency, portfolio of dashboards
Data ScientistExperimentation, predictive modelling, causal analysisPortfolio + statistics depth (this roadmap)
Analytics EngineerData pipelines, modelling layer, data qualityStrong SQL/dbt background + engineering discipline
ML EngineerModel deployment, production ML systemsSee our Machine Learning Roadmap
Job Search: Target companies where decisions are genuinely data-informed, not just data-decorated - ask about this directly in interviews. Prepare for the four recurring interview pillars: SQL, statistics, applied ML, and product case studies. Our ML Interview Guide covers the technical and behavioural rounds in depth.

Timeline & Realistic Pace

PeriodPhaseWeekly HoursFocus
Month 0–1Phase 0: Prerequisites15 hrs/weekConfirm Python and basic numeracy. Get comfortable, not expert.
Months 1–3.5Phase 1: Statistics & Mathematics20 hrs/weekProbability, inference, hypothesis testing. The most important phase.
Months 3.5–5Phase 2: Python, SQL & Wrangling20 hrs/weekSQL fluency, Pandas mastery, real data cleaning practice.
Months 5–6Phase 3: EDA & Visualisation20 hrs/weekExploratory analysis habits, charting, one BI tool.
Months 6–7.5Phase 4: Experimentation & A/B Testing20 hrs/weekDesign and analyse a full mock experiment end-to-end.
Months 7.5–9.5Phase 5: Machine Learning25 hrs/weekClassical ML, evaluation, interpretability tools.
Months 9.5–11Phase 6: Analytics Engineering20 hrs/weekPipelines, version control, lightweight deployment.
Months 11–14+Phase 7: Portfolio & Career15–20 hrs/week (ongoing)Finish two to three strong portfolio projects, start applying, iterate.

Total commitment: ~10–14 months at 15–25 hours/week for a strong entry-level foundation, then ongoing depth-building for career growth. Candidates with a quantitative degree can often compress Phases 1 and 5 significantly. Non-technical career switchers should budget extra time in Phase 1 rather than rushing it.

Learning Tips

  • ✓ Treat statistics as the core skill, not a box to check before "the real work"
  • ✓ Practise SQL daily from week one - it decays fast without regular use
  • ✓ Work with genuinely messy data early; cleaned Kaggle CSVs teach you the wrong lessons
  • ✓ Write down your hypotheses before you look at the answer, every time
  • ✓ Practise explaining every analysis to an imaginary non-technical stakeholder
  • ✓ Build at least one project around an experiment, not only prediction
  • ✓ Join analytics or data science communities - Discord servers, local meetups, online forums

Frequently Asked Questions

  • A data analyst primarily describes what has already happened - building dashboards, running SQL queries, summarising trends for stakeholders. A data scientist goes further: designing experiments, building predictive models, and quantifying uncertainty to inform decisions, sitting between analysis and engineering. An ML engineer focuses on building, deploying, and maintaining models in production at scale, with a heavier software engineering emphasis. The boundaries blur constantly between companies - a "data scientist" at a 50-person startup may do all three jobs, while at a large tech company the roles are sharply separated. This roadmap targets the data scientist role, with pointers to our Machine Learning Roadmap where the two paths diverge.
  • It is not strictly required, but a quantitative background - statistics, mathematics, economics, computer science, or a physical science - makes the path considerably shorter, since much of Phase 1 of this roadmap is coursework you would already have. Bootcamps and self-study can substitute, provided you treat the statistics foundations as seriously as a formal course would; the most common gap in bootcamp graduates is a shallow understanding of statistical inference, which shows up immediately in interviews and on the job. A portfolio of real analyses and a clear statistical intuition matter more to hiring managers than the credential itself.
  • For most data scientist roles, yes - arguably more important day-to-day. Python is where modelling and analysis happen, but SQL is how you get the data in the first place, and most working data scientists spend more hours writing queries against a warehouse than training models. Interviewers at nearly every company test SQL directly, often before touching statistics or ML questions. Treat SQL as a first-class skill from week one rather than an afterthought picked up on the job.
  • Enough to be dangerous, not necessarily enough to be a specialist. Most data scientist roles lean on classical, interpretable methods - logistic and linear regression, gradient boosting, clustering - far more often than deep learning, because business stakeholders need to trust and explain a model's decisions. You should be fluent in the classical ML toolkit (Phase 5 of this roadmap) and comfortable with the basics of neural networks, but deep specialisation in transformers or computer vision is only necessary if your target role or company specifically requires it - in which case our Machine Learning Roadmap is the natural next step.
  • At most product-driven technology companies, it is at least as important, and often the more frequently used skill. Being able to design a valid experiment, choose the right metric, compute the required sample size, and correctly interpret a p-value or confidence interval is what separates a data scientist who can be trusted with decisions worth real money from one who cannot. A shocking number of candidates can build a random forest but cannot explain why peeking at an A/B test early inflates the false positive rate. Do not treat Phase 4 of this roadmap as optional.
  • Weight practice heavily from the very start - roughly 70% hands-on work with real (or realistic) datasets and 30% theory - while still taking the statistics foundations seriously rather than skipping straight to modelling libraries. The most common failure mode is collecting notebook tutorials without ever wrangling a genuinely messy dataset end-to-end; the second most common is running statistical tests without understanding what assumptions they rely on. Pair every statistical concept with a dataset you interrogate yourself.
  • A non-technical background lengthens the path but does not preclude it. Budget an additional six to eight weeks for Phase 0 and Phase 1 - statistics and basic programming are learnable skills, not innate talents, but they take longer to internalise without prior exposure. Many successful data scientists transitioned from economics, biology, psychology, marketing, or the social sciences; what those backgrounds share is comfort reasoning about data and uncertainty, which this roadmap builds deliberately rather than assuming.
  • Choose based on the kinds of questions and data that genuinely interest you rather than what looks most fundable this year. Product and growth analytics at technology companies has the broadest job market and the heaviest emphasis on experimentation. Finance and risk roles reward rigorous statistics and reward caution about overfitting. Healthcare and biotech data science has strong demand for causal inference and works with especially messy, high-stakes data. Marketing analytics leans on attribution modelling and customer lifetime value. If nothing pulls you clearly toward a domain, product analytics at a tech company is the most transferable starting point.
  • It depends on your starting point and target role. If you already have a quantitative undergraduate degree and a strong self-built portfolio, a master's adds credentialing value and networking but is rarely necessary. If you are switching careers from a non-technical field, a master's in data science, statistics, or analytics can provide structure, an internship pipeline, and a credential that gets your resume past automated filters - a real advantage in a crowded entry-level market. Weigh the one to two years and tuition cost against building an equivalent portfolio through self-study, which is entirely possible but requires more self-direction.
  • Re-derive a core result - the Central Limit Theorem, the bias-variance decomposition, why cross-validation works - from memory every few months; the ability to explain a statistical idea from first principles decays faster than most people expect once daily work becomes routine. Read a methods-focused newsletter or blog such as Andrew Gelman's statistical modelling blog for exposure to how working statisticians reason about messy real-world problems. When you catch yourself running a test you cannot fully justify, stop and look up the assumptions before trusting the output.
  • Two or three end-to-end projects that each tell a complete story: a clearly stated business or scientific question, data that was genuinely messy and required real cleaning decisions, an analysis or model with honestly reported limitations, and a conclusion written for a non-technical stakeholder. One project should demonstrate a designed experiment or causal analysis, not only predictive modelling - this is the most commonly missing piece in junior portfolios. Quality and clarity of reasoning matter far more than the number of projects or the sophistication of the model used.
  • Expect four recurring pillars: SQL (write correct, efficient queries under time pressure), statistics and probability (explain concepts like p-values, confidence intervals, and Bayes' theorem clearly and defend experimental design choices), applied machine learning (build and evaluate models, explain tradeoffs, and reason about metrics), and a case study or product-sense round (e.g. "how would you measure the success of this feature?"). Practise explaining your own portfolio projects out loud end-to-end, since interviewers probe reasoning far more than final results. Our ML Interview Guide covers the technical and behavioural rounds shared across data science and ML roles in depth.

Comprehensive Resource List

Free Courses & Learning Platforms

ResourceWhat It Covers
Google Data Analytics Professional CertificateBroad, structured intro to the analyst-to-data-scientist pipeline (audit free)
Coursera - Andrew Ng's ML SpecializationIndustry-standard supervised/unsupervised learning fundamentals
Mode Analytics: SQL TutorialPractical SQL against real sample databases, in-browser
Udacity: A/B Testing CourseExperiment design and analysis, built with Google
dbt Learn: Analytics EngineeringModern data transformation and the analytics engineering stack
Kaggle LearnMicro-courses in Pandas, SQL, feature engineering, and ML
Seeing Theory (Brown University)Interactive visual introduction to probability and statistics

Recommended Books

BookWhy It Matters
Practical Statistics for Data Scientists - Bruce, Bruce & GedeckStatistics written specifically for working data scientists, not statisticians
Trustworthy Online Controlled Experiments - Kohavi, Tang & XuThe standard reference on rigorous A/B testing at scale
Causal Inference: The Mixtape - Scott Cunningham (free online)Approachable, applied introduction to causal methods
Storytelling with Data - Cole Nussbaumer KnaflicThe definitive guide to communicating analysis visually
An Introduction to Statistical Learning - James et al. (free PDF)Approachable statistical ML with R and Python labs
The Book of Why - Judea Pearl & Dana MackenzieConceptual foundations of causal reasoning, written for a general audience

Key Websites & Tools

ResourceUse For
KaggleCompetitions, datasets, community notebooks
SQLZooInteractive SQL practice, beginner to advanced
Tableau PublicFree BI dashboarding practice and portfolio hosting
SHAP documentationModel interpretability for classical ML
GitHub TrendingCode exploration, open-source contribution ideas
MLflowExperiment tracking and model versioning

Conclusion: Your Data Science Journey Starts Now

Data science rewards patient, statistically grounded thinking over flashy modelling, and that is precisely what this roadmap is built around. It provides a structured path from zero to genuine professional competence. But no roadmap replaces action.

Start today. Pick Phase 0, spend the next week on it, then move into Phase 1. Work with real data. Write down your reasoning, not just your code. Share what you build. The best way to learn data science is to analyse real questions with real consequences, even small ones.

The timeline is 10–14 months. This is longer than most "learn data science fast" guides promise, and it is also honest. Skipping the statistics foundations to reach modelling faster is the single most common reason capable people plateau at a junior level for years.

Finally: enjoy the process. Data science is a genuinely useful blend of detective work and rigour - the satisfaction of a well-designed experiment or a cleanly explained model is real. And when you are ready to turn this knowledge into a job offer, our ML Interview Guide is the natural next step.

Next Steps

  • Assess your current level (Python, SQL, statistics, business context)
  • Pick a start date and commit to a schedule (15–25 hours/week)
  • Join a learning community (Discord, forums, local meetups)
  • Build in public - share your analyses and their limitations honestly
  • Never skip statistics - it compounds more than any other skill in this roadmap