All Projects
Data Analysis
E-Commerce Power BI Dashboard
This dashboard was built on top of the E-Commerce Data Warehouse (SSIS + SQL Server) and provides four analytical pages covering the full business picture — from executive-level KPIs to granular product and customer insights. It surfaces $57.34M in revenue, 54K orders, customer lifetime value of $71.67K, and a 65% repeat purchase rate.
Gallery
Screenshots & diagrams
Architecture
How it's built
SQL Server Data Warehouse (Star Schema)Power BI DirectQuery4-Page Interactive Dashboard
Data analyst — designed dashboard layout, built DAX measures, created interactive reports.
Highlights
Key achievements
- 01$57.34M total revenue analyzed with 30.7% gross margin across 54K orders
- 02Customer LTV of $71.67K with 65% repeat purchase rate — 520 returning vs. 280 new customers
- 03Campaign attribution: $40.09M (70%) of revenue is campaign-attributed
- 04Returns analysis: 5.3% return rate, $1.47M refunds — Wrong Size is #1 driver
- 05Geographic distribution across US, AU, JP, DE, CA, FR, GB markets
Stack
Technologies used
SQLSQLPythonPython