How HeadChannel Built a Business Intelligence Tool for William Pears

William Pears is one of the largest property companies in the UK, managing thousands of properties across the country. HeadChannel built it a business intelligence system, integrated with Qlik for data visualisation, that automates report generation and gives the company better information for its decisions.

The Challenge

William Pears tracked financials, income and expenses by entering data by hand into multiple spreadsheets. The work was slow and prone to error, and it couldn't produce detailed reports quickly. As the volume of data grew, the company needed a system that would automate reporting and help it organise and categorise its business data, for better visibility and control of its finances. It also wanted the system to integrate with Qlik for advanced data visualisation.

The Approach

A custom back end. HeadChannel built a back end that handles the growing volume of property and financial data. It includes an ETL summary, source data management tools and snapshot approvals to keep data integration accurate. Manual mappings and data exception reports let the system organise data by business parameters and highlight anomalies such as rent discrepancies.

Qlik integration. The system feeds Qlik, so William Pears could view and analyse financial and property data from several angles, for more accurate forecasts and better decisions.

Automated reports. William Pears no longer relies on manual data entry in Excel. The system generates a wide range of customised reports on demand, cutting administrative time and freeing people for more strategic work.

The Outcome

The system saves the company up to 50 hours per report by removing manual data manipulation. With real-time access to financial data and organised property insights, William Pears could spot cost-saving opportunities and make strategic decisions more easily. The time once spent on data entry now goes to more important work.