For students and early-career professionals

Business Intelligence Analyst

Builds dashboards and metrics so teams can track performance and make decisions.

12 chapters · About 3–5 months · 15–30 min a day

Start this plan free →

Chapter 1 is free.

Skills

14 skills, and what you'll learn in each

Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.

Core to the job

Chapter 2

SQL

Write queries that filter and summarise data and join tables

What you'll learn

  • Query output shape
  • Join logic
  • Grouping level
  • Query plan

Practice

  • Find the bug in a SQL query15 min
  • Refactor a tangled query into tested steps30 min

Chapter 3

Data cleaning

Clean a messy data set and note each fix

What you'll learn

  • Tidy table shape
  • First data profile
  • Missing value choice
  • Repeatable cleaning steps

Practice

  • Clean a Messy Dataset and Document Your Fixes10 min
  • Profile a new public dataset in 20 minutes30 min

Chapter 3

Data quality

Write checks for a table and run them before sharing

What you'll learn

  • Data checks
  • Plausible values
  • Root cause fix

Practice

  • Reconcile a dashboard number against its source40 min

Chapter 4

Metric definitions

Define a business measure so everyone gets the same number

What you'll learn

  • Metric grain
  • Metric definition
  • Shared definitions
  • Grain mismatch

Practice

  • Write a Plain-Language Metric Definition15 min

Chapter 4

Dashboards

Build a dashboard with clear filters and honest charts

What you'll learn

  • Question before charts
  • Chart choice
  • Data-ink ratio
  • Filters and refreshes
  • Calculated measure

Practice

  • Pick the right chart for four questions15 min
  • Three measures, each proved twice30 min
  • Measure or column, and last year's number25 min

Chapter 6

Data modeling

Organise data into linked tables and describe each column

What you'll learn

  • Table grain
  • Primary key
  • Table relationships
  • Normalised design
  • Star schema
  • Model levels
  • Transactional and analytical

Practice

  • Spot What Is Wrong With This Table Design15 min

8 more in the plan

SpreadsheetsBuild a spreadsheet summary that updates when filters changeCh 2

What you'll learn

  • Formula references
  • Lookup logic
  • Pivot tables
  • Auditable workbook

Practice

  • Answer 3 manager questions with a pivot table20 min
Report publishingPublish one report and test what each reader can seeCh 4

What you'll learn

  • Audience and access
  • Row-level security
  • Content people trust
  • Usage and retirement

Practice

  • Set the Permissions for One Report with Three Audiences25 min
  • Design a Row-Level Security Rule and Test It as Two Users35 min
Data storytellingChoose fitting charts and rewrite a finding for a managerCh 7

What you'll learn

  • Audience decision
  • Action headline
  • Chart choice
  • Chart clutter

Practice

  • Push back on a bad data request20 min
CommunicationRewrite an update for two different readers, cutting extra linesCh 7

What you'll learn

  • Lead with the point
  • Match detail to the reader
  • Said versus heard
  • Specific feedback

Practice

  • Gather Report Requirements from a Vague Request15 min
Business understandingTrace how one business number affects money earned or spentCh 7

What you'll learn

  • Business model
  • Key business metrics
  • Metric context
  • Decision before analysis
  • Unit economics
  • Revenue drivers
  • Request to brief
Problem solvingTest each possible cause of a problem instead of guessingCh 9

What you'll learn

  • Problem vs symptom
  • Clean problem splits
  • Root cause
  • Deciding under uncertainty

Practice

  • Separate the Problem from the Symptom10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 9

What you'll learn

  • Early team friction
  • Clear ownership
  • Challenge ideas, not people
  • Lead or follow

Practice

  • Write a Request That Makes It Easy to Say Yes10 min
Adapting to changeTry a new tool and describe how you handled changeCh 9

What you'll learn

  • Change vs your response
  • The messy in-between
  • Not there yet
  • Real change vs a feeling

Your plan

Chapter by chapter.

12 chapters, in this order. Chapter 1 is free.

1~1 wk

See business intelligence analyst work up close

StartFree
21–2 wks

Query, shape and share data

Skills
31–2 wks

Get messy data ready to trust

Skills
41–2 wks

Publish dashboards where every metric agrees

Skills
51–2 wks

Build a sales dashboard with five KPIs

Project
61–2 wks

Organise data so others can use it

Skills
71–2 wks

Explain what your numbers mean for business

Skills
8~1 wk

Talk to two working business intelligence analysts

People
91–2 wks

Solve problems together when plans change

Skills
101–2 wks

Decide how you will get in

Decide
111–2 wks

Answer the questions interviewers ask

Interview
12on your timeline

Send your first applications

Apply

The job

What a Business Intelligence Analyst does

Turns business data into clear reports and dashboards so teams can track results and choose what to do next.

The work

  • Gather reporting needs from teams and turn them into clear metrics and questions
  • Write SQL queries to pull, join, and clean data from different systems
  • Build dashboards and reports that show trends, targets, and key drivers
  • Define and document metric definitions so everyone measures the same way
  • Check data quality and investigate sudden changes or missing data
  • Explain insights in simple language and recommend next steps
  • Automate recurring reports and improve performance of slow dashboards

A typical day

  1. Review dashboard alerts and investigate any unusual metric changes
  2. Meet stakeholders to clarify questions and agree on success metrics
  3. Query data, validate results, and update dashboards or scheduled reports
  4. Share findings in a short write-up and answer follow-up questions
  5. Tidy documentation and log data issues for engineers to fix

Tools

BI tools: Power BI, Tableau, LookerDatabases: SQL, PostgreSQL, SQL ServerSpreadsheets: Excel, Google SheetsData modeling: Star schema, Dimensional modelingVersion control: GitDocumentation: Confluence, Notion

Ways in

There is more than one route.

Ways to study

  • Bachelors degree in business, economics, information systems, or a related field
  • Diploma or certificate in analytics, business intelligence, or data visualization
  • Online courses or bootcamps focused on SQL, dashboards, and data storytelling
  • Workplace training through reporting roles in operations, finance, or marketing

How people get their first job

  • Apply for reporting or analytics internships and build 2 to 3 dashboard examples
  • Start in roles like data analyst, reporting analyst, or operations analyst
  • Earn a practical SQL certificate and a BI tool certificate with a small portfolio
  • Volunteer to improve reporting for a student club or local nonprofit
  • Move from a business role by owning weekly metrics and automating reports

How the work is changing

What AI is doing to this role

How AI is changing this role · one of 6 tasks we track

Build dashboards and visual reports

Sped up a lot

What AI does

Power BI Copilot and Tableau AI generate charts from a prompt.

Still yours

You decide what belongs on screen and what would mislead the reader.

Reviewed September 2026

In the app · Premium

The rest is in the app

  • How AI affects the other 5 tasks
  • Whether this job is growing or shrinking
  • How hard the first job is to get
  • Similar roles that are easier to get into
  • Updated every month, with sources
See it in the app →

How we rate a job →

Already working

Already a Business Intelligence Analyst?

Plan your move to BI Analyst: 13 chapters that end with a strong case for your next review.

Grow in the role →

Other roles in Data & Analytics

Questions

Questions about this plan

How long does it take to become a business intelligence analyst with Welica?

The plan is 12 chapters, 3–5 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.

Do I need a degree?

Not always. Common routes are bachelors degree in business, economics, information systems, or a related field, diploma or certificate in analytics, business intelligence, or data visualization, online courses or bootcamps focused on SQL, dashboards, and data storytelling, or workplace training through reporting roles in operations, finance, or marketing.

What is free?

Chapter 1, See business intelligence analyst work up close, is free for good. Premium unlocks the rest of the plan.

Start the Business Intelligence Analyst plan.

Chapter 1 free. About 15 to 30 minutes a day.

Start on web Continue your session Download for MacMac Get the iPhone appiPhone Get it on Google PlayAndroid