You will get a government-grade Excel invoice tracking system for multi-agency billing
Project details
You will receive a fully interactive Power BI dashboard and/or Excel-based Master Invoice Tracker customized for your government program, healthcare agency, or multi-vendor contract.
I built a $97M+ invoice reconciliation system for the California Department of Public Health (CDPH, FY 2022-23) — tracking 327+ invoices across 10 staffing agencies, with audit-ready reporting, variance analysis, and an executive-level Power BI dashboard with KPI cards, trend charts, and dynamic filters.
What I deliver:
✔ Custom Power BI dashboard (KPI cards, bar/trend charts, slicers by date, status, vendor, and category)
✔ Excel Master Invoice Tracker with reconciliation logic, progress tracking, and summary reports
✔ Clean, auditable data structure ready for FEMA, government, or executive review
✔ Clear documentation and walkthrough
Whether you need to track staffing invoices, grant disbursements, or contract payments — I bring the analytical rigor and government-level attention to detail your program deserves.
I built a $97M+ invoice reconciliation system for the California Department of Public Health (CDPH, FY 2022-23) — tracking 327+ invoices across 10 staffing agencies, with audit-ready reporting, variance analysis, and an executive-level Power BI dashboard with KPI cards, trend charts, and dynamic filters.
What I deliver:
✔ Custom Power BI dashboard (KPI cards, bar/trend charts, slicers by date, status, vendor, and category)
✔ Excel Master Invoice Tracker with reconciliation logic, progress tracking, and summary reports
✔ Clean, auditable data structure ready for FEMA, government, or executive review
✔ Clear documentation and walkthrough
Whether you need to track staffing invoices, grant disbursements, or contract payments — I bring the analytical rigor and government-level attention to detail your program deserves.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$1,500
|
Standard
$3,000
|
Advanced
$5,000
|
|---|---|---|---|
| Delivery Time | 5 days | 10 days | 14 days |
Number of Revisions | 1 | 2 | 3 |
Frequently asked questions
About Cristina
Power BI Dashboard & Data Analyst | Government, Housing & Construction
Houston, United States - 5:15 pm local time
With 16+ years of experience in data analytics, infrastructure programs, and government-funded projects, I specialize in building reporting systems for housing, construction, and public-sector programs.
I currently support large housing recovery and infrastructure programs, designing data models, dashboards, and reporting tools used by leadership teams to track funding, compliance, and project performance.
What I can help you build:
✔ Power BI dashboards for executives and program managers
✔ Data models connecting Excel, databases, and cloud systems
✔ KPI dashboards for housing, construction, and infrastructure programs
✔ Automated reporting for funding, grants, and compliance
✔ Data cleanup and transformation using Power Query
✔ Reporting systems for QuickBase, Excel, and project management tools
Industries I work with most:
• Housing programs
• Construction and infrastructure
• Government and public sector programs
• Disaster recovery and grant-funded projects
• Real estate development
Tools I use
Power BI
Power Query
Excel Advanced Modeling
QuickBase
Data Cleaning & Transformation
Dashboard Design & Data Storytelling
Clients work with me when they need clear reporting, reliable dashboards, and better visibility into their data.
If you're looking for someone who understands both the data and the operations behind complex programs, I’d be happy to help.
Let's build dashboards that make your data actually useful.
Steps for completing your project
After purchasing the project, send requirements so Cristina can start the project.
Delivery time starts when Cristina receives requirements from you.
Cristina works on your project following the steps below.
Revisions may occur after the delivery date.
Discovery & Structure Design
Review your data, map out all agencies and invoice fields, design the workbook architecture with all required tabs and naming conventions.
Data Entry & Formula Building
Build per-agency sheets with lookup formulas, accounting status tracking, warrant/claim schedule columns, and automated reconciliation calculations.