SAMPLE: Blue Sky Farms × BI Consulting Services

Trend · last 12 months

Milk per cow per day, actual vs weather-adjusted

Heat penalty removed above THI 68 so the herd's real trend is visible under a Panhandle summer

Actual lb/cow/dayWeather-adjustedBudget 80 lbTemperature-humidity index (THI)

What this board answers

Three questions from the discovery call

Signature view · site coverage

Dairies and irrigated farm ground across Texas, New Mexico and Kansas

Marker size = milking cows · fill = cost per cwt vs budget · each pivot circle ≈ 1,000 acres of feed ground · click a dairy to filter

At or under budgetOver budget cost/cwtNot in baseline (heifer yard · Twin Circle KS ramping · Westland NM · management)Pivot (~1,000 ac)

Input costs vs budget

Cost per cwt by category

Feed, labour, fuel & energy, repairs, crop inputs, other — actual against the $19.00 plan

Actual under budgetActual over budgetBudget

Ranking · by dairy

Cost per cwt and milk per cow, best to worst

Dairy	Cows	lb/cow/d	Feed $/cwt	Total $/cwt	vs $19.00 budget

Farming units · feed grown

Harvest by crop and days of feed on hand

Corn & sorghum silage, alfalfa, triticale/wheat, haygrazer from the farms supplying the selected dairies

Crop	Acres	t/acre	Tons in period	Share of harvest

Data capture · replaces the spreadsheet

Daily parlor log, submitted from a phone

A Power Apps / Microsoft Forms tile the herdsman fills at end of shift; it lands in the model directly

Parlor log · PM shiftAuto-synced

Dairy

High Plains Dairy

Date

Sat 5 Sep 2026

Cows milked

4,790

Milk shipped (lb)

386,240

Bulk tank SCC (k/mL)

168

Feed delivered (t as-fed)

132.4

Notes / exceptions

Pen 7 fans out 40 min — maintenance ticket raised

Submit logValidated on entry · no re-keying · 38 sec median fill time

Phone form→Dataverse→Power BI model→This board, 06:00 daily

Ask the data · AI layer

Plain-English questions over the same model

A typed question, answered with figures and a pointer to the panel that proves it

Which dairy had the highest feed cost per cwt this summer, and what drove it?

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.