Due to the scope and volume of the data it processes, the General Directorate of Customs (GDC), which is part of the Czech Republic’s financial and customs administration, must be able to analyze the data and prepare reports in record time.
This is possible thanks to the data warehouse Adastra built and has continued to develop for the past 15 years.
The GDC itself considers this data warehouse a business-critical solution. At work, the GDC’s analysts can depend on the current and quality data it produces
The Customs Administration of the Czech Republic is a security authority ensuring the execution of processes in the area of customs administration and related taxes, as well as other non-fiscal activities to the benefit of the state and its citizens. It reports to the Ministry of Finance. The organizational structure of the Customs Administration of the Czech Republic is two-tiered and consists of the General Directorate of Customs of the Czech Republic (GDC), which manages 15 customs offices.
The customs authorities administer all excise duties (taxes on mineral oils, alcohol, beer, wine and intermediate products, and tobacco), environmental taxes (on natural gas and others, solid fuels, and electricity), taxes on raw tobacco and value-added tax, though the last only in situations where goods are imported from third countries and the declarant is not registered as a VAT payer in the Czech Republic.
Adastra is built on long-term cooperation with its customers, one of which is the GDC. The company started building the data warehouse in the year 2004 and continues to maintain and develop it alongside the customs office. As the GDC has established new purviews and programs related to the customs office’s expanding jurisdiction, Adastra’s con sultants have continuously added more and more sources to the data warehouse. At present, there are 40 of these sources, so it is easy to picture the enormous reach of this solution.
At present, there are 40 of these sources, so it is easy to picture the enormous reach of this solution.
Based on data from the data warehouse, the GDC’s analysts prepare managerial reports and statistics for the organization’s own purposes, as well as for use outside the customs office (for example, for the Ministry of Finance, the Czech Statistical Office, the General Financial Directorate, EU bodies, etc.). These reports are based on certified, quality data from the data warehouse, are interactive, and meet requirements for the use of up-to-date technological and visual reporting tools.
The principle behind the solution is to collect and integrate data from various discrete systems and, subsequently, to make these data accessible to users via an analytical platform, reports, and management dashboards. The data in question include information about entities, tax collection, checks that have been carried out, the movement of goods, fuel distribution, alcohol production, and so on.
The basic aims of the solution developed by Adastra are:
Analysts and customs officials have 200 reports at their disposal. As these are prepared, results from many data stores are displayed in a matter of seconds. When assessing whether a taxpayer is high risk, for example, data from 13 different data marts is automatically recalculated at the same time. Assuming that it takes the user about 5 minutes to locate and inspect one taxpayer record, checking 13 records would take over an hour. Using the data warehouse, however, reduces the time necessary to review all the records to approximately 10 minutes, saving each user 55 minutes. The total time saved in 2016, calculated according to the number of times the data was accessed (17,564), is 16,100 hours – 670 days, i.e. almost 2 years, of labor.
Prior to 2004, the GDC already realized the importance and benefit of using up-to-date information technology and having quality data available for decision-making. As such, it has been one of the few administrative bodies in the Czech Republic to do so. Since then, the organization has
The owner of the solution is the department of Analysis and Information Support, which manages the project and sets the course of its development. Other departments’ requirements converge here. Analysis and Information Support ensures the gradual integration of business requirements according to pre-established priorities, and the subsequent assimilation into existing content.
Everything is accomplished with a proven and reliable combination of technologies based on innovative but recognized products and methodologies, as well as Adastra’s best practices.
Today, as the digitalization of the state administration advances, the GDC is able to take real advantage of the benefits of a high-quality and proven database from which to compile its managerial reports. Data stored in the data warehouse are readily available for any given purpose, connected, up-to-date, and consolidated so analysts can process and analyze them without long preparation.
In 2018-19, Adastra built an on-premise Data Analytics Platform (DAP)...
At a large manufacturing company, we have automated data uploads...
ESG reporting should not be a one-off necessity – data can move companies forward, and artificial intelligence can help.
The task seems clear. From the year 2025, certain companies will have to submit non-financial reports monitoring their (un)sustainable behavior. This reporting will not...
The task seems clear. From the year 2025, certain companies will have to submit non-financial reports monitoring their (un)sustainable behavior. This reporting will not...