Project 3: Finance Performance Dashboard – Power BI + SQL Server

Project 3: Finance Performance Dashboard –

Power BI + SQL Server

Description: A financial performance dashboard comparing “Actual vs Budget” monthly for each

department (Operations, Sales, R&D;, HR) across Revenue, Opex, and Capex, with variance

indicators and achievement percentages. Includes headcount tracking for workforce analysis.

Tools & Technologies: Microsoft Power BI (Visualization), SQL Server (Backend), DAX Measures

for variance calculations

Key Features: KPI Cards for total Revenue/Opex/Capex with variance %. Clustered or waterfall

charts for Actual vs Budget by category. Matrix table by department and month with color-coded

variance. Slicers for year, month, and department selection. Custom DAX measures for variance

and variance percentage.