The ultimate Data Analyst (Transition to Analytics Engineer) Roadmap 2026. You don’t need expensive courses. This repository collects the best 100% FREE video tutorials and official documentation to help you become a production-ready Data Analyst and Analytics Engineer.
Master Data Analysis and Analytics Engineering with This Roadmap and Free Learning Resources. Follow our step-by-step guide from basics to advanced skills to launch your career.
- Phase 1: Foundations
- Phase 2: Core Analysis Skills
- Phase 3: Databases
- Phase 4: Analytics Engineering Tools
- Phase 5: Big Data Technologies
- Phase 6: Cloud Platforms
- Phase 7: Advanced & Specializations
This section lays the groundwork, covering Mathematics & Statistics, Python Programming, SQL Basics, and Excel for Data Analysis.
This section lays the groundwork. These are the essential skills required before moving to more advanced topics.
Focus on the core statistical and mathematical concepts that underpin data analysis, including probability, hypothesis testing, and regression.
Video Resources:
| Statistics For Data Science | Data Analytics Tutorial |
|---|---|
 |
 |
Documentation & Reading:
- https://www.khanacademy.org/math/statistics-probability
- https://www.statlearning.com/
- https://seeing-theory.brown.edu/
Learn the fundamentals of Python, a versatile language essential for data manipulation, analysis, and automation. Focus on libraries like Pandas and NumPy.
Video Resources:
| Python For Data Analysis | Python Analytics Full |
|---|---|
 |
 |
Documentation & Reading:
- https://www.freecodecamp.org/learn/data-analysis-with-python
- https://pandas.pydata.org/docs/
- https://www.datacamp.com/tutorial/pandas
Master the basics of SQL (Structured Query Language) for querying and managing relational databases, a critical skill for any data professional.
Video Resources:
| SQL Full Course | SQL in 4 Hours |
|---|---|
 |
 |
Documentation & Reading:
- https://www.w3schools.com/sql/
- https://sqlbolt.com/
- https://www.udacity.com/course/sql-for-data-analysis--ud198
Develop proficiency in Excel for data analysis, including functions, PivotTables, and charting, to quickly analyze smaller datasets.
Video Resources:
| Excel Data Analysis | Excel Full Course |
|---|---|
 |
 |
Documentation & Reading:
- https://www.coursera.org/learn/excel-basics-data-analysis-ibm
- https://support.microsoft.com/en-us/excel
- https://www.mygreatlearning.com/academy/learn-for-free/courses/data-analytics-using-excel1
✅ Want a structured Data Analyst roadmap?
Explore the interactive visual roadmap with free resources here:
👉 Data Analyst
This section focuses on practical data skills.
You will learn about Data Manipulation with Pandas, Data Visualization with Python, EDA, Tableau, and Power BI.
Dive deep into the Pandas library for efficient data cleaning, transformation, and analysis in Python.
Video Resources:
| Pandas Tutorial | Pandas Full Course |
|---|---|
 |
 |
Documentation & Reading:
- https://pandas.pydata.org/docs/
- https://www.codecademy.com/learn/data-processing-pandas
- https://www.kaggle.com/code/kashnitsky/topic-1-exploratory-data-analysis-with-pandas
Learn to create compelling and informative visualizations using Python's primary plotting libraries, Matplotlib and Seaborn.
Video Resources:
| Seaborn Tutorial | Matplotlib in One Hour |
|---|---|
 |
 |
Documentation & Reading:
- https://seaborn.pydata.org/
- https://matplotlib.org/stable/users/index.html
- https://www.datacamp.com/tutorial/seaborn-python-tutorial
Develop a systematic approach to EDA to summarize main characteristics of a dataset, often with visual methods.
Video Resources:
| Data Exploration Guide | Mastering EDA |
|---|---|
 |
 |
Documentation & Reading:
- https://www.datacamp.com/tutorial/exploratory-data-analysis-python
- https://towardsdatascience.com/a-gentle-introduction-to-exploratory-data-analysis-f11d843b8184
- https://www.kaggle.com/learn/data-cleaning
Gain expertise in Tableau, a leading business intelligence tool, to create interactive dashboards and reports.
Video Resources:
| Tableau Full Course | Tableau Live |
|---|---|
 |
 |
Documentation & Reading:
- https://www.tableau.com/learn
- https://help.tableau.com/current/pro/desktop/en-us/default.htm
- https://www.tableau.com/learn/training
Learn to use Microsoft Power BI to model data, create visualizations, and share insights across your organization.
Video Resources:
| Power BI Analytics | Power BI Advanced |
|---|---|
 |
 |
Documentation & Reading:
- https://learn.microsoft.com/en-us/training/powerplatform/power-bi
- https://docs.microsoft.com/en-us/power-bi/
- https://powerbi.microsoft.com/en-us/learning/
This section deepens your database knowledge.
You will learn about Advanced SQL and NoSQL with MongoDB to handle various data storage needs.
Go beyond basic queries to master advanced SQL topics like window functions, CTEs, and query optimization.
Video Resources:
| Advanced SQL Tutorial | SQL Beginner to Advanced |
|---|---|
 |
 |
Documentation & Reading:
- https://www.mode.com/sql-tutorial/
- https://datalemur.com/sql-tutorial
- https://www.w3schools.com/sql/
Explore NoSQL databases with MongoDB to understand how to work with flexible, unstructured data.
Video Resources:
| MongoDB Complete | MongoDB Tutorial |
|---|---|
 |
 |
Documentation & Reading:
- https://www.mongodb.com/docs/manual/
- https://university.mongodb.com/
- https://docs.mongodb.com/manual/tutorial/
This section marks the transition to engineering.
You will learn about Version Control with Git, ETL Processes, Apache Airflow, dbt (Data Build Tool), and Data Warehousing.
Learn Git and GitHub for version control, essential for collaborating on code and managing analytics projects.
Video Resources:
| Git & GitHub DE | Git Crash Course |
|---|---|
 |
 |
Documentation & Reading:
Understand the fundamentals of ETL (Extract, Transform, Load) processes for moving and preparing data for analysis.
Video Resources:
| ETL Process Explained | Learn Data Engineering |
|---|---|
 |
 |
Documentation & Reading:
Learn Apache Airflow to programmatically author, schedule, and monitor data workflows and pipelines.
Video Resources:
| Airflow for DE | Airflow Tutorial |
|---|---|
 |
 |
Documentation & Reading:
- https://airflow.apache.org/docs/
- https://academy.astronomer.io/path/airflow-101
- https://www.datacamp.com/tutorial/getting-started-with-apache-airflow
Master dbt to transform data in your warehouse more effectively using SQL-based transformation logic.
Video Resources:
| dbt Ultimate Guide | dbt from Scratch |
|---|---|
 |
 |
Documentation & Reading:
Understand the principles of data warehousing, including data modeling (star schema) and storage solutions.
Video Resources:
| SQL Data Warehouse | Data Warehouse Guide |
|---|---|
 |
 |
Documentation & Reading:
- https://www.datacamp.com/courses/data-warehousing-concepts
- https://rivery.io/data-learning-center/best-data-warehousing-tools/
- https://www.integrate.io/blog/17-best-data-warehousing-tools-and-resources/
This section introduces you to large-scale data processing.
You will explore Apache Spark and Hadoop Basics.
Learn Apache Spark for fast, large-scale data processing and analytics, using its PySpark API.
Video Resources:
| Spark Ultimate Guide | Intro to Spark |
|---|---|
 |
 |
Documentation & Reading:
- https://spark.apache.org/docs/latest/
- https://github.com/awesome-spark/awesome-spark
- https://www.coursera.org/learn/scala-spark-big-data
Grasp the fundamentals of the Hadoop ecosystem, including HDFS for distributed storage and MapReduce concepts.
Video Resources:
| Hadoop Training | Hadoop Full Course |
|---|---|
 |
 |
Documentation & Reading:
- https://hadoop.apache.org/docs/r1.0.4/#Getting+Started
- https://www.cloudera.com/resources.html
- https://www.edureka.co/blog/hadoop-tutorial/
This section covers the use of cloud platforms for data analytics.
Focusing on AWS for Data Analytics.
Learn to leverage AWS services like S3, Redshift, and Glue for building scalable data pipelines and analytics solutions in the cloud.
Video Resources:
| AWS Data Engineering |
|---|
 |
Documentation & Reading:
- https://aws.amazon.com/training/
- https://aws.amazon.com/big-data/datalake/
- https://docs.aws.amazon.com/
This section finalizes your transition.
Covering Machine Learning Basics and Data Quality & Governance.
Get an introduction to machine learning concepts and learn how to use libraries like scikit-learn for predictive modeling.
Video Resources:
| Data Analytics ML | Learn AI for Analytics |
|---|---|
 |
 |
Documentation & Reading:
- https://www.coursera.org/learn/machine-learning
- https://www.geeksforgeeks.org/machine-learning/scikit-learn-tutorial/
- https://www.kaggle.com/learn/intro-to-machine-learning
Learn the principles and tools for ensuring data quality, and understand the fundamentals of data governance frameworks.
Video Resources:
| Data Governance | Data Quality Rise |
|---|---|
 |
 |
Documentation & Reading:
- https://www.datacamp.com/blog/data-quality
- https://atlan.com/open-source-data-quality-tools/
- https://dqops.com/open-source-data-quality-tools/
Found a great free Data Analytics resource?
- Fork this repository
- Add the resource to the correct section
- Submit a Pull Request
If this Data Analyst Roadmap helped you save money and learn, please give this repo a Star ⭐.
- Data Analyst Roadmap (Interactive): Data Analyst Roadmap
- AI Tutor Lyra: https://codersnote.com/