Data Operations & Analytics Case
Srishti Jain
Data Operations & Analytics Case Study: Amazon Sales & Customer Churn Analysis
Automated raw dataset processing using Advanced Excel, Power Query, and SQL logic to extract key operational metrics and customer behavior insights.
Key Highlights & Workflow:
Data Cleaning & Sanitization: Handled duplicate records, missing categories, and standardized raw fields into clean summary structures.
Amazon Sales Analytics: Modeled monthly sales trends, revenue distribution by region/product category, and payment channel performance.
Customer Churn & Feedback Analysis: Evaluated order satisfaction rates and post-purchase feedback trends to identify key churn drivers.
Automation Impact: Reduced manual reporting time and ensured 100% data accuracy across key dashboard metrics.
Tools Used: Excel (Power Query, Advanced Formulas), SQL Logic, Data Cleaning Protocols.:
Like this project
Posted Sep 15, 2026
Data Operations & Analytics Case Study: Amazon Sales & Customer Churn Analysis Automated raw dataset processing using Advanced Excel, Power Query, and SQL lo...
Likes
0
Views
0
