The client

A worldwide healthcare company dedicated to improving people’s health to their fullest potential. The company provides an extensive range of leading products that cater to positive, long-term healthcare trends across both advanced and emerging markets. With a workforce exceeding 100,000 and more than 4,000 FLMs operating in over 160+ countries, they are constantly finding innovative solutions to enhance lives.

The challenge

Due to scale of operations, the diversity of the managed regions, as well as strict internal and external regulations – our client required tailored, reliable a way to track and manage the prices of its top brands. Global pricing management required measurement of the realization of actual net selling prices compared to pricing guidelines on daily basis. This was to be done in order to establish and maintain optimal guidelines for individual company affiliates, monitor and supervise price formation of various products across countries.

 

The challenging aspect was the of dispersion of services and multiple data sources with different data structures (manual Excel file, VENA, SAP Analytical Cloud) which needed to be restructured.

 

Last but not least, the tool needed to present all aspects of business and financial analysis in user-friendly way.

The scope

  • Gathering of required business rules and guidelines to enable data analysis of price transparency, guidance and forecasting as historical data becomes available.
  • Providing a holistic view of price transparency and pricing guidance, with data integrated from multiple data sources.
  • Creating Power BI dashboard supporting supervision and decision-making in the field of price transparency and pricing guidance with additional functionalities dependent on the user needs or regional differences.

The solution

First bespoke dashboard covering all aspects of global pricing transparency and guidance

 

Tailored design

 

Delivery of first bespoke dashboard covering all aspects of global pricing transparency and guidance in as per requirements of client, including advanced conditional (Benchmark) and designed KPIs.

 

The KPIs, requirements and region-specific needs were gathered during extensive workshops provided to all stakeholders.

 

Introduction KPIs regarding pricing guidance are calculated at various levels of detail to establish guidelines for individual company affiliates and monitor and supervise price formation for various products across markets (countries). One important aspect we have considered was differences in currencies that needed to be accounted for during pricing calculations. This enabled us to provide much more meaningful comparison on a global scale, while preserving region-specific insights.

 

Additionally, BitPeak was able to calculate average price per singular unit of the product such as pill or tube, increasing the precision and reliability of calculated trends and forecasts.

 

Data integration

 

The data was sourced from 4 systems (manual Excel file, VENA, SAP Analytical Cloud) and processed to ensure highest data governance standards, compatibility and excellent data quality. The integration and development of the data layer were facilitated by the client’s use of cloud-based technology, which ensured easier deployment and much higher scalability.

 

Power BI Functionality

 

Thanks to addition of a current selection panel at the top of each functional page, the dashboard was equipped with multiple filter values  as well as a wide range of interactive slicers and filters according to needs of Client.

Personal Visual table from Power BI was also used to enable table content modification by end user.

 

Additionally, thanks to Power Apps we enabled business users to assess the pricing recommendation in real time, increasing the trust in the solution and its reliability.

 

To reach our goal we used the following tech stack:  

  • Power BI: for data visualization
  • SQL: for data transporting
  • VENA: for data sourcing
  • SAP Analytical Cloud: for data sourcing
  • AWS Redshift: For data gathering and storage
  • Power Apps: For business user assessment

Benefits:

Management

We helped our client find the optimal prices for their products by presenting holistic, up-to-date information about sales values, units sold, including forecasted value and volume. This was further supported by analysis and visualization of those trends and price guidance KPIs and empowered the client’s product owners to efficiently manage prices on both local and global scale.

 

Strategy

We augmented client’s strategic decision-making by providing high-value information about interesting patterns in financial data, trends in product performance (including sales, average prices and margins) as well as establishing price guidelines and controlling their implementation. The result? Reliable, data based pricing strategy for both short and long term.

 

Business users

Our solution provided easy access to reliable data which could be further customized to fit current business needs. Combined with easy to use UX, customizable data sliders and filters this resulted in quick and nearly full adoption of the tool among business users. Thanks to tools provided, employees on multiple levels of the company were empowered to work more efficiently and with a higher degree of accuracy.