Data Analysis Tool For All

Intake data from your case management system, including

• Demographics about which you are curious
• Open date and close date
• Other case information that you might be able to use in other analyses, including problem code, other demographics, etc.
• Exclude cases that were identified as errors or duplicates, but make sure to keep cases that ended up not being served

1. GIS mapping using ArcGIS or other similar software.
2. To look at these results in tabular format, you would need two create a “crosstab” (MS Excel calls them Pivot Tables) from variables in your in your case management system. The rows of the resulting table would be the geography level – cities, for example. The columns would be intakes and served. So for each city in the table, you would know the number of intakes and the number of intakes served, from which you could calculate the percent of intakes served. Directly from these data you could identify the high and low percent served cities in your service area.
3. To map the results, you could start with that same crosstab/pivot table output, and join those data to their corresponding geography file to generate a map.
4. In this example, data are aggregated to the community level (the ward level within the city of Cleveland), and mapped for the service area over a 5-year period. Darker shades represent higher percentages of all intakes that were served.
5. You should note for maps based on percentages that small numbers might result in misleading percentages. For example, a community with only 1 intake, which didn’t happen to be served, would show on the map as 0% served. A 0% served finding might initially cause great concern, but such small numbers should be interpreted with great caution. In this example, we noted communities where the total intakes were below 30.