Understand and clean
Inspect source tables, contextual missing values, duplicate geolocation data, and inconsistent timestamps.
Data Analytics / Operations case study
An operational analysis connecting delivery delays, customer reviews, seller performance, and geography across Olist order data.
The context
This portfolio case study uses Olist's public Brazilian e-commerce dataset. It joins nine relational tables to investigate operational problems and translate findings into practical recommendations.
The approach
Inspect source tables, contextual missing values, duplicate geolocation data, and inconsistent timestamps.
Join orders, customers, products, sellers, and reviews into a consistent analytical dataset.
Analyze delivery performance, review scores, product categories, sellers, and regional differences.
Inside the repository