Automation index

Can AI do the work of a BI analyst?

A dashboard and a query assemble themselves. Knowing which metric lies, and what the business is asking, do not.

It also does not predict how many people will lose their jobs.

Task comparison

IS WORK OVER?

34%

AI or a robot can already do 34% of this job.

#18 / 103

BI analyst

Score = Σ (weight × saving). Weight is our estimate from frequency, not a time share published by O*NET. Saving is separate.

Weights are our estimate from O*NET frequency (FT). O*NET does not publish % of the week.

Task	Share	AI	Adds
Model data, light ETL and dashboards. Estimate No public source pins this saving. It is an estimate of the method.	24%	58%	+13.9
Write SQL, measures and docs. Estimate No public source pins this saving. It is an estimate of the method.	18%	50%	+9
Define KPIs with the business and negotiate meaning. Estimate No public source pins this saving. It is an estimate of the method.	16%	22%	+3.5
Present insights and defend the number. Estimate No public source pins this saving. It is an estimate of the method.	16%	18%	+2.9
Data quality, alerts and lineage. Estimate No public source pins this saving. It is an estimate of the method.	14%	15%	+2.1
Prioritise requests and say no. Estimate No public source pins this saving. It is an estimate of the method.	12%	20%	+2.4
Total	100%		34%

Modelled week 100% · Public evidence 0% · Estimate 100% · Confidence: Low

IS WORK OVER?

17%

#96 / 103

Police officer

Score = Σ (weight × saving). Weight is our estimate from frequency, not a time share published by O*NET. Saving is separate.

Weights are our estimate from O*NET frequency (FT). O*NET does not publish % of the week.

Task	Share	AI	Adds
Write reports, complaints and duty logs. Estimate No public source pins this saving. It is an estimate of the method.	18%	35%	+6.3
Search records, cameras and internal databases. Estimate No public source pins this saving. It is an estimate of the method.	14%	30%	+4.2
Patrol, presence and deterrence on the street. Estimate No public source pins this saving. It is an estimate of the method.	18%	8%	+1.4
Arrests, ID checks and use of force. Estimate No public source pins this saving. It is an estimate of the method.	18%	6%	+1.1
Victim support and conflict mediation. Estimate No public source pins this saving. It is an estimate of the method.	16%	10%	+1.6
Testify in court and coordinate with prosecutors. Estimate No public source pins this saving. It is an estimate of the method.	16%	12%	+1.9
Total	100%		17%

Modelled week 100% · Public evidence 0% · Estimate 100% · Confidence: Low