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

March 16, 2024
Rockhop logo bug
“The process has introduced dynamic Power BI reports for alignment on key outputs / metrics and highlights more insights into key forecast drivers”
We helped Sobi achieve their goals. 
See how we can help you.

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
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.
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.”

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
[email protected]
(720) 263-1623
75 Waneka Parkway Lafayette, CO 80026
Visit our LinkedInVisit our YouTube channel
Copyright ©2024Rockhop LLC. All Rights Reserved.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram