This repository conducts a comprehensive SQL analysis on the Olist Brazilian E-Commerce dataset, focusing on trends from 2016 to 2018. It aims to uncover insights into customer behavior, delivery failures, revenue trends, and business growth using PostgreSQL.
From the README
Brazilian-ecommerce-analysis From 329 orders in 2016 to 54,000+ in 2018 — a deep-dive SQL analysis on Brazil's largest e-commerce platform uncovering customer behavior, delivery failures, revenue trends and business growth patterns using PostgreSQL. This project performs an end-to-end SQL analysis on the Olist Brazilian E-Commerce dataset — one of the most comprehensive public e-commerce datasets available, containing 100,000+ real orders placed between 2016 and 2018. The goal was to think like a Data Analyst — not just query data, but extract meaningful business insights that can drive decisions around logistics, customer retention, product quality, and revenue growth. 🗂️ Dataset Source:...
