A pharmaceutical company implements Custom PowerBI Visual for deeper insights into drugs launch milestones

Overview


VNB developed a custom PowerBI visual for a pharmaceutical company to aid seamless reporting of program/product launch milestones across their products, regions, sub-regions, and countries  

Customer Profile  

The customer is a leading nationally and internationally recognized pharmaceutical dedicated to providing innovative treatment in several therapeutic areas of cardio-metabolic diseases, infectious diseases, genetic medicines etc.  

They strive to research and provide best-in-class medications created through innovative methodologies and specialized technologies hence ensuring best treatment to people that need them the most.  

Customer Situation 


vnb-custom-powerbi-visual

The Customer has been using a multitude of technologies in trying to keep up with their program launch timelines for all their products in various countries. It is a tedious manual effort for them currently to provide a report every two weeks to upper management.  Along with the usual challenges of connecting to various technologies and manual consolidation of data they were also dealing with the inconsistencies in data. Hence, the customer needed a system that would eliminate the duplication of efforts across various teams providing similar reports to upper management and move away from manual effort and ensure error free reporting.  They needed a robust reporting system that would read, and report program/product launch timelines based on pre-defined milestones across regions and countries in a seamless manner that would ensure accurate, better, and faster insights to the upper management.    After a thorough vendor selection process, the customer selected VNB Team to help them build the custom visual and reports for their situation.

VNB Solution 


vnb-custom-powerbi-visual-develpoment

VNB BI & Analytics team kicked off the project with multiple rounds of business team/user interviews to capture requirements and detailed review of the current siloed reporting landscape. After a thorough review of requirements, current landscape, and future vision, VNB team proposed creating a new custom visual to handle the specific reporting needs of the customer.     The existing out-of-box matrix visual was enhanced using typescript code to incorporate the milestone icons, text corresponding to icons, visual representation of progress between milestones, custom groupings for regions, sub-regions and countries, custom ordering within groupings and dynamic legend and heading displays for the report. VNB team worked relentlessly to ensure that every business requirement of the client was in place and the generated report was very similar to the legacy reports so that it is an easy transition for the power users from the legacy to new report.   VNB provided timely support and effective communication throughout the UAT process. 

Customer Benefits 

  • Created a centralized reporting system for program/product specific timelines
  • Automated the flow of data  
  • Built user friendly reports to cater to various audience groups and aided their ability to make business decisions
  • Quick turnover on creating reports and dashboards

Related Case Studies


gas-utilities-power-bi-sap-hana-customer-story

A natural gas & utility company implement PowerBI with SAP HANA to improve operations

VNB assisted a Utilities company with Microsoft Power BI (Business Intelligence) infrastructure set up and configuration, establish industry standard best practices for design and development of Power BI reports and to develop enterprise Power BI dashboards with SAP HANA data  for operations team

VIEW DETAILS
retail dashboard power bi solution vnb consulting

Transition From Manual Predictive Process To Automated Predictive Analytics For A Retailer

VNB assist a retailer to transition from a manual predictive process to an automated predictive solutions leveraging Azure Analytics and PowerBI.

VIEW DETAILS