This project is a McDonald's South America Sales Dashboard for 2024, built to visualize key performance metrics, sales trends, customer satisfaction, and country-wise sales data in an interactive and visually appealing format.
The dashboard provides actionable insights for decision-making by consolidating all relevant KPIs into one place.
- Key KPIs
- Sales, Profit, and Number of Customers with progress toward targets
- % completion vs. remainder
- Sales Trend Analysis
- Year-over-year monthly comparison (2023 vs 2024)
- Geographical Sales Distribution
- Country-wise sales mapped on South America
- Customer Satisfaction Metrics
- Speed, Quality, Hygiene, Service, and Availability
- Detailed Tables
- Sales figures by month
- Sales figures by country
- General Manager contacts by country
- Total Sales: $2,544M (85% of target achieved)
- Profit: $890M (89% of target achieved)
- Customers: 87M (87% of target achieved)
- Top Country by Sales: Argentina ($953.3M)
- Best Customer Satisfaction Metric: Availability (95%)
- Lowest Customer Satisfaction Metric: Service (53%)
- Tool: Microsoft Excel (Power Query, Pivot Tables, Charts)
- Data Visualization: Custom dashboards with slicers, maps, and charts
- Map Visualization: Bing Maps integration
📦 mcdonalds-sales-dashboard-2024 ┣ 📂 images ┃ ┣ Dashboard.png ┃ ┣ Input.png ┃ ┗ Contact.png ┣ 📜 README.md ┗ 📜 McDonalds_Sales_Dashboard_2024.xlsx
yaml Copy Edit
- Clone the repository:
git clone https://github.com/yourusername/mcdonalds-sales-dashboard-2024.git
Open the Excel file: McDonalds_Sales_Dashboard_2024.xlsx
Interact with the dashboard using slicers and filters to explore data.