Data Visualization Quick Start at the Supreme Court
As part of their offering to the public, The Supreme Court of Ohio creates a long PDF document that outlines multiple case statistics for all the counties in Ohio. While this document contains important information, it is hard to navigate and the overall usage is low. In order to facilitate usage, The Supreme Court wanted to create an interactive visual that they can embed on their public webpage for all visitors to use. The main objective of this project was for Navigator to work together with The Supreme Court to create a visualization in Tableau, while also building the Tableau skill set of their team.
The Supreme Court was spending too much time creating and updating a yearly PDF for case statistics for every county. Users complained about the difficultly to find the statistics they needed and the overall usage of the PDF was low.
Our approach was to break down the solution into multiple steps
1. Requirement gathering
We sat down with The Supreme Court team members to gather their initial goals and objectives they wanted to complete during the duration of the quick start. We mapped out a general outline of how this was going to be accomplished and a timeline of when events needed to be completed.
2. Data source creation
For each metric The Supreme Court wanted to capture, we identified the data source that they could be found in. With this information we created a data model that would be used to create the dashboards in Tableau.
3. Design Prototypes and Implementations
In additional to creating the dashboard, part of the requirements from The Supreme Court was to provide training by working on the project with their team members. To do this, we sat down with the team and drew out potential prototypes for each metric they wanted to capture. With an idea of how we wanted to display the visuals we then created the visuals using Tableau. The actual Tableau dashboard creation was done by The Supreme Court team. The Navigator team was there as the dashboards were being built providing guidance on how to actual build the dashboards as well as providing context around why the steps we did actual create the desired view.
4. Prototype Review
After the initial prototype was created, the leadership team provided their feedback on the dashboard that included some changes they wanted to see. Based on the recommended changes we iterated back through our approach of identifying the data source and updating the prototype.
With the dashboard design complete, the dashboards was then thoroughly tested for functionality and potential security risks.
Throughout the project the Navigator team provided useful information in regards to what is needed for future maintenance. Because The Supreme Court did the actual dashboard creation, they had a good idea of how to fix any design issues in the future.
Overall, The Supreme Court was very impressed with the final product. We were able to create a user friendly dashboard that saved them time by eliminating the need to prepare and update a PDF document every year. They also have a much better understanding of how Tableau works and have gone on to create additional dashboards for internal use.
Contact us at firstname.lastname@example.org