velop the front end of the database and additional tools. Naturally, over the years the composition of the team has flexed and shifted due to departures and the awarding of additional funding as part of time limited programmes of work. However, the ‘core’ of the team are two analysts to maintain the database and develop it, and a role that acts as a conduit between frontline services and offers non-technical project support. Currently day-to-day tasks including data loading processes are led by 2-3 staff within the Insight Bristol Team within Bristol City Council, including the TFD technical lead. They share responsibility for overseeing the data loading from within the council and are the same staff that operate the database more generally. If there are challenges due to the networking or security arrangements, the council’s IT services staff may be called in to support the process. Appendix 4 – Data Processing and Technical Infrastructure of the TFD This appendix presents a summary of the three stages of data processing carried out by the TFD, and the technical infrastructure that underpins the process. The three processes summarised below are: staging / cleaning, warehousing, and analysis. It should be noted that the technology in this space has developed significantly since the TFD was first developed, and if the team were to undertake this project again, they would make changes to their initial approach, utilising these new technologies. Social Finance Limited +44 (0) 20 7770 6836 87 Vauxhall Walk, London SE11 5HJ socialfinance.org.uk 83 Figure 19: SQL Server data pathways Staging / Cleaning This describes the step in the processing of data where raw data is initially placed and transformed upon being loaded from its source. New data is initially pulled into the Ra