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?
Video producer
34%
#22 / 623
View rankingVideo producer
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 |
|---|---|---|---|
Write and edit news stories from information collected by reporters and other sources.EstimateNo public source provides a precise figure. This is our estimate. | 9% | 55% | +5 |
Research production topics using the internet, video archives, and other informational sources.EstimateNo public source provides a precise figure. This is our estimate. | 9% | 48% | +4.3 |
Plan details such as framing, composition, camera movement, sound, and actor movement for each shot or scene.EstimateNo public source provides a precise figure. This is our estimate. | 8% | 28% | +2.2 |
Communicate to actors the approach, characterization, and movement needed for each scene in such a way that rehearsals and takes are minimized.EstimateNo public source provides a precise figure. This is our estimate. | 7% | 28% | +2 |
Compose and edit scripts or provide screenwriters with story outlines from which scripts can be written.EstimateNo public source provides a precise figure. This is our estimate. | 6% | 28% | +1.7 |
Cut and edit film or tape to integrate component parts into desired sequences.EstimateNo public source provides a precise figure. This is our estimate. | 6% | 28% | +1.7 |
Perform management activities, such as budgeting, scheduling, planning, and marketing.EstimateNo public source provides a precise figure. This is our estimate. | 6% | 28% | +1.7 |
Direct live broadcasts, films and recordings, or non-broadcast programming for public entertainment or education.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. | 44% | 28% | +12.3 |
| Total | 100% | 34% |
Modelled workweek: 100% · Public evidence: 0% · Estimate: 100% · Confidence: Low
Skills and activities
- project management principles
- film production process
- accounting techniques
- audiovisual products
- copyright legislation
- work with motion picture editing team
- manage budgets
- consult with production director
- select scripts
- liaise with financiers
Sources for this job· O*NET 27-2012.00· ESCO/ISCO 2654