Automate budget reporting to maximize marketing effectiveness
2024
The finance function of a EUR 3bn pharmaceutical company primarily relied on Excel and manual reporting for marketing spend tracking and the associated management (e.g., correcting over- / underspend). This was error-prone and time-consuming for both Finance and Marketing.
Based on standardized SAP reports that are refreshed daily, we built a Power BI Dashboard that displays data according to a familiar cost center and brand hierarchy. In addition, we recreated familiar, formerly Excel-based, reports in Power BI that are refreshed daily.
Marketing with 50+ users no longer tracks budget manually and accesses spend quickly through self-service. Finance no longer needs to prepare slides and Excel tables for discussion with the business counter-parts, and, in addition, can quickly react to critical changes through smart KPIs.