Selected Work

Dashboards that turned messy data into decisions.

Six projects built for companies in logistics, transport, e-commerce and sales — each one replacing manual spreadsheets with automated, trusted BI.

From Google Sheets to Power BI

A chaotic three-sheet sales pipeline rebuilt as a clean, automated funnel dashboard tracking revenue, conversion and rep performance in real time — without changing how the team worked.

Power BIData ModelingSales
Read the case study →

The Hidden €131K Loss

A European logistics company was quietly losing six figures a year. Route-level analysis in Power BI surfaced the profit leaks and turned scattered operational data into a clear optimisation plan.

Power BILogisticsProfitability
Read the case study →

Operational Report for Transport

Invoices on a desktop, notes in WhatsApp, toll receipts in a drawer. One operational report that pulls the everyday chaos of a transport business into a single source of truth.

ReportingTransportAutomation
Read the case study →

E-Commerce Dashboard

End-to-end analysis of online transactional data: Python for exploration, SQL for investigation, and a dashboard that makes customer and product behaviour readable at a glance.

PythonSQLE-Commerce
Read the case study →
VAR _activePartners =
    FILTER( ALL( 'Partner'[ID] ),
        [Status] = "Active"
        || [Dropped] >= _nextMonth )

RETURN COUNTROWS( DISTINCT(
    UNION(
      INTERSECT( _active, _txn ),
      INTERSECT( _active, _rec ) ) ) )

One Metric, Two Revenue Models

One-off transactions and multi-month installment plans resolved into a single monthly count of revenue-generating partners — using set logic rather than arithmetic, so nobody in both streams is counted twice.

DAXData ModellingPower BI
Read the technical write-up →

Revenue Analytics

A revenue performance dashboard breaking down growth, retention and margin. The write-up for this one is still being put together.

Power BIRevenue
Case study coming soon

Want something like this for your data?

I build automated BI systems that replace manual reporting. Tell me what you’re working with.

Text me on WhatsApp