top of page
E-Commerce Business Insights Analysis
Project Requirement

I have obtained a real ecommerce dataset of Orders made at Olist Store (A Brazilian ecommerce company). The objective of this project is to analyze the data and provide insights on all aspects on the business

Data Source: Kaggle

Project Work Done

  • Obtained data from Kaggle and performed some data cleaning in SQL

  • Performed a detailed exploratory data analysis using SQL 
    The analysis is grouped into order analysis, seller analysis, customer analysis, product analysis, payment analysis,     and shipping analysis

  • Built a Tableau report with multiple dashboard tabs to visualize the insights from the analysis 

  • Please view the SQL queries and a Tableau dashboard below

​

SQL Queries
Tableau Dashboard
Olish Dashboard.PNG

Click anywhere on the charts below to view the live dashboard on Tableau Public

Top Insights Obtained

Customer Retention:

The number on customers on the site significantly affects the amount of sales and the site. There are currently very few repeat customers on the site. Investing in customer-retention programs will boost sales.

​

Black-Friday Sales Trend:

The company can expect a huge increase in the total sales orders, sellers, customers on the platform at around the last Friday of November

bottom of page