Complete Olist Store E-Commerce Analysis Project in SQL | Mysql Database
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.
📺 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
بـار بازدید شده