top of page

Business Intelligence Dashboards

Some of the Projects I've done for my clients.

Data privacy note:

All project visuals are presented with anonymized and AI-generated sample data. Original client information (including names, numbers, and identifiers) has been removed. No confidential or personally identifiable client data is displayed.

FP&A Budget Dashboard

A regional finance team from a multinational firm needed fast, reliable Budget vs Prior Year insight across countries, business units, segments, practices and lines of business. I automated the database extractions from core financial systems, outputting standardized Excel files. From there, I built an end-to-end Power BI solution that ingests those extracts, validates and normalizes data, models it for flexible analysis, and delivers secure, drillable views for executives and country finance teams.

image002.png

Key Value I Delivered

  • Owned full Extract–Transform–Load pipeline: source queries, export to Excel, ingestion, schema & data validation, dimensional mapping,  currency normalization, model load.

  • Built star-schema data model (time, country, BU, account, scenario) for scalable reporting.

  • Authored dynamic DAX measures: Budget, PY, $ / % variance, scenario comps, unit scaling.

  • Implemented Row-Level Security for regional vs local visibility.

  • Designed drillable UX (region, country, account) with variance color thresholds.

  • Scheduled automated refresh + failure alerts, cutting consolidation effort.

  • Delivered exec-ready layouts, documentation, and finance team training.

image001.png

Travel Expense Dashboard

Global travel expense was scattered across exported expense files, vendor feeds, and budget trackers, making it hard for finance to see Month-to-Date (MTD), Year-to-Date (YTD), Budget, Forecast, and Prior-Year variances by country, business unit, and vendor. I built an end-to-end Power BI travel expense reporting solution: I extracted recurring data drops from the firm’s travel/expense and GL systems, ran automated ETL to cleanse vendor names, map departments, normalize currencies, and align calendars, then modeled the data for fast comparison and drillable analysis across regions and vendors.

image001 (1).png

Key Value I Delivered

  • Owned full Extract–Transform–Load pipeline: source system exports, validation, vendor normalization, currency conversion, model load.

  • Modeled MTD, YTD, Forecast, Budget, Prior Year measures with $ / % variance and growth logic in DAX.

  • Built interactive slicers (month, vendor) enabling instant analysis.

  • Created trend, variance, and allocation visuals plus detailed tabular views for audit & reconciliation.

  • Added data quality rules to flag missing months, negative values, and unmapped vendors.

  • Implemented scheduled refresh + failure notifications to finance stakeholders.

  • Delivered training so regional teams can self-serve and export review packs.

image002 (1).png
bottom of page