In a testing economic operating environment, with increasing need to expand social housing provision whilst maintaining the highest quality of services to tenants and other customers, Housing Associations need to take care to ensure investment is accurately targeted and carefully managed, and that business performance is subject to continuous, detailed scrutiny.
Business Intelligence and Corporate Performance Management are two sometimes overlapping, often complementary solutions which can deliver accurate, reliable insights into operational effectiveness and business performance. BI and CPM can be complex, but effective solutions can be delivered quickly using a combination of the business knowledge possessed by your finance team and other experts within your business, the design-build-deliver skills of a professional consulting organisation, and powerful, modern, integrated technologies.
Esuasive has been working since 2011 to deliver modern BI and CPM solutions to Housing Associations. We are a Microsoft Gold Certified Partner (that’s the highest accreditation achievable), as well as an accredited BOARD partner, and by combining this expertise with a sound understanding of the sources of data and business processes housing associations typically have, and the type of insights they would like to achieve, we are ideally placed to create solutions which deliver real value.
Some examples of Housing Associations already achieving business insight with our help:
The key issue for Moat was to integrate data from across multiple operational systems to deliver a ‘single version of the truth’. We tackled this problem by bringing together a small team of ‘super users’ to select the core data sets and identify key data fields. We then developed a reliable extract-transform-load process to create a single SQL Server data warehouse containing accurate, cleansed and verified data, as a basis for KPI reporting and ad hoc data analysis using BOARD.
For L&Q, the desire was to create an easy-to-use BOARD solution centred around the concept of a dashboard. BOARD was used to pull data from Microsoft Dynamics GP and a host of secondary sources to create a platform for KPI reporting (covering Development, Maintenance, Lettings, Customer Care, Finance, Treasury, etc.), management accounting and cross-scheme reporting. L&Q users were keen to become self-sufficient as soon as possible after launch, and through basic training and desk-side support they have quickly developed the skills to serve the requests of senor manager and users with only minimal ongoing consulting support.
By contrast, Richmond wanted to focus on delivering a visual, highly interactive dashboard to its executive board members. The focus was on delivering insights which would allow the executive team to reveal trends, profile customers, streamline business processes and be innovative in delivering service improvement. Speed of delivery was also crucial.