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 ServerEBI 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 MinerThese tools provide an advanced analytic framework to begin generating offender typologies needed to focus on intervention efforts.
SAS Stat and ETSSAS 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 senior editor for Government Computer News. Follow him on Twitter: @Yasin36.