E-Commerce Business Analysis with PostgreSQL and SQLE-Commerce Business Analysis with PostgreSQL and SQL
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
Jamie's avatar
Jamie Tran
• Oct 1
E-Commerce Business Analysis
PostgreSQL • SQL • Business Analysis
Overview Analyzed approximately 100,000 e-commerce orders using PostgreSQL to investigate revenue trends, customer behavior, product performance, seller performance, and delivery experience.
What I Built I developed targeted SQL queries using joins, CTEs, aggregations, window functions, ranking, and date analysis to transform transactional data into business-focused findings.
The analysis uncovered patterns in revenue growth, geographic performance, repeat purchasing, product categories, seller concentration, and the relationship between delivery performance and customer reviews.
Key Findings Revenue increased substantially during the analyzed period • Repeat purchasing represented a relatively small share of customers • Revenue was not heavily concentrated among the top sellers • Longer delivery times were associated with substantially lower customer review scores
Tools: PostgreSQL • SQL • pgAdmin • Excel
Want to see the queries? View the complete SQL analysis on GitHub → https://github.com/jamietran8818/business-data-analytics-portfolio/blob/main/olist-sql-business-analysis/README.md
Completed work
Business AnalysisData AnalysisData VisualizationMicrosoft ExcelMicrosoft WordSQL
Post image
Post image
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