Automated Dashboard for Better Decision Making

Overview

To automate download of scope files from a website and do ETL process. Store the tuned data in Redshift and visualize the data in the decision making format. S3 used to store all formats of data and later move to Redshift for analysis

Solution Overview

null

AWS Glue studio used to accumulate all data under a commonly readable format.

null

Redshift’s fact and dimension helped to form a dynamic dataset which is the base for QuickSight's infographic

null

File downloads are automated, periodically using Power Automate

Impact

null

Automation reduced 60% of their workload.

null

Dashboard and graphs help client team to make better decision making

Technology

Related Success Stories

Related Insights

Free Consulting