1 / 11

Child Welfare Data Warehousing: Making Your Information Accessible

Child Welfare Data Warehousing: Making Your Information Accessible. Jody Medeke, Business Intelligence Section Chief Robert Salas, dWiSACWIS Project Manager Kelly Smithback, CPS Performance Planner. Agenda. Business Intelligence concepts - Jody Goals of CPS Data Warehouse - Kelly

Download Presentation

Child Welfare Data Warehousing: Making Your Information Accessible

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Child Welfare Data Warehousing: Making Your Information Accessible Jody Medeke, Business Intelligence Section Chief Robert Salas, dWiSACWIS Project Manager Kelly Smithback, CPS Performance Planner

  2. Agenda • Business Intelligence concepts - Jody • Goals of CPS Data Warehouse - Kelly • CPS Data Warehouse products and demonstration – Kelly and Robert • Future plans – Kelly and Robert • Questions – Jody, Kelly, and Robert dcf.wisconsin.gov

  3. Business Intelligence Concepts Business Intelligence (BI) unites data, technology, analytics, and human knowledge to optimize business decisions and ultimately drive an enterprise’s success. BI helps organize data into manageable, easy to understand parts to help the problem of drowning in data, yet starving for knowledge

  4. Business Intelligence Concepts Key Concepts • Data reconfigured for analysis and tracking trends • Ability to drill into details • Single version of the truth • Timely • Joint effort between the Program and I.T.

  5. BI Concepts continued:Success Factors Critical Success Factors for BI: • Program sponsorship and active involvement • Committed executive management sponsorship • Data quality • Mapping solutions to user requirements • User training and support • Robust and expandable framework

  6. Current BI at DCF Source Systems BI Systems

  7. Investment in CPS Data Warehouse The goal of the CPS Data Warehouse is to have: • Users understand their data quickly, easily, and accurately. • Users to take this new knowledge to make data-driven decisions.

  8. How was the CPS Data Warehouse designed? • State researchers met with state leaders and county representatives from: • Milwaukee, Barron, La Crosse, Rock, Marathon • Discussed research needs and wants as it relates to dashboards and new reports

  9. New Initial Assessment Dashboards • I.A. Executive/ Performance Dashboard: Provides a high-level overview of how the County or State is doing in terms of Initial Assessments. 2. I.A. Detail Dashboard: Provides a view into the caseload of a County, including providing information on alleged victims and alleged maltreaters.

  10. Future Plans • Reports: • Child Fatality Detail report • Child Fatality Summary report • Egregious Incidents report • Dashboards: • County comparison of I.A. information • Worker and supervisor performance dashboard • Access dashboard • Ongoing Data Warehouse: • Out-of-home care placements • Case information

  11. Questions and Contact Information • Kelly Smithback, CPS Performance Planner kellye.smithback@wisconsin.gov 608.279.3780 • Robert Salas, dWiSACWIS Project Manager robert.salas@wisconsin.gov 608.266.3793 • Jody Medeke, Business Intelligence Section Chief jody.medeke@wisconsin.gov 608.261.8862

More Related