Free 1:1 career roadmap call: what to learn, in what order, for your background.
Skills & tools

The Data Analyst Skills Roadmap: What to Learn, in What Order

Excel, SQL, Tableau and Python are not a menu. They are a sequence. Here is the order that turns learners into hireable analysts, and why each step comes where it does.

·
Updated October 2026
·
4 min read

Key takeaways

Effort is rarely the problem for self-taught analysts. Direction is.
Each tool should build on the one before it: Excel, statistics, Power Query, SQL, Tableau, Python.
Prove every stage with a small project before moving on.
Skip machine learning and tool collecting until you can answer business questions end to end.

Most people who teach themselves data analytics are not short on effort. They are short on order.

LaRita W. was already teaching herself SQL, Python and Tableau when she found Data in Motion. She had the discipline and she was putting in the hours. She also had no feedback on anything she produced and no sense of whether she was learning the right things in a useful order. Once the same skills were sequenced deliberately and reviewed, she had dozens of interviews and 5 data analyst offers within 3 months.

Here is the sequence, what each stage is for and how to prove it.

Stage 1: Excel for business analytics

Start where the business already works. Excel is on every analyst’s machine, and it teaches you to think in rows, columns and calculations before any code is involved.

Stage 2: Statistics

You do not need a math degree. You need enough statistics to avoid the classic mistakes and to make a recommendation you can defend: when to use a median instead of an average, what a distribution looks like, how much variation is normal and why correlation is not causation.

Stage 3: Power Query

Most analyst time goes into getting data ready. Power Query lets you import, clean, combine and reshape data in steps you can repeat, so next month’s report refreshes instead of being rebuilt by hand. It is the bridge between spreadsheet thinking and database thinking.

Stage 4: SQL

Data lives in databases, and SQL is how you get it out. It is also the skill most analyst interviews test directly.

The 5-Day SQL Study Plan follows this exact progression with a case study each day.

Stage 5: Tableau and data storytelling

Decision makers rarely read queries. They read dashboards and slides. Learn to build interactive dashboards with calculated fields, then learn the harder skill: leading with the insight and choosing the one chart that proves it.

Stage 6: Python

Python comes last on purpose. Once you can think in tables and queries, Python for cleaning, analysis and automation is far easier to learn, and you will know what you want it to do.

Prove each stage before moving on

StageLearnProve it with
ExcelFormulas, lookups, PivotTablesA sales or budget summary that answers one question
StatisticsDistributions, variationA short write-up that explains a trend honestly
Power QueryImport, clean, combineA report that refreshes from raw files
SQLJoins, window functions, CTEsFive business questions answered from a public database
TableauDashboards, calculated fieldsAn interactive dashboard on Tableau Public
PythonCleaning and analysisA repeatable analysis notebook

What to skip, for now

Get feedback on the work itselfFeedback is the one thing teaching yourself cannot supply. Ask someone who does the job to review each project and tell you what to fix. In the program, every project is reviewed by a senior analyst and revised.
Get a roadmap for your background.
Book a free 1:1 call: the skills you need, in the order that gets people hired, and how your experience becomes proof.

Frequently asked questions

Should I learn Tableau or Power BI?

Either works. The concepts transfer, and employers hire for both. The Data Career Launch Program teaches Tableau, and graduates have landed roles that use Power BI.

Python or R?

Python. It is widely used across analytics teams, and it carries over into automation and engineering work later.

How long does SQL take to learn?

The basics take days. Interview fluency, with joins, window functions and CTEs, takes steady practice. The 5-Day SQL Study Plan covers basics through CTEs in five focused days.

Want a plan made for you?

Book a free career roadmap call, or apply to the Data Career Launch Program.