Demonstration · Illustrative data · BI Consulting Services

Shoreline CPM × BI Consulting Services

Resource & Project Portfolio Board · owner-side program & construction management
Prepared for Roza
September 2026 · Power BI concept demo

Who is staffed where, and is every program still on plan?

One board for the questions Shoreline asked in early 2025: billable utilisation by person and role, staffing demand versus capacity by month, budget-to-actual hours and schedule health across healthcare, civic and science & technology programs.

Staffing demand vs. capacity by month

Hours · planned demand, staffed actuals, team capacity · dashed = next 3 months
Actual staffed hoursPlanned demandTeam capacity (80% billable target)

Resource heat-grid · allocation by person and month

Budget vs. actual hours by project

Sand = budget hours for period · blue = actual staffed hours

Active sites across San Diego County

Bubble = hours staffed in period
HealthcareGovernment & CivicScience & Tech

Ask the data

AI layer · natural-language questions over the same model
Which projects are trending over budget hours?Show me open PM demand by quarterCompare healthcare utilisation vs civic
Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min