Level 1
Pick a Beginner Course
Pick at least one beginner course, which will help you learn how to think like a data analyst while introducing you to several tools. Note: I earn as an affiliate from these links and it helps me continue providing free resources. I included many courses from the same subscription to reduce cost.
Google Data Analytics (Recommended)
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
Pick a SQL Course
Structured Query Language is an essential skill for data analysts and highly in-demand.
LearnSQL (Premium Option)
The #1 rated platform dedicated entirely to SQL with 1+ million learners. Their courses are hands-on, with no fluff, and give you a certificate.
SQL Basics For Data Science
Specialization is key to success. Here, you’ll learn how to use SQL for data analysis fast. It’s ideal if you already know the absolute basics.
Level 3
Pick a Python Course
Python is a key skill to land your data analyst job. Plus, it’s versatile and used outside of data science too. Alternatively, you could learn R. For this roadmap we focus on Python as it is in way higher demand.
Google Advanced Data Analytics (Best)
This course dives deeper than the original, involves lots of Python practice, and comes with a valuable Google Certificate.
Python For Everybody Specialization
Top rated Python course and has millions of enrollments with top reviews.
Level 4
Pick 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
The 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
Pick a Course To Boost Your Excel Skills
Spend a few hours making sure your Excel skills are sufficient.
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
Try a Guided Project
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
HR Analytics – Build an HR dashboard using Power BI
Level 7
Optional: Prepare For a Real Certification
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.