Date: 16 November 2025
Tools: Excel (Pivot Tables, Charts, Slicers, KPI Cards, Dashboard Layout)
๐ Project Context
This Excel dashboard supports high-level review of financial performance across FY 2013โ2014, with emphasis on profitability, cost structure, and margin behavior.
It is designed for fast, transparent analysis of Revenue, Net Profit, COGS, Operating Expenses, and performance across segments, countries, and products.
๐ฏ Decision Supported
- Review profitability trends across multiple years
- Identify margin pressure driven by COGS and operating expenses
- Compare product- and country-level performance efficiency
- Highlight segments and periods requiring deeper investigation
- Enable quick drill-down using slicers for transparent analysis
๐ซ Scope & Limitations
- Based on historical financial data only
- Designed for descriptive and diagnostic analysis
- Not intended for forecasting, scenario modeling, or prescriptive decision-making
๐งฎ Key Metrics (KPIs)