PathTailor
FRSign inBuild my path
PathTailor
Build my pathSign inLire en français

Data analyst path

The Data analyst learning path chains 17 courses: 87 lessons, 269 exercises and about 47 hours of content. It starts with “Programming Basics and Algorithms” and ends with “Simple ETL Pipelines”. This is the base order: your personal path is built from it and from your goal.

  • 17 courses
  • 87 lessons
  • 269 exercises
  • about 47 h
  • Runs in: browser
  1. Programming Basics and Algorithms
  2. Coding with an AI Assistant (Prompts, Code Review)
  3. SQL Fundamentals (SELECT, Filters, Aggregates)
  4. Intermediate SQL (joins, subqueries)
  5. Descriptive Statistics
  6. Python Fundamentals
  7. Data Analysis with pandas and NumPy
  8. Data Cleaning and Preparation
  9. Visualization (Matplotlib, Seaborn, Plotly)
  10. Probability and Inferential Statistics
  11. Exploratory Data Analysis
  12. Business Metrics and KPIs
  13. Advanced SQL (CTEs, window functions)
  14. Data Storytelling and Presenting Results
  15. Automate with Python (Files, Excel, APIs)
  16. A/B Testing and Experimentation
  17. Simple ETL Pipelines
  • Foundations
  • SQL
  • Statistics
  • Python
  • Data analysis
Build my pathBecome a data analyst

The 17 courses, in order

  1. Foundations2 courses
    1. 01Programming Basics and AlgorithmsLearn to program step by step in Python: variables, conditions, loops, functions and your first algorithms.Beginner5 lessons2 h 25 minBrowser
    2. 02Coding with an AI Assistant (Prompts, Code Review)Use an AI assistant to code effectively: precise prompts, critical review, tests, debugging and security.Beginner5 lessons2 h 30 minBrowser
  2. SQL2 courses
    1. 03SQL Fundamentals (SELECT, Filters, Aggregates)Learn to query a database in SQL: select, filter, sort, count and summarize data by groups.Beginner5 lessons2 h 9 minBrowser
    2. 04Intermediate SQL (joins, subqueries)Combine several tables with joins, write subqueries, and master CASE WHEN, UNION and EXCEPT.Intermediate5 lessons2 h 32 minBrowser
  3. Statistics1 course
    1. 05Descriptive StatisticsSummarize and describe data: variable types, mean, median, spread, quantiles, outliers and correlation, using Python.Beginner5 lessons2 h 26 minBrowser
  4. Python4 courses
    1. 06Python FundamentalsLearn the basics of Python: variables, conditions, loops, lists, dictionaries, functions and error handling.Beginner5 lessons2 h 30 minBrowser
    2. 07Data Analysis with pandas and NumPyAnalyze data in Python: NumPy arrays, pandas DataFrames, filters, computed columns, groupby, pivot tables and joins.Intermediate6 lessons3 h 20 minBrowser
    3. 08Data Cleaning and PreparationClean real-world data with pandas: diagnosis, missing values, types, duplicates, outliers and a reproducible pipeline.Intermediate5 lessons3 h 5 minBrowser
    4. 09Visualization (Matplotlib, Seaborn, Plotly)Build clear charts in Python with Matplotlib, Seaborn and Plotly: choosing the right visual, formatting, facets and interactivity.Intermediate5 lessons3 h 5 minBrowser
  5. Statistics1 course
    1. 10Probability and Inferential StatisticsGo from sample to population: probability, distributions, the central limit theorem, confidence intervals and hypothesis tests in Python.Intermediate5 lessons2 h 34 minBrowser
  6. Data analysis2 courses
    1. 11Exploratory Data AnalysisExplore a dataset with pandas: profile, missing values, duplicates, distributions, relationships, anomalies, time and summary of findings.Intermediate5 lessons3 h 1 minBrowser
    2. 12Business Metrics and KPIsDefine, calculate and interpret a company's KPIs in Python: sales, customers, trends, targets, margin and marketing profitability.Beginner5 lessons2 h 27 minBrowser
  7. SQL1 course
    1. 13Advanced SQL (CTEs, window functions)Write analytical queries with CTEs, recursive CTEs and window functions: rankings, running totals, period-over-period changes.Advanced5 lessons2 h 47 minBrowser
  8. Data analysis1 course
    1. 14Data Storytelling and Presenting ResultsTurn an analysis into a clear message: audience, key message, chart choice, clean design, narrative, recommendations and uncertainty.Intermediate5 lessons2 h 57 minBrowser
  9. Python1 course
    1. 15Automate with Python (Files, Excel, APIs)Automate your tasks with Python: files and folders, CSV and JSON, formatted Excel reports, web APIs and scheduled scripts.Intermediate5 lessons3 h 5 minBrowser
  10. Statistics1 course
    1. 16A/B Testing and ExperimentationDesign, size, and analyze reliable A/B tests in Python: power, proportion tests, bootstrap, SRM, and multiple comparisons.Intermediate5 lessons2 h 44 minBrowser
  11. Data analysis1 course
    1. 17Simple ETL PipelinesBuild reliable ETL pipelines in Python: CSV, JSON and SQL extraction, transformation, data quality checks, upsert, incremental loading and orchestration.Advanced6 lessons3 h 49 minBrowser

Optional courses

Suggested depending on your goal, on top of the base path.

Other paths

  • Data scientist

    27 courses · 139 lessons · about 83 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. SQL Fundamentals (SELECT, Filters, Aggregates)
    6. Intermediate SQL (joins, subqueries)
    7. Advanced SQL (CTEs, window functions)
    8. Descriptive Statistics
    9. Probability and Inferential Statistics
    10. Python Fundamentals
    11. Intermediate Python (Functions, Modules, OOP)
    12. Data Analysis with pandas and NumPy
    13. Data Cleaning and Preparation
    14. Visualization (Matplotlib, Seaborn, Plotly)
    15. Exploratory Data Analysis
    16. Introduction to Machine Learning (scikit-learn)
    17. Supervised Learning: Regression and Classification
    18. Unsupervised Learning: Clustering and Dimensionality Reduction
    19. Model Evaluation and Validation
    20. Feature Engineering
    21. Time Series and Forecasting
    22. HTTP and REST APIs
    23. APIs with FastAPI
    24. Deep Learning with PyTorch
    25. Natural Language Processing (NLP) and LLMs
    26. Deploying a Model (API, MLOps Basics)
    27. Docker and Deployment
    • Foundations
    • SQL
    • Statistics
    • Python
    • Data analysis
    • Data science
    • Back-end
    • Python for the web

  • Power BI

    13 courses · 65 lessons · about 26 h
    1. SQL Fundamentals (SELECT, Filters, Aggregates)
    2. Intermediate SQL (joins, subqueries)
    3. Database Modeling
    4. Descriptive Statistics
    5. Business Metrics and KPIs
    6. Getting Started with Power BI Desktop
    7. Power Query: Import and Transform
    8. Star Schema Modeling
    9. DAX Fundamentals
    10. Advanced DAX (Context, Time Intelligence)
    11. Data Storytelling and Presenting Results
    12. Designing Reports and Dashboards
    13. Power BI Service: Publishing, Sharing and RLS Security
    • SQL
    • Statistics
    • Data analysis
    • Power BI

  • JavaScript web developer

    24 courses · 127 lessons · about 75 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. HTML Fundamentals
    6. CSS Fundamentals
    7. Responsive Layout (Flexbox, Grid)
    8. JavaScript Fundamentals
    9. DOM and Events
    10. Asynchronous JavaScript (Promises, fetch, APIs)
    11. Accessibility and SEO
    12. Data Structures and Complexity
    13. TypeScript
    14. React
    15. SQL Fundamentals (SELECT, Filters, Aggregates)
    16. Intermediate SQL (joins, subqueries)
    17. Database Modeling
    18. HTTP and REST APIs
    19. Node.js Fundamentals
    20. API with Express
    21. Automated Testing
    22. Authentication and Web Security (OWASP)
    23. Full-Stack React + Node Application
    24. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • Back-end
    • Server-side JavaScript

  • Python web developer

    22 courses · 115 lessons · about 70 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. Python Fundamentals
    6. Intermediate Python (Functions, Modules, OOP)
    7. HTML Fundamentals
    8. CSS Fundamentals
    9. Responsive Layout (Flexbox, Grid)
    10. JavaScript Fundamentals
    11. DOM and Events
    12. Asynchronous JavaScript (Promises, fetch, APIs)
    13. SQL Fundamentals (SELECT, Filters, Aggregates)
    14. Intermediate SQL (joins, subqueries)
    15. Database Modeling
    16. HTTP and REST APIs
    17. APIs with FastAPI
    18. Django Fundamentals
    19. Automated Testing
    20. Authentication and Web Security (OWASP)
    21. Complete Application with Django
    22. Docker and Deployment
    • Foundations
    • Python
    • Front-end
    • SQL
    • Back-end
    • Python for the web

  • PHP web developer

    22 courses · 116 lessons · about 68 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. HTML Fundamentals
    6. CSS Fundamentals
    7. Responsive Layout (Flexbox, Grid)
    8. JavaScript Fundamentals
    9. DOM and Events
    10. Asynchronous JavaScript (Promises, fetch, APIs)
    11. SQL Fundamentals (SELECT, Filters, Aggregates)
    12. Intermediate SQL (joins, subqueries)
    13. Database Modeling
    14. PHP Fundamentals
    15. Object-Oriented PHP and Composer
    16. PHP and Databases (PDO)
    17. HTTP and REST APIs
    18. Laravel Fundamentals
    19. Automated Testing
    20. Authentication and Web Security (OWASP)
    21. Advanced Laravel (API, Queues, Tests)
    22. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • PHP
    • Back-end

  • Java web developer

    23 courses · 121 lessons · about 70 h
    1. Programming Basics and Algorithms
    2. Terminal and Command Line
    3. Git and GitHub
    4. Coding with an AI Assistant (Prompts, Code Review)
    5. Data Structures and Complexity
    6. HTML Fundamentals
    7. CSS Fundamentals
    8. Responsive Layout (Flexbox, Grid)
    9. JavaScript Fundamentals
    10. DOM and Events
    11. Asynchronous JavaScript (Promises, fetch, APIs)
    12. SQL Fundamentals (SELECT, Filters, Aggregates)
    13. Intermediate SQL (joins, subqueries)
    14. Database Modeling
    15. Java Fundamentals
    16. Object-Oriented Java
    17. Collections, Streams, and Exceptions
    18. Testing with JUnit
    19. HTTP and REST APIs
    20. Spring Boot: REST API
    21. Persistence with JPA and Hibernate
    22. Authentication and Web Security (OWASP)
    23. Docker and Deployment
    • Foundations
    • Front-end
    • SQL
    • Java
    • Back-end

  • Excel and data for the office

    8 courses · 40 lessons · about 12 h
    1. Excel Fundamentals
    2. Excel: Lookup and Logical Functions
    3. Excel: PivotTables
    4. Build and Safeguard a Reliable Excel Workbook
    5. Using Generative AI at Work
    6. Power Query and Power Pivot in Excel
    7. Automating Excel (VBA and Office Scripts)
    8. Power Automate: Automate Your Tasks
    • Excel
    • Generative AI
    • Power Platform

  • AI at work

    5 courses · 25 lessons · about 8 h
    1. Using Generative AI at Work
    2. Cybersecurity: The Basics for Everyone
    3. GDPR for Data and Product Teams
    4. AI Governance and the AI Act
    5. Power Automate: Automate Your Tasks
    • Generative AI
    • Cross-functional skills
    • Power Platform

  • AI developer

    12 courses · 61 lessons · about 28 h
    1. Programming Basics and Algorithms
    2. Python Fundamentals
    3. Intermediate Python (Functions, Modules, OOP)
    4. Git and GitHub
    5. Using Generative AI at Work
    6. HTTP and REST APIs
    7. Integrating an LLM into an Application
    8. RAG in Production
    9. AI Agents and Automation
    10. Evaluating and Monitoring an AI System
    11. Docker and Deployment
    12. Self-Hosting AI Models Locally
    • Foundations
    • Python
    • Generative AI
    • Back-end

  • Data engineer

    18 courses · 91 lessons · about 43 h
    1. Terminal and Command Line
    2. Git and GitHub
    3. SQL Fundamentals (SELECT, Filters, Aggregates)
    4. Intermediate SQL (joins, subqueries)
    5. Advanced SQL (CTEs, window functions)
    6. Database Modeling
    7. Python Fundamentals
    8. Intermediate Python (Functions, Modules, OOP)
    9. Data Analysis with pandas and NumPy
    10. Data Warehouses and Analytical Modeling
    11. Data Quality and Governance
    12. Transforming Data with dbt
    13. Orchestrating Pipelines with Airflow
    14. Distributed Processing with Spark
    15. PostgreSQL in Practice (indexes, performance)
    16. Docker and Deployment
    17. Cloud Fundamentals
    18. Deploying an Application to the Cloud
    • Foundations
    • SQL
    • Python
    • Data engineering
    • Back-end
    • Cloud and DevOps

  • A website for my business

    4 courses · 21 lessons · about 7 h
    1. Build Your Website with WordPress
    2. Online Store with WooCommerce or Shopify
    3. Local SEO and Online Presence
    4. HTML Fundamentals
    • Websites and CMS
    • Front-end

  • Marketing analyst

    9 courses · 45 lessons · about 19 h
    1. SQL Fundamentals (SELECT, Filters, Aggregates)
    2. Intermediate SQL (joins, subqueries)
    3. Descriptive Statistics
    4. Business Metrics and KPIs
    5. Marketing Analytics
    6. E-commerce Analytics
    7. Data Storytelling and Presenting Results
    8. A/B Testing and Experimentation
    9. Local SEO and Online Presence
    • SQL
    • Statistics
    • Data analysis
    • Business analytics
    • Websites and CMS

  • Cloud and DevOps

    10 courses · 50 lessons · about 20 h
    1. Terminal and Command Line
    2. Git and GitHub
    3. Linux for Developers
    4. Docker and Deployment
    5. Continuous Integration and Deployment
    6. Cloud Fundamentals
    7. Deploying an Application to the Cloud
    8. Kubernetes
    9. Infrastructure as Code with Terraform
    10. Cybersecurity: The Basics for Everyone
    • Foundations
    • Cloud and DevOps
    • Back-end
    • Cross-functional skills

  • Mobile developer

    10 courses · 53 lessons · about 28 h
    1. Programming Basics and Algorithms
    2. Git and GitHub
    3. JavaScript Fundamentals
    4. DOM and Events
    5. Asynchronous JavaScript (Promises, fetch, APIs)
    6. TypeScript
    7. React
    8. HTTP and REST APIs
    9. Mobile Apps with React Native
    10. Mobile Apps with Flutter
    • Foundations
    • Front-end
    • Back-end
    • Mobile

  • Digital project manager

    7 courses · 35 lessons · about 12 h
    1. Using Generative AI at Work
    2. Agile Project Management
    3. Business Analysis: From Needs to Specifications
    4. UX Design and Mockups
    5. GDPR for Data and Product Teams
    6. SQL Fundamentals (SELECT, Filters, Aggregates)
    7. Business Metrics and KPIs
    • Generative AI
    • Cross-functional skills
    • SQL
    • Data analysis

Say what you want to be able to do, we build your path

Your path is assembled from the catalogue courses. With the Pro plan, every lesson is told with examples from your job.

The preview is free, and you can take the courses one at a time without paying. The path only contains lessons from the catalogue.