Amazon Pinpoint
Redpack
About Redpack
Redpack is a Mexican company with 28 years of experience operating nationwide. They specialize in providing tailored logistics solutions to meet the unique needs of each client. Their services play a vital role in supporting businesses throughout the supply chain, enhancing their competitiveness, and fostering growth. Redpack serves a diverse range of industries, with a particular focus on e-commerce, technology, and manufacturing, both within Mexico and abroad.
THE CHALLENGE
The challenge was to create a delivery stream that received all the email events and create a specific analysis with a visual dashboard.
THE SOLUTION
To achieve this, we proposed a Data Lake architecture with Amazon Kinesis Firehose as streamingtool and Amazon QuickSight as BI tool.This architecture utilizes an Amazon Kinesis Data Firehose Delivery Stream as a conduit connecting Amazon Pinpoint events to Amazon S3. Data is stored in JSON format in S3, organized by a yyyy/mm/dd partitioning scheme.
THE STEPS
AWS Glue Crawler was implemented to autonomously detect schema changes and is configured to run daily, ensuring new partitions are seamlessly integrated into the data table.
After the table schema was established, we generated an Amazon Athena view to extract only the essential fields required for analysis.Subsequently, Amazon QuickSight incrementally populates a data set from the Athena View every 30 minutes.
Finally, we created a comprehensive analysis incorporating the metrics specified by the customer, which was then published to a dashboard.
ABOUT NUBOSPERTA AND AMAZON WEB SERVICES
Amazon QuickSight consumes the data through Amazon Athena to produce weekly dashboards. The project started on October 2022 and entered production on December 2022 after completing the extraction and validation of the data sources and the creation and validation of the Amazon QuickSight dashboard.
Currently, the dashboard is being consumed on a weekly basis and a second stage is being defined to integrate more data sources and dashboards.
This automated dashboard helped reduce the construction time of the report in a 90%.
DASHBOARDS
NEXT STEPS
To learn more about how AWS and Nubosperta can help your business, visit www.nubosperta.com
Contáctanos y realiza una prueba de concepto sin costo
Contáctanos
Queremos ayudarte a descubrir la mejor versión de tu negocio a través de nuestros servicios en la nube, Si lo deseas puedes agendar una reunión con nosotros, eligiendo fecha y horario de tu preferencia.
