Sales Dashboard

This project highlights transforming raw sales data into actionable insights through a comprehensive and interactive Excel Sales Dashboard:

• Data Transformation: Cleaned and standardized raw data for accuracy and robust analysis.
• Dynamic Analysis: Enabled flexible data exploration using interactive pivot tables and dynamic KPIs (e.g., total sales, profit percentages, top products, and categories).
• Visual Storytelling: Designed compelling dashboards with charts and infographics to illuminate trends, patterns, and performance metrics.
• Macro Automation: Streamlined repetitive tasks with custom macros, enhancing efficiency and freeing time for strategic decision-making.
• Engaging Insights: Delivered scrollable bar charts, dynamic column charts, and intuitive pie charts to analyze sales by time, product, and payment method.

This project demonstrates expertise in data cleaning, dashboard design, and process automation, making complex data accessible and actionable.