Building D.C.'s data warehouse

The Court Services and Offender Supervision Agency for the District of Columbia has deployed a data warehouse that officials can use to monitor and supervise the more than 20,000 ex-offenders in the city. The backbone of the agency is the Supervision and Management Automated Records Tracking (SMART) case management system. A new component, the SMART-STAT Web portal, gives managers visibility into the outcome of offender supervision and treatment.

The environment runs on a SAS 9 platform and consists of a Microsoft Windows server on which the following technologies are loaded.

SAS Enterprise Data Integration Server

EDI provides a way to build and manage the Enterprise Data Warehouse that supports SMART-STAT and other forms of management reporting and intelligence-building exercises.

SAS Enterprise BusinEss Intelligence Server

EBI provides CSOSA a way to develop and surface reports via a portal, providing SMART-STAT intelligence to executives, managers and supervisors within the agency.

SAS Enterprise Miner and Text Miner

These tools provide an advanced analytic framework to begin generating offender typologies needed to focus on intervention efforts.

SAS Stat and ETS

SAS Stat and ETS provide CSOSA analysts and statisticians with an environment to explore the data warehouse and other data sources for potential new areas of management and performance reporting.

About the Author

Rutrell Yasin is is a freelance technology writer for GCN.

Reader Comments

Please post your comments here. Comments are moderated, so they may not appear immediately after submitting. We will not post comments that we consider abusive or off-topic.

Please type the letters/numbers you see above