Bed-stock Audit for the South of Scotland
At the end of 2021, TEAM was commissioned by South of Scotland Enterprise (SOSE) to produce a bed-stock accommodation audit for the South of Scotland (Scottish Borders and Dumfries and Galloway). The brief for the audit was to provide not only core factual details on sector, capacity, geography, facilities etc. but also richer content, including employment and Fair Work, Net Zero credentials and accessible tourism.
To achieve the objectives, TEAM sourced and aggregated the widest possible range of sources of accommodation data and listings and integrated them using both digital and manual de-duping. To obtain richer, qualitative information, TEAM also made enquiries direct to operators via a questionnaire, for a deeper dive on issues unavailable from accommodation databases.
The deliverables for the project focused on:
- Dynamic and intuitive displays of data, delivered as: Interactive online mapping of the database (which can be filtered and sorted by many factors and presented as individual heatmap HTML files, for use as a visual aid);
- Master database in Excel;
- Interactive dashboard (a visual display of the most important project information arranged on a user-friendly single screen); and
- A top line report explaining the methodology and high level results, graphics and insights with further commentary, tables and detail in appendices.
(Project completed in May 2022)