Complete Olist Store E-Commerce Analysis Project in SQL | Mysql Database

All about data
All about data
6.2 هزار بار بازدید - 7 ماه پیش - Complete Olist Store E-Commerce Analysis
Complete Olist Store E-Commerce Analysis Project  in SQL | Mysql Database

📺 YouTube      :   @all_about_data_
📷 Instagram    :  Instagram: allabout_data_
📺Google Drive  :   https://drive.google.com/drive/folder...




DataAnalyst_FullProject
Tools - SQL

The primary goal of this project is to :
•     Identify insights and trends that can help improve the overall performance business.
•     Identifying top–performing products and categories.
•     Analysing customer behaviour and preferences.
•     Analysing sales and revenue trends over time.
•     Identifying factors that contribute to customer retention
•     Developing recommendation for targeted marketing Campaigns and promotions.


KPI’s

1)     Weekday Vs Weekend (order_purchase_timestamp) Payment Statistics
2)     Number of Orders with review score 5 and payment type as credit card.
3)     Average number of days taken for order_delivered_customer_date for pet_shop
4)     Average price and payment values from customers of sao paulo city
5)     Relationship between shipping days (order_delivered_customer_date -           order_purchase_timestamp) Vs review scores.
7 ماه پیش در تاریخ 1402/10/26 منتشر شده است.
6,200 بـار بازدید شده
... بیشتر