Technical Assistance for Increasing the Capacity and Quality of Judicial Statistics (EuropeAid/139115/IH/SER/TR)

Project Title 12

Technical Assistance for Increasing the Capacity and Quality of Judicial Statistics

(EuropeAid/139115/IH/SER/TR)

BYS Grup

Türkiye

Republic of Türkiye

Ministry of Justice

EU

COMPLETED

07.03.2019 -

22.12.2022

GOPA Consultants

BYS Grup,

GOPA Luxembourg,

Teched Consulting Services

The overall objective of the project is to ensure rule of law and fundamental rights in Turkey fully in line with international and European standards.  

The purpose of the project is to further strengthen and make more concrete and visible the independence, impartiality, efficiency, and administration of the judiciary. In this regard, project outputs were i) EU Turkey 2023-2024 Report on Chapter 23: Judiciary and fundamental rights and Chapter 24: Justice, freedom and security, ii) Judicial Statistics Report, iii) more judicial datasets and iv) more judicial statistics. 

The project is structured along several converging components in order to increase the capacity as well as quality in Judicial Statistics. As part of the project IT and IT-based tool for calculation of judicial statistics to shorten the period elapsing during the communication and processing of judicial data including migration will be promoted. Moreover, the available data warehouse will be reviewed, and necessary parts improved in close collaboration with the Information Technology Department (ITD). 

This project supports ongoing improvements in the national judicial system and statistics system. The project also focuses on training personnel entering UYAP (National Judiciary Informatics System) administrative records and aims at diversifying the data pool. The increase of capacity and quality in the judicial statistics depends on the multi-stakeholder collaboration in exchange of timely and correctly entered data.  

Improvement of stronger and more reliable statistics system will also contribute to international efforts as Turkey provides various international organizations and agencies with judicial statistics.  

An important aspect of the Criminal Justice system is Probation. The project covers the analysis of variables and available data in the Probation Module in the Judicial Data Bank, which is integrated with UYAP, within the Ministry of Justice. The analysis of probation data (e.g., the number of persons entering probation and   the number of probation officers) will enable improving the efficiency of decision-making processes in the probation system. 

Expected results are: 

• The content and method of the judicial statistics are revised. 
• Information Technology (IT) infrastructure is enhanced. 
• Awareness is raised on judicial statistics. 
• Institutional capacity of GDCRS and other stakeholders are increased. 

Revision of content and method of Judicial Statistics

• Review of the content and identification of the needs 
• Drafting “the Judicial Statistics Production and Data Dissemination Strategy Document” 
• Development of the data exchange and ownership protocols in the TJSS 
• Workshops on the mapping study of the International Classification of Crime for Statistical Purposes and classification of types of lawsuits 
• Improving the design and content of statistical publications 

Enhancing IT infrastructure

• Gap Analysis & Upgrade of the existing data warehouse: gap analysis for the existing data warehouse consisting of 8 modules in order to identify pluses and minuses, upgrade points etc., including analysis of existing data warehouse design, determination of new modules and variables to be added to the data warehouse, gaps to be filled in terms of statistical rules and terminology, upgrade methodology, time & action plan for data warehouse upgrade.  
• Designing and Implementing Extract–Transfer–Load (ETL) Processes: rules and processes applied into ETL tool, outcomes of the tests reported, developed and tested ETL tool uploaded to the servers, the data transfer to the statistical data warehouse initiated.  
• Designing Statistical Tabulation and Calculation (STC) Tool and Business Intelligence (BI) application: STC tool will enable users to transform the data into tables and have the ability to make simple linear models and projections. Business intelligence (BI) application will be designed, developed and implemented on top of ITD’s licensed BI software platform. This BI application will enable ministry staff to make cross table queries and calculations between different tables and indicators. 
• Developing Statistical Tabulation and Calculation (STC) Tool: analysis and architectural design documents of the STC Tool will be prepared, defining the functional requirements, non-functional requirements (UI design constraints, security requirements etc.), use-case scenarios, high-level software architecture; STC tool is development and upload on the servers. 
• Pilot Implementation: pilot implementation of the new system carried out and impact assessment conducted 
• Strengthening advanced statistical analysis and modelling capacity of GDCRS staff 

Awareness raising on judicial statistics

• National and International Conferences 

Increasing the Institutional Capacity of GDCRS and other stakeholders

• Study Visits and Trainings