Supply Chian for Maxab

Developed an interactive Power BI dashboard to analyze and optimize supply chain performance for MaxAB (FMCG). The project focused on evaluating key delivery and fulfillment metrics including OT%, IF%, and OTIF% across multiple Egyptian cities. Applied Power Query for data transformation, DAX for advanced calculations, and data modeling techniques to generate actionable insights. Identified major contributors to delivery issues, including dairy products causing 78.7% of total shortfall and high-risk customers representing 53% of orders. Provided data-driven recommendations to reduce late deliveries, improve operational efficiency, and enhance customer satisfaction.