Property Management
Case Study

L&Q is a regulated charitable housing association and one of the UK’s most successful independent social businesses. The L&Q Group houses around 250,000 people in more than 110,000 homes, primarily across London and the South East.

Find out more about how we helped organise their data and streamline their processes below.

Project Details

  • Client: L&Q Group
  • Original: Microsoft Excel
  • Solution: Web App & SQL database
  • Project Duration: 10 weeks
  • Client Website: www.lqgroup.org.uk

The Challenge

Historically, each property had its own dedicated spreadsheet containing its details, such as the workstream, programme and any contracted works. However, with such a large portfolio of properties, it is easy for spreadsheets to get corrupted, lost, or have duplicate copies made; all of which are headaches for the team. It is also difficult to generate reporting, as some of the spreadsheets have a slightly different format, making it difficult to quickly consolidate data. Another major challenge is that every year the team has to go into each individual spreadsheet and apply an uplift for inflation; a process that can take up to 6 weeks.

The Desired Outcome

Originally the client wanted a re-built Excel workbook that would be more resilient, easy-to-use and allow for easier reporting. However after some discussion it was clear that the platform itself was not as important as the robustness of the data, and the ideal system should consolidate data, allow multiple users to use it concurrently without issues, allow for regular backups and ideally provide an audit trail.

The Solution

Based on the above requirements, we identified that a database solution would be more appropriate. Due to restrictions in installing software, a web application was recommended as the front-end as all it needed was a browser and internet connection to function, and allowed L&Q team members to work remotely if needed, from any suitable device such as an iPad, laptop or even smartphone.

The Impact

By upgrading L&Q to a web application and consolidating their spreadsheets into a database, the team has realised the following benefits:

  • Improved workflow - the team is now able to work on multiple properties simultaneously, without worrying about overwriting each other's changes.
  • Improved data quality - the quality of the data has improved significantly, as the web application applies validation upon data entry
  • Audit trail - it is easy to capture an audit log of what actions were performed by whom by mandatory log in to use the system
  • Significantly faster process (from weeks to minutes) - the uplift process that originally took 6 weeks and multiple team members can now be done at the click of a button within 5 minutes

Overall, the team has seen a boost in productivity (equivalent to hiring several extra team members) but at a fraction of the cost, resulting in a significant return on investment.

Get your free initial consultation.

Book a free, 30-minute initial consultation to discuss your requirements and explore available options with one of our helpful team members.

Contact Us

Address:

Aldgate Tower
2 Leman Street
LONDON
E1 8FA

Loading
Your message has been sent. Thank you!
Rest assured, your email address will not be added to a mailing list or used for anything other than responding to your enquiry. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.