About Project
This project was created to analyze sales and profitability across a global skincare and beauty e-commerce store using an order dataset. The objective was to track key business KPIs, including a minimum 15% profit margin, 20% annual sales growth (with a target of 30% for the corporate segment), and achieving at least $ 400,000 in annual sales per market. The analysis was built using Microsoft Fabric, cleaned and modeled with Power Query, and visualized using Power BI to deliver clear, actionable insights.
The final report spans two pages and presents insights into total revenue, monthly trends, segment and market performance, as well as top-selling products. By exploring product categories, regional profitability, and customer segments, this dashboard equips decision-makers with the tools to optimize pricing, identify underperforming regions, and better target high-value customers.
Business Performance Overview
This page provides a high-level summary of business KPIs: total sales ($7M), total profit ($1M), and a 16% average profit margin, meeting the 15% target. Monthly trends in sales and profit, top product categories, and key customer insights are visualized to show where growth is happening. It also highlights best-performing products and top-spending customers, helping the business recognize what’s driving revenue.
NB: Click on the image below for a full view of the dashboard report.
Segment and Market Deep Dive
This page focuses on performance by customer segment (Consumer, Corporate, Self-Employed) and by regional markets (USCA, Europe, Asia Pacific, etc.). It evaluates whether each market is meeting the $400K annual sales goal and whether segments are on track to meet sales growth targets. Stakeholders can use this page to refine regional strategies and prioritize high-impact segments.
NB: Click on the image below for the full view of the dashbaord report.
