Using Data in Child Welfare and Youth Justice Practice Child Welfare practice is documented in the case management database eWiSACWIS. Data is provided back to agencies to allow for an understanding of caseload. Use this page to learn how to find and use data related to your agency’s child welfare and youth justice cases. Find Data Related To Your Caseload There are a number of child welfare dashboards that may be found in eWiSACWIS. These dashboards are web pages where you may learn about a topic of interest (e.g. Access, or Workload Management). The eWReports User Guide provides a description of the dashboards. This guide also has instructions on how to access the dashboards. There are many reports available in eWReports that summarize information workers enter in eWiSACWIS. These reports are usually formatted as spreadsheets. The eWReports User Guide offers instructions on how to get permission to download and use these reports. The Most Frequently Used Child Welfare and Youth Justice Report Guide ("Reports-Frequently Used" in the eWiSACWIS Quick Links tab) provides descriptions of reports you may find helpful. The Reports Catalog, a descriptive list of all reports, is available in eWReports as a link in the navigation bar. Tableau Dashboard Quick User Guide covers the basic components of dashboards. eWiSACWIS Knowledge Web The eWiSACWIS Knowledge Web provides user guides and videos to assist with child welfare case work. It is also accessible in the Quick Links tab within eWiSACWIS. Lunch & Learn Sessions Listen in and ask questions during Lunch & Learn conversations. These talks are to assist staff in learning more about their agency’s casework. A DCF Research Analyst will provide an overview of a data report or dashboard. A question/answer period will follow. If you are having problems joining the Skype Meeting, try the Skype App. Discussion Topic Invitees Date Time Skype Meeting Link Phone Number & Participant Code Child Welfare Worker Dashboard Internal DCF Staff 3/09/2020 Monday 11:30am-12:30pm Please email DCFCWRA@wisconsin.gov for room information and webinar link. Child Welfare Out-of-Home Care Dashboard All eWiSACWIS Users 3/30/2020 Monday 11:30am-12:30pm Join the meeting (877) 820-7831 Code: 432112 Child Welfare Out-of-Home Care Dashboard Internal DCF Staff 4/09/2020 Thursday 11:30am-12:30pm Please email DCFCWRA@wisconsin.gov for room information and webinar link. Older Youth Dashboard Internal DCF Staff 5/7/2020 Thursday 12:00pm-1:00pm Please email DCFCWRA@wisconsin.gov for room information and webinar link. Older Youth Dashboard All eWiSACWIS Users 5/20/2020 Monday 12:00pm-1:00pm Join the meeting (877) 820-7831 Code: 432112 If you have suggestions on reports or dashboards to be featured, please make a request to: DCFCWRA@wisconsin.gov. Working With Child Welfare Reports Within Microsoft Excel Child Welfare Reports are usually presented in large spreadsheets that allow users to further review data. It may be helpful to have the following base understanding of how to work with Microsoft Excel: Hiding and Unhiding Columns; Grouping Rows (3 minutes) Realize a better understanding of datasets by learning these skills. Freezing Panes (3 minutes) Learn how to freeze panes to keep certain column and row headings always visible Filter columns (First 6 minutes) Find out how to filter the data 10 General Excel Tips (First 10 minutes) Included are how to display data, create tables and charts, and write formulas Pivot Table (6 minutes) Discover Pivot Tables, a great tool used to summarize data Getting To Know Your Data Each report begins with a Report Info tab providing a high-level description of: What the report population is What is included in each worksheet The suggested use A detailed description of each report including the definitions of each variable is also available. Please reference page 6 of The eWReports User Guide to learn how to access this documentation.