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?

18%

#94 / 103

Lighting technician

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
Plot and programming Estimate No public source pins this saving. It is an estimate of the method.	25%	35%	+8.8
Rig and focus Estimate No public source pins this saving. It is an estimate of the method.	50%	12%	+6
The show Estimate No public source pins this saving. It is an estimate of the method.	15%	15%	+2.3
Incidents Estimate No public source pins this saving. It is an estimate of the method.	10%	12%	+1.2
Total	100%		18%

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