Coffee Sales Dashboard in Excel (Interactive Analysis & KPIs)
تفاصيل العمل
I developed an interactive Excel dashboard to analyze coffee shop sales data and provide clear insights into business performance. The dashboard includes data cleaning, structuring, and analysis to transform raw data into meaningful visual insights. I used pivot tables, charts, and slicers to create an easy-to-use and interactive experience. Key features of the dashboard: Sales analysis by time of day Sales trends across days of the week Product category performance analysis Interactive filtering using slicers Clear visualizations using bar charts and line charts Organized layout for easy understanding and decision-making The goal of this project was to help business owners understand sales patterns, identify peak times, and optimize product offerings to increase revenue. This project demonstrates my ability to build professional dashboards in Excel and turn data into actionable insights.
مهارات العمل