Olist Store is the largest department store in Brazilian marketplaces. Olist connects small businesses from all over Brazil to channels without hassle and with a single contract. The Brazilian ecommerce public dataset of orders (from 2016 to 2018) made at Olist Store is provided to your company for analysis.
Your manager is asking you to critically analyse the provided datasets using Business Intelligence tools and provide some marketing findings / recommendations in a report format. The dataset has information of 100k orders made at multiple marketplaces in Brazil. Its features allow viewing an order from multiple dimensions: from order status, price, payment and freight performance to customer location, product attributes and finally reviews written by customers. A geolocation dataset that relates Brazilian zip codes to lat/lng coordinates is also integrated in the dataset.
After a customer purchases the product from Olist Store, a seller gets notified to fulfill that order. Once the customer receives the product, or the estimated delivery date is due, the customer gets a satisfaction survey by email where they can give a note for the purchase experience and write down some comments.
- Create data pipeline to ingest data in PostgreSQL or SQL server database
- Use Power BI to answer following questions:
- How many customers, orders, and orders per customer does the company have?
- What is the number of customers by state?
- What is the number of orders by month?
- What are the top 5 product categories?
- Visualise the company’s customers’ demographics, sales trend, orders by categories, orders changes by year, etc. and use Power BI to help make better decisions
- Map and compare report data with data from database query to validate the reports (functional testing).
- Critically analyse relevant data using statistical methods (e.g., Predictive Modelling or Machine Learning)
- Provide some recommendations and improvements (please refer to point 3 in the project description)
Use "!pip install --" command to install the following libraries:
!pip install os
!pip install pandas
!pip install sqlalchemy
!pip install transformers
!pip install -U deep-translator
The scraped data will be cleaned, transformed, loaded and stored in MySQL Database:
- Frankie Lam
- Gordon Kwok
- Janny Leung
- Natalie Lau