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.


  • 2020 Government Innovation Awards
    Government Innovation Awards -

    21 Public Sector Innovation award winners

    These projects at the federal, state and local levels show just how transformative government IT can be.

  • Federal 100 Awards
    cheering federal workers

    Nominations for the 2021 Fed 100 are now being accepted

    The deadline for submissions is Dec. 31.

Stay Connected