Analysis of transactional data to understand product demand and sales patterns to highlight growth opportunities.
Overview
This project analyzes coffee shop transaction data to uncover patterns in product performance, customer behavior, and sales trends over time. Focused on sales behavior and demand, this analysis identifies opportunities to optimize product offerings, staffing, and sales strategy.
business context
The coffee shops generate high volumes of daily transactions across multiple products and locations.
objective
Identify key sales patterns across products, locations, and time to support better decision-making and highlight opportunities for growth.
Approach
- Cleaned and standardized raw transactional data using Excel
- Replaced missing and invalid values using mean and mode imputation
- Built auxiliary tables and pivot tables to validate data quality
- Structured analysis around key business questions
- Developed a Power BI dashboard to visualize trends and insights
impact
This analysis provides a data-driven foundation for:
- Optimizing product offerings based on demand
- Increasing revenue by prioritizing high-value products
- Improving operational planning through time-based insights
- Tailoring strategy by location
key insights
1. Product demand is uneven. Opportunities exist to reduce low-performing products or promote them differently.
- Clear differences in sales volume across products
- Some items consistently underperform in quantity sold
2. Revenue growth should focus on high-value and volume items
- Highest-selling product ≠ highest revenue product
- Some higher-priced items contribute more to total sales
3. Shifting to a location-based strategy can improve sales performance
- Sales distribution varies between locations (ex: in-store vs takeaway)
4. Staffing, inventory, and promotions should align with peak periods
- Clear variation by day of the month and across time periods
tools
Microsoft Excel (data cleaning, transformation, pivot tables)
Power BI (visualization and dashboard development)
