Global Automation Potential by Sector

Visualization Overview

This interactive heatmap from McKinsey Global Institute (MGI) analyzes the technical potential for workplace automation across sectors and countries, using 2016 data on over 800 US occupations. Hosted on Tableau Public, it employs color-coded tiles—blue for high automation potential (e.g., predictable physical tasks in manufacturing at 60%) and red for low (e.g., social/emotional skills in healthcare at 36%)—to reveal where machines could replace human activities with currently demonstrated technologies.

The dashboard breaks down global workforce exposure, with bar charts comparing countries like China (highest total) and Japan, and filters for sectors, focus metrics, and employee chart types. It highlights that up to 45% of global work activities are automatable, equating to $15 trillion in wages, though full job displacement remains limited.

Data Sources and Methodology

McKinsey drew from occupational databases like O*NET, assessing activities’ susceptibility based on five factors: technical feasibility, deployment costs, labor market dynamics, benefits (e.g., productivity gains), and synergies with human labor. Sectors like manufacturing and transport score high due to repetitive tasks, while personal services lag due to needs for empathy and unpredictability.

The Tableau Public version builds on MGI’s 2017 report “A Future That Works,” using anonymized workforce data from 46 countries covering 80% of global employment. Variations arise from economic structures—high-wage nations prioritize costly automation sooner.

Creation in Tableau

Likely built with Tableau’s native heatmap features: dimensions (sectors, countries) on rows/columns, measure (automation %) on color via diverging palette (blue-red). Treemaps or packed bubbles visualize total exposure; parameters enable toggles for “employee chart type” vs. “variation by sector.”​

Advanced elements like radial or square heatmaps (common in Tableau tutorials) use calculated fields for X/Y coordinates or INDEX() for sequencing. Joins handle multi-table data (e.g., sectors + countries), with tooltips for drill-down. McKinsey’s public Tableau profile hosted the original interactive viz, allowing users to filter and export insights.​​

Design Analysis

Strengths include intuitive color gradients for quick pattern spotting—e.g., manufacturing’s blue dominance signals 60-90% potential in welding— and responsive filters for interactivity. Clean layout with focus/regional toggles aids exploration, while gray vertical lines denote averages for context.​

Limitations: Static 2016 snapshot ignores post-GenAI advances (e.g., NLP boosting finance from 43% to 66%); lacks occupation-level granularity in views. Tableau’s pixel-perfect tiles excel for dense data but risk overwhelming non-experts without guided navigation.

Key Insights

Automation targets data processing, predictable physical work (high in manufacturing/retail), sparing creative/social tasks. Country leaders like China face massive scale (1.1B workers affected long-term), but benefits include 0.5-0.9% annual US productivity gains by 2030 via GenAI.

Physical/manual skills decline; demand surges for tech (55% growth to 17% of hours) and social/emotional skills.

Conclusions

This viz underscores automation’s dual edge: displacing routine jobs while boosting productivity and GDP, provided reskilling addresses skill shifts. Leaders must map internal potentials, invest in human-AI collaboration, and policymakers foster transitions to avert inequality—echoing MGI’s call for proactive workforce evolution amid accelerating AI.