Matt's Cafe is a local charity which intercepts surplus food destined for the bins, they then make meals from this food to be served to the homeless community of Swansea.
Volunteers collect food from various stores around the city and deliver to Matt's Cafe premises. On delivery, the food is weighed and logged in paper records. These records are stored away without being tracked digitally.
I developed a digital system to provide a central data warehouse for all food interception data. The system includes data entry, data dashboards and statistical analysis. The system was built using Oracle Apex and I relied heavily on SQL to acheive data analysis.
Get in touch with me by filling out the form below. I aim to respond within 24 hours!