Comprehensive Market Sales Analysis
ESRAA MORSY
🛒 Comprehensive Market Sales Analysis
🔗 View the Interactive Dashboard on Power BI
Project Overview
This project focuses on uncovering business insights from comprehensive sales and market data using interactive dashboards and performance metrics. The goal is to support decision-making and optimize business strategies.
Tools Used 🧰
Power BI: Data modeling and interactive visualizations
Excel: Data extraction and preliminary cleaning
DAX: Used for complex calculated fields and KPIs
Data Cleaning 🧽
Remove Duplicates: Eliminated duplicate values from the dataset.
Format Modification: Adjusted data formats for numbers and dates.
Fill Missing Data: Populated empty cells in the "adjustment_reason" column based on the available data.
Fill Missing Data: Populated empty cells in the "simplified_return_reason" column based on the available data.
Project Outcome 🎯
OVERALL ANALYSIS
CUSTOMER BEHAVIOUR
EMPLOYEE BEHAVIOUR
PRODUCT PERFORMANCE
STORE CHARACTRISTICS
SALES AND PROFIT TRENDS
Sample DAX Measures
Project Dashboard
Like this project
Posted Jun 14, 2025
Conducted market sales analysis using Power BI and Excel for business insights.
