e-commerce_analysis_using_sql

Overview

The objective of this project is to provide an analysis of Olist Store (Brazilian E-commerce) sales.

Dataset

The dataset can be downloaded at Brazilian E-Commerce Public Dataset by Olist from kaggle.com. The dataset has information of 100k orders from 2016 to 2018 made at multiple marketplaces in Brazil.

Tool

• Microsoft SQL Server

Problem

1. Top 10 best selling products
2. Top 10 best-selling product categories
3. Top 10 products by profit
4. Top 10 product categories by profit
5. Total profit per year
6. Total profit per month
7. Top 10 customers by order quantity
8. Top 10 sellers by order quantity
9. Top 10 cities by profit
10. Most commonly used payment types
11. The product categoriy that has a review score of less than 3
12. Sellers who have a review score less than 3 and total reviews greater than 10

Algorithm

1. Create database and use database
2. Import dataset to SQL Server
3. Analyze using sql query

   • Problem 1: Top 10 best selling products

     

   • Problem 2: Top 10 best-selling product categories

     

   • Problem 3: Top 10 products by profit

     

   • Problem 4: Top 10 product categories by profit

     

   • Problem 5: Total profit per year

     

   • Problem 6: Total profit per month

     

   • Problem 7: Top 10 customers by order quantity

     

   • Problem 8: Top 10 sellers by order quantity

     

   • Problem 9: Top 10 cities by profit

     

   • Problem 10: Most commonly used payment types

     

   • Problem 11: The product categoriy that has a review score of less than 3

     

   • Problem 12: Sellers who have a review score less than 3 and total reviews greater than 10

     

Thank you!