Town Team Sales Dashboard

Town Team Sales Dashboard This dashboard was built using Microsoft Excel to analyze sales performance and provide clear business insights through interactive visualizations. Key Metrics: Total Sales: EGP 273,380 Number of Orders: 305 Average Sales: EGP 896 Product Count: 10 Dashboard Features: Sales by Items: Identifies the best-selling products and compares their sales performance. Sales by Category: Analyzes revenue distribution across different product categories. Order Types: Shows the proportion of sales by order channel. Monthly Sales Trend: Tracks sales performance over time to identify patterns and trends. Year Filter: Allows users to analyze data dynamically for different years. Skills Applied: Data Cleaning Data Analysis Pivot Tables Pivot Charts Dashboard Design Data Visualization Interactive Reporting using Slicers Business Value: The dashboard helps decision-makers monitor sales performance, identify top-performing products, understand customer purchasing behavior, and track sales trends over time.