Texas Workforce Outlook

Overview

Texas continues to out‑pace most U.S. states in both population and job growth. To understand where the Lone Star State’s labour market is heading, I consolidated the Texas Workforce Commission’s Report on Texas Growth Occupations – 2024 (covering actual 2022‑2023 data and 2022‑2032 projections) into a single, analysis‑ready data set and built an interactive Power BI report. This document summarises the data pipeline, visual design choices, and the major insights surfaced on the two report pages.

Data Source & Preparation

• Primary source: Report on Texas Growth Occupations – 2024 (TWC). The PDF contains 331 occupation rows spread across industry-specific tables.
• Extraction: PDF tables were converted to CSV using AI tools.
• Enrichment: Added an “Industry Sector” column so each occupation was tagged with its parent NAICS industry (e.g., Accommodation & Food Services) to enable cross-sector analysis.

• Cleaning: Column names were standardised and numeric columns (e.g., job counts, wages, growth rates) were converted to proper number formats for analysis.
• Validation: Spot‑checked aggregates in Python (pandas / seaborn / matplotlib) to confirm totals matched source of publications.

Visualisation Workflow

The polished visuals were built in Power BI (two pages). To double‑check every graphic, I recreated the core cuts in Python first. Once validated, visuals were themed in Power BI’s corporate blue palette and exported at 1366×768 for easy embedding.

Dashboard Highlights — Page 1

• Explosive demand continues: Professional, Scientific & Technical Services alone is set to add +224K jobs by 2032, with Healthcare close behind.
• Healthcare dominates pay: General Internal Medicine Physicians top the charts at $225K median pay; eight of the ten best-paid occupations sit in healthcare, engineering, or finance.
• Largest absolute growth: Software Developers (+29 662), Registered Nurses (+29 336), and Heavy and Tractor–Trailer Truck Drivers (+28 195) lead the pack.
• Fastest-growing jobs: Wind Turbine Service Technicians top the list with a projected 77.4 % increase, followed by Information Security Analysts (69.0 %), Software Developers (68.7 %), and Nurse Practitioners (66.6 %).

Dashboard Highlights — Page 2

• Relationship between job concentration (LQ) and median wage: There is no strong correlation between how concentrated a job is in Texas compared to the national average and the wages it pays.
• Fastest-growing roles cluster in Tech & Health: Developers, nurses, and truck drivers together account for approximately 85,000 new jobs over the decade.
• Most concentrated jobs in Texas: Most highly concentrated jobs are in the mining, quarrying, and oil & gas extraction sector — with Wellhead Pumpers reaching the highest location quotient (LQ) of 7.10.