In Spring 2025, Team Satisfeed partnered with the nonprofit Satisfeed, which provides hunger relief for families in and around Gwinnett County through food co-ops and weekend programs. Their mission is to fight food insecurity, reduce waste, and connect communities. The team created a data-driven dashboard using Google Colab and Power BI to visualize client demographics and service usage, giving the organization insights for program planning and resource allocation.
This semester’s work expands the original dashboard by integrating a new dashboard section with an interactive map. The goal is to help Satisfeed identify trends in food insecurity around Georgia's schools / libraries in relation to food distribution geographical data to improve distribution planning.
Project Demo
Project Website
Project Poster (in the Docs folder)
Final Report
Project Demo Vlog
Project Poster
Final Report
- Next.js
- Firebase
- Python
- MapLibre GL JS - https://maplibre.org/maplibre-gl-js/docs/
- Dashboard Login
- Select Dashboard Data Version
- Data visualization by:
- Race
- Income
- Education
- Employment Status
- Food Distribution by County
- Food Distribution by ZIP Code
- Total Families Reached
- Total People Helped
- Upload Raw Data
- Manage Data Versions
-
Dashboard Insights Tab
New section of the Satisfeed dashboard focused on interactive layered maps enabling Satisfeed to view food distribution around GA, statistical information, and locations of schools / libraries. -
School Data Integration
Interactive map overlay showing Georgia schools, allowing Satisfeed to view distribution geographically in relation to schools. Involved integrating scripts to parse school data from public APIs and saving data to firebase. This allowed users to access said data when interacting with the maps in Dashboard Insights' Schools tab. -
Food Distribution Data Integration
Dashboard now highlights total families served allowing deeper insight into which communities need the most assistance. Involved integrating a backend endpoint to safely parse CSV file of dirstibution data, and save (approximate) address coordinates with LocationIQ api as a persistant file. This allowed users to safely view distribution data on the map. -
Library Data Integration
Interactive map overlay showing Georgia Libraries, allowing Satisfeed to view distribution geographically in relation to libraries. Involved integrating scripts to parse library data from public APIs and saving data to firebase. This allowed users to access said data when interacting with the maps in Dashboard Insights' Libraries tab. -
County / ZIP Statistics
Dashboard integrates relevant statisitcs per county / ZIP code selected while also showcasing location on maps. Involved working with exisiting GEOJson data which allows users to select needed County / ZIP to be presented with relevant information.
- Clone the repo: git clone https://github.com/nhuthanhtran/Satisfeed
- Install dependencies: install npm with "npm install"
- Add environment variables to .env.local file in root directory
- Ensure MapLibre is installed
npm install maplibre-gl
- Apply updated environment variables
NEXT_PUBLIC_MAPTILER_KEY=
LOCATIONIQ_KEY=
- Verify Firebase credentials include rules for new data models.
- Run the development server:
npm run dev
# or
yarn dev
# or
pnpm dev
# or
bun dev
- Open http://localhost:3000 with your browser to see the result.
- Sign up for an account and verify with your email to get approved as an admin.
- You can start editing the page by modifying app/page.tsx. The page auto-updates as you edit the file.
Caleb Cedeno - Project Manager & Visualizations Elizabeth Doss - Data analyzer & Client Liason Damaris Montecinos - Data modeler, Project Documenter
Sam Keller - Code Architecture / Lead programmer, UI/UX designer, Client liaison
Dylan Long - Testing lead / Team manager 🦉
Ewura Ama Awere - Data Modeler, Documentation Lead
- Poster was presented at Georgia Gwinnett College's Student Talent and Research Showcase (STARS) 4/17/2025
- Dashboard demo was given at Georgia Gwinnett College's CREATE Symposium 4/24/2025
- Expanded Dashboard demo was given at Georgia Gwinnett College's CREATE Symposium 11/21/2025
Data was analyzed and visualized using Google Collab, a cloud version of the Python-based Jupyter Notebook. Project management was conducted using Jira. Dashboard layout was created in Power BI for later implementation in Javascript by Thanh Tran. The final project will include a database and password-protected site where the dashboard can be viewed by Satisfeed employees.
Disclaimer: The notebook, dataset, and PBIX file cannot be displayed, as they contain personal information of Satisfeed customers including full names, addresses, and phone numbers. Therefore, all displayed metrics and stats are a high-level overview of the analysis without specific data points displayed.
PCA and linear regression were attempted on the data set, but failed due to a lack of numerical data and numerous gaps in client reporting. As a result, most of the statistics are simple descriptive ones.
One of the key findings related to a possible motivation for clients using Satisfeed. Of clients who answered demographic questions, 30% reported being unemployed or employed only part time. Additionally, the most common income bracket for Satisfeed clients was in the 0-25k range. This suggests that many clients come to Satisfeed because they are experiencing financial difficulties.
Another key finding was the background of Satisfeed clients. Of clients who answered, almost 80% were Hispanic or Latino. This may indicate a need for Satisfeed to develop bilingual programming, in order to reach those among their client base more confident in Spanish than English.
It would be optimal to pull data to the dashboard straight from Satisfeeds database, for which plug-in compatibility with PowerBI would have to be researched. The client would also like the "lbs of food served" card to be real time where they can live update the data. As of now the card pulls static data from a hypothetical table and is used as a placeholder.
This project is licensed under the MIT License.
© 2025 Georgia Gwinnett College