The GreenLight Fund supports non-profits that directly address issues important to local community members. To help identify those issues, DataWorks conducted interviews with 100 people from Fulton, Dekalb, Gwinnett, Clayton, and Cobb counties. The team recruited participants by canvassing locations like MARTA stations, shopping centers, and neighborhoods. The interview responses were documented in a spreadsheet and the team identified patterns. The primary concern in metro-Atlanta is income and housing inequality, and the second major concern is access to safe, affordable mental healthcare. The team composed data visualizations to illustrate their findings. This project is an important path for community members to inform supportive organizations of their needs.
Tools: Excel, Power BI
The Carter Center
The Carter Center tracks explosive weapons use in Syria to identify areas that are likely to be contaminated with abandoned or unexploded weapons that pose a risk to civilians. To do this tracking, the Carter Center collects data on weapons use and identifies their type, number, and location. In this project, DataWorks received a record of 19,000 events spanning 2019 and 2020. The team examined narrative descriptions and identified the type and number of weapons used. The tagged data contributed to the Explosive Weapons Use in Syria, Report 4, which is shared with humanitarian organizations planning to clear these remnants of war.
Tools: OpenRefine, Excel
In an effort to preserve Atlanta’s DIY art history, DataWorks has partnered with The Bakery to archive documents from Atlanta’s DIY music and visual arts organizations and venues over the past 50 years. To build this archive, the team is leveraging physical artifacts and online resources. These resources are then tagged and labeled to help communicate the role that DIY arts organizations have had in shaping the impact of Atlanta on American music, fashion, and culture.
Tools: Excel, Python
The Human-Automation Systems Lab at Georgia Tech is developing a predictive tool for early detection of neurological diseases in infants, which respond best to early treatment. The lab focuses on intelligent machines that learn from humans. DataWorks contributed to this project’s training data set by tagging anonymized videos of infants lying on their backs, identifying when an infant kicks each leg. Patterns in movement offer important indicators of neurological development and can aid diagnosis. Learning to detect specific motions is one computational task closer to realizing this important medical technology.
Tools: Excel, Bespoke video application
In their growth process, Concrete Jungle, a local non-profit committed to food access in Atlanta, migrated their donor records to AirTable, a customer relationship management software. DataWorks facilitated this migration by preparing the data to import into the new software. The team cleaned up individual and organization donor names, completed missing last names, split couples into two entries, and resolved misplaced information and duplicate entries. Leveraging an enterprise tool, this community organization is better prepared for faster growth, and the first step is clean data.