Case Study
Artificial Intelligence, Data and Analytics
Pharmaceutical Analytics Optimization
Problem
Pharmaceutical company had standard reporting from various source systems for finance, accounting, and procurement. This caused difficulty assembling data for analysis and security constraints for additional access. The inability to combine disparate data meant they couldn’t get a full picture of process and status.
Solution
Implemented Snowflake data warehouse on AWS with transformation with Glue to ingest data, curate and prepare reporting in Qlik Cloud. To enable more customized user experience, Power Pages was leveraged to create a portal providing a single point of access for company analytics as well as ability to share related information like training and announcements.
Outcome
User experience was streamlined through portal access and visibility of full financial process was enabled through integration of disparate system data. Due to architecture and technology, data refresh was able to be achieved every half hour to allow for timely month end reconciliation.