Ecommerce Sales Dashboard

🚀 Excited to share my first project for the FP20 Analytics Challenge 19! 🚀

I analyzed the global skincare and beauty e-commerce market, focusing on key performance indicators (KPIs) for sales, profit, and growth. Using Power BI, I visualized data trends from 2020-2023 to uncover actionable insights. 💡

A big thanks to Federico Pastor and ZoomCharts for giving us this opportunity to participate, learn a lot, and share with others who have the same interests. Special thanks to my mentors Anh Leimer and Trang Tran for their motivation and guidance.

🔗 Link to Power BI app:https://lnkd.in/gk6C62ST

Key Insights:

Top-performing segments:

• Product Categories: The most profitable category was Skincare, contributing 35% of total profits over the last 3 years.

• Corporate Segment: The corporate segment saw a 28% annual sales growth, nearly hitting the 30% target.

Market growth:

• Overall Sales: The e-store achieved 18% year-over-year sales growth, just below the 20% target. The strongest growth came from North America, where sales grew by 22%, driven by increased demand for premium beauty products.

Profit distribution:

• Geographical Breakdown: Europe was the most profitable region, generating $3.5 million in profits, accounting for 40% of the total.

• Interactive Map: Use the interactive Power BI map to explore regional profits and identify emerging markets.

Best-selling products:

• Top Seller: The best-selling product was the Vitamin C Serum, contributing $800K in revenue between 2020-2023, representing 12% of total product sales. It consistently achieved a 30% profit margin each year.

Profitability trends:

• Market Profit Growth: Profits grew consistently in Asia, with an annual increase of 15% with Fragrances underperforming at 10% margins.

Discount Strategy Insights:

• Discount Performance: Our analysis revealed that deeper discounts didn’t necessarily result in higher profitability. For example, while holiday discounts increased sales by 25%, profit margins fell by 8% during these periods, suggesting a need to revisit discounting tactics.

Top Customers:

• High-spending Customers: The top 10 customers were from Germany and spent an average of $50K per year. These high-value customers accounted for 8% of total revenue.