Sobi increase efficiencies & gain better insights into key forecast drivers with Power BI

The Challenge

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 standardized forecast approaches were not adopted across countries. Many individual excel files were utilized 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.

The Requirments

Automated Reporting

Simplified and automated report capabilities – With the ability to change the currency during analysis

Data Visualization

Easier comparison of key assumptions / output across countries (to enable focused review discussions)

Off-Line Usage

Ability for forecasters to utilize the forecasting tools off-line

Restricted Data Access

Users can only see the data relevant to their region / country and / or products

Company

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 specializes in providing innovative treatments in the areas of haematology, immunology, and specialty care.

Industry

Healthcare

Technologies Used

Power BI

"Through the adoption of the solution developed with Rockhop’s support, for Sobi’s long range planning forecast for on-market assets, the process has introduced dynamic Power BI reports for alignment on key outputs / metrics and highlights more insights into key forecast drivers.”

Sobi

The Solution

Rockhop 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 Results

Better data and forecast consistency / transparency – creation of a single source of information, which is comparable across regions through the adoption of a consistent forecasting structure for each product

Improved efficiency – data is accessed by many users during the course of the year, a simple Power BI dashboard has decentralized some key data / assumptions allowing business users to identify insights for their own questions (as opposed to requesting data from a small number of central users)

Clean, crisp data visualizations detailing; market share, product, volume, and revenue forecasts