TechRat

AI & Data

AI & Data Scientist roadmap

From statistics and data wrangling to machine learning models and LLMs, ending with an applied capstone.

Before you start

What you will learn

  1. 1. Statistics Foundations

    Summarize data with descriptive statistics, reason with probability and distributions, and spot sampling bias.

  2. 2. SQL FoundationsOptional

    Query relational data with SELECT, filtering, sorting and joins.

  3. 3. Statistical Inference & Experiments

    Draw conclusions from samples with hypothesis tests and confidence intervals, tell correlation from causation, run A/B tests and fit simple regressions.

  4. 4. Data Analysis with NumPy & pandas

    Load, clean, join and aggregate tabular data with NumPy and pandas.

  5. 5. Time Series & Reproducible Notebooks

    Resample and window time-indexed data with pandas, and keep notebook analyses reproducible.

  6. 6. Data VisualizationOptional

    Pick the right chart for the question, plot it with Matplotlib and Seaborn, and combine charts into clear dashboards.

  7. 7. SQL for AnalyticsOptional

    Summarize data with GROUP BY and HAVING, and answer harder questions with subqueries, CTEs and window functions.

  8. 8. ML Foundations

    Supervised and unsupervised learning, training and validation, and the metrics used to judge models.

  9. 9. LLM Application Basics

    How neural networks, transformers and LLMs work, tokens and context windows, and prompting for structured outputs.

  10. 10. Supervised Models

    Regression and classification, the bias-variance trade-off and regularization, and tree ensembles.

  11. 11. Features, Clustering & Neural Networks

    Engineer better features, find structure with clustering and PCA, and train neural networks.

  12. 12. RAG & RetrievalOptional

    Embeddings and vector search, and retrieval-augmented generation with chunking and reranking.

  13. 13. AI & Data Scientist Capstone

    A scenario-based final challenge mixing statistics, data wrangling, machine learning, model evaluation and LLMs.

Each step unlocks when you answer its questions well enough, and a module you finish counts in every roadmap that shares it.

Start this roadmap for free