Home Education Experience Skills Projects Contact
Home/Projects

Selected Work

Projects & Case Studies

Analytics, strategy, and reporting projects with measurable business impact.

Featured Project
Dashboards · Finance

Revenue Performance Dashboard

Designed and built a Power BI dashboard for a SaaS company to monitor recurring revenue, churn, expansion revenue, and regional growth, replacing a time-consuming manual reporting process.

  • Reduced reporting time from 4 hours to 20 minutes per cycle.
  • Improved visibility of churn and expansion revenue trends.
  • Used in monthly leadership meetings as the primary performance review tool.
The Challenge
Leadership reporting was spread across multiple spreadsheets and updated manually each month, creating inconsistencies and delays.
The Approach
Built a centralised Power BI dashboard connected to cleaned SQL datasets, with automated monthly revenue movement, customer segment analysis, and KPI views.
Tools Used
Power BISQLDAXExcel
Forecasting · Strategy

Retail Demand Forecasting Model

Built a Python forecasting model to improve SKU-level demand planning and reduce stock inefficiencies for a retail client.

Challenge

The team relied on static averages that did not account for seasonality or promotional periods, leading to stock errors.

Impact
Improved forecast accuracy by 22% across key product categories.
Identified high-risk stockout categories ahead of peak periods.
Supported better inventory planning and reduced overstock waste.
PythonpandasstatsmodelsExcel
Automation · Finance

Automated Finance Reporting Pack

Created an automated monthly finance reporting workflow using Excel, VBA, and Power Query to eliminate manual formatting.

Challenge

Finance analysts were spending 6+ hours each month formatting reports manually, with inconsistent outputs and frequent errors.

Impact
Saved 6 hours per month through full automation of data imports and formatting.
Reduced manual formatting errors to near zero.
Improved reporting consistency across the finance team.
ExcelVBAPower Query
Strategy · Finance

Pricing Scenario Model

Developed a flexible scenario model to evaluate pricing changes and their impact on revenue, margin, and customer retention.

Challenge

The commercial team needed to compare different pricing options but had no structured model for assessing risk and upside.

Impact
Supported pricing strategy discussions at senior leadership level.
Enabled clear comparison of revenue and margin trade-offs across scenarios.
Improved decision confidence and reduced time spent debating assumptions.
ExcelFinancial modellingScenario analysis
Strategy · Analytics

Customer Segmentation Analysis

Analysed customer behaviour data to identify high-value customer groups and recommend targeted engagement strategies.

Challenge

Marketing activity was broad and not clearly aligned to customer value, resulting in inefficient spend across segments.

Impact
Identified three priority customer segments with clear value characteristics.
Supported more targeted campaign planning and budget allocation.
Improved understanding of customer retention and churn behaviour.
SQLExcelPower BI
Dashboards · Strategy

Executive KPI Scorecard

Designed a one-page executive scorecard to summarise revenue, margin, customer, and operational performance in a format suitable for senior leadership review.

Challenge

Senior leaders needed a cleaner way to review performance without navigating long slide decks or raw data exports.

Impact
Improved executive reporting clarity and reduced review meeting time.
Reduced reliance on long slide decks in monthly leadership reviews.
Made performance discussions more focused and action-oriented.
Power BIPowerPointExcel