McDonald-s-South-America-Sales-Dashboard-2022

McDonald's South America Sales Dashboard (2022)

? Project Overview This comprehensive dashboard provides an executive-level view of McDonald's sales performance across the South American market for the year 2022. The project focuses on monitoring key business metrics, geographic revenue distribution, and operational quality through customer satisfaction scores.

? Business Key Performance Indicators (KPIs) The dashboard tracks performance against set targets for the year 2022:

Total Sales: $2,544M (85% of the $3,000M target).

Total Profit: $890M (89% of the $1,000M target).

Customer Count: 87.0M customers (87% of the 100M target).

?️ Dashboard Features & Analysis Geographic Sales Map: A detailed heat map showing revenue by country, with Argentina ($953.3M) and Brazil ($553.2M) leading as the top markets.

Year-over-Year (YoY) Sales Trend: A comparative line chart showing monthly sales growth from 2021 to 2022, highlighting a consistent upward trend in the latter half of the year.

Customer Satisfaction Radar: A multi-dimensional analysis of service quality, including:

Hygiene: 93%

Quality: 86%

Availability: 95%

Service & Speed: (Average 53-54%)

Regional Contact Management: A dedicated section for General Managers and communication channels for each country.

? Project Structure The project is organized into three main areas:

Executive Dashboard: The primary visual interface for stakeholders.

Data Inputs: Structured monthly sales data and KPI breakdown for 2021 and 2022.

Contacts: A directory of regional leadership and management.

? Technical Skills Used Advanced Data Visualization: Creating Radar (Spider) charts, Heat Maps, and Ring Gauges.

Excel Dashboard Design: Implementing a clean, brand-aligned UI with intuitive navigation.

Financial Modeling: Calculating Target Completion percentages and YoY growth trends.