The document explains how the Swiss division of a global pharmaceutical company automated its manual, monthly reporting process using an AWS-based pipeline. Pages 1–2 show that the old workflow relied on manual downloads from multiple sources, causing errors, delays, and limited insight. The solution, outlined on page 3, used Lambda, Python, PostgreSQL on RDS, and S3 to ingest and process data into bronze, silver, and gold layers, with daily Power BI reporting enabled through the REST API. Page 4 highlights results: daily insights, fewer errors, elimination of manual workload, scalable cloud integration, and a 50% reduction in licensing costs.

Join for free to read