SAMPLE: Vortex Civil Infrastructure × BI Consulting Services

Corridor map — progress by project

Hand-drawn NC schematic · fill length = % complete against contract value

EarnedRemaining

Weekly earthwork production — planned vs actual

Cubic yards moved per week, all crews in the selection

Actual CYPlanned CY

Earned value S-curve

Cumulative PV · EV · AC ($M)

Planned (PV)Earned (EV)Actual cost (AC)

Production by crew

Quantities in the selected period vs crew plan

Cut / fill earthwork profile

CutFill

Equipment utilisation

Operated hours ÷ available hours, by class

Safety

Recordables and hours worked in the period

Backlog by owner

Contract value remaining to earn

Data structure — proposed star schema

The "optimum data structure" you asked about: one fact per daily report line, four conformed dimensions

Every tile above is a measure over fact_daily_report (one row per crew × cost code × day) joined to dim_project, dim_cost_code, dim_equipment and dim_date. Equipment hours and safety events land as two thin secondary facts sharing the same keys, so one slicer filters all of them.

Ask the data

Natural-language layer over the same model (mock)

›

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.