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?

30%

#42 / 103

Hotel receptionist

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
Greet, register, and assign rooms to guests of hotels or motels. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Issue room keys and escort instructions to bellhops. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Verify customers' credit, and establish how the customer will pay for the accommodation. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Keep records of room availability and guests' accounts, manually or using computers. Estimate No public source pins this saving. It is an estimate of the method.	7%	55%	+3.9
Make and confirm reservations. Estimate No public source pins this saving. It is an estimate of the method.	7%	28%	+2
Review accounts and charges with guests during the check out process. Estimate No public source pins this saving. It is an estimate of the method.	6%	28%	+1.7
Answer inquiries pertaining to hotel services, guest registration, and travel directions, or make recommendations regarding shopping, dining, or entertainment. Estimate No public source pins this saving. It is an estimate of the method.	6%	28%	+1.7
Compute bills, collect payments, and make change for guests. 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.	47%	28%	+13.2
Total	100%		30%

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