Demonstration · Illustrative data · BI Consulting Services

Cardinal Health × BI Consulting Services

Environmental Health & Safety · Site-safety scorecard prototype
Prepared for Caleb · Environmental Health & Safety
September 2026 · Snowflake → Power BI · role-based access
EHS COMMAND BOARD · v0.9 PROTOTYPE

One board for TRIR, DART, near misses and audits — across every Cardinal Health site, refreshed from Snowflake, not Excel.

Every tile, chart and sentence below recalculates when you change Region, Business segment or Period. This is the 4–5 page report described in the April 2025 proposal, compressed to a single page so you can feel how it behaves.

Region
Segment
Period
Incident trend

Monthly recordables and rolling-12 TRIR vs industry benchmark

Recordables / monthRolling-12 TRIRBLS benchmark (segment-weighted)
What this board answers

Three questions the EHS team asks every month

Site coverage · signature view

US facility map — each dot is a site, coloured by TRIR band

TRIR < 2.02.0 – 3.5> 3.5Dot size = hours worked
Site ranking

Highest TRIR sites in scope

Near-miss funnel

Reported → investigated → closed

Safety pyramid

Leading vs lagging indicators in scope

Audit completion

Completed vs planned EHS audits

Ask the data · AI layer (mock)

Natural-language questions over the same Snowflake model

Answers cite the visuals above
Which sites drove the Q2 2026 rise in recordables?
Show DART by segmentSites with overdue auditsNear-miss closure > 30 daysCompare to same period last year
Illustrative interface. In production this runs against governed Power BI semantic models with the same row-level security as the report pages, so a regional EHS lead only ever sees their own sites.
    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