Unifying Data Across a 5-Unit Government Agency
DC's Department of Consumer and Regulatory Affairs operated five distinct business units with disconnected data systems, manual reporting, and no shared intelligence layer. We built the infrastructure to change that — from data warehouse to public-facing dashboards to predictive ML models.
160+
Hours saved in manual KPI processing per month
30,000+
Public users on dashboards within month one of launch
15%
Efficiency improvement on all permit processing jobs
5 → 1
Siloed business units unified on a single data platform
The Organization
The DC Department of Consumer and Regulatory Affairs (DCRA) is Washington DC's primary regulatory agency — overseeing building permits, business licenses, property inspections, residential regulations, and land surveying across the city. Five distinct business units, each with its own data, its own workflows, and its own reporting needs.
The agency had grown into its complexity. Each unit operated independently, with no shared data infrastructure and no common view of agency performance. Getting a cross-cutting answer required manually aggregating data from multiple disconnected sources — a process that consumed significant analyst time and introduced inconsistency.
The Challenge
-
No centralized data. Five business units (Buildings, Business, Inspections, Residential, Surveyors) operating in data silos with no shared infrastructure.
-
Manual KPI reporting. Agency KPIs were collected and assembled by hand — a process consuming 160+ hours of analyst time every month.
-
No predictive capability. Permit workload prioritization was reactive — no mechanism to identify which permits were low risk and could be expedited vs. those requiring full review.
-
No public transparency layer. The agency lacked a way to give residents and businesses access to regulatory data — an increasing priority for modern government agencies.
What We Built
Enterprise Data Warehouse
Designed and built the data warehouse that became the agency's central BI environment. Integrated data from all five business units into a single, queryable platform — powering every analytic tool deployed across the organization and for public access.
Automated KPI Pipeline
Replaced a 160+ hour/month manual process with a nightly automated pipeline that collected, validated, and delivered KPIs to the executive team through Tableau dashboards. What previously required a team and days of effort ran unattended overnight.
Machine Learning Permit Risk Model
Designed a machine learning pipeline to predict building permit risk. Low-risk permits were automatically prioritized for expedited processing — resulting in a 15% efficiency improvement across all permit jobs without reducing oversight on high-risk applications.
Property Inspection Intelligence
Conducted hypothesis testing to identify statistically significant factors in negligent property identification. The analysis produced a targeting strategy for future inspection campaigns — shifting inspections from calendar-driven to data-driven.
Public-Facing Dashboards
Launched public-facing dashboards giving DC residents and businesses access to regulatory data in real time. The platform handled over 30,000 public users in its first month — with no performance issues.
The Results
160+ hours
Saved monthly in KPI collection and reporting — time now spent on analysis, not assembly.
30,000+ users
On public dashboards in the first month — delivering transparency without burdening agency staff.
15% efficiency
Improvement on all permit processing jobs — by prioritizing low-risk applications using ML, not guesswork.
One platform
Five business units, one data warehouse, one source of truth. Leadership could finally ask cross-cutting questions and get answers in minutes.
What this means for your business
The core problem here — siloed data, manual reporting, no single source of truth — shows up in every growing business, not just government agencies. The tools change. The fundamentals don't.
If your team is spending hours every week assembling reports that should run automatically, or making decisions on data you don't fully trust, that's exactly the problem we solve.
Talk to us about your dataServices used in this engagement:
This engagement was conducted by our principal consultant prior to founding Blue Ridge Dataworks.
Ready to talk about your data?
Book a free 30-minute strategy call. No pitch, no pressure — you'll leave with at least two actionable insights about your data situation.