Replacing a €50,000/yr controlling role with a BI stack and 23 KPIs.
A mid-sized German marketing agency (~20 employees) lacked end-to-end visibility into billable efficiency across project and service teams. Over ten weeks I designed and deployed 8 Power BI dashboards backed by a Node/Express middleware bridging Absence.io (HAWK auth) and Toggl (API-key auth) — neither of which Power BI supports natively. First month of deployment moved project-team billable efficiency from 49% to 65% (Δ +16 pp). The COO attributed €50,000/yr in controlling-role cost savings to the new reporting surface.
Read the engagement