Welcome to the repository for my final dissertation, submitted in 2025. This project explores how SQL-based clustering techniques—combined with Principal Component Analysis (PCA)—can be used to uncover regional equity patterns and inform policy decisions.
Download the complete document here:
📥 Dissertation PDF
This study demonstrates how SQL-driven clustering and PCA can reveal hidden structures in regional equity data. The findings offer actionable insights for policymakers seeking to design more equitable resource allocation strategies.
- SQL – for data wrangling and clustering logic
- Power BI – for dynamic visualizations and dashboards
- PCA – to reduce dimensionality and highlight key equity indicators
- DAX – for advanced data modeling within Power BI
- Translate complex technical methods into accessible insights for policy stakeholders
- Showcase scalable, reproducible analysis using SQL and business intelligence tools
Explore the interactive dashboards and visualizations:
🔗 Power BI Workspace