◆ Data & Analytics

What a business intelligence analyst
really does.

20 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.

20evidenced tasks
262,440in the US (2025)
$120,230median pay / year
8systems it runs on
See the 20 tasks ↓Open in the atlasThe full career map →
km/h RPM
This is what one task looks like here
Create and maintain BI dashboards and reports
Build and update the weekly executive dashboard showing sales, churn, …2 sources agree

The shape of the day

tap a movement to see its tasks

Which one is you, right now?

Pick the moment · no score, no sign-up
Which moment is you right now?
Whichever you pick, the task behind it opens below.

The work, task by task

20 tasks
Hands on the work13
km/h RPM Create and maintain BI dashboards and reports+
Build and update the weekly executive dashboard showing sales, churn, and operational KPIs; automate data refresh, add drill-down by region and product, validate calculations against source extracts, and publish the dashboard to leadership before Friday 10:00.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Present visual data to leadership+
Create a concise deck of the last quarter’s sales and churn trends with clear visuals, two-slide executive summary, three recommended actions, and speaker notes for Anna and Marcus before Wednesday’s leadership review.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Identify opportunities for process optimization+
Run a diagnostics review of the order-to-fulfilment workflow, highlight three bottlenecks with supporting metrics and estimated weekly savings for each, and propose one quick test to run next sprint.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Translate stakeholder requirements into analysis solutions+
Turn Mara and Dev’s interview notes into three analysis options, map required data sources and estimated effort for each, then recommend the option that answers the top three stakeholder KPIs.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Report data findings to management+
Prepare a two-page report of this month’s product usage signals, call out the top five insights with business impacts and one recommended decision for the C-suite meeting on Friday.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Identify and analyze industry or geographic trends with business strategy implications.+
Analyse sales and customer data across North America and Western Europe for the last 24 months, identify three industry or regional trends that change our market position, quantify revenue impact, and recommend two strategic actions for product, pricing, or channel by next Tuesday.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Maintain library of model documents, templates, or other reusable knowledge assets.+
Consolidate our approved BI templates, model specs, and dashboards into a single searchable library, standardise naming and version notes, and publish access rules so analysts can reuse assets starting Monday.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Create projections for company growth+
Build three growth projection scenarios for the next three fiscal years using current bookings, churn, and pipeline conversion rates, show assumptions, upside/downside drivers, and deliver the forecast model and one-page executive summary by Wednesday.
jd
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Watch and assess4
Grow the practice3

What the work runs on

named inside the evidenced tasks
6 tasksApache Sparkperform large-scale data transformations and aggregations before loading into the dashboard
5 tasksAmazon Redshiftserve as the centralized analytical data store enabling fast queries for dashboard refresh
4 tasksApache Hivequery and aggregate cleaned data into analysis-ready tables for reporting
3 tasksAlteryxprofiles workflows, identifies transformation inefficiencies, and estimates impact for optimization
2 tasksApache Kafkaoperates the streaming layer whose lag and throughput need monitoring and alerting for completeness and latency
1 taskApache Hadoopstore and process large raw feeds and enable distributed data cleaning workflows
1 taskAmazon Web Services AWShost and run analytics services and scalable compute needed to process operational metrics and simulations
1 taskAdobe Acrobatproduces a single-shareable, secure one-page summary and annotated notes for stakeholder distribution
Browse every evidenced software task →

The same task, four heights

this page is height one
ExecuteDo today's task, with fewer mistakesyou are here → ImproveMake it easy for the next person to acceptin the atlas → DecideWork out the right move when it is unclearin the atlas → BecomeLearn the pattern so it stops coming backin the atlas →

Can AI actually do this job?

the honest answer

It can

where it genuinely helps
  • Explain the theory behind the work
  • Draft, tidy and structure your writing
  • Rehearse a hard conversation before you have it
  • Build a study plan that fits your gaps

It cannot

where it stops, completely
  • Be in the room where a business intelligence analyst actually works
  • Carry the responsibility when the call is wrong — that weight stays yours
  • Notice what no one wrote down: the hesitation, the thing left unsaid
  • Live with the outcome

What the work pays

two countries, two different measures

United States

this exact occupation · BLS 2025
  • $120,230 a year — the middle: half earn more, half earn less
  • The lowest tenth earn near $67,240; the top tenth near $199,130
  • 262,440 people employed in this occupation

India

the occupation GROUP, not this job · PLFS via ILOSTAT 2025
  • ₹38,298 a month — the median for Professionals, the group this work sits in
  • India publishes pay by broad occupation group, so this covers many jobs besides this one. It is a shape, not a salary.
read this carefullyThese two numbers are not comparable and must not be converted into each other. One is a yearly figure for this job alone; the other is a monthly figure for a whole family of jobs. What travels between them is the pattern, not the amount: experience lifts pay almost everywhere.

Where the evidence lives

open any of it yourself
O*NETThe US Department of Labor's own record of this job5 of these tasks ESCOThe European skills and occupations register6 of these tasks Job descriptionsReal postings, in the wild12 of these tasks US Bureau of Labor StatisticsPay and employment, by occupation2025 figures UK NOS TECHDUBI1Create business insight dashboards and reportsnational standard UK NOS TECHDUBI3Perform basic business intelligence analysisnational standard

Close to this work

12 nearby
Data & AnalyticsFinancial Analyst26 evidenced tasks Data & AnalyticsExperimentation Analyst26 evidenced tasks Data & AnalyticsData Governance Analyst26 evidenced tasks Data & AnalyticsR Analyst26 evidenced tasks Data & AnalyticsCrm Analyst26 evidenced tasks Data & AnalyticsWeb Analyst26 evidenced tasks Data & AnalyticsGrowth Analyst26 evidenced tasks Data & AnalyticsProduct Analyst25 evidenced tasks

Questions people actually ask

Most days mix data work and meetings. Mornings often start with checking dashboards in Redshift or Hive, running data quality checks, and monitoring ETL jobs in AWS or Spark.

Afternoons can be stakeholder time: translating requirements into analyses, presenting visual reports to leadership, and coordinating tests to ensure the intelligence fits the business need.

Expect SQL and cloud warehousing like Amazon Redshift, plus big-data tools — Apache Spark, Hadoop, and Hive — for large datasets. Kafka is used where streaming data matters.

For prep and workflows you might see Alteryx; AWS hosts infrastructure. Adobe Acrobat or similar is used for sharing static reports and model documents.

Use models to suggest trends or forecasts, but always validate results with data quality checks and business rules. Keep human review for decisions that affect customers or revenue.

Document model inputs, assumptions, and tests in the reusable knowledge library so others can reproduce or audit projections and avoid hidden biases.

According to the U.S. Bureau of Labor Statistics (BLS), 2025 data for SOC 15-2051.01 shows about 262,440 employed, median pay $120,230 per year. The lowest tenth is $67,240 and the top tenth is $199,130.

Actual pay varies by location, company size, and your experience with tools like Redshift, Spark, or AWS.

Learn SQL first and practice building dashboards in a BI tool; then study AWS basics and one big-data tool like Spark or Hive. Try small projects: load data into Redshift, run queries, build a report.

Internships or projects that show you can translate stakeholder requirements into analysis and run data quality checks are the quickest path to hiring interviews.

BI Analysts focus on reporting, dashboards, operations improvement, and translating stakeholder needs into actionable metrics — think Redshift queries, Alteryx workflows, and management presentations.

Data Scientists spend more time building predictive models and advanced machine learning; BI work prioritizes clear metrics, process optimization, and making data usable for leaders.

The single most important skill is translating stakeholder requirements into repeatable analysis: understanding what leaders actually need, then delivering dashboards, projections, and documentation that answer that question.

Combine that with solid SQL and basic AWS/Redshift or Spark knowledge so your analyses are correct, reproducible, and ready for business decisions.