Federico Fortunati
Automating Weekly Business Review Metrics on AWS with Amazon Redshift and Amazon QuickSight.
Rel. Daniele Apiletti. Politecnico di Torino, Corso di laurea magistrale in Data Science And Engineering, 2025
Abstract
This thesis describes the design of an end-to-end solution to automate Weekly Business Review (WBR) metrics and publish them as interactive dashboards in Amazon QuickSight. The WBR is the weekly meeting in which teams and the organization review operational KPIs against targets and focus on corrective actions. The project, conducted in collaboration with Amazon S.à r.l., Luxembourg, starts from a spreadsheet-based process, then it migrates to a cloud architecture which preserves historical data, decouples operational monitoring from the data warehouse, and provides stable dashboard performance for the weekly review. At the heart of the system is the Redshift Visibility Tool (RVT), which queries Amazon Redshift system tables and views (query history, errors, usage statistics) on a schedule and writes clean, time-stamped datasets to Amazon S3 in Parquet.
These datasets are then registered in AWS Glue and queried with AWS Athena
Relatori
Anno Accademico
Tipo di pubblicazione
Numero di pagine
Informazioni aggiuntive
Corso di laurea
Classe di laurea
Aziende collaboratrici
URI
![]() |
Modifica (riservato agli operatori) |
