In today's fast-paced digital marketplace, understanding consumer behavior and optimizing operations are crucial for success. Olist, a Brazilian e-commerce company, has leveraged data analysis to gain critical insights and streamline their business strategies. This article delves into the findings from an extensive exploratory data analysis (EDA) of Olist's operations, highlighting key trends and strategic recommendations for improving performance.
Data Overview and Preprocessing
The dataset used for this analysis spans from 2016 to 2018 and includes nine interconnected sub-datasets covering customers, geolocations, order items, payments, reviews, orders, products, sellers, and product category translations.
Here's a breakdown of the key datasets:
- olist_customers_dataset
- olist_geolocation_dataset
- olist_order_items_dataset
- olist_order_payments_dataset
- olist_order_reviews_dataset
- olist_orders_dataset
- olist_products_dataset
- olist_sellers_dataset
- product_category_name_translation
To ensure the data was ready for analysis, several preprocessing steps were undertaken:
Data Cleaning:
- Null Values: Null values were removed from the datasets to maintain data integrity.
- Duplicate Values: Duplicate entries were identified and removed to avoid redundancy and inaccuracies.
- String Values: Null string values were replaced with 'NA' to standardize the dataset.
Data Merging:
The product_category_name_translation dataset was merged with the olist_products_dataset to obtain English translations of product categories, facilitating easier analysis.
Data Integration:
Relationships between datasets were established to ensure a comprehensive and cohesive analysis. This step involved creating connections between datasets to avoid duplication and enhance data integrity.
Key Insights
Order Behavior
Weekdays vs. Weekends: Analysis reveals that weekdays see higher order volumes, with a peak on Monday and a gradual decline towards midweek. This trend indicates that customers are more active during weekdays, suggesting an opportunity for targeted promotions.
Payment Preferences:
Dominance of Credit Cards: Credit cards are the preferred payment method, especially for 5-star reviews, followed by boleto. This highlights the importance of secure and convenient payment options in driving customer satisfaction.
Delivery Times:
Category Variations: Office furniture has the longest delivery time, while arts and craftsmanship have the shortest. On average, deliveries take 12 days, with pet shop products averaging 11 days. Streamlining delivery processes for categories with longer times could enhance overall efficiency.
Geographical Insights:
City-wise Trends: Sao Paulo and Rio de Janeiro record the highest order counts. In Sao Paulo, the average payment surpasses the average price, likely due to high order density. Tailored marketing strategies for these regions could further boost sales.
Shipping Duration and Reviews:
Negative Correlation: A clear negative correlation exists between shipping duration and review scores. Faster shipping times are associated with higher review scores, emphasizing the need for efficient logistics.
Dashboards
Tableau Dashboard Link :- Tableau dashboard link
Power Bi Dashboard
Recommendations
Targeted Weekday Promotions:
Capitalize on higher weekday order volumes by launching specific promotions and offers to boost sales during these peak periods.
Enhance Payment Security:
Prioritize measures to further secure credit card transactions, maintaining customer trust and encouraging repeat business.
Streamline Delivery Processes:
Optimize logistics operations by improving route planning and inventory management, particularly for categories with longer delivery times.
Localized Marketing Strategies:
Develop region-specific marketing campaigns for high-order cities like Sao Paulo and Rio de Janeiro, leveraging local insights to connect with customers more effectively.
Improve Shipping Efficiency:
Address bottlenecks in the shipping process by enhancing warehouse workflows and forming strategic carrier partnerships to reduce delivery times.
Diversify Payment Options:
Expand payment options to include alternatives like debit cards and promote the use of boleto, catering to diverse customer preferences and expanding market reach.
Conclusion
Olist's exploratory data analysis provides valuable insights into customer behavior, payment preferences, and operational efficiencies. By leveraging these findings, Olist can implement targeted strategies to enhance customer satisfaction, streamline operations, and drive growth. As e-commerce continues to evolve, data-driven decision-making will remain a cornerstone of success in the competitive digital marketplace.
By understanding and applying these insights, e-commerce businesses can stay ahead of the curve, ensuring sustained growth and customer loyalty in an ever-changing market.