Business Analyst Roadmap 2026-27: Skills, Tools & Plan

01

The plan

Business analyst roadmap at a glance

This is a month-by-month plan for a part-time learner starting from zero. It covers about 6 months at 10–12 hours a week. Every stage gives you something you can show — an Excel model, a SQL report, a BRD, a dashboard or a case study.

Month-by-month plan — part-time estimate (10–12 hours a week)
Month	Learn	Practise / Build	Milestone you can show
Month 1	Business and domain basics, the BA role, SDLC	Pick a domain (banking, retail, healthcare) and map its core processes	Short write-up explaining a domain process and where a BA fits
Month 1–2	Excel for business analysis	Build pivot tables, lookups and a small dashboard in Excel	Excel workbook with a working analysis
Month 2	SQL for business analysts	Query a sample database to answer five business questions	SQL queries with a short findings note
Month 3	Requirement elicitation, BRD/FRD, user stories and acceptance criteria	Write a BRD and 10 user stories for a sample feature	BRD and backlog in a shareable document
Month 3–4	Process modelling (flowcharts, BPMN) and wireframing	Draw as-is and to-be process flows and sketch 3 wireframes	Process diagrams and wireframes in a portfolio file
Month 4–5	Power BI / Tableau dashboards for stakeholders	Build a dashboard on a public dataset and write a stakeholder summary	Published dashboard with a one-page explanation
Month 5	Agile, Scrum, JIRA and Confluence, stakeholder management	Create a JIRA board with epics, stories and acceptance criteria; write a Confluence page	JIRA board screenshot and Confluence documentation
Month 6	AI tools for BAs (drafting stories, summarising meetings — with review)	Use AI to draft stories and summarise a sample meeting, then review and correct	Notes on what AI helped with and what needed editing
Month 6	Capstone case study, portfolio, interviews	Complete an end-to-end BA case study from requirements to dashboard	Portfolio with case study, BRD, dashboard and resume

Time estimate note: 6 months part-time is an estimate for someone studying 10–12 hours a week. A fast-track learner at 20+ hours a week can finish in about 3–4 months. Estimates are not guarantees — your pace depends on prior experience with Excel and data.

Visual roadmap: A designer-built SVG timeline of all nine stages, with a downloadable one-page PDF summary, is planned for this page. The text version above and the stage sections below cover the same content in accessible HTML.

02

Stage 1

Business & domain basics, the BA role, SDLC

A BA has to understand the business before documenting it. This stage gives you the vocabulary and the domain context you will use in every later stage.

Topics checklist
Topic	What to cover
The BA role	What a BA does, what a BA does not do, how it differs from a project manager and a data analyst
Business fundamentals	Revenue, cost, margin, KPIs, business models, value chain
Domain basics	Pick one domain — banking, retail, healthcare, insurance — and learn its core processes
SDLC	Waterfall vs Agile, where requirements sit, why discovery matters
Stakeholder map	Who is involved in a project, who decides, who uses the system

Free official resources: IIBA BABOK guide overview (free summaries), Atlassian Agile Coach, Microsoft Learn (business analysis basics).

Mini project: Write a one-page note on a business process in your chosen domain — the actors, the steps, the pain points and where a BA would help.

You are ready for the next stage when: you can explain what a BA does, what a stakeholder map looks like and why requirements come before solutions.

03

Stage 2

Excel for business analysis

Excel is still the BA's daily tool. This stage takes you from basic formulas to pivot tables and lookups — the operations you will use to analyse business data.

Topics checklist
Topic	What to cover
Formulas	SUM, AVERAGE, IF, COUNTIF, SUMIF, nested IF, text functions
Lookups	VLOOKUP, INDEX-MATCH, XLOOKUP (if available), when each one works
Pivot tables	Grouping, filtering, calculated fields, pivot charts
Data cleaning	Removing duplicates, text-to-columns, handling blanks, basic validation
Charts	Bar, line, combo charts, choosing the right chart for the message

Free official resources: Microsoft Excel help and training, Excel Jet (formula basics), Microsoft Learn (Excel for analysts).

Mini project: Take a public sales or survey dataset and build an Excel workbook with three pivot tables and a one-page summary of the findings.

You are ready for the next stage when: you can build a pivot table and a lookup formula without help, and explain what the numbers mean to a non-technical reader.

04

Stage 3

SQL for business analysts

Most business data lives in a database. This stage teaches you enough SQL to answer business questions yourself instead of waiting for a data team.

Topics checklist
Topic	What to cover
Basic queries	SELECT, WHERE, ORDER BY, LIMIT, DISTINCT
Joins	INNER JOIN, LEFT JOIN, joining three tables
Aggregations	GROUP BY, HAVING, COUNT, SUM, AVG, MIN, MAX
Subqueries and CTEs	Writing a subquery, when a CTE makes a query easier to read
Business framing	Turning a business question into a query and a short answer

Free official resources: MySQL documentation, PostgreSQL documentation, SQLBolt, Mode SQL tutorial.

Mini project: Load a sample database and answer five business questions with SQL — for example top customers, monthly revenue, repeat orders.

You are ready for the next stage when: you can join two tables and explain your result to someone who does not know SQL.

05

Stage 4

Requirement elicitation, BRD/FRD, user stories & acceptance criteria

Requirements are the BA's core deliverable. This stage teaches you how to ask the right questions and write documents a development team can actually use.

Topics checklist
Topic	What to cover
Elicitation techniques	Interviews, workshops, observation, surveys, document analysis
BRD and FRD	What goes into each, how they differ, how to keep them short and useful
User stories	As-a / I-want / So-that format, splitting large stories, writing them with the team
Acceptance criteria	Given-when-then format, testable criteria, definition of done
Traceability	Linking a business goal to a requirement to a test case

Free official resources: Atlassian (user stories, acceptance criteria), IIBA BABOK overview, Microsoft Learn (requirements basics).

Mini project: Write a short BRD for a sample feature and turn it into 10 user stories with acceptance criteria.

You are ready for the next stage when: a developer can pick up your user story and start work without asking you what it means.

06

Stage 5

Process modelling (flowcharts, BPMN) and wireframing

Diagrams explain what words cannot. This stage teaches you how to model a business process and sketch a screen before development starts.

Topics checklist
Topic	What to cover
Flowcharts	Standard shapes, as-is vs to-be flows, decision points
BPMN basics	Start and end events, tasks, gateways, swimlanes, when BPMN is better than a flowchart
Swimlane diagrams	Showing handoffs between teams and systems
Wireframing	Low-fidelity sketches, fields, buttons, states, notes for developers
Tools	Visio, draw.io, Figma (free tier) or Balsamiq alternatives

Free official resources: draw.io documentation, BPMN Quick Guide (Camunda), Figma learn.

Mini project: Draw an as-is and a to-be process flow for a sample business process, then sketch three wireframes for the improved flow.

You are ready for the next stage when: someone outside the project can follow your diagram and point to where they fit in the process.

07

Stage 6

Power BI / Tableau dashboards for stakeholders

A BA often has to show data to stakeholders, not just analyse it. This stage teaches you to build a dashboard that answers a business question and explain it in a page.

Topics checklist
Topic	What to cover
Connecting data	Connecting to Excel or a database, basic data model, relationships
Visuals	Bar, line, card, table, slicer — choosing the right visual for the question
DAX basics (Power BI)	Measures, CALCULATE, simple time intelligence
Tableau basics	Dimensions vs measures, basic charts, filters, dashboards
Storytelling	One dashboard, one message, a short written summary for stakeholders

Free official resources: Microsoft Learn (Power BI), Tableau learning resources, SQLBI (DAX basics).

Mini project: Build a one-page dashboard on a public dataset and write a one-page stakeholder summary — what the numbers say and what you would recommend.

You are ready for the next stage when: a stakeholder can read your dashboard and your one-page summary without you explaining it.

08

Stage 7

Agile, Scrum, JIRA & Confluence, stakeholder management

Most BA work happens inside a delivery team. This stage teaches you how to work in Agile ceremonies, keep a backlog organised and communicate with stakeholders.

Topics checklist
Topic	What to cover
Agile and Scrum	Sprints, ceremonies, roles, backlog refinement, definition of done
JIRA	Creating epics, stories and subtasks, boards, filters, linking issues
Confluence	Documenting requirements, meeting notes, linking to JIRA issues
Stakeholder management	Identifying stakeholders, managing expectations, escalation paths
Communication	Writing concise updates, running a requirements workshop, handling disagreement

Free official resources: Atlassian Agile Coach, JIRA documentation, Scrum Guide (official).

Mini project: Set up a JIRA project with one epic and five stories with acceptance criteria, and write a short Confluence page documenting the feature.

You are ready for the next stage when: you can run a backlog refinement session and explain how a story moves from To Do to Done.

09

Stage 8

AI tools for BAs (drafting stories, summarising meetings — with review)

AI can speed up drafting and summarising, but a BA is still accountable for accuracy. This stage teaches responsible use with a review step every time.

Topics checklist
Topic	What to cover
Where AI helps	Drafting user stories, summarising meeting notes, rewriting a BRD section
Where AI fails	Invented requirements, missing domain context, wrong assumptions about stakeholders
Review discipline	Reading every line, checking against the source, correcting before sharing
Privacy	Not pasting confidential business data into public AI tools
Tools	ChatGPT, Microsoft Copilot — with a documented review process

Free official resources: Vendor documentation for ChatGPT and Microsoft Copilot, OWASP guidance on AI risks.

Mini project: Use an AI tool to draft five user stories and summarise a sample meeting, then review and correct them. Write a short note on what needed changing.

You are ready for the next stage when: you can explain when to trust an AI-drafted requirement and when to rewrite it from scratch.

10

Stage 9

Capstone case study, portfolio, interviews

The final stage turns learning into a portfolio. One end-to-end case study with real artefacts is worth more than a list of certificates.

What to build and prepare
Item	What it involves
Capstone case study	Pick a business problem, write the BRD, draw the process flows, build the dashboard, recommend a solution
Portfolio	One document with the case study, BRD, user stories, diagrams and dashboard screenshot
Resume	One-page resume that leads with the case study and the tools used
Interview prep	Explaining requirements, trade-offs, stakeholder decisions and how you validated a solution

Interview prep: Be ready to walk through your case study from problem to recommendation. Expect questions on elicitation, writing a good user story, handling a conflicting stakeholder and how you measure success.

You are ready to apply when: you have a portfolio with one complete case study, a BRD, a dashboard and a resume that leads with your BA work.

11

Portfolio

Projects to build along the way

Each stage produces one artefact. By the end, these projects are your portfolio — they prove you can gather requirements, model processes, build dashboards and support delivery, not just talk about them.

Stage → project → what it proves
Stage	Project	Tools	What it proves
Stage 1	Domain process note	Word or Notion	You understand a business domain and the BA role
Stage 2	Excel analysis workbook	Excel	You can analyse business data and summarise findings
Stage 3	SQL business questions	MySQL, PostgreSQL	You can answer business questions from data yourself
Stage 4	BRD and user stories	Word, JIRA	You can write requirements a team can build from
Stage 5	Process diagrams and wireframes	Visio, draw.io, Figma	You can model a process and sketch a solution
Stage 6	Power BI / Tableau dashboard	Power BI, Tableau	You can present data to stakeholders clearly
Stage 7	JIRA board + Confluence page	JIRA, Confluence	You can work inside an Agile delivery team
Stage 8	AI-assisted drafting notes	ChatGPT, Copilot	You can use AI tools responsibly with review
Stage 9	Capstone case study	All of the above	You can run an end-to-end BA engagement

12

Pace

Fast-track vs part-time plan

The roadmap is the same either way — only the pace changes. Choose the plan that fits your available hours, not the one that looks impressive.

Time estimates — starting from zero
Plan	Weekly effort	Estimated months	Best for
Fast-track	20+ hours a week	3–4 months	Full-time learners, career switchers with free time
Part-time	10–12 hours a week	5–6 months	Working professionals, students with college

Estimate note: These are estimates, not guarantees. Your pace depends on how comfortable you already are with Excel and data, and how much time you can protect each week.

13

Starting points

Business Analyst roadmap for different backgrounds

01

Fresher (any degree)

Start with Stage 1 and follow the roadmap in order. Your capstone case study matters more than your degree — build it early and keep improving it.

02

Non-IT / commerce background

You already understand business context, which helps. Spend extra time on SQL and Power BI. The capstone case study is a strong first portfolio piece for commerce graduates.

03

Working professional

Go part-time (10–12 hours a week). Compress Stage 1 if you already know your domain. Focus on Stages 4–9 and ship one complete case study rather than several half-finished ones.

04

Career-gap returner

Treat the portfolio as your re-entry proof. Include the BRD, user stories, process diagrams and dashboard in one document. Add a short write-up of what you learned at each stage.

14

Role comparison

Business analyst vs data analyst roadmap — where they overlap and differ

The two roles overlap in tools but differ in intent. A BA decides what to build; a data analyst explains what the data says.

Where the two roadmaps overlap and differ
Factor	Business Analyst	Data Analyst
Shared tools	Excel, SQL, Power BI / Tableau	Excel, SQL, Power BI / Tableau
Core focus	Requirements, process, stakeholders, solution direction	Data quality, analysis, reporting, insight
Key documents	BRD, FRD, user stories, process diagrams	Analysis notebooks, dashboards, insight reports
Programming depth	Light — SQL plus tools	Moderate — SQL, sometimes Python or R
Typical output	A clear solution direction and backlog	Clear answers to data questions
Career path	Senior BA, Lead BA, Product Owner	Senior Data Analyst, Analytics Lead, Data Scientist

15

Avoid these

Common mistakes on this roadmap

Skipping the domain — a BA who does not understand the business writes documents nobody uses.
Writing BRDs that are too long — short, clear requirements beat impressive-looking documents.
Ignoring Excel and SQL — they are still daily tools for most BAs.
Never building a dashboard — stakeholders remember visuals, not paragraphs.
Collecting certificates instead of a capstone case study.
Treating AI output as final — every AI-drafted requirement needs review.

16

After the roadmap

Jobs you can apply for at the end

At the end of this roadmap you can apply for Business Analyst, Process Analyst, Systems Analyst, Product Analyst, Requirements Analyst and BI Analyst roles. Uncodemy's BA page reports the following ranges (sources: AmbitionBox, Glassdoor, Indeed and Uncodemy records; reviewed Sept 2026).

Business Analyst salary — Uncodemy BA page, reviewed Sept 2026
Role / level	Salary range	Source
Entry BA	₹3–6 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
BA mid	₹6–10 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
Senior BA	₹10–16 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
BI Analyst	₹7–12 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
Product BA	₹7–14 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026
Lead BA	₹12–20 LPA	AmbitionBox, Glassdoor, Indeed + Uncodemy records, reviewed Sept 2026

Indeed figure: Indeed reports an average Business Analyst salary of ₹9,06,661 (754 salaries, updated 14 Aug 2026; city figures: Bengaluru ₹10.39L, Pune ₹9.19L, Mumbai ₹9.01L, Gurgaon ₹8.81L).

Note: Salaries vary by city, company, skills and experience. Uncodemy does not guarantee any salary. Figures above are for context only.

17

Guided learning

Follow this roadmap with a trainer

Uncodemy's Business Analyst program follows the same path — Excel, SQL, BRD/FRD, process modelling, statistics, Power BI, Tableau, Agile and AI tools, ending with a capstone. Fee and duration are verified on the course page.

Uncodemy Business Analyst program
Program	Details
Business Analyst	Business Analyst — ₹17,500 + GST, 6–7 months. 100+ hours, 75+ live sessions, 10 modules, capstone on a real business scenario. No coding needed. Classroom Noida / live online / hybrid.

Ready to explore? Book a free counselling session, try a 2-class trial or use the AI-powered career guidance tool.

18

FAQs

Business Analyst roadmap FAQs

Q1 How long does it take to become a business analyst? +

For a learner studying 10–12 hours a week, about 5–6 months. The roadmap covers business basics, Excel, SQL, requirements, process modelling, Power BI, Agile, AI tools and a capstone case study. A fast-track learner at 20+ hours a week can finish in 3–4 months.

Q2 Do business analysts need coding? +

No. Most BA roles need Excel, SQL and a BI tool, not programming. Uncodemy's BA program is explicitly no-coding. SQL is the closest thing to code, and even that is only light querying for most roles.

Q3 Is MBA required for business analyst jobs? +

No. An MBA helps for some senior or consulting roles, but most entry-level BA roles accept graduates of any stream. Skills, portfolio and communication matter more than the degree. Uncodemy's BA program eligibility is graduates of any stream and final-year students.

Q4 Which certification helps a business analyst fresher? +

A recognized BA certificate plus a portfolio with a real case study is the strongest combination. IIBA's ECBA is the best-known entry certification, but it is not required. Uncodemy's BA program certificate is verifiable at certificate.uncodemy.com.

Q5 Can a non-IT graduate become an IT business analyst? +

Yes. Non-IT graduates often bring strong business context, which is an advantage. The gap is usually technical vocabulary and tools — covered by Excel, SQL, Power BI and JIRA. A strong capstone case study can open doors without an IT degree.

Q6 What should a BA portfolio contain? +

One complete case study with a BRD, user stories with acceptance criteria, process diagrams, a dashboard screenshot and a short recommendation note. Keep it in one document with a clear table of contents. A portfolio with one strong case study beats five half-finished ones.