Our client is a museum that hosts hundreds of thousands of visitors every year. The key reporting activities for the museum are to track visitors and manage its vast collection of artefacts. This was being done using a mix of on-premise system data and ad-hoc downloads from SaaS solutions. The reports used a combination of SQL Server, Excel & PowerBI.
Due to ongoing changes in both information needs and staffing, data and reports were not always prepared in the same way. This meant there was variability in approaches and understanding of data that led to inconsistent outcomes. This resulted in reduced productivity when trying to understand the organisation’s performance.