Career guides

What does a business intelligence analyst do?

A business intelligence (BI) analyst builds and looks after the reports and dashboards a company uses to follow how it is doing. Sales by region, orders delivered late, how many people finished signing up. The job is as much about agreeing what a number means as it is about drawing the chart.

A typical week

How it differs from nearby roles

BI analystData analyst
Main outputDashboards and recurring reports others use dailyAnswers to specific questions, often one-off
Typical audienceMany managers who check regularlyThe team that asked the question
Skill emphasisClear design, definitions, reliable dataExploring data, testing ideas, explaining findings
OverlapBoth use SQL and spreadsheets and explain numbers in plain wordsMany job titles blur the two

A decision to practise

Imagine a dashboard has room for five numbers for a leadership team. Which five, and what do you leave out? Choosing is the hard part. Try a free decision on Compass to practise making a call with limited room. Nobody scores you.

Signs you might enjoy it

Signs it might frustrate you

How to test it in a week

  1. Pick any public dataset and choose three numbers that tell its story.
  2. Make one simple chart for each in a spreadsheet and add a one-line title saying what to take from it.
  3. Show it to a friend and ask what they understood. Change whatever confused them.

Common questions

Do I need to know SQL?

It helps a lot in most BI roles. You can start learning with a small practice dataset in a week or two.

Where can I read more?

See what a data analyst does and data analyst vs business analyst.

Try the work before you choose it

Compass lets you try a realistic decision from each path you’re weighing, notice how it felt, and choose your next step with evidence. The preview on our home page is free.

Try a free decision

Weighing two or three paths seriously? See our packages, each prepared and reviewed by a person.

Related guides