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

Edit This Case Study Record

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

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

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Finance & Insurance
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Predictive Quality Analytics Real-Time Location System (RTLS)
Services	Data Science Services System Integration
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Finance & Insurance

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Predictive Quality Analytics

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

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 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.

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.

Impact #1	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.
Impact #2	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.
Impact #3	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.

Impact #1

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.

Impact #2

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.

Impact #3

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.

Benefit #1	In the first month after the implementation of QlikView, HDN increased its market share by 5%

Benefit #1

In the first month after the implementation of QlikView, HDN increased its market share by 5%

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit