Global Beauty E-commerce Dashboard

Thanh Tra Nguyen Avatar

Thanh Tra Nguyen

EPRO

Global Beauty E-Commerce Dashboard

About this project

Top Selling Products by Market:****Herbal Essences Bio emerged as the top-selling product across all regions, signaling strong universal appeal.In Europe, Gold Spectrum and Silver Embrace followed closely, suggesting a preference for premium products in this market.
Profit and Discount Analysis by Market:****Asia Pacific leads in discount usage but lags behind Europe in profit generation. This indicates that while discounts drive sales volume, they might be impacting profit margins negatively.The highest profit was recorded in Europe despite lower discount levels, pointing towards a more profitable pricing strategy.
Sales and Profit Trends Over the Years:Sales have shown a steady increase from 2020 to 2023, with total sales peaking in 2022.The profit trend indicates a challenge in 2023 with a 12.16% decrease compared to the previous year, despite an increase in sales, highlighting potential issues in cost efficiency or market saturation.
Discounted Sales Distribution:****Asia Pacific and Europe have comparable order volumes, but the discount amounts in Asia are more than double, affecting the overall profitability.
Geographical Sales Distribution:The interactive map reveals high sales concentration in North America, Europe, and the Asia Pacific regions, with significant opportunities for growth in underpenetrated markets.
Sales by Category and Segment:****Body Care and Makeup dominate the sales, with Body Care generating the highest profits, indicating successful market penetration and product positioning.Corporate sales contribute significantly to the total, suggesting a strong B2B market presence.
Customer Purchase Behavior:The quantity distribution chart shows that most orders contain 1-4 items, with 2 items being the most common basket size.Peak sales occur during summer and Christmas seasons, while sales on Thursdays are notably lower, which could influence promotional activities or specific marketing campaigns.
Top and Bottom Performing Products:Top performers include Cappuccino Lg and Sustainably Grown Organic Lg, with notable growth in sales.Lower performers like Serenity Green Tea and Dark Chocolate still show growth, presenting potential for targeted marketing to boost sales.