New Moon0% lit

Projects Data Analytics & BI

Superstore Executive Intelligence Portal

Lead project

Developed an interactive Power BI Executive Portal to track financial health, product profitability, and customer risks. Built: A multi-page dashboard featuring automated alert cards, regional financial tracking, category/shipping drill-downs, and a comprehensive slicer filter panel. Found: Discounts over 20% destroy profit margins; the Tables sub-category loses -$18K despite high revenue; and certain high-volume accounts like Sean Miller generate negative net profits.

A project by Mohammed Ashraf Hassan

Published
Type
Power BI
Built with
Power BI DAX Power Query Data Modeling Microsoft Excel JSON
Total Sales
$2.30M
Net Profit
$286.4K
Profit Margin
12.5%

Data model

02 · Waxing Gibbous · 90% lit
Data model

Tools

03 · Waning Gibbous · 98% lit

Tools

Power BI DAX Power Query Data Modeling Microsoft Excel JSON

Keep exploring.

04 · New Moon · 0% lit
Previous project

Retail Performance & Operations Dashboard

Lead project · DEPI capstone
Next project

Flight Tracking DB

Pricing & route analytics