Rasaq Akanmu Ojelade

CAPSTONE PROJECT ONE IDAP 11 GROUP C DATA ANALYSIS ON BUSINESS CHALLENGES RELATED TO CUSTOMER PERSPECTIVE ‘What gets measured gets done’ and ‘if you can’t measure it, you can’t manage it’ PROJECT RECAP SUMMARY PROBLEMS THE DATA ANALYTICS TEAM TODAY’S AGENDA VISUALIZATIONS CAPSTONE ONE PROCESS INSIGHTS PROJECT RECAP CAPSTONE PROJECT 1 01 Objectives  To group customers based on recency, frequency and monetary value.  To identify customers who are at risk of churning & how to retain them.  To re-sell, cross-sell and up-sell to customers after the decision to buy from us.  To merchandize the customers through optimization of marketing campaign.  Effective management of our inventory  To predict the potential value of our customers 02 Deliverables and Timelines  To provide insights on customer perspectives through connection to PowerBI for visualizations.  One Month from hired date. 03 Key Stakeholders  Capstone Shareholders and Employees  Customers  Suppliers  Data Analytics Team PROBLEM STATEMENTS CAPSTONE PROJECT 1 CUSTOMER SEGMENTATION Segmentation of our customer base understand their behaviors and needs. to CUSTOMER RETENTION Identification of customers who are at risk of churning and proactive measures to retain them. CROSS-SELLING AND UPSELLING Identifying opportunities for cross-selling or upselling to our existing customer base. MARKETING CAMPAIGN OPTIMIZATION Optimization of marketing campaigns to target the right customers at the right time. INVENTORY MANAGEMENT Effective and efficient management of inventory based on customers demand and preferences. CUSTOMER LIFETIME VALUE (CLV) ESTIMATION Prediction of the potential future value of our customers. PROCESS 1 CAPSTONE PROJECT 1 Data Set Audits 2 Extract, Transform and Load (ETL) 3 SQL Data Extractions & Tables Joining 4 Connections to Power BI for Visualizations 5 Insight Generation INSIGHTS CAPSTONE PROJECT 1 RFM SCORE TOTAL MONETARY VALUE TOTAL NO OF CUSTOMERS MONETARY VALUE BY REGION CUSTOMER RETENTION & CHURN ANALYSIS IN THE LAST 6 MONTHS CUSTOMER SEGMENTATION BY REGION AVERAGE MONETARY VALUE FREQUENCY SEGMENTATION CUSTOMER LIFETIME VALUE (CLV) TOP 5 POPULAR PRODUCT AMONG MARKETING HIGH VALUE CAMPAIGN CUSTOMERS OPTIMIZATION VISUALIZATIONS CAPSTONE PROJECT 1 Process 4 5 VISUALIZATIONS CAPSTONE PROJECT 1 Process 4 5 VISUALIZATIONS CAPSTONE PROJECT 1 Process 4 5 VISUALIZATIONS CAPSTONE PROJECT 1 Process 4 5 VISUALIZATIONS CAPSTONE PROJECT 1 Process 4 5 VISUALIZATIONS CAPSTONE PROJECT 1 Process 4 5 VISUALIZATIONS CAPSTONE PROJECT 1 SUMMARY CAPSTONE PROJECT 1 1) Retention strategies should focus on Re-engaging Lost and Low-Risk Churn customers. 2) Loyalty-building efforts should be concentrated on Platinum and Silver customers, especially in high-value regions like the Southwest. 3) Optimize marketing efforts by targeting customers who are most likely to purchase high-revenue products. 4) Finally, Cross-Selling efforts should target High-Frequency segments for additional revenue opportunities. ANY QUESTIONS? CAPSTONE PROJECT 1