OBT Consulting
Utilities & Field Safety

SDG&E, Safety Performance Dashboard

Executive dashboard showing where violations concentrate, which sites are trending worse, and which contractors need an audit next.

What this is

The reporting layer built on the same governed model as the conversational assistant. One foundation, two ways to consume it: ask a question, or scan the dashboard.

The challenge

Safety reporting existed, but every business unit produced its own version with different totals. Leadership spent meetings reconciling numbers instead of acting on them.

What we built

A Power BI dashboard reading from the single source of truth, with contractor ranking, severity filtering, and GPS-tagged observation mapping. The same numbers appear in every view because they come from the same model.

  • Contractor ranking with rank-and-filter interaction
  • Violation concentration by site, severity, and business unit
  • GPS-tagged observation map for field context
  • Trend direction highlighting which sites are worsening
Time OptimizationReal-time vs monthly
Resource Optimization1 architect
Business IntelligenceViolation concentration
Business ImpactCost optimization

Live Dashboard

The working Power BI style dashboard, embedded below. Use the rank and filter controls to drill into any contractor or site.