Magdy Fawzy

📊 Business Intelligence (BI) Project Description: Sales and Performance Analysis 💡 Project Overview: This project involved the development and implementation of a comprehensive Business Intelligence (BI) system utilizing Microsoft Power BI to provide real-time, data-driven insights for executive management and sales teams. The system focuses on analyzing financial performance, product sales, return rates, and the effectiveness of sales representatives and inventory levels across four key governorates: Qena, Minya, Assiut, and Beni Suef. A core feature is the detailed comparison of performance between the years 2024 and 2025. ✨ Key Objectives: Sales Efficiency Improvement: Identify top and bottom-performing products and pinpoint geographical areas for strategic focus. Inventory/Returns Management: Monitor and analyze the volume and value of returns to address underlying issues. Performance Evaluation: Measure and track the performance of sales representatives (Top 10 REP) and the number of active pharmacies. Strategic Planning: Provide insights into seasonal trends (June, July, August, September) related to sales value and order volume. 🛠️ Methodology and Tools Used: Primary Tool: Microsoft Power BI (for dashboard development). Data Modeling: Designed a robust Star Schema/Snowflake data model to link key tables (e.g., ProductsTable, BranchesTable, rep sales, DimDate), ensuring data accuracy and reporting efficiency. DAX (Data Analysis Expressions): Wrote complex measures and calculations to define core Key Performance Indicators (KPIs), including: Net Sales Value, Total Quantity Sold, Total Returns Value, Transactions 2025, and Total Sales Value. Visualization: Created clear and informative visualizations (Bar Charts, Line Charts, and focused KPI cards) organized into multiple interactive reports: Core KPIs: Highlighting metrics such as 248.20K Net Sales Value and 5814 Total Quantity Sold. Product Analysis: Identifying and comparing the TOP 7 Products performance for 2024 vs. 2025. Channel Analysis: Ranking the TOP 10 Pharmacies by sales value. Geographical and Time Series Analysis: Tracking sales and returns performance across different regions and months. 🎯 Results and Achievements: Successfully developed 4 interactive dashboards covering (Overview, Sales Reps/Agents 2025, Products & Pharmacies), providing a 360-degree view of the business. Established a monthly tracking system that highlights significant fluctuations in sales value (e.g., the notable recovery/increase in September). Enabled management to identify products like Olustat 120mg, Glycokinase, and Ibuprofen as critical items requiring continuous monitoring and strategic focus.