🚀 Portfolio Project: E-Commerce Data
Srishti Jain
🚀 Portfolio Project: E-Commerce Data Pipeline & Analytics (PostgreSQL)
Processed and analyzed ~500,000 raw transactional logs from the Online Retail II dataset to clean messy operational records and extract executive business intelligence metrics.
💡 Key Highlights:
Data Staging & Cleaning: Engineered custom transaction flags (SALE vs RETURN), deduplicated raw records, and stripped non-inventory fee entries (AMAZON FEE, POSTAGE).
Executive Metrics: Isolated $426.07K in Net Revenue across 5,266 distinct orders, evaluating an overall 13.1% return rate.
Customer Lifetime Value (CLV): Segmented Registered vs. Guest checkouts, uncovering top-tier accounts with $27,000+ in lifetime spend.
Time-Series Growth: Implemented advanced SQL window functions (LAG()) to compute Month-over-Month (MoM) revenue growth velocity.
🛠️ Tools Used: PostgreSQL | Data Modeling | SQL Analytics | CTEs | Window Functions
📂 Check out the complete SQL scripts & documentation on GitHub: https://github.com/srishtijain1674/ecommerce-sql-analytics
#DataAnalytics #PostgreSQL #SQL #DataOperations #FreelanceAnalyst
Like this project
Posted Sep 16, 2026
🚀 Portfolio Project: E-Commerce Data Pipeline & Analytics (PostgreSQL) Processed and analyzed ~500,000 raw transactional logs from the Online Retail II data...
Likes
0
Views
0
