Brazilian E-Commerce Public Dataset by Olist
https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce
In this project, we use advanced MySQL to gain insights from the Brazilian ecommerce public dataset of orders made at Olist Store. The dataset has information of around 100k orders from 2016 to 2018. The tables of the dataset are Customers, Order Items, Order Payments, Order Reviews, Orders, Products, Sellers, Product Category Name English.
1. DataSet: Find the datasets here. These were downloaded from Kaggle and the format of ‘date’ was change where ever required.
(Note: I haven’t used the geolocation dataset for this project. Thus, not uploading its data file. However, if you wish to, then you can download it from here: https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce?select=olist_geolocation_dataset.csv )
2. olist_Load_Table_data: SQL file to create database and table, and load data in it.
3. Olist_Analysis: SQL file to analyze the data and gain insights from it.