DataZymes Field Reporting Solution for a Specialty Pharma Product – enabling 360o Accurate and Precise information for Field and Home Office

How our data expertise, functional expertise and technology expertise enabled a sales reporting platform.

This suite covers data from all major data sources such as sales, call activity, hub performance, access, claims, audited sales, Speaker Program, Digital (NPP) promotional activities etc.

A large Global Pharma major was looking to set up their field performance reporting for a Specialty Product. The challenges were around aggregating data from multiple internal and external data sources, as well as around creating integrated KPIs that provided consistent and accurate performance monitoring for both the Field Force and Field Leadership.

The problem was further compounded by the fact that financial metrics had to be linked to the sales promotion channels and view the impact of spends on sales.

The current standard was manual processes, where all sales reports were created manually using SQL and Excel. Financial reports were also created by other teams and shared as excel outputs. The field reps had no way to see their performance in a consistent and accurate manner. This was compounded by the frequent restatements in Specialty Distribution and Redistribution data. The field leadership on the other hand had no way to measure true performance and compare performance with spends to understand the true impact of promotional activities at various levels such as Territory, District and Region. Owing to the sensitive nature of Financial metrics, multiple files had to be created for multiple stakeholders, each with view of selected data that was permissible for them to view.

DataZymes approached the problem with a 3-step approach:

The reporting Layer was built in the clients’ data warehouse on Oracle. Data Quality rules were inbuilt to the reporting layer to ensure accuracy of the data at every step, and to enable an early warning system. These QC Checks were dynamic and automated. (Read More in our Data Quality) Case study.

DataZymes leveraged its extensive expertise in commercial reporting and technology to propose and finalize key lagging and leading indicators, with the business team. User personas, use cases, past issues, tickets, and information through business interviews was used to design the dashboards. These KPIs were storyboarded in an intuitive and impactful manner allowing each user persona to get to the business answer with minimal clicks. User level, row level security, SSO integration, server optimization, performance tuning was the key hand off tasks to ensure the solution is stable and set up for long term.

Adoption of the reporting solution was the next step that DataZymes worked with the client on. DataZymes ensured user acceptance testing, user guides, training workshops and query resolution as a part of the hyper care period, which focused on adoption and support for the solution.

A unified reporting suite thar enables business users across various levels to see consistent and accurate performance views. A powerful centralized performance reporting platform that allows to view sales performance, spends and promotional activities in an integrated manner.

Drill down to various levels of geography with integrated row level user-based security.