Business Analyst

Business Analyst completes the specific actions outlined on this page and you’ll find 20 real tasks to study. The templates focus on who benefits and what success looks like. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

20evidenced tasks
20ready prompts
8tools of the trade
15-2051.01O*NET-SOC code
262,440hold this job (US, BLS 2025)
$120,230median pay/yr (US)
Open Business Analyst in the interactive atlas →

What it pays

Government survey numbers — not estimates, not ads.

Half of all Data Scientists in the U.S. earn more than $120,230 a year — the middle 80% land between $67,240 and $199,130. About 262,440 people in the U.S. do this work. Figures are for the U.S. occupation group “Data Scientists”. (U.S. Bureau of Labor Statistics survey, published 2025.) In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
$120,230typical pay / year
262,440people in this work
$199,130+top 10% earn
₹4.6 lakha year in India (family avg)
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →

The work, task by task

These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.

Keeping the record1
km/h RPM

Create and maintain BI dashboards and reports

+
Build the weekly executive dashboard: pull last quarter metrics, calculate month-over-month deltas, visualise…
Build the weekly executive dashboard: pull last quarter metrics, calculate month-over-month deltas, visualise bookings and churn by region, schedule the dashboard to refresh every morning and share with Finance and the CEO.
The tools that do the workApache SparkAmazon Redshiftjob descriptionsO*NET
Analysing1

Collect and analyze corporate data

+
Gather the sales, HR and finance datasets for the Q2 data quality review, profile each table for missing…
Gather the sales, HR and finance datasets for the Q2 data quality review, profile each table for missing values and duplicates, produce a short issue log with suggested fixes, and hand it to the data engineering lead by Wednesday.
The tools that do the workAlteryxAmazon Redshiftjob descriptionsO*NET
Negotiating1

Improve company operations

+
Run an operations improvement scan: map the current order-to-delivery steps, time the bottleneck activities…
Run an operations improvement scan: map the current order-to-delivery steps, time the bottleneck activities for three recent orders, propose three low-cost changes to reduce lead time, and present recommendations to Ops and the COO on Monday.
The tools that do the workApache HadoopESCOjob descriptions
The daily work17

Gain knowledge of the industry

+
Read the latest industry analyst reports, regulatory filings, and three competitor annual summaries, extract…
Read the latest industry analyst reports, regulatory filings, and three competitor annual summaries, extract market size, growth drivers, and risk themes, then produce a one-page briefing for the leadership team by Wednesday.
The tools that do the workAmazon RedshiftESCO

Contrast industry processes with company operations

+
Map our end-to-end order-to-cash steps against the industry standard process flow, highlight three…
Map our end-to-end order-to-cash steps against the industry standard process flow, highlight three operational gaps with root causes and estimated monthly cost impact, and prepare recommendations for the operations director by next Tuesday.
The tools that do the workApache SparkESCO

Focus analysis on sales

+
Analyze the last twelve months of closed deals and pipeline activity, identify the top three drivers of win…
Analyze the last twelve months of closed deals and pipeline activity, identify the top three drivers of win rate and the weakest stage conversion, and deliver a prioritized list of sales actions for the head of sales by Friday morning.
The tools that do the workAlteryxESCO

Facilitate communication

+
Collect current project updates from product, sales, and support, reconcile conflicting status points, draft…
Collect current project updates from product, sales, and support, reconcile conflicting status points, draft a single weekly update with clear owner actions and two escalation triggers, and send it to the stakeholder group before the Thursday stand-up.
The tools that do the workAJAXESCO

Improve revenue

+
Review pricing, customer segments, and churn patterns for the past year, model three revenue uplift scenarios…
Review pricing, customer segments, and churn patterns for the past year, model three revenue uplift scenarios with required investments and expected payback, and present the preferred plan plus risks to the CFO next Monday.
The tools that do the workApache HiveESCO

Present visual data to leadership

+
Create a concise slide deck with executive summary, three visual dashboards showing monthly KPIs by product…
Create a concise slide deck with executive summary, three visual dashboards showing monthly KPIs by product line, a one-slide risk/insight page, and speaker notes for the Thursday leadership meeting — check numbers against the source tables first.
The tools that do the workAmazon Redshiftjob descriptions

Identify opportunities for process optimization

+
Map the end-to-end purchasing workflow, highlight five bottlenecks using process metrics and stakeholder pain…
Map the end-to-end purchasing workflow, highlight five bottlenecks using process metrics and stakeholder pain points, and produce a prioritized list of improvement actions with estimated effort and savings for Monday’s ops review.
The tools that do the workApache Kafkajob descriptions

Develop data models and databases

+
Design a normalized logical data model for sales and inventory covering customers, orders, SKUs and daily…
Design a normalized logical data model for sales and inventory covering customers, orders, SKUs and daily stock levels, include DDL scripts and a migration plan to support the quarterly reporting load.
The tools that do the workApache Hivejob descriptions

Translate stakeholder requirements into analysis solutions

+
Translate the product team’s needs into a requirements brief with acceptance criteria, list the data sources…
Translate the product team’s needs into a requirements brief with acceptance criteria, list the data sources and transformations required, and propose two analytical solutions with pros, cons and delivery estimates for the stakeholders’ review on Friday.
The tools that do the workAlteryxjob descriptions

Report data findings to management

+
Draft a one-page report summarising this month’s analysis: main findings, three supporting charts,…
Draft a one-page report summarising this month’s analysis: main findings, three supporting charts, recommended actions and impact estimates, and circulate to the management team by Wednesday after validating the source queries.
The tools that do the workAmazon Redshiftjob descriptions

Monitor data collection processes

+
Set up monitoring of the daily ingest pipeline, document data quality checks for missing or delayed feeds,…
Set up monitoring of the daily ingest pipeline, document data quality checks for missing or delayed feeds, and send an alerting playbook and first-week anomalies report to the data ops lead by next Tuesday.
The tools that do the workApache Kafkajob descriptions

Identify and analyze industry or geographic trends with business strategy implications.

+
Scan last five years of market reports and our regional sales data, identify emerging industry or geographic…
Scan last five years of market reports and our regional sales data, identify emerging industry or geographic trends that change our competitive position, quantify likely revenue impact by quarter, and recommend three strategic responses with risk tradeoffs by next Wednesday.
The tools that do the workApache SparkO*NET

Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.

+
Design and run test scenarios that verify the intelligence products meet the stakeholder requirements…
Design and run test scenarios that verify the intelligence products meet the stakeholder requirements checklist, record pass/fail results, log any gaps with reproduction steps, and produce a concise remediation plan for the product owner by Friday.
The tools that do the workApache HiveO*NET

Maintain library of model documents, templates, or other reusable knowledge assets.

+
Audit the repository of model documents and templates, remove duplicates, standardize naming and metadata,…
Audit the repository of model documents and templates, remove duplicates, standardize naming and metadata, version-control the approved set, and publish an indexed library with usage notes for the delivery teams by end of month.
The tools that do the workAmazon DynamoDBO*NET

Create projections for company growth

+
Build growth projections using the past three years of sales, pipeline conversion rates, and planned product…
Build growth projections using the past three years of sales, pipeline conversion rates, and planned product launches, produce best/likely/worst-case revenue curves for the next three years, and highlight assumptions and sensitivity to price changes.
The tools that do the workAmazon Redshiftjob descriptions

Conduct data quality checks

+
Run the scheduled data quality checks across customer and transaction feeds, flag records failing…
Run the scheduled data quality checks across customer and transaction feeds, flag records failing completeness or validity rules, estimate total downstream impact, and produce a prioritized remediation list for the data engineering lead by Tuesday.
The tools that do the workAlteryxjob descriptions

Manage analytics and metrics

+
Define the key metrics for business health, implement dashboards that update weekly, set alerts for KPI…
Define the key metrics for business health, implement dashboards that update weekly, set alerts for KPI threshold breaches, and deliver an executive one-page metrics brief with interpretation and recommended actions each Monday.
The tools that do the workApache Kafkajob descriptions

Says who?

These are the pages we read to build this. Open any of them and check us.

Related careers

Same family of work — each with its own tasks and prompts.

The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.

The rest of the map

Same library, five ways in.

Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses