130 likes | 235 Views
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
E N D
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 • CPS Data Warehouse products and demonstration – Kelly and Robert • Future plans – Kelly and Robert • Questions – Jody, Kelly, and Robert dcf.wisconsin.gov
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
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.
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
Current BI at DCF Source Systems BI Systems
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.
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
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.
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
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