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?
BI analyst
34%
AI or a robot can already do 34% of this job.
#18 / 103
View rankingBI analyst
Where the time goes
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.EstimateNo public source pins this saving. It is an estimate of the method. | 24% | 58% | +13.9 |
Write SQL, measures and docs.EstimateNo public source pins this saving. It is an estimate of the method. | 18% | 50% | +9 |
Define KPIs with the business and negotiate meaning.EstimateNo public source pins this saving. It is an estimate of the method. | 16% | 22% | +3.5 |
Present insights and defend the number.EstimateNo public source pins this saving. It is an estimate of the method. | 16% | 18% | +2.9 |
Data quality, alerts and lineage.EstimateNo public source pins this saving. It is an estimate of the method. | 14% | 15% | +2.1 |
Prioritise requests and say no.EstimateNo 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
Skills this job uses
- Model data, light ETL and dashboards
- Write SQL, measures and docs
- Present insights and defend the number
- Data quality, alerts and lineage
- Prioritise requests and say no
- business intelligence
- analista bi
- power bi
- looker
Sources for this job· O*NET 15-2051.00· ESCO/ISCO 2511
IS WORK OVER?
Management consultant
39%
#8 / 103
View rankingManagement consultant
Where the time goes
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 |
|---|---|---|---|
Gather and organize information on problems or procedures.EstimateNo public source pins this saving. It is an estimate of the method. | 23% | 28% | +6.4 |
Develop and implement records management program for filing, protection, and retrieval of records, and assure compliance with program.EstimateNo public source pins this saving. It is an estimate of the method. | 13% | 55% | +7.2 |
Confer with personnel concerned to ensure successful functioning of newly implemented systems or procedures.EstimateNo public source pins this saving. It is an estimate of the method. | 13% | 28% | +3.6 |
Analyze data gathered and develop solutions or alternative methods of proceeding.EstimateNo public source pins this saving. It is an estimate of the method. | 13% | 48% | +6.2 |
Recommend purchase of storage equipment and design area layout to locate equipment in space available.EstimateNo public source pins this saving. It is an estimate of the method. | 11% | 28% | +3.1 |
Design, evaluate, recommend, and approve changes of forms and reports.EstimateNo public source pins this saving. It is an estimate of the method. | 7% | 55% | +3.9 |
Prepare manuals and train workers in use of new forms, reports, procedures or equipment, according to organizational policy.EstimateNo public source pins this saving. It is an estimate of the method. | 5% | 55% | +2.8 |
Review forms and reports and confer with management and users about format, distribution, and purpose, identifying problems and improvements.EstimateNo public source pins this saving. It is an estimate of the method. | 5% | 55% | +2.8 |
Other less frequent tasks (weight estimated from frequency).EstimateNo public source pins this saving. It is an estimate of the method. | 10% | 28% | +2.8 |
| Total | 100% | 39% |
Modelled week 100% · Public evidence 0% · Estimate 100% · Confidence: Low
Skills this job uses
- business analysis
- risk management
- market research
- scientific research methodology
- perform business analysis
- identify undetected organisational needs
- analyse business plans
- interpret financial statements
- conduct quantitative research
- analyse financial performance of a company
Sources for this job· O*NET 13-1111.00· ESCO/ISCO 2421