BI for Land Engineering

Land Engineering is one of the leading names in public realm environmental improvement work, stone work and grounds maintenance. 

Winter gritting - Land Engineering

Spanning three decades of achievement in infrastructure development, public realm and environmental improvement projects, Land Engineering works in a variety of sectors including local authority, social housing, infrastructure and education. 

Products

  • .NET line of business system
  • SQL 2008 Reporting Services
  • SharePoint 2010

Key Challenges

The operation and administration of Land Engineering were handled manually and it was becoming increasingly difficult to manage using people and paper-based processes. LE approached Chess to design and develop a custom solution for the business. As a further part of this solution Chess were asked to provide a flexible reporting suite.

Land Engineering required the ability to analyse data, create contracts and invoice clients from their Winter Gritting System. Due to their core business systems having SQL Server as the database platform, it was a case of leveraging the functionality of SQL Server Reporting Services and integrating it with SharePoint to provide the base for their Business Intelligence requirements. 

Solution

Parameterised reports were created for statistical analysis, contract creation, sub-contractor invoicing and client invoicing. There were then deployed to a SharePoint environment, allowing us to leverage its document management and workflow capabilities while extending its reach beyond the internal network and simplifying access controls by using Active Directory user accounts and group membership. 

SQL Server Reporting Services was integrated with the SharePoint portal, hosting the Winter Gritting application, to provide a single point of access for all related resources, subject to appropriate access controls.

Information which would normally take hours to correlate was now available instantly. Invoicing issues for both clients and sub-contractors were now reviewed quickly and accurately. Exceptions reporting was made available in real-time thus allowing a faster response. The information was now available to authorised members of staff who work outside the main office environment.