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.

KeepWatch by InterWorks

Whether you need support for one platform or many, our technical experts have you covered.

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 →

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


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!