Pharmaceutical Sales Management

Multidimensional live reporting drives real actionable insights and a true competitive advantage for the client, a leading US-based global bio-pharmaceutical giant addressing 170 unique markets. This firm sought an efficient and transparent visualization process to support their growing data needs and gain a competitive sales and market advantage using agile business analytics for big data.

• Advanced ETL producing clean, credible data that key stakeholders can rely on.
• Cross module analysis incorporating SAP, market share, patient, and CRM data.
• Granular reporting at Sales Rep and Account levels across 140 individual markets.
• Sales performance and incentive management.
• Actionable insights that drive daily decision making.

Challenges

• Unravelling and correctly reallocating the performance of their direct and wholesale sales approach.
• Understanding the growing discrepancy of their sales versus target KPIs.
• Growing complexity of using SQL to apply their business logic.
• Frustrations in using a 3rd party data service provider.
• The reactive culture of addressing data validation requests and errors.
• Attrition and turnover on the firm’s development team.
• Explicit lack of confidence in data quality and accuracy by key decision-makers.

Solution

 

Changes in business logic, or requests for different views of the SQL tables, required an extensive development effort, incremental costs, as well as independent data validation reporting tools – making it impossible to foster an agile and responsive service needed to stay on pace with the evolving business landscape. Pomerol Partners, a best in class global data visualization consultancy, first digested the requirements, then wire-framed and implemented a solution in a collaborative technology approach. This allows seamless data preparation and analysis – first visualizing (Qlik) all the data and then transforming (Lavastorm) all of it, with a proof of concept ready and confidence restored in just 20 days.

“Working with consultants who understood our business,
made all the difference.”

—Head of CRM

 

Benefits

 

• Efficiency – Significantly reduced SQL development costs.
• Accelerated ROI.
• Agility – Analysts can now implement immediate changes to input variables and produce accurate current and past data outputs of an assortment of formats, including Excel and Qlik – rather than relying on a 3rd party service provider.
• Transparency – The complementary techniques of the visualization process which highlights data issues in Qlik, with the associated corrected logic in the embedded in Lavastorm not only re-established data trust, but also provided a “whiteboard” view of their data to the business users.