Industry
Health
Type
Data Lake
Technology
Redshift Data Lake
What did they need?
To improve medication sales strategies by reducing empirical criteria and implementing data-driven strategies.
Optimization and automation of reports, leveraging their AWS infrastructure.
How did we support and what was achieved?
- Differentiated strategies were generated by Business Unit, type of clients, and medications. The company identified that using the same strategy for all medications is ineffective, leading to dedicated sales strategies.
- Interpretation of results and generation of applicable strategies for the business.
- Integration of new methods into current analysis procedures through process automation and BI dashboards.
- Analysis of the initial data model, optimizing five management reports by designing solutions in AWS Redshift using Materialized Views and Stored Procedures.
- Integration of external data sources into the Data Warehouse by designing Stored Procedures in Redshift and performing analysis on the Business Intelligence platform.
- Significant improvements in response times of the BI platform due to preprocessing in AWS Redshift.