Improving data quality in Estonia’s integrated e-services

Case study with Centre of Registers and Information Systems

THE CUSTOMER

The Centre of Registers and Information Systems or RIK is a government agency under the jurisdiction of the Ministry of Justice of Estonia with the aim to establish an innovative environment providing integrated e-services for a more efficient implementation of state administration, legal and criminal policy. They have developed and administer over 80 different systems and various registers important both for the state and its citizens.

CHALLENGES

When handling large amounts of data that’s crucial for many of the Ministry of Justice’s employees’ everyday work, issues with data can affect not only their everyday tasks, but also the citizens.

Some of the concerns RIK’s data teams faced on a daily basis were:

  • Requests from data users to fix found errors
  • Errors loading data when a system is not responding
  • Faulty statistics due to poor data
  • Missing values when importing data
  • Erroneous information affecting employee workflows

DATABASE SYSTEMS

  • Vertica
  • Oracle
  • PostgreSQL
  • Mictosoft SQL Server

INDUSTRY

  • Public sector

LOCATION

  • Estonia

HOW SELECTZERO IS HELPING

Manual data validations and solving data related ticket requests consumes a lot of time and takes priority from other important tasks when managing several systems and databases. At the same time data downtime is affecting users from other departments.

To manage these issues, RIK needed a platform to visualise data quality in different systems, test new internal features and changes, automate data validations with error reporting, and help save time to find and fix data errors.

In 2021 RIK started using SelectZero’s data observability platform and implemented new internal processes for better data management. For example, every time a new error is found, a new regression test is created within the data observability platform to prevent the same errors from impacting different processes in the future.

IMPACT

Implementation of SelectZero’s data observability platform has had a positive impact on RIK-s data quality processes. The application brings great benefits in getting a systematic overview of the quality of data in the institution’s systems and allows for increased automation in data governance processes.

This saves time as RIK can validate data automatically on a daily basis and the database managers do not have to check the data manually every couple of hours. The self-service platform gives the freedom to create test cases based on the users’ need, and the role-based access gives different departments the possibility to define and execute data tests on demand.

Previously, users created a lot of requests by notifying data teams of various errors. With SelectZero’s platform, RIK managed to reduce the amount of tickets by proactively solving data issues, resulting in data users being more satisfied with the service and quality. They also improved the integrations between systems where data didn’t get loaded from the source to the target due to unforeseen errors by implementing validations into data pipelines and automating alerting.

USED IN

  • Register of Prisoners
  • Land Register
  • Museum Information system
  • … and 5 other systems

USED BY

  • Database managers
  • Business and system analysts
  • Data warehosue developers

In addition, RIK can offer more transparent communication with the business side, allowing them to define business rule validations and discover issues sooner. This increased transparency fosters collaboration between the IT and business units. On the other hand, the IT side can reciprocate by enhancing transparency regarding data quality issues within the system. This involves presenting these issues to the business side, enabling them to prioritize and allocate resources to address specific problems effectively. This dual-sided transparency not only strengthens collaboration but also empowers informed decision- making between the organizations.

SelectZero’s software was implemented over two years ago and is currently being used daily in eight different databases (ie. Register of Prisoners, Land Register, Museum Information System) with many more to follow in the near future. The platform is being used by five different data teams, including database managers, data analysts and engineers. Currently there are close to 260 test cases and most of them are being run almost daily.

WHY SELECTZERO?

“SelectZero’s data observability platform is easy to use and understand, giving the users dynamic features for better data quality management. In addition, SelectZero provides quick, professional support and is open to on-demand developments based on our feedback“

– Susanna Metsla, Competence Manager for Data Management and Data Governance at RIK

Interested in hearing more?

Case study: Centre of Registers and Information Systems

December 17, 2024|

Improving data quality in Estonia's integrated e-services Case study with Centre of Registers and Information Systems THE CUSTOMER The Centre of Registers and Information Systems or RIK is a government agency under [...]

Release 2024.11

November 25, 2024|

Custom attributes Enhance your platform flexibility by defining custom fields for any glossary term or test case. With this new feature, you can capture the unique details and nuances that matter most to [...]

How ensuring data quality can improve your business?

August 22, 2024|

Data is an integral part of all our business processes. The activities carried out in a business process need data, and the activities produce data. So, we cannot look at business processes without data, [...]

LiTech is named a Representative Vendor by Gartner

July 16, 2024|

Last month Gartner published a Market Guide for Data Observability Tools. In the report LiTech is recognized as a Representative Vendor. Gartner, a leading research and advisory company that provides insights and advice for [...]