virtualisation layer , enabling business systems to query the data virtualisation layer , and adding more data sources including flat files , SaaS platforms , National Statistical data , Central Bank data and some open data platforms as well .

3 . The third phase involved creating a data sharing platform ( DSP ) in which a domain developer working on the source database itself would create the sharing view . These views can be accessed by users working in different domains . This data sharing platform makes it easier for the information intelligence team to know what a database contains .

These experiences led Landsbankinn to the idea of housing all business rules and security protocols together . But to consolidate these data sources and feed the demand of the various user groups such as the board of management , customers , general reporting , risk reporting and operational reporting , Landsbankinn needed a novel data integration solution that was cheaper , easier to implement and technology agnostic .

Solution

The large number of disparate data sources at Landsbankinn needed to be integrated to build a data-driven , holistic overview of business activities , so the company could use that integrated data to optimize operations and improve the customer experience . Landsbankinn implemented a logical data warehouse ( LDW ) using the data virtualisation capabilities of the Denodo Platform . The LDW logically aggregates data from the disparate data sources , transforms the data based on the applied business rules and makes it available to the consuming application through a variety of APIs , such as JDBC , ODBC and REST . The LDW at Landsbankinn was implemented in three phases :

1 . In the first phase , data virtualisation was used to create a single data access layer to the unified enterprise data , sourced from a variety of disparate source systems , and make it available to reporting tools , analytics and APIs .

2 . In the second phase , data virtualisation capabilities were expanded by connecting new BI and analytics platforms to the data

Landsbankinn is leveraging the LDW to streamline its data infrastructure in a variety of ways :

• The overarching , central LDW is now used primarily for traditional BI and all the data preparation now takes place in the LDW .

• A self-service analytics platform has been built , using Tableau , which heavily uses the Denodo Platform ’ s data catalogue to identify the relevant datasets among the shared datasets .

• Web services such as REST APIs are being used to connect natively to Microsoft Excel to retrieve data and enable users to experiment . Excel is still heavily used for ad-hoc data extraction at Landsbankinn .

• APIs are also being used for connecting operational systems , such as CRM systems , to the warehouse .

Benefits

• The logical data warehouse has extended the reach of data across the organisation . Around 80 % of the targeted users are now using the LDW in one way or another . Adoption for the remaining 20 % is in full swing .

• The data can now be used by all kinds of users within the organisation , even the ones with limited data / IT skills , to make informed decisions .

• Landsbankinn gained significant improvement in terms of time and resources required to perform operational reporting and traditional BI reporting . www . intelligentfin . tech

45