Coffee Sales Dashboard using Microsoft Power BI
- Built using Microsoft Power BI
- Interactive dashboard for sales analysis and monitoring
- Clean and professional UI design
- Enables quick, data-driven decision-making
- Filters available for:
- Location
- Month
- Enables drill-down analysis
- Includes “Clear All Slicers” button for quick reset
- Minimalist and user-friendly layout
- Coffee-themed color palette
- Easy-to-read visuals
- Suitable for both technical and non-technical users
- Sales distribution across store locations:
- Hell’s Kitchen
- Astoria
- Lower Manhattan
- Donut chart visualization for easy comparison
- Identifies top-performing branches
- Shows total items sold per store
- Helps determine high-volume locations
- Useful for inventory and operations planning
- Sales by Day: Tracks daily revenue patterns
- Sales by Month: Shows monthly trends (January–June)
- Helps identify:
- Peak sales periods
- Growth trends
- Seasonality
- Sales breakdown by product
- Top-performing products include:
- Barista Espresso
- Brewed Chai Tea
- Gourmet Brewed Coffee
- Hot Chocolate
- Identifies high- and low-performing items
- Supports product and marketing strategies
- Sales categorized into:
- Coffee
- Tea
- Bakery
- Drinking Chocolate
- Flavours
- Coffee Beans
- Includes:
- Sales value
- Sales percentage
- Items sold
- Coffee category contributes the highest share (~39%)
Coffee products generate the highest revenue share, while store performance remains balanced across locations—indicating stable operations with opportunities for targeted growth.
Note
Created with ❤️ using Microsoft Power BI by gesibell
As I continue to develop my data analytics skills, I welcome any feedback or suggestions for improvement.