Ice Cream Shop Analysis
This project identifies top product combinations and evaluates how discounts and increased demand impact sales and profit. It covers performance from 2023 to 2025, providing a 360-degree view of the business including revenue, net profit, and order trends.
Management lacked clear insights into branch performance (Cairo vs Alex), couldn't track employee efficiency, and had no automated way to simulate the effects of changing discount rates on future profits.
Data was extracted and cleaned using Power Query. I created a star schema data model, calculated advanced KPIs using DAX (AVO, Profit Margin), and implemented "What-if" parameters to allow dynamic scenario testing.
- Cairo branch leads revenue with $111K.
- Cash is the preferred payment method ($116K), followed by Cards.
- The most frequent product pair is "Cone" and "Ice Cream Cup" (87 pairs).
- A 5% discount combined with a 10% order increase leads to a 2.29% profit growth.
- Focus marketing on "Waffles" as they yield the highest margin (73%).
- Expand digital payment options (Vodafone Cash/Instapay) to capture more "Evening" shift customers.
- Implement a 5% discount strategy for low-demand periods to boost overall volume and net profit.
