Learn the skills data analyst jobs ask for in the order analysts use them: spreadsheets, SQL, a dashboard tool, then Python. Every exercise is checked as you go, and the pathway ends in projects, a timed assessment across the tools and the interview.
Take the steps in this order. Each step is a set of units from one course, not the whole course: the units this role uses. Open a unit to start its first lesson.
1
Spreadsheets in Excel
Most analyst work still starts in a spreadsheet: an export someone sends you, a check before a meeting, a summary for a manager. These units cover formulas and references, IF logic, conditional totals, lookups, text and dates, tables and PivotTables.
With SQL you pull the data yourself instead of waiting for an export. You go from a first SELECT to joins, subqueries and window functions, then the patterns analysts use every week: deduplication, funnels, cohorts and month over month.
A dashboard is how most of your work reaches people. You build a report on a data model, write DAX measures, use CALCULATE and compare periods. If the jobs you want ask for Tableau instead, the Tableau course covers the same ground.
pandas does in a notebook what you did in the spreadsheet and in SQL, on bigger files and in a form you can run again next month: loading, filtering, cleaning, merging, reshaping and time series.
Build reusable warehouse fields and measures, test join grain and save a dashboard definition. Use access filters for regional restrictions and check the source totals before sharing.
Each project starts from a fictional company's brief and moves between tools the way the job does: what you build in one stage is where the next one starts. Every brief is free to read.
Hearthline
ExExcelSQLSQLpdpandasBIPower BI
ProjectFree
Why is profit falling when sales are up?
Your first week as Hearthline's data analyst. Turn a messy order export into gross profit in Excel, roll it up in SQL, measure what each discount code costs in pandas, chart the margin in Power BI and tell your manager what to change.
Marketing ran eight promotions this summer and wants to plan the fall. Turn the offers into numbers, measure each one against the weeks before it, total the extra sales and write the memo.
The monthly report shows September down on August, and the CFO wants to know why before the board meeting. Separate the calendar from a real decline and say where it came from.
Operations reports one on-time rate and finance reports a lower one, for the same month. Find out why, write the measure both teams agree on, and recommend which number goes to customers.
A checkout test offered half the visitors an annual plan. The dashboard says it worked; count the test fairly and decide whether the difference is real before it ships.
You've joined Greenbasket's two-person analytics team. Review the summer promotions, find the stores running out of stock, then explain a bad month to the CFO.
When you finish the units, test yourself across the tools of the job at once: 15 practical tasks in 60 minutes, each in the tool it is about and checked automatically. The clock keeps running if you close the page.
Tool
Tasks
Minutes
Looker and LookML
3
11
Excel
3
10
SQL
3
11
Power BI
3
15
pandas
3
13
How it is scored
Each tool
Ready when you get two thirds of its tasks right or more, Close at one third, otherwise Not yet. A coding task earns the share of its tests that pass.
Ready for interviews
75% or more overall, and every tool at Ready.
Nearly ready
50% or more overall, and no tool at Not yet.
Keep practicing
Anything else. The report lists every task you missed with the lesson that teaches it.
The assessment is free. The result is practice feedback in the Interview Hub's report format, not a hiring decision. Retakes draw different tasks where the question pools allow.
The interview
The Interview Hub runs the data analyst interview round by round, at a fictional employer: you answer out loud or in writing, the interviewer follows up, and the report quotes your answers.
The first unit of every course, with no account: 6 of the 39 units on this pathway. Every project brief is free to read, and the job-readiness assessment is free.
One Course
One course in full. On this pathway that is one of these: Excel (9 units), SQL (8 units), Power BI (7 units), Python (4 units), pandas (8 units), Looker and LookML (3 units).
All Access
The whole pathway: every unit, every project stage and spoken interview practice.
A data analyst turns raw records into answers people can act on: which stores sold less after a price change, why sign-ups fell in March, what a promotion really cost. Most of the job is getting the data, checking it and explaining what it means to someone who has to decide. The tools differ from one company to the next. The work doesn’t.
The skills, in the order you use them
Analyst job ads usually name a spreadsheet, SQL, a dashboard tool and often Python. This pathway follows that order. Each step takes only the units an analyst needs from that course, so you reach the projects sooner. When you want more depth in one tool, the rest of its course is there.
Showing what you can do
Employers want to see work, not a list of courses. The projects start from a fictional company’s brief and move between tools the way the job does. In Hearthline’s profit question you clean an order export in Excel, roll it up in SQL, price each discount code in pandas and chart the margin in Power BI. Finish one and you have something specific to walk through in an interview. The assessment then shows which tool to practice before you apply.
For database reports, practice SQL query optimization: read the plan and preserve the result as you rewrite the query. The SQL cheat sheet covers the query syntax.
Common questions
How long does it take to become a data analyst?
The lessons on this pathway add up to about 47 hours. How many weeks that is depends on how much time you have. Getting hired also depends on your background and on the jobs near you, so we don't promise a timeline.
Do I need a degree or experience to start?
You need no experience: every course on the pathway starts from first steps. Whether a job asks for a degree is up to the employer, so read the ads you plan to apply to. This pathway gives you practice and projects to show, not a credential.
How is this different from the data analyst course page?
The data analyst course path lists whole courses in order. This pathway takes only the units an analyst uses from each course, adds a timed assessment across the tools, and tracks your progress through all of it.
Is there a certificate at the end?
No. The Work Gym doesn't issue certificates, and this pathway isn't a program from Microsoft, Google or any other vendor. You get a record for each project and mock exam you finish, with a code anyone can check, and the assessment report.
What does it cost?
The first unit of every course is free, with no account. One Course opens one course in full; All Access opens the whole pathway. The pricing page shows every plan and its price.