SibaSnlv/sa-labour-market-dashboard

South African Labour Market Analytics Dashboard: Power BI, Python pipeline, Stats SA QLFS 2008–2026 # South African Labour Market Analytics Dashboard A six-page interactive Power BI dashboard built on real Stats SA Quarterly Labour Force Survey data (2008–2026 Q1), combining a Python data cleaning pipeline, DAX time intelligence measures, and linear regression projections to analyse South African unemployment across provinces, sectors, youth demographics, and a 2-year forward outlook. > **To interact with the dashboard:** Download > `SA_Labour_Market_Analytics_Dashboard.pbix` and open it in > Power BI Desktop > (free). No account required. --- ## Dashboard Pages | Page | What it shows | |---|---| | National Overview | 4 KPI cards, unemployment trend line, industry treemap, province slicer | | Provincial Analysis | Filled map, province ranking bar chart, GDP vs unemployment scatter plot, time series | | Youth Focus | Youth vs overall trend, gender breakdown line chart, NEET by province | | Sector Analysis | Sector employment trends, YoY growth ranking, province × sector matrix | | Projections | 8-quarter linear regression forecast per province with confidence bands, trend summary table | | Key Insights | 5 written analytical findings drawn directly from the data | --- ## Screenshots ### National Overview ### Provincial Analysis ### Youth Focus ### Sector Analysis ### Projections ### Key Insights --- ## Key Findings - South Africa's unemployment rate averaged **28.3%** across all provinces from 2008 to 2026 Q1, masking a 16 percent gap between Western Cape (consistently below 22%) and Eastern Cape and Limpopo (consistently above 38%). - Youth unemployment (15-34) averaged **40.3% nationally**, approximately 12 percent above the overall rate, with no meaningful closing of the gap since 2012, indicating structural barriers rather than cyclical economic factors. - Women face consistently higher unemployment than men (3-4pp gap nationally), with the gap widening during economic contractions (2009, 2020) and narrowing during recoveries. - Mining emp …