Back to Portfolio

Business Performance Analytics

Interactive Power BI report for business insights

Interactive Dashboard

Open in Power BIView on GitHub

About This Report

Power BIFinancial AnalysisKPIs

This Business Performance Analytics report summarizes McDonald's financial performance from 2021–2024. Built in Microsoft Power BI, it highlights headline KPIs, profitability, cost structure, and growth drivers to support fast, data-informed decisions.

Key Features & Capabilities

Executive KPI Overview

Revenue, Net Income, Profit Margin %, ROA, ROE with YoY trends

Drill-through Insights

Navigate from summary KPIs to category and regional breakdowns

Cost Composition

Operating vs Non‑Operating costs and margin analysis by year

Growth Drivers

Revenue mix (Franchised, Company Operated, Other) and YoY growth

Technical Implementation

  • Data Source: Kaggle – McDonald's Financial Data 2021–2024
  • Model: Flat table with calculated measures for KPIs and margins
  • Refresh: Manual refresh aligned with dataset updates
  • Visuals: Cards, gauges, line and bar charts, composition donuts, KPI tables

How to Use

  1. Scan KPIs: Review headline metrics and YoY trends on the overview
  2. Compare costs: Review operating vs non‑operating cost composition
  3. Assess growth: Analyze revenue mix and growth alongside profitability

Quick Info

Technologies Used

Power BIDAXFinancial KPIsData Visualization
McDonald's 2021–2024 financials (Kaggle‑sourced)