04 · POWER BI · DAX · FINANCIAL ANALYTICS

Grant Financial Analytics & Reporting Dashboards

Overview

Built a centralized Power BI reporting system for grant and cost-center review, with a Databricks data-processing layer that automated a preparation process which used to take two days. One data model with DAX measures and Power Query transformations sits behind a grant overview, current-month verification, and payroll / non-payroll drilldowns.

Details

Key result1,074 — recurring reports automated

Stack

Power BIDatabricksDAXPower QueryPythonSQLPeopleSoft

1,074reports automated

50%manual work reduced

11+departments

10+dashboard views

Next projectCost Center Verification App — Monthly Manager & DBA Sign-off →

Evidence note — sample data

The dashboards below are real — every figure, name, and ID shown in them has been replaced with fabricated sample data. The actual grant, financial, and employee records are private and are not shown.

Grant cost center financial overview with total budget, expenses, commitments, available balance, and budget-vs-expenses breakdowns by status. Underlying dollar figures are sample data for privacy; the charts reflect the real shape of the dashboard.

High-level grant view with budget, expenses, commitments, balance, funding dates, and cost-center status. Shown with sample data to protect real grant and personnel records.

Monthly review screen for selecting a cost center and checking budget, payroll, non-payroll, and fiscal-period activity. Shown with sample data to protect real financial records.

Detailed employee-level payroll view with award, project, speed type, fiscal year, period, and date filters. Shown with sample data to protect real employee payroll records.