SQL | Microsoft Excel | Data Analysis | Business Intelligence | Dashboarding | Business Insights
The company is experiencing fluctuating sales and wants to identify revenue drivers, customer demand patterns, and underperforming products in order to optimize pricing, promotions, and inventory planning.
Dataset: Historical pizza sales transaction data (2015)
-
Which time periods generate the highest sales and order volume? Sales and order volume are highest between 6–8 PM
-
Which pizza categories and products contribute most to revenue? The most contributing product and category is Classic Deluxe pizza and Classic category respectively.
-
Which products underperform and should be considered for removal or promotion?
The Brie Carre Pizza consistently underperforms and should be considered for removal, while the Classic Deluxe Pizza should receive increased promotional focus.
| | Key Insights | Business Recommendations |
| 1 | Sales volume peaks between 6–8 PM | Enables targeted evening promotions and optimized staffing |
| 2 | Classic category contributes the highest revenue share | Prioritize this category for inventory planning and marketing investment |
| 3 | Top 20% of pizzas generate the majority of revenue | Focus on high-performing items to maximize profitability |
| 4 | Certain pizzas consistently underperform | Menu rationalization can reduce operational costs and improve margins |
- Strengthened SQL skills in data extraction and transformation.
- Developed ability to convert raw data into business insights.
- Improved dashboard design and storytelling with Excel.