E-commerce Analytics / Beauty Industry Insights
Global Lifestyle & Cosmetics Analytics Dashboard
An interactive Power BI dashboard designed to analyze global cosmetics market performance. This visualization explores brand popularity, pricing behavior, product diversity, and regional trends, transforming raw e-commerce data into executive insights for strategic decision-making. Note: You can see the whole walkthrough of my work down in view project and to try the project please go to my github.
My Role
Appiled Research Work
Duration
1 Month
Tools
Power BI, DAX, Power Query, Excel, Kaggle Dataset
Link
Overview
How can data visualization uncover patterns in global cosmetics sales, brand performance, and consumer preferences — helping businesses identify market opportunities across regions and price segments?
Built an interactive Power BI dashboard that integrates global cosmetic review and sales data to provide a holistic view of the industry.
The dashboard combines market KPIs, product-level insights, and regional breakdowns to help executives understand brand trends, pricing behavior, and category performance.
Key components:
Data cleaning and transformation using Power Query
Dynamic visuals for brand share, rating trends, and price analysis
Region-based filters for Europe, Asia, North America, and Oceania
Automated metrics for popularity score, cruelty-free distribution, and luxury category share
Research
Sisley emerged as the most popular luxury cosmetics brand, leading in both price and sentiment metrics.
Europe leads the global shift toward cruelty-free products, with over 60% of total reviews linked to ethical brands.
Found that mid-range products received the highest customer satisfaction (average rating 3.0–3.5).
Face oils and serums were the fastest-growing product categories by review volume.
Helped segment global markets into luxury, mid-range, and affordable tiers, offering a data-driven view of brand positioning.
Design
Used a rose–plum gradient palette reflecting luxury and elegance in the beauty industry.
Typography and layout were optimized to keep executive KPIs central while maintaining visual softness and contrast through feminine tones.
Results
Delivered a decision-ready dashboard that helps marketing and brand managers:
Compare performance across regions and product categories
Identify high-growth product lines
Align marketing strategy with ethical beauty trends
Enable executive storytelling through dynamic Power BI visuals
Takeaway:
“Where beauty meets business — decoding global trends that shape the cosmetics industry.”
