LA Coordinated System of Care

Emergency.Louisiana.gov

Data Warehouse

Background

The agencies current data warehouse technology was implemented in late 2007 when it was deployed to help analyze the data that was contained in the organizations old Mapper and Case Management systems.  With the introduction in 2009 of the new JETS system that replaced these old legacy systems the data warehouse had to be recreated from scratch to access the new database file structures and additional data that was being collected.

The technology and software platform of the OJJ data warehouse is from a company called SAS.  SAS is a key provider in business analytics software and services and is one of the largest independent vendors in the business intelligence market.  Additionally OJJ staff has benefitted from specialized training in programming, macros, server optimization, statistical analysis and managing data.


Implementation

The analytics platform provides OJJ with an integrated environment for the collection, classification, analysis and interpretation of data to reveal patterns, anomalies, key variables and relationships.  It is also beneficial for indentifying, monitoring and measuring quality processes over time and is key for measuring performance based and quality assurance standards.  In the future we hope to utilize the technology for data mining, text analytics and forecasting.  In short, it enables OJJ to turn a vast amount of data from multiple sources into meaningful information that is used by the agency every day.
 
The technology differs from our JETS transactional system that is geared for data entry in a normalized relational format.  The data warehouse structure utilizes datasets that are created nightly.  The file structure is an arrayed, flat, redundant format.  These datasets are optimized for analysis and reporting and integrated over multiple systems.  Analysis and reports can be requested by management by ad hoc reports directly from the data warehouse staff (almost daily), running stored processes that provide information in saved reports, some that allow for time variables or from a web based decision support system that enables users to create reports to address a broad-range of management questions using a simple point-and-click interface.  The interface accesses the full-range of datasets available for both present and past fiscal or calendar years. It enables selective analyses by admissions, discharges, census, and persons served, arrayed for a full range of variables (e.g., age, race, gender, legal status, etc.), and reports can be organized by various OJJ program levels (e.g., statewide, region, parish, judicial district).  It is the tool that allows OJJ to develop trends.

It is also the platform the agency has used in sharing data and for annual surveys, some examples include:
 

  • Louisiana Commission on Law Enforcement
  • Office of Juvenile Justice and Delinquency Prevention
  • Picard Center for Child Development
  • Vera Institute of Justice
  • National Center for Juvenile Justice
  • Department of Children and Family Services
  • Department of Education
  • University of New Orleans
  • Council of Juvenile Correctional Administrators (CJCA)
  • MacArthur Foundation Models for Change Research
  • LEEDS/Education
  • Performance Based Standards (PBS)
  • US Census Bureau
  • Prison Rape Elimination Act (PREA)
  • National Council of Juvenile and Family Court Judges


For more information contact: Will.Paulson@LA.GOV