General Financial Directorate: How to automate data cleaning?

The digital age of today is accompanied by ever-increasing demands on the quantity and, more importantly, the quality of data within individual organizations.

Every company and government body has to contend with greater or smaller inconsistencies in their data and must solve this issue – either with manual checks and fixes or with a fully automated approach.

The General Financial Directorate found itself in the same situation and chose the path of automation.

The administration of state taxes requires fast and automated data handling

The General Financial Directorate (GFD) is a government body responsible for administering state taxes (including personal income tax, corporation tax, value added tax, road tax, immovable property tax, tax on the acquisition of immovable property, stamp duty land tax, inheritance tax, and gift tax). Consequently, the GFD handles a huge amount of taxpayer data.

GFD staff often had to solve the problems associated with a large number of taxpayers (approximately 10 million residents, nearly 500 thousand foreigners, more than 450 thousand businesses, and almost one million self-employed individuals) and a correspondingly vast amount of data.

One of these issues was the unequivocal identification of natural and legal persons together with the clear and correct assignment of individual taxes to the tax subject. The processed data needed to be updated regularly, and as quickly and automatically as possible.

The GFD manages and processes massive volumes of data with a value of tens to hundreds of millions of Czech crowns.

The ADQC installation took place in a matter of days.

“ADQC is a very effective and user-friendly tool that can be implemented quickly and easily. The supplier provides extensive high-quality training, documentation, and the necessary coordination and support on-site.”
Ing. Bedřich Valigura, Director of the Tax Analytics Department, General Financial Directorate

The Ataccama Data Quality Center (ADQC) helps the financial administration process billions of data

The GFD chose a tool from the Ataccama Data Platform as the one best suited to its requirements. The Ataccama Data Quality Center (ADQC) was thus implemented to fulfill the following functions:

  • Consolidating taxpayer records from external sources for the purposes of further analysis
  • Identifying and immediately rectifying duplicates
  • Automatically completing and consolidating address details
  • Other tasks

The data is processed in batches, allowing the combined use of ADQC and other ETL resources.

The goal of actualizing the highest-quality database for the GFD’s analytical operations is thus achieved. Furthermore, the adjustable input and output formats in ADQC make it very easy to use.

“We appreciate the Ataccama tool chiefly for its clarity and efficiency. End users were able to utilize it to the fullest extent almost immediately after deployment and training. What have we gained through this investment? Process automation, tremendous time savings, and the ability to rely on quality data for our analyses.”
Ing. Bedřich Valigura, Director of the Tax Analytics Department, General Financial Directorate

Implementation in a few days and easy management of the tool

The ADQC can be operated by the employees of the tax administration themselves

The installation of the ADQC tool at the General Financial Directorate was accomplished in a matter of days. The implementation team also included employees from the Financial Directorate, who now manage and adjust everything themselves. During the implementation, the local, Czech-speaking development and support team was much appreciated.

Aside from those already in use, the ADQC tool also offers a number of additional features that the General Financial Directorate will utilize in the future.

These will be deployed gradually in the next stages of the project, taking into account current possibilities and needs.

Get inspired on our blog

Unlocking Data Governance: 3 Proven Strategies from Top Czech Managers

Managing data governance within organizations and among stakeholders can be an overwhelming task for CIOs, CDOs, or data strategists. The implementation and sustained adherence...

Read more

Functional Data Governance: Imperative for Success, Yet Over a Fifth of Major Czech Corporations Lack a Starting Point

Up to 72% of major Czech companies are currently in the initial stages of implementing data governance. Approximately one-fifth of these companies recognize its...

Read more

The Inevitability of Cloud Adoption Means A Challenge for Business Infrastructure Maintenance

The existing on-site infrastructure is gradually turning into a relic of the past, akin to the once-ubiquitous floppy disk. David Kaláb from Adastra outlines...

Read more