Excel
For Excel assessments, MO-200
df.head()
Learn data, code and cloud by doing the work.
Real exercises in workspaces modeled on the tools. Pick one below and try it.An interviewer who listens and follows up. Watch a practice call below.
Excel course
- SUM
- COUNT
- IF
- VLOOKUP
- INDEX MATCH
- XLOOKUP
Lesson 1 · SUM
Total the revenue in B5
- Click cell B5. The formula is already started.
- Finish it so it adds the three revenue cells.
- Press Enter or Check answer.
FileHomeInsertFormulasDataReviewView
SalesTargets
Your turn
SQL course
- WHERE and ORDER BY
- GROUP BY
- JOIN
- Subqueries
- Window functions
Lesson 1 · WHERE and ORDER BY
Find the big orders
- On line 3, keep only orders over 500 with WHERE.
- On line 4, sort them biggest first with ORDER BY.
- Press Run query or Ctrl + Enter.
Table orders: order_id customer amount region
Your turn
pandas course
- groupby
- Filtering rows
- merge
- pivot_table
- Dates
Lesson 1 · groupby
Revenue by region
- In In [2], add ["revenue"] to pick the revenue column.
- Add .sum() to total each region.
- Press Run cell or Enter.
In [1]:
Out[1]:
Out[2]:
Your turn
Power BI course
- Your first visual
- Measures
- CALCULATE
- Time intelligence
- PL-300 practice
Lesson 1 · Your first visual
Chart revenue by region
- Under Visualizations, pick the clustered bar chart.
- Under Fields, tick Region and Revenue.
- Press Check visual.
Visualizations
Fields · Sales
Your turn
Tableau course
- Columns and rows
- Filters
- Calculated fields
- LOD
- Dashboards
Lesson 1 · Columns and rows
Build a bar chart
- Drag Region onto Columns.
- Drag Revenue onto Rows. (Or click a field, then click a shelf.)
- Press Check chart.
Dimensions
RegionRepMeasures
RevenueUnitsColumns
Rows
Your turn
Python practiceYour turnOpen this tab to start.
AWS practiceYour turnOpen this tab to start.
Terminal practiceYour turnOpen this tab to start.
Salesforce practiceYour turnOpen this tab to start.
Google Sheets practiceYour turnOpen this tab to start.
{FREE_LINE}
Courses by subject
All 34 coursesAnalyze data in spreadsheets, SQL workspaces, notebooks and dashboard builders.
SQL
For SQL interviews and tests
pandas
For Take-home tasks
Machine learning
For Data scientist and machine learning interviews
Power BI
For PL-300
Tableau
For Desktop Specialist
Google Sheets
For Office and analyst roles
Power Query
For Reporting roles, PL-300
Snowflake SQL
For SnowPro Core
BigQuery SQL
For Analytics roles, GA4 work
dbt
For Analytics engineering
Databricks
For Databricks Data Engineer Associate
Alteryx Designer
For Analyst roles and Core-style practice
Write code, solve problems and practice system design.
Python
For Coding interviews
Python for software engineers
For Python software engineering and coding interviews
System Design
For System design interviews
Coding interview patterns
For Coding screens and mock interviews by role
Java
For Java developer interviews and Java SE 21 certification topics
JavaScript and TypeScript
For JavaScript and TypeScript engineering interviews
Front end
For Front end development interviews and practical job tests
Use the command line, manage code with Git and work with containers.
Configure cloud services and troubleshoot infrastructure in a local simulator.
Work with business records, reports, workflows and workforce plans.
Workday HCM
For HCM analyst work and skills assessments
SAP
For SAP end-user and analyst roles
Power Automate
For Operations roles and PL-900 objectives
Workforce and resource planning
For Resource planning and workforce analyst job tests
ServiceNow
For Certified System Administrator
Salesforce Administrator
For Salesforce Administrator certification and admin roles
Build financial models, record transactions and prepare financial statements.
See how it works
Every lesson is the same four steps, in whichever tool you pick.
Practice the rounds employers run, out loud, with an interviewer who follows up.
- 1Read the task
A short explanation, then one clear task.
- 2Do it in the tool
Work in the tool, as you would at your job.
- 3Get checked
At once, with a hint when it's wrong.
- 4Move up
The next exercise, from beginner to expert.
Practice the tools for your job
Data analyst tools, one at a time
Most data analyst jobs ask for the same few tools: a spreadsheet, SQL, Python with pandas and a dashboard tool. Learn them in the order analysts usually do, or jump to the one your next test asks for.
Start hereExcel
From the first function to the system
Software interviews test a language you know well, the classic coding patterns and how you design a system. Practice each in a real code workspace, with every answer run against tests.
Start herePython
From the first query to the pipeline
Data engineering interviews test SQL in depth, a cloud warehouse, modeling with dbt and processing at scale. Practice each in a workspace modeled on the real tool, the way the job uses them.
Start hereSQL
The terminal, the repo and the cloud
Cloud and DevOps roles expect you at home in a terminal, in Git, with containers and on AWS. Practice them in workspaces modeled on the real tools, where nothing you break is real.
Start hereLinux
The spreadsheets finance runs on
Finance and accounting roles live in spreadsheets: models, journal entries and the reports built on them. Practice the tools the job uses, from the first formula to a finished report.
Start hereExcel
Free lessons and plans
Practice the first unit of every course. No account needed.
Practice across 34 courses
One Course
$54.99/ year
$17.99/ month
About $4.58 a month, billed yearly
Billed monthly, cancel any time
Choose a courseAll Access
$139.99/ year
$24.99/ month
About $11.67 a month, billed yearly
Billed monthly, cancel any time
Get All AccessLessons
151 lessons
Every lesson in one course
All 2,200+
A practice workspace for every tool, nothing to install
Every answer checked, with hints
Projects and case studies
3
All in your course
306
Timed mock exams
All in your course
76
Typed interview practice
20 min a day
20 min a day
No daily limit
Plates for spoken interviews
Buy a pack
Buy a pack
30 a month, plus packs
Interviews built for a real job ad
With plates
With plates
2 a month
Progress and badges kept in your account
Interview Hub
Plates for spoken interviews, on any plan
One plate is one spoken minute. Typed practice is free up to 20 minutes a day.
- 60 plates$19.99$0.33 a plate
- 180 plates$49.99$0.28 a plate
- 400 plates$99.99$0.25 a plate
Questions
What tools do data analysts use?
Most use a spreadsheet (Excel or Google Sheets), SQL to get data out of databases, a dashboard tool like Power BI or Tableau, and often Python with pandas. The Work Gym has a hands-on course for each.
How do I practice for an Excel test for a job interview?
Do the tasks those tests use, against the clock: lookups, SUMIFS, cleaning data, charts and summaries. The Excel course builds up to exactly that and ends with mock exams in the same style.
What are common data analyst interview questions?
Expect SQL queries (joins, GROUP BY, window functions), a spreadsheet task, questions on metrics and a short case. The SQL, pandas and consulting courses each have interview sets built from these.
Is The Work Gym free?
Free access details are loading. Visit plans and pricing for current access.
Do I need to install anything?
No. The simulators run in your browser, including Python notebooks, SQL workspaces, Linux terminals, Git repositories and a local AWS account.
How long does a lesson take?
Most take 5 to 15 minutes: a short explanation and a few exercises. Projects and mock exams take longer, and you can stop and come back.
Your first lesson
Pick a tool and do lesson 1 now. No account, no card, nothing to install.