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.
In Fall 2025, Let Us Cook will build on this work by adding Gwinnett County school zone data to the existing web app dashboard, enabling Satisfeed to better understand and serve families across the area.
Project Website [https://satisfeeddashboardproject.carrd.co]
Project Poster [STARS/CREATE Poster in the Docs folder]
Final Report [(Final_Report-_Team_Satisfeed.docx )]
- Next.js
- Firebase
- Python
- 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
- 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
- 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
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.