March 11, 2016

Community Groups “Excel” at Manipulating Housing Data

by UNHP

Fourteen individuals from eleven NYC community groups joined UNHP and Research Specialist, Joseph Contreras in the Enterprise Heiskell Computer Lab at Refuge House on Friday, February 19th to brush up on Excel tips in order to better use the UNHP Building Indicator Project (BIP) data as part of their community-based housing, organizing and neighborhood work.

The hands-on Excel workshop held in the Fordham Bedford Community Services Heiskell Enterprise Center for Technology provided information on the BIP and computer skills that can be used by community groups to inform their neighborhood work.

The workshop, led by UNHP Data Analyst VaNessa LaNier, offered hands-on training at the computers on the uses of the database in community work and understanding of the data available in the BIP, as well as Microsoft Excel tips, tools, and techniques to be able to better utilize the information in the BIP database.

UNHP Data Analyst VaNessa LaNier and Research Specialist, Joseph Contreras, teamed up to provide context and Excel skills to participants.

Jim Buckley opened the workshop by showing an “old school” redlining flyer that was used in the northwest Bronx circa 1978. He explained that the BIP is just a new tool rooted in the community and tenant organizing work that has happened in low-income neighborhoods over the past few decades. With information on over 62,000 NYC multifamily buildings updated quarterly with 103 data characteristics for each multifamily building, the BIP provides what can be an overwhelming amount of information. The goal of the workshop was to provide skills to community groups to shape, manipulate and adapt this data to extract crucial information to support organizing work, programs and other neighborhood campaigns.

UNHP Executive Director opened the workshop with information about redlining in the Bronx. Jim served as Director of the Reinvestment Project for Northwest Bronx Community and Clergy Coalition during the height of redlining in the Bronx. On the right is a flyer with a primitive graph showing the reduction of mortgages issued by banks in the 1970’s.

After VaNessa reviewed the data contained in the BIP database, Joseph Contreras demonstrated a variety of excel skills to manipulate the data, including pivot tables, data aggregation and data display options. Joseph led the group in using pivot tables to parse the data using unique criteria and create custom reports. Community groups also learned how logical statements in Excel can be used for comparative analysis. Logical statements are designed to examine specific data to determine if it is true or false. This function is helpful in increasing, limiting or aggregating data points.

Participants worked in small groups and received individualized assistance during the 5 hour workshop.

VaNessa shared information about the new dashboard for the BIP and the participants broke into small groups to use the BIP and their new Excel skills to answer questions that arise in neighborhood work, such as how many distressed buildings are in my neighborhood, who holds the mortgage and who owns the building?

The UNHP Building Indicator Project (BIP) database is shared with 42 community groups, thanks to Section 4 support from Enterprise. Community groups shared with UNHP the particular ways they use the database:

  • To track violations in community managed buildings
  • To identify buildings for tenants’ rights information and community organizing within the zip codes that we work in
  • Look at lender track records in term of distressed buildings
  • To access borough-wide housing quality and trends over time

Lunch from Tino’s Deli in Little Italy of the Bronx provided an opportunity to share community work successes and challenges.