Food and Beverages Sales Dashboard using Microsoft Excel
- Built using Microsoft Excel
- Data transformation and cleaning applied
- Macro automation used for UI enhancement (Clear Filters button)
- Dynamic filters for Year, Manager, Supervisor, and Salesperson
- Enables users to drill down into specific segments for deeper analysis
- Includes a “Clear All Filters” macro button for instant dashboard reset and improved usability
- Clean and consistent layout with intuitive navigation
- Color-coded visuals for easy interpretation
- Designed for quick executive-level decision making
- Monthly sales visualization with trend line to track performance over time
- Highlights peak and low-performing months for quick insights
- Helps identify seasonality and revenue patterns
- Displays key metrics:
- Total Sales ($20.37M)
- Total Units Sold (6.63M)
- Average Monthly Revenue
- Includes year-over-year comparison (%) to track growth performance
- Sales distribution by category (Food vs Drink)
- Clearly shows dominance of Food category (~93%)
- Helps identify dependency risks in product mix
- Revenue split across:
- Retail
- Distributor
- Online
- Highlights strongest channel contribution and opportunities for expansion
- Top 10 and Bottom 10 selling products
- Identifies:
- High-performing SKUs driving revenue
- Underperforming products needing attention
- Sales contribution by:
- Manager
- Supervisor
- Salesperson
- Includes ranking system for Top Performers
- Supports performance evaluation and incentive planning
- Built-in narrative insights summarizing:
- Revenue performance
- Category risks
- Channel dominance
- Provides data-driven recommendations for decision-making
Note
Created with ❤️ by gesibell
As I continue to develop my data analytics skills, I welcome any feedback or suggestions for improvement.