Interactive Excel Dashboard for Sales Performance Analytics Using Pivot Tables

This project showcases a fully interactive Excel-based dashboard for analyzing sales data across products, stores, and sales representatives. Using raw transaction records, pivot tables, and dashboard visualization tools, the project enables stakeholders to monitor sales volume, revenue, and rep-level performance across time. Key Features: Data Source: Sales transactions with fields like Date, Store, Salesperson, Product, Quantity, Price, and Total Sales Pivot Table Automation: Total sales by product Performance comparison by store Rep-wise breakdowns for target monitoring Dashboard Views: Monthly performance summaries Top-performing stores and reps Dynamic product trends Technical Tools Used: Excel Pivot Tables Slicers and filters Conditional formatting Charting tools (e.g., column, bar, and pie charts) Impact: Delivers quick insights for decision-makers with no coding required Provides a lightweight alternative to BI tools like Power BI or Tableau Serves as a template for scalable sales dashboards in small to mid-sized retail settings Skills Demonstrated: Data cleaning and modeling in Excel Dashboard layout design for end-user consumption Interactive visualization techniques using native Excel tools Understanding of business KPIs and performance metrics