Skip to content
← Work

Professional work · University of Denver — Daniels College of Business

The Data System Behind Elevate 2035

Building the data and review system that connects Daniels' Elevate 2035 strategy to measures, faculty evidence, department action, and Dean's Office review.

active · July 2026 — Present

Method chain

A verified sequence, not a decorative process diagram.

  1. Turn approved strategy language into agreed definitions and records with named owners.
  2. Reconcile each measure with its reporting period, custodian, source of truth, and known exceptions.
  3. Give faculty, department heads, and the Dean's Office each the evidence their role needs.
  4. Route incomplete, disputed, or consequential evidence through human review and escalation.
  5. Preserve provenance, decisions, and approved amendments as traceable institutional history.

The Work in Four Facts

The problem. Daniels College of Business adopted the Elevate 2035 strategy, but the information needed to track it lived in separate systems that could answer the same question differently — definitions, sources, owners, and reporting periods unresolved.

What Kyle built. A centralized Supabase/Postgres reporting system that brings approved inputs from five source systems — Airtable, Watermark, Banner, Slate, and Salesforce — under agreed definitions, reporting rules, role-based views, and review workflows.

His role. As Manager, Data and Analytics at the University of Denver — Daniels College of Business, Kyle designs and implements the system: the data model, the reporting rules, the access model, and the review workflow.

The scope. Strategic measures, faculty evidence, department action, and Dean's Office review — three user groups reading role-appropriate views of one governed framework, live since July 2026 and deployed in stages.

Sanitized architecture diagram: Airtable, Watermark, Banner, Slate, and Salesforce feed one governed Supabase/Postgres store — agreed definitions, reporting rules, role-based access, provenance — which serves faculty, department heads, and the Dean's Office; a review and amendment workflow returns approved changes to the store as versioned history.

What the System Does

  • Governs the strategic framework — versions, pillars, goals, measures, targets, observations, initiatives, and dependencies share one controlled structure.
  • Enforces reporting rules — a measure reports a status only when it has an approved definition, an accountable custodian, a source of truth, a relevant reporting period, known exceptions, a current observation, and an approved target or comparison rule.
  • Separates kinds of evidence — outcomes, delivery, contribution, and data readiness remain distinct measurement lenses rather than one collapsed percentage.
  • Keeps readiness visible — missing definitions, custodians, sources, baselines, or approved targets appear as work to resolve, not as false performance signals.

Three User Groups, Three Views

Faculty members see their own evidence, initiatives, research, timeline, amendment history, and the strategic criteria used to organize that information.

Department heads see the evidence and decision work within their departments, with college-level context presented at an appropriate level of aggregation.

The Dean's Office sees the college register: strategic measures, readiness gaps, department contributions, initiative dependencies, evidence-review queues, and items awaiting judgment.

The same governed framework serves each audience without exposing information beyond that audience's responsibility.

Review Workflows

Definitions are versioned and historical observations are retained. Faculty can flag inaccurate or missing evidence; department heads review the request; the Dean's Office approves, returns, or rejects it. An approved amendment creates a new governed version while preserving the prior value and the decisions that produced the change.

Automation handles stable, repeatable steps with explicit inputs and reviewable outputs. It does not replace ownership when definitions conflict, classifications are ambiguous, or a consequential judgment is required.

From the writing

What Makes a Quantitative Claim Credible?

A credible quantitative claim makes its question, data, failure criteria, uncertainty, reproducible artifacts, and decision boundary inspectable.

Operating disciplines

Data governanceInstitutional analyticsBusiness intelligenceSource validationWorkflow automation