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?

28%

#53 / 103

Waiter

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
Collect payments from customers. Estimate No public source pins this saving. It is an estimate of the method.	6%	28%	+1.7
Check with customers to ensure that they are enjoying their meals, and take action to correct any problems. Estimate No public source pins this saving. It is an estimate of the method.	6%	28%	+1.7
Remove dishes and glasses from tables or counters, and take them to kitchen for cleaning. Estimate No public source pins this saving. It is an estimate of the method.	5%	28%	+1.4
Prepare checks that itemize and total meal costs and sales taxes. Estimate No public source pins this saving. It is an estimate of the method.	5%	28%	+1.4
Clean tables or counters after patrons have finished dining. Estimate No public source pins this saving. It is an estimate of the method.	5%	28%	+1.4
Take orders from patrons for food or beverages. Estimate No public source pins this saving. It is an estimate of the method.	5%	28%	+1.4
Write patrons' food orders on order slips, memorize orders, or enter orders into computers for transmittal to kitchen staff. Estimate No public source pins this saving. It is an estimate of the method.	5%	28%	+1.4
Inform customers of daily specials. Estimate No public source pins this saving. It is an estimate of the method.	5%	28%	+1.4
Other less frequent tasks (weight estimated from frequency). Estimate No public source pins this saving. It is an estimate of the method.	58%	28%	+16.2
Total	100%		28%

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