Pizza Hut Project

Project Scope

The case study was from RMIT RBAC 2023 competition, sponsored by Pizza Hut. The scope of this project is to:

1. Describe customer's portrait and their behaviors

2. Segment customers into groups using RFM model.

3. Calculate CLV and predict churn rate for each group

4. Recommendations to attract new customers and increase re-purchase

Tool & Language Used:
MySQL, Power BI, DAX, Power Query and MS PowerPoint