advisory

Power BI for logistics, 3PL and e-commerce operations

The carrier is costing you more than the invoice shows.

K.I.E Advisory is an independent Power BI consultancy for logistics operators, 3PLs, freight forwarders, and DTC brands sitting on messy operational data. I spent three years inside European supply chain (PostNL, DB Schenker, Denso, Royal FloraHolland) before going full-time on analytics. I build the dashboards operations and finance teams actually use. Fixed-fee builds, or €420/day.

Request a Margin-Leak Assessment See what we do
  • Logistics analytics · carrier benchmarking, cost-to-serve, return-rate, delivery performance
  • E-commerce BI · SKU, channel, contribution margin, ROAS attribution
  • €420/day for build work · Fixed-fee audit from €1,500 · also on Malt

You already have the data. You do not have the answer.

You can pull a WMS report, a carrier invoice, a Shopify export, and a stock movement file. What you cannot do is sit them on top of each other and ask which lane is losing money after returns, which carrier is silently dragging your return rate up, or which SKU is propping up the entire portfolio. That is the question I answer.

Who I work with

Two focus areas, one lens: unit economics

Operators moving physical goods across Europe, and consumer brands selling direct online. Most clients start with a fixed-fee audit or book a few days of Power BI build time, and expand from there.

Logistics, 3PL & Fulfilment

3PLs, freight forwarders, warehouse operators, and cross-border fulfilment networks. The weekly ops review runs on four spreadsheets and nobody trusts the margin number. Carrier invoices and WMS exports do not reconcile.

What's included

  • Cost-to-serve per lane, with the lanes losing money named
  • Carrier benchmarking on return rate, damage, and delivery days
  • Country and region performance decomposition
  • Fulfilment KPI dashboards for weekly ops reviews
  • Carrier reallocation and network optimisation plans

See the Logistics case study

DTC E-commerce & Multi-channel

DTC brands and multi-channel sellers doing €500K–€10M annually. The headline P&L looks healthy. Nobody can tell you which SKUs are actually paying the bills after returns and ad spend.

What's included

  • SKU kill, keep, or reprice list ranked by contribution margin
  • SKU-level profitability and contribution margin analysis
  • ROAS attribution across channels and campaigns
  • Return-rate and refund erosion analysis by product and cohort
  • Scenario simulators for pricing and ad reallocation

See the Beauty DTC case study

Not sure which fits? Request a Margin-Leak Assessment and describe your data. We will tell you what an audit would surface.

Selected work

Case studies

Two reference architectures, one per vertical. The financial modelling matches live multi-carrier logistics and mid-market DTC configurations. Client numbers stay with the client, so I built these to show you what a real audit deliverable looks like page by page.

Logistics and fulfilment optimisation dashboard, executive summary page

Logistics · 3PL · fulfilment

Logistics and Fulfilment Optimisation

Six-page audit on a pan-European fulfilment network modelled at €204.7K across 1,000 orders, 20 countries, and 5 carriers (UPS, GLS, FedEx, DHL, PostNL). The headline P&L showed a 45.54% margin. One in four parcels was coming back. Country return rates ran from 15.52% in Sweden to 38.89% in Romania inside a 0.19-day delivery-time band, so returns were not about speed. The audit named the carrier (GLS, 31.91%), named the country (Romania → UPS reallocation), and named the suppliers (Philips, Logitech) driving the leak.

  • Four of the six highest-margin SKUs also sat above the portfolio return rate
  • Top three SKUs delivered 42% of sales and 42% of gross profit
  • Carrier-by-region grid (DHL 31.88% returns in Southern Europe vs 20.83% in Northern)
  • Dynamic DAX conditional formatting on country and product tables

Read the breakdown Download the PDF

Beauty DTC profit audit dashboard, portfolio overview page

DTC e-commerce

Beauty DTC Profit Audit

Eight-page audit on a reference beauty brand at €412K annual revenue across 10 SKUs. Found €40,820 sitting in the wrong SKUs, flagged two products losing money on every order, and built a live scenario simulator showing a +44% contribution uplift without launching anything new.

  • Disconnected dimension tables for shared-measure routing
  • VAR-driven contribution margin to avoid circular dependency
  • Three live what-if parameters driving simulated contribution

Read the breakdown Download the PDF

How it works

Four steps from raw CSVs to a Power BI model you can rerun.

  1. 01

    Margin-Leak Assessment

    A short working call. Bring one report you actually use to make decisions. We tell you what is missing from it and what an audit would surface. It is how we figure out together whether there is a fit.

  2. 02

    You send the data

    Order data, product cost data, carrier or shipping data, and any spend data you track. CSV or Excel is enough. If it lives in Shopify, Xero, or a WMS export, it is fine. I clean it.

  3. 03

    I build the audit

    Five to ten working days. You get a six-page Power BI report with a scenario simulator, drill-through architecture, and a written diagnosis page. The case studies above show the exact depth of the deliverable.

  4. 04

    You keep the file

    Delivered as a .pbix file. You can open it in the free Power BI Desktop on Windows. You only need a paid licence if you want to share it online with your team.

Pricing

Pricing

Prices are listed publicly and quoted up front. Three ways to engage: by the day for build work and overflow, by fixed fee for a diagnostic audit, or on a lightweight monthly retainer once a dashboard is live.

Daily Rate · Power BI Build

€420/day

Minimum two-day block

  • Dashboard builds, model refactors, DAX fire-fighting
  • Fractional / overflow capacity for BI consultancies and Microsoft Partners
  • White-label subcontracting for agencies serving logistics or DTC clients
  • Row-level security, scheduled refresh, Service deployment
  • EU timezone, Bratislava · remote across Europe
  • Also bookable via Malt
Discuss a build

Fixed-Fee Profit Audit

€1,500

One-time, scoped diagnostic

  • Six-page Power BI report on your data
  • Carrier, cost-to-serve, SKU and segment profitability
  • Scenario simulator with live what-if parameters
  • Drill-through architecture down to row level
  • Four written recommendations tied to specific measures
  • Delivered as a .pbix file you keep, no licence needed to read
Request a Margin-Leak Assessment

Insight Retainer

€400/mo

After a dashboard is live

  • Monthly data refresh
  • Scenario re-run on updated numbers
  • One dashboard adjustment per month
  • Written PDF brief on what changed
Ask about this tier

Multi-day builds, embedded analytics, or larger logistics / e-commerce data projects are scoped as fixed-fee engagements or as day-rate blocks. Ask for a quote.

About

Operator background. Advanced Power BI.

Kenechukwu (Donald) Ifeanyi-Ezeaka
Kenechukwu (Donald) Ifeanyi-Ezeaka. Principal, Bratislava.

I am Kenechukwu (Donald) Ifeanyi-Ezeaka. K.I.E Advisory is the consultancy I run from Bratislava. Before I built dashboards full-time, I spent three years inside European supply chain and logistics operations at PostNL, DB Schenker, Denso, and Royal FloraHolland. Inbound and outbound freight, inventory records, sortation, carrier account coordination, scan-vs-parcel reconciliation on time-critical shifts. The method comes from that work. I have seen where WMS data lies to you, and every model I ship is built to close the gap between the report leadership reads and what is actually happening on the floor.

The Power BI build goes deeper than most agency output. Disconnected dimension tables for shared-measure routing. Layered measure architecture from unit level to portfolio level via SUMX. VAR-driven contribution margin. Live what-if parameters for scenario simulation. Drill-through pages. Tooltip canvas pages registered as tooltips. If those terms mean something to you, you already know the level. If not, the case studies show what comes out the other side.

FAQ

The questions every prospect asks

Do I need a Power BI licence to use the audit?

No. The audit is delivered as a .pbix file. You can open it in the free Power BI Desktop application on any Windows machine. A paid licence is only required if you want to publish the dashboard online for team access.

How long does an audit take?

Five to ten working days from the moment your data lands in my inbox. Most of that time is data cleaning and modelling, not analysis.

What data do you need?

CSV or Excel exports from your existing systems. Typical inputs are order data, product cost data, carrier or shipping data, and any spend data you already track. Messy is fine. Cleaning is part of the work.

Can I hire you by the day instead of a fixed-scope audit?

Yes. €420/day, two-day minimum. Suits BI consultancies and Microsoft Partners who need overflow capacity, agencies subcontracting white-label dashboards, and in-house teams that need a Power BI specialist for a defined window. Also listed on Malt.

Can you do the audit for less than €1,500?

Not at the same scope. I do offer an audit-lite at €750 with one KPI page, two or three findings, and no scenario simulator. Different product, different depth. Most clients find the full audit pays for itself on the first finding.

Who is this for?

Logistics operators, 3PLs, freight forwarders and cross-border fulfilment networks running multiple carriers with patchy visibility into where the cost is going. DTC e-commerce brands doing roughly €500K to €10M in annual revenue who suspect their margin is leaking but cannot see where. Also BI consultancies and agencies that need an overflow Power BI developer on day-rate.

Are the case study numbers from real clients?

They are reference architectures. The financial modelling matches live mid-market DTC and multi-carrier logistics configurations. The DAX architecture, the modelling depth, and the audit structure are identical to paid client work. Client-specific numbers stay confidential with the client.

Request a Margin-Leak Assessment.

A short working call. Bring one report you actually use to make decisions. We will tell you what is missing from it and what an audit would surface. If there is a fit, we scope the work. If not, you walk away with something useful anyway.

Request the assessment Email instead

Prefer LinkedIn? DM me there. Agencies and BI consultancies can also book me on Malt.