Our (fictitious) e-commerce business was experiencing healthy growth, but we lacked a clear understanding of the underlying factors driving our sales performance. We needed to answer critical questions to optimize our strategies:

• Which product categories were our top performers and where were there growth opportunities?

• How did our sales fluctuate throughout the day and across different months, revealing potential seasonal trends or peak periods?

• Which geographic locations (cities) were our strongest markets and where should we focus our expansion efforts?

• How could promotional events (like Diwali or Valentine's Day) impact our sales, and how could we leverage these insights for future campaigns?

Here is a concise version of how I achieved the said goals:

• Data Acquisition & Preparation: Imported and cleaned raw sales data, ensuring accuracy for analysis.

• Key Metric Calculation: Computed essential metrics: total revenue, average order value, delivery time, revenue per category.

• Interactive Dashboard: Developed an Excel dashboard with pivot tables and charts, enabling dynamic data exploration by month, time, category, and city.

• Visual Storytelling: Created clear visualizations:

• Monthly sales trend chart (revealing growth and seasonality).

• Category contribution treemap (highlighting top performers).

• Hourly sales distribution chart (identifying peak periods).

• Promotional event impact analysis (quantifying effectiveness).

• Outcome: A comprehensive dashboard for data-driven sales analysis and strategic decision-making.

The dashboard provided valuable insights that led to actionable recommendations:

• Overall Performance: We achieved a total revenue of ₹3,520,984.00 with an average order value of ₹3,520.98 and an average delivery time of 5.53 days.

• Sales Trends: Sales showed a typical fluctuation throughout the day, with peak periods likely during lunch and evening hours.

• Product Category Performance: The "Cake" category was the top revenue generator, followed by "Soft Toys" and "Raksha Bandhan" items. (Mention specific percentages or rupee values if possible).

• Top Performing Products: Deserunt Box, Fuga Set, Voluptatem Box, Ad Box, and Error Gift were the top performing products.

• Geographic Insights: Our strongest markets were Dibrugarh, Bilaspur Srikakulam, Imphal and Bhubaneswar

• Impact of Occasions: Occasions like Anniversary, Raksha Bandhan and Holi contributed nearly 54% of the sales.