PROJECTS
data-analysis
UK Retail Sales Performance Analysis
SQL-driven retail analytics
- Examined 50,000+ retail transactions using advanced SQL techniques, identifying top 20% products generating 65% of revenue
- Enhanced dataset accuracy from 87% to 99.5% through data cleansing using CTEs and window functions
- Optimized 8 complex queries through indexing strategies, decreasing execution time by 87% (45s to 6s)
- Uncovered seasonal purchasing patterns that informed inventory planning, reducing stock-outs by 22%
SQLQuery OptimizationData AnalysisCTEsWindow Functions
data-analysis
UK Housing Market Analysis (ONS Dataset)
Time-series analysis of UK house prices
- Processed 18 years of UK House Price Index (2M+ records) from ONS
- Built time-series SQL queries identified top growth months and largest price drops to highlight extreme market movements
- Performed volatility assessment using standard deviation to detect unstable market periods
- Compared pre and post-COVID housing market behaviour
SQLTime-Series AnalysisONS Government Data
visualization
Employment Trends Dashboard (ONS Dataset)
Interactive Tableau dashboards for UK employment
- Standardized 10 years of UK employment statistics covering 8 industry sectors from ONS official database
- Created 5 interactive Tableau dashboards identifying 18-month recovery period post-2020 crisis
- Examined regional disparities, revealing 12% variance between highest and lowest performing regions
TableauExcelStatistical AnalysisONS Government Data
visualization
UK Immigration & Migration Analysis (ONS Dataset)
Migration trends analysis with Power BI
- Analysed UK immigration, emigration, and net migration trends using ONS official multi-year datasets
- Performed demographic and reason-based segmentation (nationality, age group, time period)
- Created pivot-table analysis and dashboards to identify key migration drivers and patterns
Power BIExcelStatistical AnalysisONS Government Data
