The Scottish Housing Regulator safeguards the interests of social housing tenants. They ensure Scottish social housing is of adequate standard, reasonable value, and well-maintained, as mandated by the Scottish Government.
When the Government introduced a number of new statutory duties, the Scottish Housing Regualtor (SHR) needed a business intelligence solution to help better acquire and understand the data provided by registered social landlords. It also had to present data in a way that ordinary social housing tenants could hold their landlords to account. We created an end-to-end system to help them meet their objectives, consisting of a public-facing portal for social housing landlords and tenants, and an internal business intelligence system for SHR.
Delivering the solution
The portal was delivered using our PortalPlus web portal solution, with the xRM core of the solution built on Microsoft Dynamics CRM. A reporting platform was created for SHR staff, built on SQL Server 2012, Power View, and SQL Server Reporting Services, which allows both real-time and more in-depth self-service reporting.
The portal significantly reduces staff time spent on tasks such as data entry, as landlords now submit data directly to the system in a standard format. Staff can now gain a single view of the customer, and focus on performing cross-cutting analysis using the self-service reporting system. The solution highlights exceptions and anomalies in real time, allowing staff to spot problem areas and intervene early.
For social housing tenants, the system provides clear and detailed reporting about each landlord. This lets every tenant compare their landlord’s performance against others across Scotland, and have the evidence to hold them to account where they fall short.
We also implemented an intranet, based on our Kira intranet platform, to encourage sharing and collaboration by SHR staff across the organisation.
“What we valued most about the solution was its self-sufficiency. CompanyNet leveraged CRM’s customisability to produce a straightforward-to-use, platform-based solution that gave us a foundation to revolutionise the way we work.” Robert Laley, Project Director & Business Intelligence Systems Director, Scottish Housing Regulator
“The business intelligence project remains wholly consistent with the SHR’s policy and business objectives … an integrated business system to support the Regulator’s core business functions will allow them to both address current business risks and position the organisation to more effectively deliver on its objectives” Scottish Government Gateway Review