Olist Store Analysis
Data Analytics Project
Introduction
The Olist Store Analysis project, this endeavor delves into the intricacies of customer behavior and payment dynamics within the Brazilian e-commerce platform, Olist. Founded in 2015 by Tiago Dalvi, Olist has been instrumental in empowering small and medium-sized businesses in the digital marketplace. Through comprehensive key performance indicators (KPIs) and insightful analytics, this project aims to uncover patterns and trends that can propel Olist's success to new heights.
Utilizing Microsoft Excel, Microsoft Power BI, and Tableau, we have created insightful dashboards for comprehensive data analysis.
Project Overview
The Olist Store Analysis delves into customer purchasing patterns and payment statistics on the e-commerce platform. It covers key performance indicators (KPIs) including weekday vs weekend sales, payment types, delivery time, and customer behavior.
Key Insights
1. Weekday vs Weekend Payment Statistics:
​
-
The Majority of sales occur on weekdays (77%), with weekends contributing 22%.
-
Doughnut chart visually depicts the distribution of payments.
2. Payment Type with Review Score 5:
​
-
Credit card is the most preferred payment method (74%).
-
Boleto is the second most used, while vouchers and debit cards are less common.
-
Helps identify satisfied customers and encourages repeat purchases.
3. Average Number of Delivery Days for Pet Shop:
​
-
Pet shop category averages 11 days for shipping.
-
Reveals areas for improving delivery times and maintaining customer satisfaction.
4. Average Price and Payment Value in Sao Paulo City:
​
-
Sao Paulo customers show higher average order price and payment values.
-
Indicates a higher cost of living, influencing purchase behavior in this region.
5. Average Shipping Days vs Review Scores:
​
-
Clear correlation between average shipping days and review scores.
-
Products with longer shipping times receive lower ratings, emphasizing the importance of timely deliveries.
Recommendations
​
1. Optimize Weekend Strategies:
​
-
Leverage insights to enhance sales strategies during weekends.
​
2. Enhance Credit Card Services:
​
-
Improve credit card services to further satisfy the majority of customers.
​
3. Fine-Tune Pet Shop Logistics:
​
-
Implement operational efficiency strategies to reduce delivery times for the pet shop category.
​
4. Targeted Marketing in Sao Paulo:
​
-
Tailor marketing efforts to the unique preferences and behaviors of customers in Sao Paulo.
​
5. Shipping Optimization for High Scores:
​
-
Prioritize shipping optimization to ensure positive customer experiences and higher review scores.
​
By implementing these recommendations, Olist can leverage data-driven insights to optimize its operations and enhance customer satisfaction.