Every tool a BA needs — requirements management, process mapping, data analysis, collaboration, and wireframing — with honest advice on which ones actually matter.
Start Free BA Training →How to Think About BA Tools
Business analysts don’t need a large toolset. What matters is mastering the tools your team actually uses. The tools listed here are those most commonly required by employers — learning them is a sound investment regardless of which organisation you end up in.
Tools fall into five categories: requirements management, process mapping and diagramming, collaboration and documentation, data and SQL, and wireframing. We’ll cover each with practical guidance on which to prioritise.
1. Requirements Management Tools
Jira
Jira is the dominant requirements and project tracking tool for Agile BA work. If you’re joining any technology, financial services, or product team, you’ll almost certainly use Jira. BAs use it to write user stories and acceptance criteria, manage product backlogs, track requirements through delivery, and link stories to epics and initiatives.
Key Jira skills for BAs: writing well-structured user stories (As a / I want / So that), defining acceptance criteria, managing epics and sprints, using Jira Query Language (JQL) to filter and report on requirements.
Confluence
Confluence is Jira’s companion documentation tool, and they’re almost always used together. BAs use Confluence for Business Requirements Documents (BRDs), functional specifications, meeting minutes, decision logs, stakeholder registers, and project wikis. Confluence templates make it easy to standardise BA documentation across teams.
Azure DevOps
Microsoft’s equivalent to Jira + Confluence, common in Microsoft-heavy enterprise environments (government, large enterprise, manufacturing). If you’re targeting government or large corporate employers, Azure DevOps familiarity is worth having.
2. Process Mapping and Diagramming Tools
Lucidchart
Lucidchart is a cloud-based diagramming tool widely used for process maps, swimlane diagrams, entity relationship diagrams, and context diagrams. It’s collaborative, works in a browser, and integrates with Google Workspace and Confluence. Preferred by teams that need to share diagrams across organisations.
Miro
Miro is a virtual whiteboard platform popular in Agile and collaborative BA environments. BAs use Miro for user story mapping, process workshops, stakeholder maps, affinity diagrams, and brainstorming. It’s excellent for facilitated workshops — particularly with remote teams. If your team runs any kind of online workshop, you’ll likely use Miro.
Microsoft Visio
Visio is the traditional enterprise process mapping tool, common in government, banking, and large enterprise environments. BPMN diagrams, swimlane process maps, and data flow diagrams are the main use cases. Worth knowing if you’re targeting government or corporate roles; less relevant for startups or Agile-only teams.
draw.io
Free, open-source diagramming tool (also available as a Confluence plugin). draw.io is a practical alternative to Visio for teams that don’t want to pay per licence. Produces professional-quality process maps and is widely used in smaller teams and government agencies.
3. Collaboration and Documentation Tools
Microsoft Office (Word, Excel, PowerPoint)
Despite the rise of Jira and Confluence, Word, Excel, and PowerPoint remain widely used in BA work — particularly in government, financial services, and traditional enterprise. BRDs, stakeholder presentations, RAID logs, and business cases are still frequently delivered in Office formats. Strong Word and Excel skills are baseline expectations.
Google Workspace
Docs, Sheets, and Slides are the Google equivalent, dominant in technology companies, startups, and organisations that have moved away from Microsoft. Functionally similar to Office for most BA purposes.
SharePoint
Microsoft’s document management and intranet platform, common in large enterprise and government. BAs often manage documentation libraries, project artefacts, and stakeholder portals in SharePoint. Worth understanding if you’re targeting corporate or government roles.
4. Data and SQL Tools
SQL
Basic SQL is increasingly expected for BA roles — particularly in financial services, data platforms, and technology companies. You don’t need developer-level SQL, but the ability to write SELECT queries, join tables, filter data, and aggregate results allows you to validate requirements against real data, investigate data quality issues, and communicate meaningfully with data engineers and developers.
Practical BA SQL skills: SELECT with WHERE and ORDER BY, JOIN (inner, left), GROUP BY and aggregation (COUNT, SUM, AVG), subqueries for data validation. Tools: MySQL Workbench, DBeaver (free), Azure Data Studio, or simply access to your team’s data warehouse.
Excel/Google Sheets
For data analysis that doesn’t require SQL, Excel and Sheets are the BA’s practical workhorse. Pivot tables, VLOOKUP/XLOOKUP, conditional formatting for data quality checks, and basic charting for stakeholder presentations are core skills.
Power BI / Tableau
Data visualisation tools increasingly expected in BA roles that involve reporting and analytics. You don’t need to be a Power BI developer, but being able to read a dashboard, understand the underlying data model, and brief a visualisation team on requirements is a clear advantage.
5. Wireframing and Prototyping Tools
Balsamiq
Balsamiq produces rough, sketch-style wireframes that communicate UI structure without looking polished. This is deliberate — the rough aesthetic signals ‘this is not the final design’ and keeps stakeholders focused on structure and flow rather than visual polish. Widely used by BAs to document screen requirements for development teams.
Figma
Figma is a professional UI design tool increasingly used by BAs in product-centric and technology companies. It’s more complex than Balsamiq but produces higher-fidelity prototypes. If you’re working closely with UX designers or in a product company, familiarity with Figma is valuable — even if you’re reviewing designs rather than creating them.
Which Tools Should You Learn First?
Prioritise based on where you’re trying to work:
- Any BA role: Jira + Confluence, Microsoft Office, Miro or Lucidchart, Balsamiq
- Financial services or enterprise: Add Visio, SQL, SharePoint, Power BI
- Technology or product: Add Figma, strong Git/Jira integration awareness, data tooling
- Government: Visio, SharePoint, Azure DevOps, Word/Excel
For templates that work with all these tools, see the free BA templates library. For the techniques you’ll use with these tools, see 15 essential BA techniques.
Learn BA Tools in Context — Free Course
The free BA introduction course covers how tools fit into real BA workflows — not just what buttons to click.
Start Free BA Training →Frequently Asked Questions
What tools do business analysts use?
The most common BA tools are: Jira and Confluence (requirements and documentation), Lucidchart or Miro (process mapping), Microsoft Office or Google Workspace (documents and presentations), SQL (data queries), Balsamiq (wireframes), and Visio (enterprise process mapping). The exact mix depends on your industry and employer.
Do business analysts need to code?
No — coding is not a standard BA requirement. However, basic SQL is increasingly expected in data-heavy roles. Understanding how code works at a conceptual level helps you communicate with developers, but you won’t be writing production code as a BA.
Is Jira a BA tool?
Yes — Jira is the most widely used tool for Agile BA work. BAs use it to manage user stories, requirements, and product backlogs. Most BA job descriptions for technology and financial services roles list Jira as a required or preferred skill.
What is the best business analyst tool for beginners?
Start with Jira and Confluence (free tier available), draw.io (free, browser-based), and Google Workspace. These cover the core BA toolset at zero cost and are widely used in real organisations. Balsamiq has a free trial for wireframing.
Further reading: 15 Essential BA Techniques | Free BA Templates | Business Analyst Career Path | Entry-Level BA Jobs Guide