LEVEL 1
Data Analyst Beginner Roadmap
Pick at least one beginner course, which will help you learn how to think like a data analyst while introducing you to several tools. I earn as an affiliate from these links and it helps me continue providing resources like this for free. I included courses from the same subscription to reduce cost.
Google Data Analytics
Learn important concepts and soft skills, work with tools like Excel, SQL, Tableau, and R, and get a Google Certificate at the end.
IBM Data Analyst
Similar to Google’s course. Work with Excel, SQL, Tableau and learn lots of Python specifically for data analysts. Get an IBM certificate.
Level 2
Learn SQL
Structured Query Language is an essential skill for data analysts and highly in-demand.
SQL Basics For Data Science
Specialization is key to success. Here, you’ll learn how to use SQL for data science & analytics fast.
Level 3
Learn Python
Python is a key skill to land your data analyst job. You could learn R but we focus on Python as it’s more in-demand.
Google Advanced Data Analytics (Best)
Focuses on Python for data analysts, including valuable Python projects.
Python For Everybody Specialization
Top rated Python course and has millions of enrollments with top reviews.
Level 4
Learn a Data Visualization Tool
Both Tableau and Power BI popular visualization tools. Pick the one you prefer, they are both in-demand skills.
Microsoft Power BI Data Analyst
Best course to learn Power BI for data analysts. HUGE BONUS: Prepares you for the PL-300 Microsoft Data Analyst Certification.
Data Analyst in Tableau
Bundle with multiple courses using Tableau to clean, analyze, and visualize data. Prepares you for the DataCamp Data Analyst certification.
Level 5
Boost Your Excel Skills
Excel is still the king when working with smaller datasets or non-technical stakeholders.
Excel For Business Specialization
I highly recommend this program. After this, you’ll know more about Excel than you could’ve ever imagined.
IBM Excel Basics for Data Analysis
Short 11-hour course by IBM to boost your Excel knowledge fast. This is a course I highly recommend.
Level 6
Start with Guided Projects
These guided projects are easy to complete. They’re a great way of learning, and you can add them to your portfolio if you don’t have personal projects yet.
COVID19 Python Data Analysis (Best)
Python For Data Analysis: Pandas & NumPy
Data Analysis with SQL: Inform a Business Decision
Level 7
Become a Certified Data Analyst
This step is optional, but it is worth considering getting certified. These courses below each help you prepare for the two most popular ones: Tableau Certified Data Analyst and Microsoft PL 300 Power BI Data Analyst.
Data Visualization with Tableau
New course from Tableau themselves. Helpful when preparing for the Tableau Certified Data Analyst exam. It will not get you entirely ready for the test, but it will take you a long way.
Microsoft PL 300 Exam Preparation
Perfect way to learn the skills for the Microsoft Data Analyst Certification exam. The final course is also specifically about exam prep.