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.

        How to become a business analyst

        Learn to write requirements and user stories and map a process, analyze it in Excel and SQL, track the work in Jira, show the result in Power BI and structure a business problem. Every exercise is checked, and the pathway ends in projects, a timed assessment across the tools and the interview.

        Tools
        Business analysis, Power Apps, Excel, SQL, Jira, Power BI, Consulting cases, PowerPoint, Word, Google Docs and Slides, Zendesk
        Units
        52 units, 281 lessons
        Checked exercises
        1,486
        Cross-tool projects
        5
        Final assessment
        12 tasks, 50 minutes

        About 68 hours of lessons, from the estimate on each lesson.

        Your progress

        Nothing done yet. Progress saves in this browser as you finish lessons, and in your account when you sign in.

        Lessons
        0 of 281 lessons
        Projects
        0 of 5 finished
        Assessment
        Not taken yet

        Start with What business analysts do

        The pathway, unit by unit

        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. Prototype and test a business app

          Turn a documented requirement into a canvas app with live formulas, a filtered gallery and a validated form. Check the saved record and test a known match beyond a connector row limit before accepting the prototype.

          1. Studio and propertiesBeginner · 5 lessons · 28 exercisesFree
          2. Validated record formsIntermediate · 5 lessons · 29 exercises
          3. Complete queries and app projectsIntermediate · 5 lessons · 30 exercises
        2. Data from SQL

          The process you are studying leaves records in a database. With SQL you count, filter and join them yourself: how many orders waited more than a day, which depot handles the exceptions, where the handoffs stall.

          1. Query a tableBeginner · 7 lessons · 34 exercisesFree
          2. Summarize dataBeginner · 4 lessons · 21 exercises
          3. Combine tablesBeginner · 5 lessons · 25 exercises
          4. Functions and typesIntermediate · 6 lessons · 28 exercises
          5. Nested queriesIntermediate · 5 lessons · 24 exercises
        3. Requirements and delivery in Jira

          Your findings turn into work for a team. You create and organize work items, follow workflows and transitions, search with JQL, run Scrum and Kanban boards, plan sprints and build the filters and dashboards a team checks every morning.

          1. Projects and work itemsBeginner · 5 lessons · 24 exercisesFree
          2. Workflows and transitionsBeginner · 5 lessons · 24 exercises
          3. JQL foundationsBeginner · 5 lessons · 24 exercises
          4. Scrum and Kanban boardsIntermediate · 5 lessons · 24 exercises
          5. Backlogs and sprintsIntermediate · 5 lessons · 26 exercises
          6. Filters and dashboardsIntermediate · 5 lessons · 26 exercises
        4. Structuring a business problem

          A business analyst is often handed a vague question. The case units teach you to break it into parts, read an exhibit, do the arithmetic and finish with a recommendation someone can act on.

          1. Case interview basicsBeginner · 3 lessons · 18 exercisesFree
          2. StructuringBeginner · 3 lessons · 16 exercises
          3. Exhibits and dataIntermediate · 4 lessons · 23 exercises
          4. Synthesis and driving the caseIntermediate · 4 lessons · 22 exercises
        5. Evidence in a presentation

          Turn findings into an answer-first PowerPoint storyline, keep source links available and prepare a review deck that separates observations from recommendations.

          1. Consulting-style storylinesAdvanced · 4 lessons · 15 exercises
          2. Review and decision decksExpert · 4 lessons · 21 exercises
        6. Documents people can review

          Build structured Word reports with headings, sections and an automatic table of contents. Review changes and comments before handing the document to its owner.

          1. Text and paragraphsBeginner · 5 lessons · 24 exercisesFree
          2. Styles and structureBeginner · 5 lessons · 24 exercises
          3. Sections and running textIntermediate · 5 lessons · 26 exercises
          4. Review and comparisonIntermediate · 5 lessons · 25 exercises
        7. Collaborate on shared files

          Set the audience and roles for a Google document or slide deck, suggest and review changes, name a version and refresh a chart from its Sheets source before handing it over.

          1. Sharing and permissionsBeginner · 2 lessons · 12 exercises
          2. Suggestions and commentsIntermediate · 3 lessons · 16 exercises
          3. History and linked dataIntermediate · 4 lessons · 22 exercises
        8. Support operations in Zendesk

          Practice ticket identity, shared views and event-driven rules on original support requests. Check the saved conversation and excluded records before recommending a workflow change.

          1. Ticket workspaceBeginner · 5 lessons · 26 exercisesFree
          2. Views and work queuesBeginner · 5 lessons · 26 exercises
          3. Event-driven triggersIntermediate · 5 lessons · 28 exercises

        Projects for this role

        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.

        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
        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
        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
        Ashgrove Engineering
        Resource planningExcel
        Project

        Staff a new programme without burning anyone out

        Ashgrove has won eight weeks of bridge inspections. Find who can really take the work in the resource planner, after leave, part-time hours and other jobs, then show everyone's load in Excel and tell operations whether to hire.

        3 stages · 1 h 15 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

        The job-readiness assessment

        When you finish the units, test yourself across the tools of the job at once: 12 practical tasks in 50 minutes, each in the tool it is about and checked automatically. The clock keeps running if you close the page.

        ToolTasksMinutes
        Excel310
        SQL311
        Jira314
        Power BI315

        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.

        Open the assessment

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

        Practice the business analyst interview

        What each plan opens

        Free
        The first unit of every course, with no account: 9 of the 52 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: Business analysis (9 units), Power Apps (3 units), Excel (8 units), SQL (5 units), Jira (6 units), Power BI (5 units), Consulting cases (4 units), PowerPoint (2 units), Word (4 units), Google Docs and Slides (3 units), Zendesk (3 units).
        All Access
        The whole pathway: every unit, every project stage and spoken interview practice.

        See plans and prices

        What a business analyst does

        A business analyst finds out how work really gets done, where it goes wrong and what should change. They sit with the people doing the work, measure the process from its data, write requirements and acceptance criteria a team can build from, and check after the change that it helped. The title covers many jobs, from operations to IT systems, but the core is the same: a clear problem, evidence, and a change someone can deliver.

        From data to requirements

        Excel comes first because it is where most analysis starts and ends. SQL follows, so you can get the evidence yourself. Jira is where requirements become work. Power BI shows the result. The case units come last, because by then you have the tools to answer a business question and only need the structure.

        Showing what you can do

        The projects are operations work at fictional companies. At Ashgrove Engineering you find who can really take eight weeks of new inspections, then tell operations whether to hire. At Quillfield you fix the Salesforce rule that sent demo requests to a rep who left. At Hearthline you explain why profit fell while sales rose. Each ends in a written recommendation, which is what a business analyst hands over. The assessment then shows which tool to practice before you apply.

        Support operations in Zendesk. Practice ticket identity, shared views and event-driven rules on original support requests. Check the saved conversation and excluded records before recommending a workflow change.

        Common questions

        What is the difference between a business analyst and a data analyst?

        There is a lot of overlap. A data analyst mostly answers questions with data; a business analyst also studies how work gets done and writes the requirements for changing it. That is why this pathway adds Jira and case structuring, and the data analyst pathway adds Python instead.

        Do I need technical skills to be a business analyst?

        Fewer than an engineer, more than many people expect. Most job ads ask for Excel, and many ask for SQL and a reporting tool. You don't need to program, but you need to understand the data well enough to question it.

        How long does it take?

        The lessons on this pathway add up to about 68 hours. Each unit ends in a practice set on fresh data. We don't promise how long getting hired takes.

        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.

        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.