Stage 1: Process & Methodology

• Ingested and cleaned transactional data using Excel and Power Query

• Segmented customers by age and order frequency

• Built KPIs using DAX to analyze order value and completion rates

• Mapped geographic performance and seasonal trends

• Designed interactive dashboards using segmentation modeling and behavioral analysis

Stage 2: Business Questions

• What is the order completion rate and lost value?

• Which age groups and devices dominate order behavior?

• Which cities and products perform best?

Stage 3: Objectives

Analyze customer behavior, order performance, and seasonal trends to improve conversion and retention.

Stage 4: Key Insights

• 84.85% order completion rate; elderly customers had highest order value

• Adults dominated order count, mostly via mobile

• Austin (TX) was top-performing city

• Digital Services was the highest-value category

• December was peak month; Jan, Feb, Aug were lowest

Stage 5: Recommendations

• Optimize payment gateways for preferred cards

• Recover lost value from abandoned/cancelled orders

• Prioritize mobile-first campaigns for adults

• Develop premium offers for elderly customers

• Expand into high-performing markets

• Launch loyalty programs and CRM systems