A project on

Olist Ecofifierce Store Analysis

by
Group – 1
Mr . Tejas Kulkarni
Mr. Ganesh Samgir
Ms. Arpita Naidu
Mr. Amit Patange
Ms. Krupa Kumari
Ms. Nitya Reddy
 Introduction
• By analyzing this dataset, we aim to understand the performance of the Olist
store, identify trends and extract valuable insights to drive business growth
and improve overall efficiency.
• The project will involve exploring different aspects of the e-commerce
domain, such as customer behavior, sales patterns, product popularity, seller
performance and more..
• Through this Olist Store Analysis project, we hope to uncover valuable insight
that can contribute to better decision making, Operational efficiency,
Customer Satisfaction.
• The finding could potentially guide marketing strategies, inventory
management, Sellers onboarding & other crucial aspect of the ecommerce
business.
Language & Tools
Used
 KPI 1- Weekday Vs Weekend Payment Statistics Using Excel Tool
.
 KPI 1- Weekday Vs Weekend Payment Statist

● The sum of payments in the week day’s is 77.26% while for weekend’s its 22.74%.
● The weekdays payment is 3.4 times of weekend payment, which is greater than 2.5
times.
● There's is need to increase the number of orders on the weekends.
● In weekdays the maximum number of orders are on Monday and so are the payments.
● Where as the least number of orders in a week falls on Saturday – in weekends and so
are the payments.
● There is a huge growth in the orders for year 2017 as compared to 2016 year.
 KPI 1- Weekday Vs Weekend Payment Statist

CONCLUSION:
● Higher customer engagement and increased order activity on weekady as compared to weekend could
be due to customers having more free time, relaxed schedules, and the opportunity to browse and make
purchases at their leisure.
● Weekdays may exhibit more consistent order activity, reflecting routine shopping behaviors and
consistent demand throughout the workweek. This could be influenced by factors such as work
schedules, limited time availability, and a focus on essential purchases.
● Marketing Opportunities: Promotions, discounts, and advertising campaigns can be strategically
planned and tailored to maximize customer engagement and drive sales during specific days of the
week.
● Customer Segmentation: Analyzing weekdays versus weekends enables customer segmentation
allowing for personalized marketing approaches to reach customers effectively on the days when they
are more likely to make purchases.
● Inventory Management: Aid in optimizing inventory management by analyzing the fluctuations in
demand between weekdays and weekends, the Olist Store can adjust stock levels and ensure sufficient
inventory to meet customer needs during peak shopping periods.
KPI 2 Number Of Order' Vs Review Score 5 Using Credit
Card
 KPI 2 Number Of Order's Vs Review Score Using Credit
Card
Observation:
● The highest orders with a review score of 5 using a credit card are 43,981.
● The lowest orders with a review score of 2 using a credit card are 2,407.
● The total number of orders are 76055 using Credit card among which the review score
5 covers 57.82% of the total orders this is really a good number.
● We can observe that there is a huge difference between the review score 5 and review
score 4 with is almost 33.37% of review score 5.
● The reviews posted by the customer should be read carefully and a proper solution to
the mention problem should be brought to increase the review score of orders that has
a score of 1, 2 & 3.
 KPI 2 Number Of Order's Vs Review Score Using Credit
Card
CONCLUSION:
● Positive Relationship, Trust and Convenience: Customers who make more orders using a credit
card may have a higher level of satisfaction and often signifies a level of trust and convenience
and may leave positive reviews, overall shopping experience, leading to higher review score
● Reliability and Security: Credit card’s use often provides an added layer of security and
protection against fraud. Customers may perceive the Olist Store as reliable and trustworthy and
conveniently use their credit cards, resulting in higher review scores.
● Enhanced Customer Experience: Using credit card offers convenience, flexibility, and potentially
faster checkout processes. A positive customer experience translates into higher review scores
and potentially increased customer loyalty.
● Influencing Factors: Other factors, such as product quality, customer service, and shipping
experience, can also impact the review scores. Use of a credit card may contribute to a positive
shopping experience, it is essential to consider the overall customer journey and satisfaction
with all aspects of the purchase process.
● Continuous Monitoring: Monitoring the relationship between the number of credit card orders
and review scores over time is crucial. It allows the Olist Store to assess customer satisfaction
levels and identify any changes or trends that may require attention or improvement.
KPI 3 Average number of days taken for pet
shop
 KPI 3 Average number of days taken for pet
shop
CONCLUSION:
• The average number of days taken for pet shop is a 11 days.
• Efficiency of operations: The average number of days taken can serve as a measure of the
pet shop's operational efficiency. A lower average indicates that tasks are being completed
promptly, potentially leading to higher customer satisfaction and improved overall
performance.
• Timeliness of order fulfillment: For pet shop transactions involving customer orders, the
average number of days taken provides insights into the speed of order processing,
packaging, and delivery. A shorter average duration suggests that the pet shop is able to
fulfill customer orders promptly, enhancing the customer experience.
• Process optimization: Identifying bottlenecks or inefficiencies in the workflow can help the
pet shop streamline operations, reduce delays, and improve overall productivity.
• Service level agreements (SLAs): The average number of days taken can be used to
evaluate the pet shop's adherence to service level agreements or predefined timelines. By
comparing the average duration against set targets, the pet shop can identify areas where
improvements are needed to meet or exceed customer expectations.
KPI 4 - Average Price & Payment Values for Sao Paulo City Using Tableau Tool
 KPI 4 - Average Price & Payment Values for Sao Paulo
• City
Average Price: Customers from Sao Paulo City tend to have a higher average price for their purchases
that is $108 compared to customers from other locations.
• Average Payment Values: Customers from Sao Paulo City also have higher average payment values,
that is $136.
• Sao paulo city demonstrate a higher profit generated by customer i.e 8,24,637 & customer of this city
ordered maximum product i.e 15,428
CONCLUSION:
• The higher average price and payment values in Sao Paulo City imply that the customer base in this city
may have a higher income level or overall purchasing capacity.
• By understanding the preferences and behaviors of customers from Sao Paulo, the Olist Store can
tailor marketing strategies and product offerings to better serve this specific segment.
• This conclusion suggests to offer competitive prices that align with customer expectations and market
conditions in each location.
• Identify areas where the Olist Store can differentiate itself by offering competitive prices or providing
additional value to customers. This analysis can help to optimize pricing strategies and stay ahead in the
market.
• Emphasize quality, unique features, or superior customer service to justify the higher prices and
enhance customer satisfaction.
KPI 5-Relationship b/w Shipping days Vs Review Score using Power BI Tool
 KPI 5- Relationship b/w Shipping days Vs Review Score
• A negative correlation implies that as shipping days increase, review scores tend to decrease.
• Product delivery for fortaleza city took 21 days & sao Paulo took 8 days.
• Some categories may experience longer shipping times and higher freight value compared to others. This can be attributed to
various factors, such as product size, fragility, or special handling requirements.
• Orders with the "delivered" status generally have the longest shipping days since they represent the entire duration from
purchase to delivery
• Product under review score 5 indicates that certain categories may have a stronger correlation between product quality,
customer satisfaction, and resulting review scores.
• CONCLUSION
• This conclusion suggests that longer shipping durations are associated with lower customer satisfaction, as reflected in the
review scores.
• The conclusion derived from this analysis can guide the development of category-specific strategies for e.g. for categories
with longer shipping times ,proactive communication or offering expedited shipping option may be necessary.
• Analyzing the relationship between shipping days and order status can help identify areas where operational efficiency can
be enhanced. By streamlining processes, reducing delays, and addressing any issues specific to certain order statuses, the
overall efficiency of the fulfillment process can be improved.
• Analyzing the relationship between product categories and review scores provides insights for identifying areas of
improvement. This includes addressing any quality issues, optimizing customer service for specific categories, and enhancing
the overall shopping experience in each category.
Dashboard
 Insights and Recommendations
INSIGHTs :
• According to the data, Olist E-commerce has about 99,440 orders.
• With about 89,940 orders being delivered, the company has a 90.44% delivery success rate.
• Their average product rating is 4.09 stars, with product categories going as high as 4.67 stars and as low as 2.5
stars.
• 1 Star reviews is on third place in the review score distribution ranking which likely indicates that there could
be problems with product quality in some product categories.
• Delivery performance could also influence review scores and success rate could certainly be improved.
RECOMMENDATIONS:
• Regularly monitor and analyze customer reviews to gain insights in product quality and identify areas for
improvement.
• Investigate delivery delays and undelivered orders.
• Providing a proper shipment tracking system aids in having clear and concise communication between
customers, sellers and deliverer.
• By establishing trust and communication, both parties can work together to resolve any issues that may arise.
 Summary
• During this project on Olist Ecommerce Store We utilized Excel and MySQL for data
modeling, manipulation, and visualization.
• We employed dashboards in Tableau and Power BI to create a comprehensive view of
key performance indicators (KPIs).
• The KPIs We focused on included Average Payment value, Average Price Value, Shipping
Days, Review Score, Payment Type, Weekday Vs Weekend, Profit, Total Orders.
• Overall, regular monitoring of customer reviews, real-time tracking of fleet
performance, together with proper shipment tracking and communication system can
improve Olist's delivery and supply chain performance and ensure customers are highly
satisfied with the service.