Naguib
Mousa.

End-to-end Power BI analytics solution built on the Brazilian Olist E-Commerce dataset. Covers sales performance, products, customers, operations, delivery, customer experience, and seller performance across six interactive dashboard pages.

End-to-end supply chain analytics solution built on a SQL Server backup, modeled as a star schema with multiple fact and dimension tables. Tracks inventory health, stockouts, overstock, sales performance, and replenishment behavior across a multi-node supply chain (Suppliers → DCs → Stores → Customers).

Built an end-to-end Business Intelligence dashboard in Excel using Power Query, Power Pivot, and DAX to analyze Year-to-Date sales, Year-over-Year growth, manufacturer performance, dealer regions, vehicle body styles, transmission types, and sales trends through interactive KPIs and slicers.

End-to-end ETL and dashboard project. Cleaned and validated raw cafe data in Power Query (TRIM, CLEAN), then built a coffee-themed interactive dashboard tracking revenue, orders by shift, and payment methods.

End-to-end Excel BI project analyzing 3 years of e-commerce performance. Built a relational data model with Power Pivot & DAX, cleaned raw data via Power Query, and designed an interactive dashboard tracking sales, profit, customer segments, regions, and shipping efficiency.

Engineered relational data models and dynamic DAX calculations to analyze retail profitability across segments, regions, and shipping modes. Includes a dedicated mobile layout for cross-device experience.

Multi-year retail sales analysis with interactive slicers for year, category, and city. Tracks 5 KPIs including weekday vs weekend splits, segment performance, and geographic distribution.