Employee Engagement Survey Dashboard
A Power BI dashboard built on Pierce County, Washington's employee engagement survey — 14,000+ responses cleaned, modelled and shaped into role- and department-level analysis with bookmark-driven navigation.
Case studies
Projects
Pipelines, dashboards and the reasoning behind them. Each write-up covers the business problem, the architecture, and the scenarios I used to test whether the design would survive a real production week.
Showing all 5 case studies
The Global Listing Intelligence Initiative
An end-to-end Microsoft Fabric solution for a global luxury real-estate company, automating property listing ingestion from London, Dubai and New York into a governed Silver layer with wildcard matching, upsert logic and automated archival.
Logistics Data Modernization
A Microsoft Fabric case study in watermark-based incremental ingestion of high-volume JSON shipment logs — replacing manual file selection with auditable state management and Delta Lake ACID writes.
Workforce Intelligence: Azure SQL to Lakehouse
A Bronze-to-Silver Microsoft Fabric pipeline that migrates HR workforce data from Azure SQL into a governed analytics layer using PySpark — with quarantine logic, deduplication, enrichment, and window-function analytics for HR reporting.
Financial Data Transformation
A PySpark and Delta Lake pipeline processing 45 million accounts-receivable records — broadcast join optimisation, schema enforcement, Time Travel recovery, and Z-ORDER compaction, each verified against Spark's physical plan.