ABRSM, the exam board of the Royal Schools of Music, wanted better business intelligence reporting to support their growing organisation. The previous static fact book relied on cumbersome manual processes, lacked the ability to drill in to the data and so was not relied upon.
We helped ABRSM to achieve their objective by constructing an online reporting solution. This provided targeted data insights on a daily basis. The online suite was designed to allow for a more interactive experience for the business by providing content already found in the fact book and new insights via standard reporting and dashboards.
Digital Cinema Media, as the leading cinema advertising scheduler, wanted to increase market share by improving sales for advertising space in cinema trailers. However, the use of spreadsheets meant that it could be a day or more before they could respond to client requirements.
Using IBM’s Cognos Express analytic suite, Northdoor delivered a cloud solution that integrated and automated DCM’s scheduling and client records, thereby simplifying and automating integration. As a result, reports are now run every day at 9am and are delivered to users by 10.30am. “We have reduced data reporting time by 87%” said Simon Rose, IT Director.
NHS Trust. Northdoor worked closely with an NHS Trust who were facing the prospect of substantially increased SQL server licensing costs of over £3m in the next financial year due to changes to the licensing mode, along with the complexities of support multiple SQL Server versions. Northdoor advised on and implemented a platform move to SQL Server 2014 which provided a highly availably solution integrated with the Microsoft Azure cloud.
The benefits to the client were annual license savings of £400k per annum, along with lower ongoing support effort and enhanced availability and disaster recovery capability.