Data alone is not enough; it must be in an accessible and understandable format so timely business decisions can be made. Incline had entered into a reporting project for a local retailer that sells furniture, white goods and electronic devices. Most of their sales are on credit, with various repayment term options. Prior to working with Incline, the client had to extract information for customer account performance by running SQL queries. This proved to be inefficient, as this required manual work while providing limited information. Incline’s role would be to provide insightful reports on a secure platform.
Incline was able to provide the above in two components; namely a data mart and a reporting platform. The data mart combined the significant origination and performance information for all accounts in a single, consistent view. This data would then be fed into a set of Account Originations and Account Management reports that would be hosted on a secure platform, and updated at the end of each billing cycle.
We worked through the project in three main steps:
- Identify and locate the relevant data
In recreating the existing set of internal reports as well as adding a new suite of reports, we used our credit risk knowledge to identify the most important customer, account and product information. This included the application scoring information, any relevant demographic information, payment behaviour, etc.
- Identify the relevant tables
The client’s database consisted of hundreds of tables. By engaging with the business to determine the most important KPI’s and current pain-points, we were able to select the required data, as well as unique identifiers. With this understanding we were then able to construct the data mart.
- Build reports
With the data mart we were able to construct the reports. This required thought into how best to structure reports. The aim was to create detailed reports that would still emphasise the most important information that would enable the client to identify potential issues, and make decisions to mitigate this. Further we had to confirm that what we were seeing in the reports corresponded with what the client was seeing in their operations.
Through these reports we have been able to provide the client with valuable insights into their customer’s behaviour, the business’s operations, as well as its technical systems. Combined with monthly meetings, we have able to advise the client to navigate business issues.