تحليل مبيعات Sales Data Analyst

Overview

This case study analyzes retail sales data to identify revenue trends, product performance, customer purchasing patterns, and key business opportunities. The analysis transforms raw sales data into actionable business insights through data preparation, KPI analysis, and interactive dashboard visualization.

Business Context

Retail businesses need to understand not only how much they sell, but also which products, customer segments, and regions contribute to sustainable profitability.

The challenge is to identify sales and profitability patterns across different products, categories, customer segments, and regions, while understanding how discounting may affect overall business performance.

Business Problem

The business lacks a consolidated view of sales and profitability performance across products, customer segments, and geographic regions.

This makes it difficult to identify revenue drivers, under performing areas, and potential profitability risks associated with discounting.

Key Business Questions

Which products and categories generate the highest sales and profit?

Which customer segments and regions contribute most to overall performance?

Are high-sales products necessarily the most profitable?

How does discounting affect profitability?

Which areas represent potential opportunities for business improvement?