AI-Driven
Reporting automation in AWS
Goal
Automate over 2000 reports for more than 100 customers. The client was manually creating reports in MS Excel and could not handle that many customers. There were multiple data inconsistencies and hardware issues. The customer has a different language mutation, units, metrics, and refresh times. Keep the data quality high and provide the monitoring.
From Art to Science
Created a custom wrapper for the AWS Boto3 API for faster manipulation and pipeline setup
Decoupled data sources and optimised query execution
Created isolated and robust pipelines in Apache Airflow for each customer with high efficiency
Template-based reports for different language mutations, units, and refresh rates in AWS Quick Suite
Integrated notification system in Slack
Results
Orchestrated and parametrised pipelines for each customer
Dashboard for management and monitoring + report, and role assignment
Reduced a lot of costs by automated execution
Createda scalable solution
Ready to Elevate Your Business?
Contact us today to explore how our AI consulting services can grow your business.