How would you analyze raw, potentially messy municipal datasets from City of Austin Texas to extract meaningful metrics?
For a hands-on SQL response, use the provided request, neighborhood, and department tables. Account for duplicate records, inconsistent status text, invalid dates, and unmatched reference values.
Output
- One row per recognized neighborhood, department, and calendar month
- Include
neighborhood_code, neighborhood_name, department_name, month_start, request_count, completed_requests, average_resolution_days, completion_rate, and completion_rate_change_points
- Include only valid, recognized requests, order by neighborhood code and month
