This Citizen Service Request (CSR) Tableau Dashboard example allows local and state government departments to gain insight into the submitted open CSRs and to help the departments better understand how to allocate resources to address the requests. Additionally, it gives information about previous CSRs to gain insight into how departments are performing when addressing these requests.
This dashboard is powered by the Snowflake Data Cloud. Learn more about Snowflake’s offerings here.
This dashboard is designed for local and state government leaders to view each of the departments to understand how the key performance indicators for the department are trending. It allows users to understand the number of requests that are open and closed by each department and go one level deeper to the sub-department level.
The Open CSR & Closed CSR dashboards allow you to quickly identify which department has the most open & closed CSRs during a particular time period selected by the user. There are additional metrics that let users know the percentage of overdue CSRs for each department as well as the median time that each CSR is open/until the CSR is closed. Some questions you can answer by using this Tableau Dashboard are:
The users of this dashboard can change the CSR Priority, the date range, and the date granularity of the trending chart. The different priorities are Total, Hazardous, Emergency, & Standard. The users can select whether to show the last seven days, last 30 days, last 90 days, and the last 12 months. Finally, the user can toggle the granularity of the trending charts to show the data by day, week, or month.
We hope that you found this dashboard useful in your journey to understand the trends of Citizen Service Requests at a local and state governmental level.
If you have any questions, need help, or are interested in having a team of Tableau experts design dashboards for you, feel free to reach out!
Data Coach is our premium analytics training program with one-on-one coaching from renowned experts.