Interactive Sales Dashboard Using Excel, Power Query & Power Pivot

Developed a complete Data Analysis project using Microsoft Excel, starting from raw data and ending with an interactive dashboard for business insights.

Project Highlights:

• Data Cleaning and Transformation using Power Query

• Data Modeling and Relationships using Power Pivot

• Creating DAX Measures for KPI calculations

• Data Analysis using Pivot Tables

• Interactive Dashboard Design using Charts and Slicers

Key KPIs:

• Total Sales

• Total Customers

• Quantity Sold

The final dashboard included 6 interactive charts that provided clear insights into sales performance and customer behavior. The project was designed to help users explore data efficiently and make data-driven decisions through dynamic filtering and visualization.

Tools Used:

Microsoft Excel, Power Query, Power Pivot, DAX, Pivot Tables, Data Visualization, Dashboard Design