Data-driven decision making is crucial to minimizing business risk and maximizing portfolio value. A global pharmaceutical company was struggling to access timely and accurate operational and financial project metrics such project delivery milestone dates, development cost forecast, revenue forecasts, Probability of Technical and Regulatory Success (PTRS). The decision makers also needed value metrics such as estimated Net Present Value (eNPV) and estimated Internal Rate of Return (eIRR).

Assessing these projects metrics across project development scenarios and in the context of the whole portfolio is essential for portfolio directors and decision-makers to inform consequential portfolio investment decisions.

Resolving data trust issues caused by data silos, data disparity and data misalignment; and the need to centralize the comparison and visualization of project data against the broader portfolio were the key challenges that prompted improvement in their decision-making capabilities. The client needed a way to access timely and accurate portfolio data all in one place.

Team i2e engineered Clairvoyance- a custom Executive Dashboard Application tailored specifically for the pharmaceutical industry. This application offers a consolidated view of the client’s project portfolio, providing executives with a powerful interactive tool for data-driven decision-making.
This custom solution delivers a robust data quality verification platform and offers the analysis and visualization features needed to tackle the various problems the client was experiencing.