This project showcases a comprehensive financial dashboard built using Power BI to analyze and visualize key business metrics. It is designed for executive and analyst-level reporting, enabling data-driven decision-making with a clear view of company financial health.
- 📈 Revenue, COGS, and Equity KPIs with target comparisons
- 📉 YoY Growth Analysis for both revenue and sales (2016–2023)
- 📊 Variance Analysis comparing actual vs. target across products and regions
- 💰 Profitability Breakdown including Gross, Operating, and Net Profit margins
- 🧾 Expense Analysis across interest, tax, and operating categories
- 🔁 Cash Flow Insights showing Operating, Investing, and Financial cash flows
- 🧮 Balance Sheet Overview with Assets, Liabilities, Equity, ROA, and ROE trends
- 🌍 Region and Product-Level Drilldowns
- Power BI Desktop
- DAX for calculated measures
- Power Query for data transformation
- SQL for backend data extraction (assumed)
- Excel/CSV files as data sources (assumed if not from DB)
This dashboard provides a 360-degree view of financial performance through rich visual storytelling. Executives can monitor KPIs, analysts can drill down into regions or products, and the finance team can assess profitability, liquidity, and variance against targets.