mlebda2004-dotcom/Carrefour-Retail-Performance-Dashboard

Power BI dashboard analyzing Carrefour retail sales, branch performance, customer behavior, and product profitability across Egypt (2022–2024). # Carrefour Retail Performance Dashboard An interactive Power BI dashboard designed to analyze Carrefour retail performance across sales, products, customers, and branches. The project started with a raw dataset that required data cleaning and preparation before analysis. The final dashboard provides interactive insights into sales performance, customer behavior, product performance, branch performance, and return rates. ## Project Overview An interactive Power BI dashboard designed to analyze Carrefour retail performance across **sales, products, customers, and branches**. The project started with a raw dataset that required data cleaning and preparation before analysis. The final dashboard provides interactive insights into **sales performance, customer behavior, product performance, branch performance, and return rates**. **The analysis was performed using a single flat table, without a separate data model.** ## Business Questions The analysis aims to answer the following business questions: 1. What is the overall sales and profit performance? 2. Which products and categories generate the highest sales and profit? 3. Who are the highest-value customer segments? 4. Which branches and cities have the strongest sales performance? 5. When do customers make the most transactions? 6. What is the return rate, and how does it affect net sales? 7. How does sales performance vary across different channels and time periods? ## Data Cleaning & Preparation The raw dataset required several cleaning and preparation steps before analysis: * **Date Correction:** Fixed inconsistencies in the date column and restructured the data to create a reliable calendar table. * **Data Standardization:** Corrected and standardized categorical values, including the Gender column. * **Feature Engineering:** Created age groups such as **Young, Adult, and Senior** to analyze customer behavior across different age segments. * **Time Analysis:** Created time-of-day categories such as …