A cloud retail analytics platform that predicts customer lifetime value, flags churn risk and suggests cross-sell items. Data lives in Azure SQL: 3 tables, 10K+ transactions and 400 households.
- CSV upload
- Azure SQL
- Random Forest
- Flask API
- Chart.js dashboard
- Random Forest models for CLV prediction and churn classification, sorting customers into Low, Medium and High retention tiers.
- Co-occurrence basket analysis over 5,000 transactions to drive cross-sell recommendations.
- Cut dashboard load time by about 80% by moving aggregation into SQL and adding in-memory caching.
- Fixed a SQL clause-ordering bug and replaced row-by-row inserts with
executemany()for bulk CSV uploads.