E-Commerce Analysis

• Developed and deployed a full-stack Power BI solution backed by a custom Python ETL pipeline, transforming raw sales, customer, and returns data into a clean, analysis-ready model for reporting and visualization. • Conducted in-depth analysis of profit margins, discount impacts, and shipping costs, revealing a significant profit margin gap (13.5% vs. 22.5% target) and identifying unprofitable managers, over-discounted products, recommended pricing, and operational efficiency improvements. • Identified declining customer retention and high return rates in specific segments (Corporate, Home Office) and product sub-categories (e.g., Envelopes), recommending loyalty programs and quality control enhancements to reduce churn and product returns.