Tomorrow morning I am presenting to a room full of GCs, subcontractors, and controllers at the CFMA Pikes Peak Chapter. The topic they asked for: how to use Power BI for construction finance.
I already know what will happen when I ask my opening question: "Raise your hand if you opened a spreadsheet this week to answer a financial question about a job." Every hand will go up.
That is the normal state of construction finance. The data is there. It lives in your accounting system, your payroll tool, your project management software. But getting answers requires exporting, copying, pivoting, and formatting. Every week. The same reports. The same drill.
I spent 20 years in data analytics, including building a 6-person team at Delta Dental of Colorado that documented $5M in savings. I started Spry Data Partners to bring that same approach to construction and healthcare. The talk I am giving tomorrow covers three Power BI dashboards that replace the manual reporting cycle. Here is what I will be showing them.
Dashboard 1: Job Cost Tracker
This is the dashboard you open every morning. It answers one question: where do we stand on every active project?
Four KPI cards sit at the top. Total budget, total spent, budget remaining, and percent consumed. Below that, a bar chart shows budget versus actual by cost code. Red bars mean over budget. Green means on track. One click on a project name filters everything on the page.
At Delta Dental, I watched our finance team spend hours pulling similar data from three systems and reconciling it in Excel. The first time we automated that into a dashboard, the reaction was always the same: "Why did we wait so long?"
The bar chart does something spreadsheets do not. It shows you budget versus actual for every cost code on a single project in one view. Concrete over budget by $20K. Electrical on track. Finishes trending high. Your brain processes color faster than numbers. In a glance, you know which cost codes need attention.
The dashboard also pulls change order data. Two cards show approved CO totals and pending CO exposure. A "Revised Budget" measure adds approved COs to the original budget, giving you the real number to track against.
I built the demo with 12 fictional projects across 144 cost line items. The data structure mirrors what most GCs and subs export from Sage, Viewpoint, or Foundation. Nothing exotic. Standard cost codes, standard categories. If your accounting system exports data, Power BI reads it.
Dashboard 2: Cash Flow Monitor
This is the dashboard controllers care about most. Two lines on a chart. Green is cash received. Red is cash paid out.
The gap between those lines is your cash position. When the gap is wide, you are in good shape. When the lines converge, you have a problem. When they cross, you are funding operations out of pocket.
Here is a story from my healthcare work that applies directly to construction. A health system had $400,000 in accounts receivable over 90 days. Nobody was chasing it because the data was buried in a spreadsheet export that nobody opened. When we built a visual AR report, the collections team recovered $180,000 in the first quarter. Construction has the same dynamic. Outstanding receivables sit in a system somewhere. A dashboard puts them in front of the right person.
The cash flow dashboard includes a forward view. Expected cash in from accounts receivable. Expected cash out from AP commitments. The gap between them for the next 30 days. Build this view and you will see cash crunches coming before they arrive.
The dashboard has an AR aging donut chart that breaks outstanding receivables into buckets: current, 1-30 days, 31-60, 61-90, and 90+. Filter out paid invoices and you have a visual collection priority list. The darkest slice is where your team should focus first.
Dashboard 3: WIP Report
If I had to pick the one report that eats the most time for construction controllers, it is the WIP report. Most firms build it monthly in a spreadsheet. Some spend a full day on it.
In Power BI, the WIP report updates with your data. Zero hours to produce after the initial build.
The table shows the standard WIP format: revised contract value, costs to date, estimated cost to complete, percent complete, earned revenue, billings to date, and over/under billing. Auditors recognize this layout immediately. Bankers expect this level of detail when you review your credit line.
Let me put a number on it. If your controller spends 8 hours a month building this report in Excel, that is 96 hours a year. At a loaded cost of $75 an hour, you are spending $7,200 a year on a report that Power BI produces automatically after the initial setup.
When you walk into a bank meeting and pull up a live WIP report on your laptop, you are telling the banker you know your numbers in real time. You filter by project, by date range, by cost category. Live. In front of them. That level of financial visibility changes the conversation about your credit line.
The over/under billing column drives the visual story. Blue cells mean underbilled (an asset). Red cells mean overbilled (a liability). A waterfall chart shows each project's over/under contribution. The net bar at the end tells you your company-wide position in 2 seconds.
What Power BI Does Not Do
I am spending time on this in the talk because it matters more than the features.
It does not fix bad data. Inconsistent job codes, duplicate entries, naming conventions that change by who enters them. Power BI will display your bad data in beautiful charts. That does not make it useful. Clean your data first.
It does not replace your accounting software. Sage, Viewpoint, Foundation, whatever you run. Power BI sits on top of those systems. It reads a copy of the data. Think of it as a window, not a replacement.
It does not build itself. Someone on your team has to learn it. The learning curve is real. But if you have someone who writes VLOOKUP or SUMIF formulas in Excel, they have 80% of the skills already. The DAX formula language in Power BI is Excel formulas with a different name.
Getting Started: The Honest Numbers
Cost: Power BI Desktop is free. Download it from Microsoft. The Pro license for sharing dashboards is $10 per user per month. If your company has Microsoft 365 E5 licenses, Power BI Pro is already included at no extra charge. Check with your IT admin before buying anything.
Time: Your first dashboard takes 20 to 40 hours if you are learning as you go. The second takes 10 to 15. By the third, you are down to 5 to 8 hours because you reuse patterns.
Data prep: This is where most projects stall. Standardize your job codes. Fix your naming conventions. Most Power BI projects that fail do not fail because of the tool. They fail because the source data was never cleaned up.
My recommendation: pick one report. The one that eats the most of your controller's time every month. Build that one in Power BI first. Get it right. Show your team. Then build the next one.
The ROI math, the three dashboards, and the getting started checklist on a single page. Print it. Pin it to your wall. Share it with your CFO.
Download the One-Pager (PDF)The Real Question
You already have the data. Every job you bid, every invoice you process, every payroll run. It is sitting in your systems right now.
The question is not whether your firm needs better visibility into its financial data. It does. The question is whether you are going to be the person who makes it happen, or the person who rebuilds the same spreadsheet next month.
Power BI Desktop is free. The first dashboard takes a weekend of focused work. The return shows up the first month you skip a manual report build.
Start with one report. Prove the value. Then expand.
Want to See Your Own Numbers?
We build the dashboards and analytics that turn your data into decisions. 30-minute consultation. No pressure.
Schedule Free Consultation