Real Work.
Real Results.

The Problem

My client's HR team was manually creating and distributing individual payslip PDFs for over 200 members of staff every single month. This process required opening each employee's record, populating a template, saving as PDF, and distributing - repeated 200+ times. The entire process took days of manual effort every month, was prone to errors, and consumed valuable HR time that could be spent on strategic work.

The Solution

• Designed a master payroll template in Excel with a structured data input sheet for all 200+ employees
• Built a VBA macro that loops through every employee record automatically
• Macro populates each employee's individual payslip template with their specific data
• Automatically saves each completed payslip as a named PDF in a designated folder
• Process is repeatable every month with one button click - no technical knowledge required from the HR team

The Result

What previously took the HR team 2 to 3 days of manual effort every single month now takes under 3 minutes. The template is reusable indefinitely and scales as the company grows. Zero technical knowledge required to run it.

Tools Used

Overview

In collaboration with a skilled team of data analysts and a medical doctor, I led the development of a comprehensive Power BI solution to address critical inefficiencies in the healthcare system. The project delivered 7 integrated dashboards that give hospital administrators real-time insights across all major operational areas—from patient flow to financial health.

Challenge: The hospital lacked a unified view of operations, forcing leaders to make decisions based on outdated, siloed reports. This resulted in resource misallocation, bottlenecks in patient care, and missed revenue opportunities.

Solution: We built a data pipeline using Google Sheets as the data source, Azure DevOps for collaboration, and Power BI for visualization. The suite of 7 dashboards provides a holistic, real-time view of the hospital's performance.

Dashboard Breakdown

🏠 Homepage

High-level snapshot of critical operations: staff efficiency, patient satisfaction, inventory status, and financial health - all in one place for instant executive oversight.

📈 KPI Dashboard

Tracks total revenue, patient visit trends, appointment counts, staff/patient numbers, department distribution, and treatment outcomes across age groups and gender.

👩‍⚕️ Staff Dashboard

Detailed staff view: name, gender, department, certification, shifts, patients treated, and average consultation time. Helps optimize workforce allocation.

🧑‍🤝‍🧑 Patient Dashboard

Comprehensive patient view: demographics, health conditions, appointment schedules, and medication tracking to enable personalized care delivery.

📦 Inventory Dashboard

Tracks total stock items, restock levels, equipment utilization rates, maintenance schedules, and condition indicators (good/needs repair) by department.

📅 Appointment Dashboard

Interactive calendar showing appointment days with linked patient and staff details, enabling efficient scheduling and reduced wait times.

💰 Financial Dashboard

Overall revenue and expense tracking with department-level breakdown, identifying profit-generating units and areas of loss to drive financial strategy.

Key Outcomes

• Real-time decision-making: Hospital leaders can now monitor performance at a glance and take immediate action, rather than waiting for monthly reports.
• Resource optimization: Better staff allocation and inventory management reduced waste and improved patient care.
• Financial clarity: Department-level profit/loss visibility enabled strategic budget reallocation.
• Scalable framework: The dashboard structure is designed to adapt to other hospitals and healthcare settings across different countries.

Tools & Technologies

Background

A fast-growing Fashion and Beauty start-up specializing in makeup products, skincare, and haircare. As the brand scaled its distribution across multiple cities in the United States, its operations became increasingly complex - relying on diverse suppliers, varied transportation modes, and fluctuating demand. The company collected internal supply chain data to identify inefficiencies in inventory, shipping, and production processes.

The Problem

Despite high product demand, the company faced critical operational challenges:

• Frequent stockouts - 46% of products at risk of running out
• Rising shipping and manufacturing costs eating into margins
• Customer dissatisfaction due to delivery delays and defective items
• No clear visibility into supplier performance, route efficiency, or product profitability

Leadership needed to identify bottlenecks from supplier performance to route choices, so they could improve operational efficiency and reduce costs.

Key Business Questions Answered

• Stockout Risk: Which SKUs are at risk based on low availability and high order quantities?
• Supplier Performance: Which suppliers or routes are causing the most delays or high costs?
• Quality Control: Are high defect rates linked to specific suppliers or manufacturing lead times?
• Product Profitability: What is the net value per product considering revenue, shipping, and manufacturing costs?
• Transportation Impact: Is there a correlation between transportation mode (Air/Road/Rail) and shipping cost?

Key Findings & Recommendations

Tools Used

Overview

This dbt project transforms raw event data from the EasyFairs platform (demo dataset) into structured, analytics-ready datasets hosted in Google BigQuery. The goal was to build a reliable and scalable data pipeline that enables comprehensive reporting and key performance metric analysis for stakeholders.

The Problem

The EasyFairs team lacked a unified view of event performance across attendees, exhibitors, and sales. Data was fragmented across multiple sources, making it difficult to answer critical business questions:

• How successful are our events in terms of attendee satisfaction and sales?
• Which regions or event types generate the most profit?
• Are there correlations between exhibitor feedback and attendee satisfaction?

This project solves this by cleaning, unifying, and modeling raw data into actionable insights using dbt.

Data Pipeline Architecture

The project follows a layered architecture using dbt's modular approach:

• Raw Layer (Sources): External datasets sourced directly from BigQuery
• Staging Layer: Basic cleaning and standardization: null handling, casting, renaming fields
• Intermediate Layer: Aggregation and joining of related datasets (e.g., sales, attendees, exhibitor metrics)
• Final/Reporting Layer: Business-friendly models used for dashboards - clean, aggregated, and documentation-ready

Key Metrics & Insights

Detailed Findings

• Top Performer: Business Summit 2024 had the highest revenue (£116,633) and profit (£34,050).
• Profitability Discrepancy: Fashion Show 2023 recorded negative profit (-£1,952) despite decent revenue, highlighting a need to revisit cost structures.
• Satisfaction vs. Profit: Tech Expo events delivered high profits and strong feedback, suggesting high-value engagement.
• Regional Differences: Brussels had the highest average satisfaction scores, while Ghent underperformed.
• Temporal Trends: Revenue peaked in January and September, indicating critical planning periods.
• Duration Impact: Longer events (e.g., Fashion Show 2023 at 42 days) did not correlate with better satisfaction or profit.

Interactive Dashboard

The final Tableau dashboard visualizes these insights with interactive filters, enabling stakeholders to explore performance by event, region, and time period. (View on Tableau Public)

Tools Used

Background

The HR department of a medium-to-large enterprise sought to use data-driven insights to improve employee performance, satisfaction, and training effectiveness. Management suspected that some employees were being enrolled in multiple training programs with minimal improvements in survey metrics or performance ratings. There were also concerns about demographic or job-type disparities in training outcomes and work-life balance.

The Problem

The organization faced several critical workforce challenges:

• Training ROI uncertainty — no clear visibility into whether training investments were driving performance improvement
• Employee engagement gaps — potential disparities in satisfaction and work-life balance across departments and demographics
• Inequitable development — concerns about training access and outcomes varying by gender, race, or age
• Cost optimization needs — some business units spending heavily on training without seeing measurable performance gains

Business Questions Answered

Dashboard Features

• Interactive Filters: Age group (Young/Mid-Age/Old), Gender (Male/Female) for demographic segmentation
• Employee Cost Analysis: Total employee cost breakdown by employment type (Full-Time, Part-Time, Temporary)
• Work-Life Balance: Department-level scores highlighting areas for improvement (Executive Office, Admin Office, Sales, Software Engineering, Production)
• Training Cost Analysis: Internal vs External training cost comparison
• Engagement by Age: Employee engagement distribution across age groups
• Training Outcomes: Program success rates (Completed/Failed/Incomplete/Passed) with tenure correlation
• Department Satisfaction: Employee count by department and satisfaction level (1-5 scale)
• Demographic Breakdown: Racial diversity distribution (Asian, Black, Hispanic, Other, White)
• Business Unit Performance: Training cost and employee rating by business unit (SVG, TNS, PL, WBL, BPC, NEL, CCDR, MSC, EW, PY2)

Key Metrics

Tools Used

Overview

A complete end-to-end customer retention analysis project using a multi-tool approach — Python for data processing, Tableau for visualisation, and Canva and PowerPoint for the executive presentation layer.

Analysis Scope

• Customer cohort analysis — retention rates by acquisition month
• Churn driver identification — which factors most strongly predict customer loss
• RFM segmentation — Recency, Frequency, Monetary value scoring for all customers
• Tableau dashboard with interactive cohort retention heatmap
• Executive presentation with recommendations for targeted retention campaigns

Tools Used

Overview

Solved a real client's trading analysis challenge — taking messy, inconsistent trading data and turning it into a clean, structured analysis with actionable findings delivered in a professional report.

What Was Delivered

• Data cleaning — standardised formats, removed duplicates, fixed date and value inconsistencies
• Performance analysis by trading period, asset class, and position type
• Win/loss ratio calculation and trend analysis over time
• Risk-adjusted return metrics calculated using Excel formulas
• Clean, formatted final report with visual summary and key findings

Tools Used