a
Case Study Property Management QlikView Reporting & Analytics

Decision Inc. Enhances
City Property’s Reporting Capabilities

Client
City Property
Industry
Property Management
Location
Pretoria, South Africa
Solution
Reporting and Analytics with QlikView

The Requirement

A solution to connect to City Property’s organisational data and eliminate the manual capture of information, a process that was time-consuming and prone to human error.

The Solution

A QlikView implementation replacing a manually driven, highly complex spreadsheet system, applying different business rules for commercial property and private clients.

The Impact

A reporting pack that took 3 people almost two weeks to produce is now compiled in minutes, with information available on demand.

01 · Client Overview

About City Property

City Property is a residential and commercial property management company. The properties are diverse in nature, ranging from traditional shopping malls, convenience shopping centres, industrial workshops, warehouses, offices and retail shops to residential flats.

Buildings
433 buildings in the managed portfolio
Residential
9,963 flats
Commercial
More than 1.5 million m² of lettable commercial space

The company is headquartered in Pretoria with a supporting office in Johannesburg. Major clients include two listed property investment companies (Premium Properties and Octodec Investments) and a number of private clients.

City Property
02 · The Requirement

The Requirement

Access to near real-time data is critical to any finance-based organisation. Decision Inc. needed to connect to the organisational data of City Property and provide a solution that would eliminate its need to manually capture information.

  • The existing process relied on a manually driven and highly complex spreadsheet system
  • It was very time-consuming: it took 3 people 2 weeks to generate the required reports
  • Manual capture made the process prone to human error
  • The spreadsheets were integral to determining arrears outstanding, so report turnaround was critical to operations

“We had already selected QlikView as our analytics platform and needed a partner with solid QlikView experience to assist us. Decision Inc. was a logical choice as they have a long pedigree in working with the software.”

Helga OlivierProject Manager, City Property
03 · The Solution

Not a Typical QlikView Implementation

“The client required a solution that would replace their existing spreadsheet system that was manually driven and highly complex. These spreadsheets were integral to determining the arrears outstanding, so it was essential to improve their efficiencies in generating reports.”

Nick BellCEO, Decision Inc.

City Property needed the QlikView solution to improve the turnaround time of its reports. These reports provided insights into late-paying tenants and were therefore critical to the company’s operations.

Business Rules

Different business rules to filter the discrete requirements of commercial property and of private clients.

Stretch Targets

Stretch target reports that track how the business is doing against where it should be.

Live Integration

QlikView integrated with City Property’s systems and tested in a live environment that needed to run all the time.

“There was a lot of complexity involved in the data and integrating QlikView with their systems. The client had very specific requirements that had to be fulfilled in terms of data sets, but our team really came through.”

Nick BellCEO, Decision Inc.
04 · The Result

From Two Weeks to Minutes

The QlikView implementation has resulted in significantly improved efficiencies in the generation of reports.

Reporting Pack
Compiled in minutes as opposed to almost two weeks
Effort
Previously 3 people for 2 weeks; now available on demand
Reporting
Transparent reporting and analysis that is easy to use
Scalability
Highly scalable, with the flexibility to present various types of data quickly

“With the solution, we are able to provide City Property with data visualisation in a meaningful way. We have also begun another project with them and are looking forward to continuing the relationship.”

Nick BellCEO, Decision Inc.

“There is massive value in that. We now have the foundation to build detailed dashboards and visualisations on top of the implementation. We now have an evolving relationship with Decision Inc. and will be walking a journey together.”

Neil Saffer
Neil Saffer
Head of Strategic Logistics, City Property