Efficient portfolio management to direct strategy and personnel
2024
The Value & Access function of a EUR 3bn pharmaceutical company manually maintained a database of their project portfolio, copying and pasting data between systems. In addition, they frequently had to manually update reports so management could take a mid-term strategy decision.
We built a Power BI solution that connected a global database with local information, and standardized and rationalized input by the local team. Moreover, we focused the management reporting and provided them with an interactive, self-service solution.
The 5-person team can provide higher-quality output and shifted resources to more value-adding tasks, such as providing management with better and more targeted analysis, so they can take better mid-term strategic decision and maximize revenues.