E-Commerce Marketplace Analysis

Designed an end-to-end BI solution using SQL Server and Power BI, transforming five years of transactional data into a

star-schema data warehouse with robust ETL, data validation, and reusable SQL views for scalable analytics.

Developed a six-page Power BI dashboard using Calculation Groups, Field Parameters, and advanced DAX, enabling

dynamic YoY, QoQ, MoM, and WoW analysis through reusable semantic models and executive KPI reporting.

Identified 21% of customers as At Risk through RFM segmentation and uncovered profit leakage from excessive

discounting and shipping SLA violations, enabling targeted customer and operational strategies.