Posts Tagged ‘data visualization’

Milwaukee County Poverty in 2012 by Census tract

My name is Jeff Zongolowicz and I am currently a senior at Marquette University and will be graduating in May with degrees in Social Welfare and Justice and Economics.  Over the past few months I have had the great experience of interning for the IMPACT Planning Council.  I decided to intern at IMPACT Planning Council after a professor of mine told me about the opportunity; I realized that it would be a great opportunity to be able to apply both my economics and social welfare and justice backgrounds to real world issues.

During my internship, I have gained valuable experience in data collection and analysis, mapping, focus groups, and some technical writing.  I worked extensively with Census data for the Milwaukee area and compiled data sets that will be useful for a wide variety of projects in the future. The data has been especially useful in creating maps (such as the one displayed here) of Milwaukee that provide valuable insight into the areas of the city where resources should be invested.   The census data I analyzed is being used for several projects already:

  • Evaluation of the Summer Reading project
  • Analysis of demand surrounding several commercial corridors
  • Sharing data with a funder who is looking to see geographically whether their grants are effecting the lower income areas in the city of Milwaukee

One project I have worked extensively on is with LISC, and preparing demographic data surrounding several commercial corridors in Milwaukee. The goal of the LISC Corridor project is to support economic growth in several corridors around Milwaukee.  The project has been interesting because the corridors have a wide variety of economic characteristics. Some are located in high income areas and others in low income areas. They vary greatly in their size and number of businesses.  The differences create a range of unique challenges that each corridor must overcome to achieve economic growth and sustainability.

My main contribution to the Corridor project has been a market analysis for several Business Improvement Districts (BIDS)  and business corridors around Milwaukee.  We combined data from the American Community Survey and Census to calculate the demand for goods and services in each neighborhood surrounding the commercial corridors, as well as the supply of those goods and services in each BID and corridor. After that data was calculated a supply-demand gap analysis was done to determine which types of new businesses each BID has the capacity to support.

In addition to working with large pools of data, I also had the opportunity to collect information directly from people by being able attend a focus group as a note taker. This allowed me to add variety to the role I have had as an intern and also gave me the opportunity to work with some qualitative data in addition quantitative data that has been my focus.  The focus group was conducted for Children’s Hospital which focuses on health in Milwaukee Public schools.  The experience allowed me to better understand the value of qualitative data.  Without the qualitative data gained from these focus groups it becomes easy to misinterpret the quantitative data.  Often times outliers in quantitative data can be easily attributed to something found in the qualitative data, however, if the qualitative data isn’t available the outliers can be wrongly attributed to incorrect causes.

As a whole my internship experience at IMPACT has been valuable in developing my skills and giving me insight into the type of work I would like to do following graduation.  Through my internship here I have become interested in the field of evaluation and come to appreciate its value in promoting efficient and valuable outcomes in communities. I have especially enjoyed the variety of work I have been able to do which has allowed me to gain a feel for the unique range of challenges in the evaluation field.

As my time at IMPACT comes to an end I am excited to continue pursuing a future in the evaluation industry and I expect my experiences here at IMPACT will prove valuable going forward.  I hope to be able to continue to work with communities in the future to be able to promote outcomes that are beneficial to the long-term future of everyone involved.


Read Full Post »

Mapping training attendees

Clockwise from upper left: Kerry Thomas, Matt Schumwinger, Aaron Bergtrom, Bob Waite and Amy Schlotthauer.

On March 26th, 2014 Virginia Carlson of the Public Policy Forum and Matt Schumwinger of Big Lake Data LLC presented an intensive one-and-a-half hour training on Tilemill here at the IMPACT Planning Council offices. . Tilemill is a free downloadable tool used to edit Cascading Style Sheets (CSS). If that is a confusing sentence to read, you would have felt right at home with the training group, over half of whom had never coded.  After an excellent presentation, attendees left the training with a homework assignment to try the tool out using their agency’s data.

Two weeks after the training, attendees returned for a discussion and the opportunity to share maps. Several of the group members had successfully created a map, and most people came back with questions.  The group spent the second meeting discussing the maps that had been created by attendees, sharing frustrations, exploring solutions and celebrating successes.  Virginia and Matt went through step-by-step solutions to problems brought up by participants.

Top lessons learned from the group:

  1. Working with CSS code is tricky.
  2. Working with CSS code means you can do almost ANYTHING you can think of to your map.
  3. Data clean-up usually takes longer than creating a map.
  4. Learning as a group makes it clear that several people hit the same stumbling blocks, and can help each another overcome them.

Ticket density map

Above is a map created by Matt Schumwinger, Big Lake Data LLC, on Tilemill, using a random sample of parking tickets issued in Milwaukee and mapping them in yellow.  The brighter the spots, the more parking tickets were issued at that location.

After the training, a short survey was sent to attendees. All of the respondents “Strongly Agreed”or “Agreed” that the training:

  • Will help them to create better maps;
  • Expanded their familiarity with data visualization; and
  • Will be useful in expanding their agency’s capacity to produce and share information.

The Tilemill training was part of the Evaluation Institute of IMPACT Planning Council, funded by the Faye McBeath Foundation, the Greater Milwaukee Foundation, the Foley Family Foundation and LISC. The Evaluation Institute builds the capacity of local agencies to use evaluation to strengthen outcomes. Data visualization has been a particular focus, kicked off by Cole Nussbaumer’s Storytelling With Data Workshop last October.

Do you have any Tilemill tips to share? We’d love to hear them!


Read Full Post »

On October 10, 2013 IMPACT Planning Council hosted a data visualization workshop at the UWM Zilber School of Public Health in Milwaukee. More than fifty attendees learned about data visualization, why it is important, and best practices from guest speaker Cole Nussbaumer.  Cole is the author of the Storytelling with Data blog and has served on the People Analytics team at Google.  Among other things, Cole told the group to focus on the context of the data and choose the right way to display the data given the message you are trying to communicate (HINT:  3-D pie charts are NEVER a good choice!).  Audience members submitted examples ahead of time and then spent time discussing the examples before Cole revealed her makeovers.  The key at all times, according to Cole, is to make it as easy as possible for the audience to understand the point you are trying to make with the data. 

The sold-out event was possible in large part due to the support of the Faye McBeath Foundation, Foley Family Foundation, Greater Milwaukee Foundation, Helen Bader Foundation, the Joxel Group, Local Initiatives Support Corporation (LISC), the Nonprofit Management Fund, Northwestern Mutual Foundation, United Way of Greater Milwaukee, UWM Peck School of the Arts, UWM School of Information Science, UWM Zilber School of Public Health, WE Energies, Zilber Family Foundation, and the Zilber Property Group. 

To read a compilation of the live Twitter feed of the workshop, and see some photos of the event, please visit our new web pageImage.  

Read Full Post »

At the Planning Council, we are busy preparing for our Data Visualization conference- coming up October 10th.

Our upcoming event inspired me to try visualizing some of the information collected in our Safety Net Clinic reports, using Tableau Public 8.0.

Safety Net Data VizEdit

The third edition of the reports, released in May 2013, was split into two documents; the 2013 Safety-Net Clinic- Planning Resource Guide and 2013 Safety-Net Clinic Referral Directory.  The utilization and geographic information on the viz is a small but interesting piece from the Planning Guide.

Thanks once again to the clinic staff and volunteers for their contribution to Milwaukee, and for sharing their data.
NOTE: Looking at this map data on Tableau enables you to highlight different clinic types in neat ways- to get to the interactive version click here.

Read Full Post »

3-1-1 calls

– Do you cringe when you see bad infographics?
– Do you wonder how to present data in an engaging yet accurate way?
– Do you want to tell effective stories visually with your data?
Then reserve October 10, 2013 on your calendar for the Planning Council’s workshop on Data Visualization. Our guest speaker is Cole Nussbaumer, a manager on the People Analytics team at Google and the brains behind the “Storytelling with Data” blog.

The workshop will take place from 1:00 – 5:00 pm at the Zilber School of Public Health.  Due to space limitations, the workshop will be capped at 50 attendees.  For more information or to get on the list to receive an invitation, contact Carrie at the Planning Council at 414-224-3055.

Read Full Post »