The Volunteers
This project was undertaken by Fatima Gil Pena.
The Approach
First, it was determined that the data collection had to be based on the invoices issued by the trust's supplier, since they were the organisation that sent the boxes to families.
Within each invoice, the main data to be collected were the type and number of items, delivery postal code and invoice date. Once all the invoices were gathered as individual pdf files, they were scraped to extract the main data using Power Query in Excel.
The database and report were subsequently designed in Excel to produce a user-friendly interface that the trust could continue working with.
Under the supervision of the volunteer analyst, the trust started adding new invoices to the database, also including a new item that was recently added to the portfolio of items gifted by the trust (“Holdall” bags).