Excel-Dashboards-Showcase

Overview

This repository contains a collection of Excel dashboards created to analyze various datasets and demonstrate Excel's data visualization and analytical capabilities. These dashboards showcase different techniques like pivot tables, slicers, charts, and KPIs to provide actionable insights.

---

Repository Structure

Excel-Dashboards-Showcase/
├── US_Superstore_Sales_Analysis/
│   ├── SuperStoreUS-2015.xlsx
│   ├── Images/
│   │   ├── Sales_Performance_Dashboard.png
│   │   ├── Product_Insights_Dashboard.png
│   ├── README.md
├── FIFA_World_Cup_Analysis/
│   ├── FIFA_World_Cup.xlsx
│   ├── Images/
│   │   ├── FIFA_World_Cup_Match_Analysis_Dashboard.png
│   │   ├── FIFA_Tournament_Trend_Analysis_Dashboard.png
│   ├── README.md
├── LICENSE
├── .gitignore
└── README.md

Projects

1. US Superstore Sales Analysis

Dashboards analyzing sales, profit, discounts, and product-level performance trends using the fictional Superstore dataset.

Key Dashboards:

• Superstore Sales Performance Dashboard:

  • Workbook: SuperStoreUS-2015.xlsx
  • Provides insights into sales and profit performance by region and manager.
  • Highlights key metrics like total sales, profit, and discounts.

• Superstore Product Insights Dashboard:

  • Workbook: SuperStoreUS-2015.xlsx
  • Analyzes product performance at the category, subcategory, and product levels.
  • Includes top 10 products by sales, profit, and discount amount.

Dataset:

• Source: Superstore Dataset (fictional retail data).
• File: SuperStoreUS-2015.xlsx

---

2. FIFA World Cup Analysis

Dashboards analyzing FIFA World Cup data, focusing on match performance, tournament trends, and team-specific insights.

Key Dashboards:

• FIFA World Cup Match Analysis Dashboard:

  • Workbook: FIFA_World_Cup.xlsx
  • Analyzes match-level data including goals scored, goal differences, and conversion rates.
  • Highlights key metrics like total goals scored, goal conversion rate, and largest goal difference.

• FIFA World Cup Tournament Trends Dashboard:

  • Workbook: FIFA_World_Cup.xlsx
  • Explores tournament-level trends in matches, goals, and attendance over the years.
  • Includes visualizations for trends in matches played, attendance, and goal distributions.

Dataset:

• Source: FIFA World Cup Dataset
• File: FIFA_World_Cup.xlsx

---

Skills Demonstrated

• Interactive Dashboards: Utilized slicers to create dynamic dashboards for filtering data.
• KPI Design: Displayed key performance metrics (sales, profit, goals) concisely.
• Trend Analysis: Visualized year-over-year trends for actionable insights.
• Category/Subcategory Analysis: Analyzed performance across hierarchical data structures.
• Pivot Tables and Charts: Leveraged Excel’s analytical tools to create meaningful visualizations.

---

How to Explore

Explore Locally:

1. Download the desired Excel file (e.g., SuperStoreUS-2015.xlsx or FIFA_World_Cup.xlsx) and open it in Microsoft Excel.
2. Navigate through the dashboard sheets for each project.
3. Use slicers to dynamically filter data and analyze trends.

---

Contribution Guidelines

• Contributions are welcome!
• To add a new dashboard:
  1. Place your project in a dedicated folder.
  2. Include the dataset, Excel files, and a README.md for your project.
  3. Update the repository's main README.md to link to your project.

---

License

This repository is licensed under the MIT License. See the LICENSE file for details.