Business analyst course: learn it by doing the analysis
Business analysis first: finding the need, writing requirements and user stories, mapping processes, prioritizing and planning UAT. Then the tools analysts use every day: a spreadsheet, SQL and Jira. Every answer is checked, and the path ends in projects, the business analyst interview and two timed mock exams.
Counts cover every course named in the path, alternatives included.
The path, step by step
Take the steps in this order. Each course starts with a free unit, so you can try a step before you commit to it.
1
Business analysis
This is the job itself. You read interview notes, emails and observation notes from fictional companies (a homewares retailer, a car insurer, a bank) and do the analyst's work on them in a workbench, with a process-map editor for BPMN.
Find the need behind a request, list the stakeholders and fill in a RACI chart
Write requirements someone can test, and user stories with Given / When / Then acceptance criteria
Draw BPMN process maps with lanes and gateways, then find the waste and the gaps between the current and future process
Prioritize with MoSCoW, RICE and weighted shortest job first
Map data from one system to another, write the UAT plan and triage the defects
Build a business case and handle a change request
2
Spreadsheets
Analysts check numbers before they write about them, such as a sample of records or the totals behind a business case. Most of that happens in a spreadsheet. Learn it in Excel, or in Google Sheets if your team uses it.
Clean an export: text that looks like numbers, stray spaces, blanks and duplicates
Look values up with XLOOKUP and total by condition with SUMIFS
Summarize with PivotTables and charts that answer one question
Check a list against business rules with data validation and conditional formatting
3
SQL
With SQL you can answer your own questions about the data, such as how many claims sit in each status or what a field holds before you map it. Many BA job ads ask for it, and so does the BA interview here.
Filter, sort and count with WHERE, GROUP BY and HAVING
Join tables and notice when a join multiplies your rows
Find the rows that break a data quality rule
Use subqueries to compare a group with the whole
4
Jira
On agile teams the requirements live in the backlog. You will keep stories in Jira, plan them into sprints and follow them across the board until they are done.
Create work items and keep their fields consistent
Find work with JQL, including the blank and boundary cases
Read Scrum and Kanban boards and plan a sprint without losing unfinished work
Save filters and build a dashboard that answers one question
Want only the units this job uses, with your progress across all of them and a timed assessment at the end? Follow the business analyst pathway
Some analyst jobs ask for more. Power BI or Tableau turns the numbers into a report other people can use, and the consulting course practices structuring a business problem and presenting a recommendation. Add the one your target jobs name.
Each project starts from a fictional company's brief and moves between tools the way analyst work does. The tables you build in one stage are where the next stage 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.
Store managers say shelves keep running empty, but the shelf checks are messy. Mark every check, compare the stores fairly and show availability next to how much was checked.
Tradewind takes a flat 12% on every sale. The marketplace lead wants tiered fees. Measure what sells in each price band, how far below the asking price it sells, and model what the tiers would earn.
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.
Demo requests from the Central region have gone quiet since August. Fix the Salesforce rule that sends them to a rep who left, build the flow that tells each owner about a new lead, and report conversion by owner in Excel.
The courses add 51 projects and case studies of their own, each checked step by step in one tool. See data analytics projects
The interview
The Interview Hub runs the interview round by round. You answer out loud or in writing, the interviewer follows up, and you get a written report that quotes your answers.
Process and requirements
Walk through a workflow, settle what a term means and write acceptance criteria someone can test.
Excel talk-through
Explain a workbook: its formulas, how you checked the source and how it refreshes.
Metrics
Define the measure that shows whether a change worked, and say what the evidence supports.
Business case
Structure a business question, show the arithmetic and recommend what to do next.
Trade-offs
A dependency with no date, a late change, a stakeholder who wants everything: say what you would do.
Project briefs and interview practice. Every project brief is free to read. With a free account you also get 60 minutes of text interviews a month.
The rest of the path. One Course opens one course in full. All Access opens every course on this page, every project stage and spoken interview minutes. See plans and prices
The practice
Each lesson explains one technique in a few short paragraphs, works an example, then hands you exercises on a fictional company’s documents. You sort cards, fill in a matrix, pick the requirement out of an interview note or draw the process in the map editor. Press Check and the answer is marked at once. If it’s wrong, the message names the likely mistake: a solution written down as the need, a requirement nobody could test, a gateway with no conditions on its paths, a Must that is really a Should.
Every exercise has a Show me how button that walks you through the answer one step at a time, for when you get stuck.
Projects, case studies and mock exams
The course has projects by employer: returns at a homewares retailer, claims intake at a car insurer and account opening at a bank, each from the first stakeholder list to a change request. Two case studies end in a recommendation: a dispute over priorities at a logistics firm and a requirement that was missed at a clinic. The library adds take-home projects for the business analyst role, each worked through several tools and finished with a written readout.
At the end come two timed, closed-book mock exams with 25 questions each, in the style of the ECBA. The interview questions run from easy to hard across the course, and the Interview Hub has the business analyst interview to practice out loud.
A week on the path
One way to spend about five hours a week:
Two sessions of lessons in the current unit.
One session on the unit’s practice set or a case study.
Every few weeks, a project, and a round of interview questions out loud.
When a unit feels easy, move on. The practice sets mix techniques from earlier units, so nothing you learned goes unused for long.
Common questions
Is there a certificate at the end?
No. The Work Gym doesn't issue certificates, and this path isn't a program from the IIBA or any other body. The business analysis course follows the public outline of the IIBA's ECBA and ends in two timed mock exams in its style, written by us. They show you where you stand; they aren't the real exam. What you get from us is a record for each project, case study and mock exam you finish, with a code anyone can check.
Do I need any experience?
No. The first unit explains what business analysts do and where they sit in waterfall and agile projects. If you already work as a tester, in support or in operations, you will recognize a lot of it; skip ahead, the course page lists every lesson.
Do I need to know how to code?
No. Business analysis is about needs, requirements and processes, and none of the course needs code. SQL is the one technical step on the path, and many analysts learn it on the job.
How long does it take?
The lesson estimates add up to about 109 hours if you take one tool at each step. How fast you get through them depends on your week.
Do I need to install anything?
No. The analyst workbench, the spreadsheet, the SQL workspace and the Jira practice site all run in your browser. The Work Gym isn't affiliated with Microsoft, Google or Atlassian.
What does it cost?
The first unit of every course is free, with no account. After that, One Course opens one course and All Access opens all of them, with the project stages and spoken interview time. The pricing page shows every plan and its price.
Will this get me a job?
We can't promise that. The path gives you practice on the work analyst jobs ask for, projects you can talk about in detail, and rehearsal for the interview. The applications are up to you.