Understanding Medical Engagement
Top 10 UK BioPharma Company
Bringing together medical data with conditionalities to power reporting
Our client wished to demonstrate the value of Medical to the wider business. Our client had widely disparate medical data that was not stored in one system. Their medical datasets were smaller and more niche than the rest of the data the BI department were using and so it had not been historically worthwhile to add it to regional dashboards.
Additionally, due to its nature, medical data was kept away from the business because it had to be ring-fenced. CSL worked with our client to bring together clinical trial data, CRM activity data, medical info data and medical requests into one reporting system.
We overcame the challenges of cleanliness and centralisation of medical data to provide the business medical reporting dashboards.
CSL created new medical dashboard summaries
In keeping with the rest of the client’s reporting software, CSL provided a customised Tableau solution.
We provided dynamic, easily navigable dashboards which displayed key metrics to senior management. Information summaries included Medical Science Liaison (MSL) Activity, IST Medical Studies, Med Info and Real-World Data dashboards.
MSL activity drilled down to show time analysis of what reps had been doing year-to-date, by channel, and by therapy area as well as topics that had been covered in conversations with HCPs. A summary view of where staff were working, at a geographical level, and which areas were being focused could be presented to allow strategic planning at a senior management level.
A key benefit was increasing accessibility to Medical data
Each dashboard overcame its own challenges. For example, the data feeding the Med Info dashboard had too many products to make a meaningful comparison from and some of the products had few interactions to record. Therefore, CSL grouped the data to improve the user experience.
IST data showed studies going on, by product, by status, by study type, and by country. Base data was muddled, as not all products had an activation date impacting study length. We therefore tabularised rules in Tableau Prep, applying business logic as to which studies would be of most interest.
Medical Engagement information was used for strategic planning by headquarters and senior management, enabling them to have a clear overview of the Medical function.