Driving AI: creating Smart Dashboards with AWS QuickSight
Industria
Government / Public Agency
Escenario
AWS QuickSight
Cliente
Government Organization
The project involved developing a visual reporting system using AWS QuickSight for Costa Rican municipalities, enabling them to generate interactive charts and gain insights into key indicators such as security, health, and education. Using Excel as the data source, it was integrated with AWS Glue to facilitate data processing and loading into QuickSight. The solution eliminated the need for traditional databases, optimizing analysis and visualization. A web-based Java system was implemented to embed the dashboards, providing an accessible platform where users can dynamically view and analyze data at both national and district levels. The architecture was enhanced with AWS Lambda and Node.js for data automation, improving real-time processing. Additionally, the system suggested data hierarchies, optimizing data analysis workflows and source data evaluation for accuracy and efficiency. This approach modernized the analysis process, with a particular focus on security, enabling municipalities to make informed decisions to improve community quality of life.
Solution Components:
Excel:
Primary data source loaded into AWS QuickSight for creating interactive charts.
AWS QuickSight:
Business Intelligence platform used for creating and visualizing interactive dashboards.
Java:
Technology used to develop the web platform where QuickSight dashboards were embedded.
Infraestructura:
AWS Amplify, AWS Lambda
Node.js & AWS Lambda:
Technologies used for backend automation and processing, enabling the dynamic flow of data and system updates in real time.
S3:
Cloud storage for files and generated results.
Service Architecture:
The data flow begins with loading Excel files into AWS QuickSight, which automatically generates visualizations and suggests suitable charts. AWS Glue was used to integrate the data with the platform, while AWS Lambda and Node.js automated the processing and loading of data. The system further suggested hierarchies of data to improve organizational workflows. The generated dashboards were embedded into the client’s website via iFrames, enabling dynamic visualization.
Project Scope:
Development and deployment of code for integrating Excel with AWS QuickSight and creating dashboards.
Public Security: A strong focus on security indicators, enabling municipalities to measure and compare the effectiveness of their security programs.
Health and Education: In addition to security, the system also covers indicators in these areas, facilitating a comprehensive analysis of social welfare.
Education and Statistics: Collaboration with a public policy research center and an academic institution, who provided the data and statistical foundation necessary for the project’s implementation.
Impact:
The system enabled municipalities to easily access key indicators such as security, health, and education, with a particular focus on security, to assess the impact of local programs and make informed decisions. Thanks to AWS QuickSight’s ability to work directly with Excel, the implementation was agile and efficient, enabling rapid data visualization and enhancing the analytical capacity of local governments. Additionally, the use of AWS Lambda and Node.js improved the automation and responsiveness of data processing, further streamlining decision-making.
