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%

#52 / 103

Barista

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
Prepare or serve hot or cold beverages, such as coffee, espresso drinks, blended coffees, or teas. Estimate No public source pins this saving. It is an estimate of the method.	9%	28%	+2.5
Receive and process customer payments. Estimate No public source pins this saving. It is an estimate of the method.	8%	28%	+2.2
Take customer orders and convey them to other employees for preparation. Estimate No public source pins this saving. It is an estimate of the method.	8%	28%	+2.2
Describe menu items to customers, or suggest products that might appeal to them. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Serve prepared foods, such as muffins, biscotti, or bagels. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Prepare or serve menu items, such as sandwiches or salads. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Clean or sanitize work areas, utensils, or equipment. Estimate No public source pins this saving. It is an estimate of the method.	6%	28%	+1.7
Clean service or seating areas. Estimate No public source pins this saving. It is an estimate of the method.	6%	28%	+1.7
Other less frequent tasks (weight estimated from frequency). Estimate No public source pins this saving. It is an estimate of the method.	42%	28%	+11.8
Total	100%		28%

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