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

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK