Profitability & Sales Dashboard (Power BI)

sales sweden.png

sales china.png

quantity china.png

performance china.png

Summary

This project involves the development of an interactive Power BI dashboard to analyze company performance across three key dimensions: gross profit, quantity, and sales. The report enables a comprehensive comparison between current year-to-date (YTD) and previous year-to-date (PYTD) values, with a focus on profitability segmentation and regional performance. The dashboard was built for dynamic business insights using layered filters and custom visualizations.

Dataset Overview

Internal company performance data for the year 2023
Metrics: Gross Profit, Quantity Sold, Total Sales, and Gross Profit %
Granularity: Monthly data grouped by country, product type, and customer segments
Simulated data to enable safe public sharing

Key Features

1. Gross Profit Analysis

Visualized YTD vs PYTD gross profit changes with a waterfall chart (Year-to-Date (YTD) and Previous Year-to-Date (PYTD))
Segmented performance by product type and region
Highlighted top contributors and detractors across months