Olist E-Commerce — Customer Retention Crisis Analysis
Python · Power BI · DAX · Star Schema
- Built an end-to-end pipeline in Python (EDA, cleaning, PK/FK validation) across 9 datasets (~99K orders, R$15.8M revenue) for a Brazilian e-commerce marketplace (2017–2018).
- Designed a 4-page Power BI dashboard with 22+ DAX measures including Retention Rate %, Lost Revenue Potential, and Delivery Experience on a validated Star Schema model.
- Uncovered a critical 3.07% retention rate representing R$14.6M in lost revenue — tracing root causes to avg 10.6-day delivery delays and delivering 4 targeted recommendations.
Domino's Pizza Sales Dashboard — SQL + Power BI
SQL Server · Power BI · DAX
- Authored 22 SQL Server views using CTEs, subqueries, and date functions to answer 20+ business questions on revenue, order patterns, and product performance.
- Connected views to a 3-page Power BI dashboard (Executive Summary + Operations) featuring KPI cards, trend lines, and category breakdowns with a custom Domino's theme.
- Surfaced 4 core KPIs and insights on best/worst-selling products, peak demand hours, and monthly trends — enabling data-driven staffing and inventory decisions.
Global Superstore BI Dashboard — Time Intelligence
Power BI · DAX · Star Schema
- Designed a 4-page executive Power BI dashboard on a Star Schema model (Orders, Products, CRM, Locations) delivering a 360° view of sales, profit, and customer performance across 2011–2014.
- Implemented advanced DAX Time Intelligence measures (Prior Year, YoY Growth) and dynamic conditional formatting with scatter plots, treemaps, and interactive slicers.
- Surfaced Total Sales, Net Profit, Profit Margin %, and YoY Growth — pinpointing high-revenue vs negative-margin products to guide pricing and promotion decisions.
2 additional projects (Carrefour Sales · Global Sales Performance) available at ayman-data-analyst.pages.dev