Summary

This Power BI E-Commerce Dashboard for cosmetics industry, provides a clear view of sales, profit, orders, customers, and product performance from 2020 to 2023. It is designed for beauty brands, online retailers, and ecommerce teams that want to monitor core KPIs and understand what drives revenue and profitability.

The report was created using the E-commerce KPI Analysis dataset and submitted to the FP20 Analytics ZoomCharts Challenge 19 in September 2024.

Key Insights of the Power BI Cosmetics E-Commerce Dashboard

The report presents business performance through overview, market, customer segment, and product category views. Key insights include:

• Sales performance: Track total sales, order quantity, year-over-year changes, monthly trends, and regional distribution.
• Profitability: Analyze total profit, profit margin, and performance across markets, customer segments, and product categories.
• Customer analytics: Explore customer distribution by country and segment, identify top customers, and compare purchasing patterns.
• Product performance: Review demand and profitability across cosmetics categories such as body care, makeup, and hair care.
• Discount impact: Examine how different discount levels affect sales and profit margins.
• Top performers: Identify the products, customers, countries, and regions contributing the most to business results.

Interactive Power BI visuals connect the different perspectives, allowing users to filter the report and drill down from overall ecommerce KPIs to individual markets, products, and customers.

How to Use This Power BI Cosmetics E-Commerce Dashboard

Use the navigation tabs to move between the Overview, Market, Segment, and Categories sections. Click active chart elements to filter the report, drill down into regions and time periods, or hover over data points to view additional details.

Download the .pbix file to examine the calculations, report structure, and visual settings. You can also connect the template to your own ecommerce data and adapt it for a cosmetics, beauty, or retail business.