Civic Data and Tableau: Exploring Volunteer Metrics


Civic Data and Tableau: Exploring Volunteer Metrics

by Mike Roberts

Is data visualized more insightful than data stockpiled? It certainly depends on who you ask but, in some very specific cases, data visualized can shed light on some tightly guarded tribal knowledge. To that end, the team for the Civic Data Challenge has provided numerous datasets on, well, civic data (volunteering, civic engagement, etc.). It’s a worthwhile project and I would encourage everyone to at least understand what it aims to accomplish.

In this example, we wanted to illustrate the path to visualization. From data preparation to data visualization, there are really 5 painless steps. I’ll simply highlight them here and leave you with the visualization. After all, there are mounds of books on ETL, ELT, data analysis and other theoretical methods of visualization. If there are specific questions that arise, please just let us know. Here are the basic steps:

  1. Understand the data: What do you want to accomplish? 
  2. Prepare the data (we used both SQLite and MySQL) 
  3. Test the data: Is it in the correct format (3NF / Denormalized)?  
  4. Visualize the data: What do you want to accomplish now? 
  5. Repeat (if necessary)

I’d encourage you to explore the visualization on the web and, if you have Tableau 8, please download the workbook.

Big thanks to Andy Kriebel for the insightful feedback on what makes an effective visualization.

More About the Author

Mike Roberts

Business Intelligence Consultant
Monitor Your Tableau Server without the GUI If you enjoy monitoring your Tableau Server cluster by constantly refreshing the admin view (image below), this might be for you. ...
InterWorks and Facebook to Share Insights on Data Culture at 2013 Tableau Customer Conference STILLWATER, Okla. – InterWorks, Tableau Software’s largest global services provider, announced plans to present alongside Facebook ...

See more from this author →

Subscribe to our newsletter

  • This field is for validation purposes and should be left unchanged.