A business analyst finds out how work really gets done, spots where it's slow, costly or error-prone, and recommends changes that people will actually adopt. You do this by interviewing people, watching the work, analyzing data, and writing clear recommendations. It's a Job Zone 4 role: most people hold a bachelor's degree (57%), but you can get hired with any degree plus a portfolio of real analysis work. The skills you can't skip are listening, critical thinking, writing, and basic math, then Excel, SQL, process mapping, and requirements writing. This roadmap has four stages: learn the core
See the full roadmap free
Every stage from beginner to expert, with lessons, practice drills, projects, interview questions and free resources. Free with a Rolearch account.
Stage 1 of 4 · about 12 weeks
Learn the BA method: ask good questions, map a process, clean and summarize data in Excel, and write plainly. Practice by mapping a real process (ordering lunch, onboarding a volunteer) as a flowchart with pain points listed. Build an Excel pivot table from a free public dataset and state three findings in one paragraph.
Asking good questions and understanding the problem
Most of a BA's value comes before any analysis. If you solve the wrong problem, perfect work is wasted. O*NET lists gathering information on problems, interviewing personnel and active listening as core to this job.
Mapping a process with flowcharts
Management analysts study how work actually flows through an organization. A process map makes hidden delays, handoffs and rework visible so people can agree on what is really happening before changing it.
Cleaning and summarizing data in Excel
Analysts spend much of their time making messy data usable. Excel is the most common tool on the job, and pivot tables are the fastest way to turn rows into answers for managers.
Writing plainly for decision makers
Your analysis only matters if a manager reads it and acts. O*NET ranks writing, reading comprehension and speaking among the top skills, and documenting findings is a core task.
Then 3 more stages (about 74 weeks in all) with lessons, drills, projects, 10 interview questions with strong answers and free resources.