Building D.C.'s data warehouse
- By Rutrell Yasin
- Sep 21, 2007
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.
Rutrell Yasin is senior editor for GCN covering cloud computing.