As an entry-level data analyst at an online retail company, I embarked on a journey to interpret real-world data and make crucial business decisions. This project involves exploring transactional data, unraveling sales trends, understanding customer behavior, and identifying popular products.
In this endeavor, my objective is to conduct exploratory data analysis, unveil patterns, outliers, and correlations, and provide actionable insights. Through visualizations and statistical analysis, I aim to optimize the store's operations and enhance customer satisfaction in the competitive online retail market.
- Describe data to answer key questions and uncover insights.
- Gain valuable insights to improve online retail performance.
- Provide analytic insights and data-driven recommendations.
-
Customer Insights:
- Customer with the highest orders is from the United Kingdom (UK).
- New customers generate more revenue than existing ones.
-
Order Statistics:
- Top 5 countries with the highest orders: UK, Germany, France, Ireland (EIRE), Spain.
- November 2011 records the highest sales.
- Approximately 25% NA values present, impacting results.
- 39.98% of orders are canceled.
- Top 5 countries with canceled orders: UK, Germany, EIRE, France, USA.
- Most customers buy less than 25 items.
-
Sales Timing:
- Most sales occur in the afternoon, with the lowest sales at night.
-
Product Insights:
- Top product is the white hanging heart T-light holder.
-
Free Items:
- Unclear why FREE items are given; on average, 2-4 times/month (except June & Dec 2011).
- Focus on top markets: UK, Germany, France, Ireland (EIRE), and Spain.
- Improve customer retention through loyalty programs or personalized promotions.
- Investigate and reduce canceled orders.
- Clarify the free item policy for fair treatment.
