Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        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.

        Steps
        4
        Checked exercises
        2,832
        Projects and case studies
        57
        Timed mock exams
        10
        Free to start
        151 exercises

        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.

          What you practice

          • 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.

          What you practice

          • 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.

          What you practice

          • 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.

          What you practice

          • 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.

        Projects to show what you can do

        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
        ExcelSQLpandasPower 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.

        5 stages · 2 h 30 minView brief
        Greenbasket Market
        ExcelSQLPower BI
        Project

        Did the summer promotions pay?

        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.

        4 stages · 2 h 30 minView brief
        Greenbasket Market
        Google SheetsSQLTableau
        Project

        The empty-shelf problem

        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.

        4 stages · 2 h 10 minView brief
        Tradewind
        BigQuerypandasGoogle Sheets
        Project

        Should cheap listings pay a higher fee?

        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.

        4 stages · 2 h 20 minView brief
        Copperline Freight
        SQLPower BI
        Case study

        Two dashboards, two on-time numbers

        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.

        3 stages · 1 hView brief
        Quillfield
        SalesforcePower AutomateExcel
        Project

        Find the leads nobody is calling

        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.

        4 stages · 1 h 50 minView brief

        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.

        Practice the interview

        What is free

        The first unit of every course is free, with no account or card. Along this path that comes to 29 lessons and 151 checked exercises.

        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:

        1. Two sessions of lessons in the current unit.
        2. One session on the unit’s practice set or a case study.
        3. 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.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.