From slow and complex Excels to an efficient solution on AWS

Services

Business

Small
~ 20 employees

Type of solution

Automated data pipelines and dashboards

- 80%

reduction in data consolidation and reporting time

Challenge

Operational processes supported across multiple Excel files, with errors, version issues, and manual consolidation.
In addition, there were recurring errors in manually generated reports for payment settlement and analytics.

Solution

An architecture was designed on AWS to automatically integrate, store, and process data. An orchestration backend and a web application with dashboards were developed on Amazon QuickSight.

Technologies used

AWS architecture · AWS Quicksight · Python · SQL

Impact

Significant reduction of manual processes and financial risk due to errors in manual data management. Improvement in information access times and availability of a centralized and scalable solution.