• Implementation of a system for analyzing membership status and related sales

• Construction of membership analysis dashboards and Self-Service BI system

• Spahros Membership Analysis Service Business Scope: Approximately 70 implementations

Characteristics and Implications:

• Membership analysis system utilizing Retail Tech

• Developed as a SaaS service based on AWS cloud

• Web-based membership analysis portal system

• Efficient analysis visualization dashboards using Tableau

• Self-service analysis feature for responsible personnel based on analysis metrics for each client

Field Participation

• Throughout the project, one key business representative is consistently involved in the analysis and design phases, contributing to decision-making.

• During the testing phase, one key business representative and four IT personnel participate in testing.

• Operational and expansion management is handled by IT personnel who have undergone separate training for operation and expansion report implementation.

Analysis Metrics

• Comprehensive analysis of membership status, growth trends, and comprehensive status of new/additional/dormant members per client

• Analysis of member activity based on customer attributes such as age, gender, residence, and commercial district

• Analysis of customer sales activity by region and branch, including average spending per customer

• Analysis of target marketing effectiveness and related sales activities based on customer characteristics

• Analysis of the effectiveness of regular and irregular events, among others.

• Development of a Retail Tech SaaS system 

• Establishment of a data warehouse using AWS Redshift, RDS, S3 

• Development of an ETL data pipeline system using AWS Glue and Java 

• Development of a membership analysis portal implemented in Java 

• Development of dashboards and self-service analysis BI functionalities using Tableau