Skip to content

Projects

Case studies and project library

Six featured case studies, each with an interactive demonstration built on synthetic data, plus shorter entries from the wider project library. Client and employer identities are withheld throughout.

12 projects

  • Case studyHuman-resources reporting function (organisation anonymised)

    HR Reporting Process Transformation

    Average reporting-cycle time fell from 1,069.6 to 117.4 minutes across ten measured cycles each — an 89.02% reduction.

    • Process mapping
    • Root-cause analysis
    • Requirements investigation
    • Reporting automation
    Read the case study
  • Case studyRetail and distribution (client anonymised)

    Retail Revenue & Customer Concentration

    About 95% of revenue came from about 5% of customers in the examined dataset, and that segment was concentrated in a single region.

    • Commercial analytics
    • Customer segmentation
    • Pareto analysis
    • Executive reporting
    Read the case study
  • Case studyMulti-store retail (client anonymised)

    Multi-Store Cash-Up Reconciliation

    One reconciliation reporting solution covering 120+ retail stores, across the current month and the three preceding months.

    • Financial reconciliation
    • Exception reporting
    • Data quality
    • Power BI modelling
    Read the case study
  • Case studyCorporate finance — supplier payments processed for multiple clients (client anonymised)

    Consolidated Supplier Onboarding Report

    One consolidated report across 8+ finance systems that flags missing or incorrect supplier information per system and client, enforces independent banking verification, and cut measured query time by about 77%.

    • Supplier data quality
    • Fraud controls
    • Segregation of duties
    • Query optimisation
    Read the case study
  • Case studyFinance shared services (organisation anonymised)

    Finance Helpdesk AI Automation

    Deployed an AI agent that identifies, classifies and assigns targeted ticket types, records an internal audit note on every assignment, and is verified by 88 offline unit tests in 15 test classes.

    • Applied AI
    • Workflow automation
    • API integration
    • Automated testing
    Read the case study
  • Case studyBeverage manufacturing — PET preform production (organisation anonymised)

    Manufacturing Loss Investigation

    Identified approximately US$10,000 in PET preform material losses and traced them to their root causes.

    • Root-cause analysis
    • Industrial Engineering
    • Loss quantification
    • Operational analysis
    Read the case study
  • Project libraryRetail (client anonymised)

    Agent performance model

    Performance model that reconciles multiple agent ID systems and handles agent reassignments without double-counting.

    • Workforce and resource analysis
    • Power BI
    • Power Query
    • DAX
  • Project libraryRetail (client anonymised)

    Dynamic period analysis

    Comparison report spanning two past fiscal years and the current year, with rolling fiscal windows maintained in the date model.

    • Financial reporting
    • Power BI
    • DAX
    • Power Query
  • Project libraryRetail (client anonymised)

    Sales performance model

    Power BI model tracking sales against monthly targets across multiple products and stores, with year-to-date measures on a non-calendar fiscal year.

    • Retail performance reporting
    • Power BI
    • DAX
    • Power Query
  • Project libraryRetail (client anonymised)

    Sales versus attendance reporting

    Report relating attendance to sales performance so staffing and performance can be read together.

    • Attendance analytics
    • Power BI
    • DAX
  • Project libraryProfessional services (anonymised)

    Data-source diagnosis after server migration

    Traced a reporting data-source failure after a server migration to the database view layer rather than the report itself.

    • Systems and access management
    • SQL
    • Power BI
  • Project libraryRetail (client anonymised)

    Shop-level performance drill-down

    Hierarchical drill-down from regional manager to store to agent, so performance conversations can start at the right level.

    • Retail performance reporting
    • Power BI
    • DAX