Provide advanced analytics to a growing user base while supporting a corporate move to cloud deployment, and controlling costs.
As a data consolidation offering, REDPHARMA’s REDDATA service gathers and enriches transactional data from across 4000+ pharmacies, capturing all prescription and over-the-counter ticket sales. This measures the return and uplift of targeted end-customer marketing campaigns and offers. The data is processed, cleansed, and extrapolated for consumption by pharmaceutical producers, such a laboratories. The REDDATA analysis platform contains secure and anonymized data that is used for market and trend analysis. Various reporting options help customers understand their marketing environment, align campaigns, and develop seamless promotions. Using this wealth of data, REDDATA also produces national and localized statistics to identify product sales trends, and support fast decision-making.
David Nicholson-Jones, Analytics Architect with REDDATA, explains further: “Collating all the data with only a small data science team is a challenge. To attract new pharmacies to our model we need to showcase the benefits of analytics. One way to do this is by providing easy-to-use dashboards, giving a detailed overview of a pharmacy’s position within a competitive landscape. We have been using Tableau to present our data in a meaningful way. Although this is great as a Business Intelligence (BI) solution, we found that as soon as our data volumes started to grow, performance went down.”
At the same time, REDDATA made a strategic move towards the cloud, and chose Amazon Web Services (AWS) as its platform. Nicholson-Jones looked for a way to split BI from data processing, while minimizing infrastructure costs.