Automation index
How much of a BI analyst’s job can AI already do?
A dashboard and a query assemble themselves. Knowing which metric lies, and what the business is asking, do not.
This percentage does not predict how many people will lose their jobs.
Task comparison
IS WORK OVER?
BI analyst
34%
AI can already do 34% of this job.
#18 / 623
View rankingBI analyst
Where the time goes
Task weights are our estimates based on O*NET frequency data, not time shares published by O*NET.
The time saving for each task is estimated separately.
| Task | Share | AI | Points |
|---|---|---|---|
Model data, light ETL and dashboards.EstimateNo public source provides a precise figure. This is our estimate. | 24% | 58% | +13.9 |
Write SQL, measures and docs.EstimateNo public source provides a precise figure. This is our estimate. | 18% | 50% | +9 |
Define KPIs with the business and negotiate meaning.EstimateNo public source provides a precise figure. This is our estimate. | 16% | 22% | +3.5 |
Present insights and defend the number.EstimateNo public source provides a precise figure. This is our estimate. | 16% | 18% | +2.9 |
Data quality, alerts and lineage.EstimateNo public source provides a precise figure. This is our estimate. | 14% | 15% | +2.1 |
Prioritise requests and say no.EstimateNo public source provides a precise figure. This is our estimate. | 12% | 20% | +2.4 |
| Total | 100% | 34% |
Modelled workweek: 100% · Public evidence: 0% · Estimate: 100% · Confidence: Low
Skills and activities
- 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?
Admin assistant
31%
#29 / 623
View rankingAdmin assistant
Where the time goes
Task weights are our estimates based on O*NET frequency data, not time shares published by O*NET.
The time saving for each task is estimated separately.
| Task | Share | AI | Points |
|---|---|---|---|
Use computers for various applications, such as database management or word processing.EstimateNo public source provides a precise figure. This is our estimate. | 8% | 48% | +3.8 |
Answer telephones and give information to callers, take messages, or transfer calls to appropriate individuals.EstimateNo public source provides a precise figure. This is our estimate. | 8% | 28% | +2.2 |
Greet visitors or callers and handle their inquiries or direct them to the appropriate persons according to their needs.EstimateNo public source provides a precise figure. This is our estimate. | 7% | 28% | +2 |
Operate office equipment, such as fax machines, copiers, or phone systems and arrange for repairs when equipment malfunctions.EstimateNo public source provides a precise figure. This is our estimate. | 7% | 12% | +0.8 |
Operate electronic mail systems and coordinate the flow of information, internally or with other organizations.EstimateNo public source provides a precise figure. This is our estimate. | 6% | 28% | +1.7 |
Create, maintain, and enter information into databases.EstimateNo public source provides a precise figure. This is our estimate. | 6% | 48% | +2.9 |
Make copies of correspondence or other printed material.EstimateNo public source provides a precise figure. This is our estimate. | 6% | 28% | +1.7 |
Set up and manage paper or electronic filing systems, recording information, updating paperwork, or maintaining documents, such as attendance records, correspondence, or other material.EstimateNo public source provides a precise figure. This is our estimate. | 5% | 55% | +2.8 |
Other less frequent tasks (weight estimated from frequency).EstimateNo public source provides a precise figure. This is our estimate. | 47% | 28% | +13.2 |
| Total | 100% | 31% |
Modelled workweek: 100% · Public evidence: 0% · Estimate: 100% · Confidence: Low
Skills and activities
- design interfaces
- prototypes
- figma
- company policies
- use spreadsheets software
- disseminate internal communications
- maintain internal communication systems
- file documents
- organise business documents
- monitor staff absences
Sources for this job· O*NET 43-6014.00· ESCO/ISCO 4120