Download PDF
Qlik > Case Studies > Hypotheken Data Netwerk and QlikView provide end-to-end, real-time insight into the complete Dutch mortgage market
Qlik Logo

Hypotheken Data Netwerk and QlikView provide end-to-end, real-time insight into the complete Dutch mortgage market

Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Finance & Insurance
Applicable Functions
  • Sales & Marketing
  • Business Operation
Use Cases
  • Real-Time Location System (RTLS)
  • Predictive Quality Analytics
Services
  • Data Science Services
  • System Integration
The Challenge
Hypotheken Data Netwerk (HDN) Beheer B.A., the Dutch Mortgage Data Network, was facing several challenges. They needed to provide mortgage providers and mortgage brokers with secure reporting and analysis capabilities for benchmarking. They also aimed to increase the added value offered by the HDN electronic messaging platform to increase market share. Furthermore, they wanted to provide insight into up-to-date and valid information about the status of the Dutch mortgage market. Traditionally, mortgage providers and intermediaries had no insight at all into market data. The only available data had come from the Dutch land registry, Kadaster, which records property sales. As the land registry only has a record when properties are actually sold, the data that is available is neither up-to-date or complete.
About The Customer
Hypotheken Data Netwerk (HDN) Beheer B.A., is the Dutch Mortgage Data Network. Founded in 1992 the cooperative is an initiative that was started by various mortgage and insurance companies in order to connect all electronic communication in the mortgage chain, using a uniform standard. Its board is made up of four representatives from mortgage brokers and four representatives from mortgage providers, including ABN AMRO and ING. HDN serves as an intermediary between the electronic highway, mortgage lenders, insurers and the land registry. The Hypotheken Data Netwerk is a platform for requesting and receiving mortgage quotes, life insurance policies, valuation reports, status updates, sending file documents and receiving portfolio reviews. HDN facilitates the process from application to overall management for 4,000 mortgage brokers and 35 mortgage providers. Today 45% of all Dutch mortgage requests pass through HDN.
The Solution
The Hypotheken Data Netwerk implemented QlikView to provide mortgage brokers and mortgage providers benchmarking, reporting and analysis capabilities. This created an end-to-end national and regional overview of the entire Dutch mortgage market, accessed daily for benchmarking purposes by more than 4,000 users. The implementation of QlikView started in June 2010. The first task was making the Extensible Markup Language (XML) message traffic available and providing insight into this data. To allow for this HDN defined the dimension criteria based on product, interest rate and demographic level. They also wanted to use geographical dimension criteria by web mapping postal codes. The data was separated accordingly so that mortgage providers and brokers would only see the data applicable to their role.
Operational Impact
  • The QlikView application, HDN Index, offers an up-to-date overview of the Dutch mortgage market. Prior to the HDN Index, market information was around six months old.
  • Intermediaries and distribution parties have access to up-to-date market information, allowing them to benchmark their results against their region and to improve their revenue.
  • Using QlikView, 4,000 mortgage brokers and 35 mortgage providers now have an insight into the Dutch mortgage market that is open and integrated. For the first time they have visibility into the most common and popular types of mortgages, the current interest rates and the mortgage market potential at a national, regional and demographic level.
Quantitative Benefit
  • In the first month after the implementation of QlikView, HDN increased its market share by 5%

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.