Project Start Date: March 7 2019
Duration: 43 months
Budget: 2.000.449,50 EUR
Beneficiary:
General Directorate of Criminal Records and Statistics, Ministry of Justice of the Republic of Turkey
Consortium members:
· GOPA Worldwide Consultants
· GOPA Luxembourg S.a. r.l
· BYS Grup Corp.
· Teched Consulting Services Ltd.
Project Objective
To ensure rule of law and fundamental rights in Turkey fully in line with international and European standards.
Purpose
To further strengthen and make more concrete and visible the independence, impartiality, efficiency and administration of the judiciary.
Scope of the Project
The project is implemented under the following four components:
Component 1: Revision of content and method of Judicial Statistics
Activity 1.1. Review of the content and identification of the needs
Task 1.1.1. Gap analysis
Task 1.1.2 Determining subdomains
Task 1.1.3. Data availability exercise
Task 1.1.4. Resource analysis
Task 1.1.5 Assessing business processes and dissemination of judicial statistics
Activity 1.2. Drafting "the Judicial Statistics Production and Data Dissemination Strategy"
Activity 1.3. Development of the data exchange and ownership protocols in the TJSS
Activity 1.4. Workshops on the mapping study of the ICCS and classification of types of lawsuits
Activity 1.5. Improving the design and content of statistical publications
Component 2 :Enhancing IT infrastructure
Activity 2.1 Gap analysis and upgrade of the existing data warehouse
Task 2.1.1. Analysis of existing DW design
Task 2.1.2 Determination of new modules and variables to be added to the DW
Task 2.1.3 Gaps to be filled in terms of statistical rules and terminology
Task 2.1.4 Upgrade methodology
Activity 2.2 Designing and implementing Extract-Transfer-Load (ETL) processes
Task 2.2.1 Technical design and build
Task 2.2.2 Testing
Task 2.2.3 Training
Task 2.2.4 Deployment
Activity 2.3 Designing statistical tabulation and calculation (STC) tool and BI application
Activity 2.4 Developing STC tool
Activity 2.5 Pilot implementation
Activity 2.6 Strengthening advanced statistical analysis and modelling capacity of GDCRS staff
Component 3:Awareness raising on judicial statistics
Activity 3.1 National conference
Activity 3.2 International conference
Component 4:Increasing the capacity of GDCRS and other stakeholders
Activity 4.1 Study visits
Activity 4.2 Trainings
Task 4.2.1 T1 Training of Trainers
Task 4.2.2 T2 Training of Trainers II (in provinces),
Task 4.2.3 T3 Introduction to Statistics
Task 4.2.4 T4 Data mining and prediction
Task 4.2.5 T5 SQL and R
Task 4.2.6 T6 Introduction to Big Data and Hadoop
Task 4.2.7 T7 Infographics and desktop publishing
Task 4.2.8 T8 Introduction to ETL tools
Task 4.2.9 T9 Professional English training
