Coffee Sales Performance Analysis using Excel dashboards
RoleData Analysis, Sales Trend Analysis, Dashboard Design, Data Cleaning, Business Insights
Year2026
Project Details
This project analyzes coffee sales data to understand sales trends, product performance, and customer purchasing patterns. Raw data was cleaned and transformed using Excel formulas and Power Query. Interactive dashboards were built using Pivot Tables, charts, slicers, and KPIs to track monthly sales, top products, peak days, and revenue contribution. The dashboard provides clear, management-ready insights to support data-driven decision-making and improve overall sales performance.
Skills
Data Analysis, Sales Trend Analysis, Dashboard Design, Data Cleaning, Business Insights
Tools
Microsoft Excel, Pivot Tables, Charts, Slicers
