Portfolio

People Analytics & Workforce Insights Platform (live project)

A live people analytics project demonstrating how workforce data can be transformed into clear, decision-ready insight for HR and leadership.
The platform analyses retention, sickness absence, DEI representation, and wellbeing trends using a realistic synthetic dataset.

Tech stack:
Python · MySQL · SQL analytics · PHP · Chart.js

View Live Dashboard

Source Code (GitHub)

Why this project matters commercially

Focused on translating HR data into insight leaders can act on, rather than producing static reports.

• Workforce data reliability – maintaining accurate dashboards across hires, leavers, role changes, and absences, even as data evolves over time
• Ethical, privacy-safe analytics – using realistic synthetic data and aggregation techniques that reflect real HR practice without exposing personal or sensitive information
• Actionable people insight – translating raw HR data into metrics leaders care about (attrition risk, sickness patterns, DEI representation, wellbeing signals)
• Decision support at scale – enabling HR and leadership teams to identify trends early, prioritise interventions, and evaluate the impact of people initiatives

Together, this demonstrates how people analytics can convert complex workforce data into clear, trustworthy insight that supports better organisational decisions — without over-engineering or reliance on heavyweight HR systems.

UK Energy Data Platform (Live Project)

A live data engineering and analytics project ingesting near real-time UK electricity generation data from the BMRS / Elexon API.
The system automates data ingestion, calculates renewables share and estimated carbon intensity, and presents the results via a public dashboard.

Tech stack:
Python · MySQL · Cron · SQL analytics · PHP · Chart.js · API connection
Includes automated monitoring, idempotent ETL, and derived carbon metrics.

View Live Dashboard

Source Code (GitHub)

Why this project matters commercially

This project mirrors the challenges organisations face when turning live operational data into decision-ready insight:

• Real-time data reliability – ensuring dashboards stay accurate even when data arrives late, changes, or needs reprocessing
• Cost-efficient infrastructure – delivering production-grade analytics on modest hosting, not heavyweight platforms
• Actionable insight – converting raw technical data into metrics stakeholders actually care about (renewables share, carbon impact)
• Operational resilience – automated monitoring ensures issues are detected before they affect users or decisions

Together, this demonstrates how complex, high-volume data can be transformed into trustworthy, business-relevant intelligence without over-engineering — a pattern applicable across energy, sustainability reporting, finance, and operations.

Here the details of other client projects we have undertaken across analytics, cleanup, and database work.