Sobi is a global Biopharmaceutical company, which prides itself on transforming the lives of people with rare diseases. With over 1,600 employees working across 30 countries, Sobi specialises in providing innovative treatments in the areas of haematology, immunology, and specialty care.
Sobi wished to gather more data and insights on key revenue drivers from affiliates during the course of the annual long- range planning exercise, however, the current approach had some challenges, for example: data collected was limited, consistent metrics (for products and countries) were not consolidated, and standardised forecast approaches were not adopted across countries.
Many individual excel files were utilised and to gather / consolidate the required insight using the current approach was highly manual, time consuming and requiring significant discussions, often resulting in additional questions. As Sobi continues to grow, a review of the current approach was required to introduce efficiencies and scalability.
Bespoke started by creating a consolidated data tool, which combined the data from various excel forecasts with different structures and formats – once this was established, we were able to create a custom Power BI dashboard for Sobi which detailed 11 key products and
has the ability to add further products when required.
The consolidated dashboard considers layers of specific requirements in the backend, such as specific product / country level views, as well as differing requirements at a regional / global level. Through building in these requirements, and automating the data capture and refreshing, the output is simple, effective, and accurate.
“The process has introduced dynamic Power BI reports for alignment on key outputs / metrics and highlights more insights into key forecast drivers”.