This project showcases an interactive Excel dashboard designed for data analysis and visualization. The dashboard provides insights from structured datasets, enabling users to track key performance indicators (KPIs), trends, and patterns efficiently.
By leveraging Excel's advanced features, such as Pivot Tables, Charts, Slicers, Conditional Formatting, and Power Query, this project demonstrates how to create an effective data-driven reporting tool.
- 📊 Dynamic Pivot Tables: Enables quick analysis and filtering of key metrics.
- 📈 Interactive Charts & Graphs: Includes bar charts, line graphs, pie charts, and more for intuitive data visualization.
- 🔍 Slicers & Filters: Provides user-friendly options to segment and explore data.
- ⚡ Power Query Automation: Automates data cleaning and transformation processes.
- 🎨 Conditional Formatting: Highlights trends, anomalies, and key insights dynamically.
- 📂 Customizable Dashboard Layout: Designed for ease of use and scalability.
- Tool Used: Microsoft Excel
- Features: Pivot Tables, Charts, Power Query, Slicers, Conditional Formatting
- Data Sources: CSV, Excel
- All the required business question that have been asked and the answers are provided in the screenshot as an excel dashboard.