Civic Data and Tableau: Exploring Volunteer Metrics

Civic Data and Tableau: Exploring Volunteer Metrics

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.

Need Expert Help?

See Our Full Menu of Data Services

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
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
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!