Overview
Here, you will learn more about S3 Bucket Exports - how to use them, what data can be found there, and the best approaches to leveraging Open Loyalty export capabilities.
With Open Loyalty, you have the ability to seamlessly export your data as a CSV file directly to the AWS S3 (Simple Storage Service) buckets. This allows you to access and retrieve the data effortlessly, empowering you to construct detailed reports that go beyond simple data sets, perform insightful analyses, visualize your data with tools like Quicksight, and much more.
Approaches available for leveraging Open Loyalty's data exporting capabilities
Exporting a CSV file and importing it into tools like Quicksight: With this approach, you can easily export your data to a CSV file and import it into popular data visualization tools such as Quicksight. This enables you to create visually appealing reports and gain valuable insights.
Directly connecting data visualization tools to S3: Open Loyalty offers the convenience of connecting your preferred data visualization tool directly to the AWS S3 buckets. By doing so, you can streamline the data retrieval process
Implementing advanced ETL processes or integrating with existing ones: For those seeking more advanced capabilities, Open Loyalty enables you to implement advanced ETL processes or seamlessly integrate your data with existing ETL workflows. This empowers you to create custom reports that merge your data with the organization's comprehensive dataset.
Use Case
The Analytical Dashboard version 0.1 in the QuickSight application enables quick and accurate analysis of units within the Open Loyalty system.
We have the option to select the date range for transfers from 01/06/2023 to 31/07/2023. Beyond this date, we can efficiently observe the distribution of five unit types: Issued Units, Active Units, Pending Units, Spent Units, and Expired Units.
Furthermore, we can track the progress of key metrics such as breakage and Redemption growth over a specific period of time.
Last updated