Demonstration · Illustrative data · BI Consulting Services

Transition Program Dashboard × BI Consulting Services

The 60-day countdown board — staffing, offers, site performance and weekly activities for a four-site base-operations transition, built from Nicole's December 2024 data spec.

Prepared for NicoleSeptember 2026 · Power BI on SharePoint concept

Site

Week

Days left in transition

60-day countdown

Updated daily by the Transition Manager · transition runs 60 days

Sites

Four-site transition route — BEC · BDSC · UIII · Erbil

Schematic, not to scale · each node links to that site's program org, schedule and deliverables · ring = positions filled vs plan

Staff positions filled

Americans · Third Country Nationals · Local Nationals vs plan

Running totals, daily from HR Specialists · tick = planned positions

Hiring trend

Cumulative hires by day — actual vs plan curve

Day 1 to selected as-of day · dashed = plan to Day 60

Offers

Offers made → accepted → onboarded

Daily from HR · funnel against planned positions

Performance

Six functional areas by week — Staffing / Fuel / Food / Utilities / O&M / Inventory

Weekly readiness score from each area Lead (0–100) · hatched = not yet reported

Weekly activities

Week 6 activities

Weekly from the Transition Manager

What this board answers

Three questions Nicole asked

Each answered with a number from the board, for the current filter

Ask the data

Natural-language layer over the same model

Mock-up · answers cite the panel they came from

🔍

Which site is behind on TCN hiring?Show fuel readiness by weekOffers still open at Erbil

Documents

Site document tiles — Program Org · Schedule · Deliverables

Stored on the SharePoint site alongside the dashboard · placeholders, version-stamped · tiles outside the selected site are dimmed

Also from BI Consulting Services

Private AI on your own server

The "ask the data" panel above is built to run on a GPU server inside your own network: an open-weight model over your own documents, with every answer citing the file it came from. No per-seat licence, works offline, and nothing leaves the building.

How it sits in your environment

One appliance-class server on your rack or in a secured closet. Your files are indexed where they already live; the model runs locally; answers come back with the source page attached.

What that means in practice

1
Your data only, on your hardwareAn open model over your own documents and exports. No third-party AI processor, no data-transfer agreement to review.
2
Every answer cites its sourceReplies point to the file and page they were drawn from, so people check the answer instead of trusting it blind.
3
No per-seat licenceThe whole team can ask questions. Cost is the server and our build, not a monthly number that grows with headcount.
4
Works offlineIf the internet connection goes down, the answers still come. Nothing depends on a vendor's uptime or pricing changes.