Olist Case Study · Lab 05
Brazilian E-Commerce Public Dataset
The Brazilian E-Commerce Public Dataset by Olist contains information about 100,000 real orders made between 2016 and 2018 across multiple marketplaces in Brazil. Provided by Olist, the largest department store in Brazilian marketplaces, this dataset allows analyzing orders from multiple perspectives: order status, pricing, payment methods, freight performance, customer locations, product characteristics, and customer reviews. It is a classic dataset for learning relational data modeling, data quality cleaning, and star schema optimization in Power BI.
Relational Tables Breakdown
To build a proper analytical model, you will import and relate nine separate files. Review the table description below to understand the structure of the data:
| Table / CSV Name | Short Description & Purpose |
|---|---|
| olist_customers_dataset.csv | Contains customer demographics and address details. Links each unique customer profile to their zip code, city, and state. |
| olist_geolocation_dataset.csv | Maps Brazilian zip code prefixes to latitude/longitude coordinates. Essential for spatial mapping and analysis. |
| olist_order_items_dataset.csv | Contains item-level order records, detailing the products purchased, seller info, shipping limit dates, prices, and freight values. |
| olist_order_payments_dataset.csv | Details billing information including credit card, voucher, boleto, debit card options, and installment counts. |
| olist_order_reviews_dataset.csv | Tracks customer satisfaction scores, comments, creation dates, and administrative answer timestamps. |
| olist_orders_dataset.csv | The core transactional table containing order statuses and key operational timestamps (purchase, approval, carrier hand-off, delivery). |
| olist_products_dataset.csv | Catalog of products sold, detailing categories in Portuguese, description length, image counts, weights, and physical dimensions. |
| olist_sellers_dataset.csv | Stores registration details and geographical locations of all independent sellers who fulfill Olist orders. |
| product_category_name_translation.csv | A lookup table mapping Portuguese category names to English, allowing for localized reporting. |