🚀 Portfolio Project: E-Commerce Data Pipeline & Analytics (PostgreSQL) Processed and analyzed ~5...🚀 Portfolio Project: E-Commerce Data Pipeline & Analytics (PostgreSQL) Processed and analyzed ~5...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Srishti's avatar
Srishti Jain
• Sep 16
🚀 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
Completed work
PostgreSQLData Analysis
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started