Signature view · Build-season street
Every active lot on one street, placed by planned completion
Each house is one project; its fill is % of tasks complete. The bar behind it is the planned start–finish. Hover a lot for detail · overlapping bars in the same weeks are the projects competing for the same crews.
New construction
Repairs
ReStore-funded
Today (wk 23)
Trend · 24-week build season (Apr–Sep 2026)
Tasks completed vs planned, by week
Planned load comes from Project for the Web schedules; actuals from task and checklist status. Weeks after today are plan only.
PlannedCompletedShortfall
What this board answers
Three questions from the site trailer
Ranking · Schedule risk
Projects by days behind plan
Days behind = open planned tasks ÷ the project's planned daily rate. Click-through in Power BI would open the project's task list.
Resource utilization · by week
Crews, volunteers and site supervisors vs capacity
Demand is summed from every project active that week; capacity is the season plan (12 crews · 180 volunteer slots · 6 site supervisors). Cells show % of capacity; cells over 100 are the weeks where overlapping projects collide.
<70%70–100%>100%
Data integration · one semantic model
Where every number on this board comes from
Four sources refresh into one Power BI semantic model; the 2–3 dashboards read from it, so a task status changed in Project for the Web lands on the street view within the hour.
Ask the data · mock-up
Plain-English questions over the same model
Static illustration of a natural-language layer on top of the semantic model. Answers cite the visual they were read from.
The February 2025 ask · verbatim
“Delivery and support of interactive PowerBI dashboards to facilitate construction planning; recommendations for structural changes to existing Microsoft Project for the Web files; creation of 2-3 Power BI dashboards; semantic model; data integration from Microsoft PFW, SharePoint, Salesforce, Excel, CSV; ability to monitor progress of more than 10,000 tasks and checklist items across 100–200 individual projects; allow users to visually understand interactions between 20–30 overlapping projects related to task status, deadlines, assignments and resource utilization; filter and drill down into and across projects.”
From Brian's notes, February 2025. This page is a scope-definition exercise: each clause above maps to a panel.
Monitor 10,000+ tasksKPI row + trend: 10,460 tasks across the season's 28 projects, counted from PFW task and checklist rows.
20–30 overlapping projectsThe street view + utilization grid: where planned windows stack up on the same crews.
Filter & drill across projectsProgram and Window filters recalculate every panel; each house drills to its task list.
PFW structural changesSuggested: one project per lot, a standard 6-phase checklist template, a Salesforce family ID on every project.
