Part of the service that NHBC provides to house builders across the UK is quarterly reports on their performance. The reports detail the building inspection defects that were found and actions that need to be taken to resolve them. Prior to implementing OpenTextTM Analytics, NHBC used a variety of reporting tools and a snapshot of data was produced each month, taking two to three days to complete. The data was then ‘sliced and diced’ to create the final report, manipulated with a combination of Microsoft® Excel® spreadsheets and Adobe® PDF documents. Once complete, reports for the top 50 builders were printed, emailed and dispatched. NHBC’s regional directors then booked meetings with the builders to review and discuss. This process was time-consuming and resource-intensive.
Jiten Prajapati, strategic development manager at NHBC, explains the company’s goals for a new, web-based, self-service portal, “We wanted to be more business intelligence (BI) focused, with standardization across all builders, regardless of their size. Our aim is to provide a ‘My Reports’ portal, where builders can access not only standard reports, but also where they create their own views on the data available to them and run ad-hoc reports too.” NHBC set about identifying a solution to meet their needs.
Analytics: easily embeddable analytics and the perfect fit for NHBC’s reporting platform
NHBC had some experience with Analytics, having used it for some of its internal reporting needs. Having looked at a number of possible solutions, NHBC decided to evaluate the latest version.
“We looked at solutions from Oracle, Informatica and others. However, as we had experience of the ease with which we can embed OpenText Analytics into applications, we decided to build a proof of concept using the latest version. We were delighted with the results, and decided to push ahead with OpenText Analytics as our solution, which is a perfect fit for our IT architecture,” said Prajapati.
The implementation began by engaging with the Professional Services team at OpenText. On-site meetings were held to jointly scope the implementation, design the solution architecture and provide training and knowledge transfer.
“Working with OpenText Professional Services meant that we could kick-start the project and accelerate the implementation, benefitting from their experience and knowledge of OpenText Analytics. Everything was documented and we worked closely to configure the solution to our specific needs. With the knowledge we’ve gained, we’re now self-sufficient and able to install into other environments, make changes, and support our customers,” said Prajapati.
Having involved all internal stakeholders throughout the POC and design stages, once live, the solution was universally accepted, with positive feedback.