Financial Performance & Profitability Dashboard

📌 Overview

Interactive fiscal reporting dashboard covering 5 years of revenue, expense, and net profit data across 3 business segments.

🛠️ Tools Used

• Power BI (Advanced DAX)
• Excel
• Financial Reporting

📊 Key Features

• 5-year multi-segment profitability analysis
• 8+ automated KPI calculations
• Profit margin %, cost efficiency ratio
• YoY revenue growth tracking
• Multi-year benchmarking

🔍 Key DAX Measures

• Profit Margin %
• Cost Efficiency Ratio
• YoY Revenue Growth
• Segment-level aggregations

🔗 Live Dashboard

View Live Dashboard

💼 Business Impact

Reduced manual reporting effort by 40% and eliminated formula errors through custom DAX automation across 8+ KPIs.