What is Harzemli Project

1. National Seminar on Developing a Program for the Implementation of the 2008 SNA and Supporting Statistics in Turkey Mahmut MOL10 September2013 Ankara - Turkey

2. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey What is Harzemli Project • Harzemli Project is an attempt to standardize all statistical IT processes with respect to metadata. • Metadata is used in • Production • Analysis and data mining. • Dissemination • Harzemli Project especially focuses on production. • Its main objective is to develop IT applications that automatically creates data entry applications from metadata. 14.10.2014

3. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey TURKSTAT ITC Background 14.10.2014

4. National Seminar on Developing A Program for the Implementation of the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Data Collection Model Data collection by forms Microdata filled on forms Harzemli Web Production DB Data collection by netbooks Harzemli Desktop Local DB Web Services

5. National Seminar on Developing A Program for the Implementation of the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Harzemli Project Metadata Editor Rule Editor Classification Server DDI Document XML Rule File Codelists + Variables Harzemli Web Software Harzemli Desktop Software Web Data Collection Interface Desktop Data Collection Interface

6. National Seminar on Developing A Program for the Implementation of the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Harzemli Project

7. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Screenshot of “Supply and Use Tables Questionaries ” data entry interface prepared by Harzemli Web

8. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Screenshot of “Supply and Use Tables Questionaries” data entry interface prepared by Harzemli Web

9. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Metadata Editor • Metadata Editor is a tool to create metadata in DDI format. • Surveys can be designedon this software by defining the structural • and referential metadata. • Structural metadata consists of datasets, variables and variable groups. • Document description and study description constitute the referential metadata.

10. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Rule Editor • Rule editor is a desktop application that defines the rules for a variable or between • the variables. • Rule editor consists of • simple edit rule • show-hide rule • function rule • read only field rule • nullable fields rule

11. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Metadata Usage • Metadata studies in TURKSTAT • Sessions were arranged to inform and aware personnel about metadata. • Metadata workgroup was founded. • All departments were trained about elementary metadata. • Data and process standardization activity plan was prepared.

12. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Metadata Usage • Metadata studies in TURKSTAT • Household Labour Force Continuous Survey was chosen as pilot study. • Codelists was defined which will be used in production databases. • “Variable and Dataset Naming Standards” document was prepared. • Metadata of 125 study was prepared and presented on intranet of TURKSTAT.

13. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Standardization • Data and process standardization activity plan • All productive units will apply TURKSTAT data architecture. • All statistical processes will be defined according to GSBPM. • Metadata needs and standards will be defined. • Studies will be presented on a common platform (NADA).

14. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Standardization • Data and process standardization activity plan • Common variables and standard codelists will be defined. • Applications will be developed on basis of metadata system. • All statistical production, analysis and dissemination processes will use metadata system.

15. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Harzemli Projects Done Harzemli Desktop projects Household Labour Force Continuous Survey Life Satisfaction Survey Labour Cost Survey ICT Usage in Households and by Individuals

16. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Harzemli Projects Done HarzemliWeb projects Supply and Use Tables Questionaries Waste Disposal and Recovery Facilities Statistics Municipal Waste Statistics Municipal Wastewater Statistics Municipal Water Statistics Environmental Revenue And Expenditure Statistics For Municipalities Community Survey on ICT Usage and E-commerce in Enterprises Environmental Employment and Expenditure Statistics For Governmental Organisations/Private Provincial Administration Mining Establishments Water, Wastewater and Waste Statistics Environmental Expenditure Statistics for Local Administration Unions

17. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • TURKSTAT Harzemli Projects Done HarzemliWeb projects (continued) Organized Industrial Zones Environmental Statistics Waste Statistics of Health Institutions Technical Training Programs Level Determination Form Thermal Power Plants Water, Wastewater and Waste Statistics The Community Innovation Survey Non-Domestic Producer Price Index Cause of Death Statistics Manufacturing Industry Water, Wastewater and Waste Statistics Business Sector Environmental Employment Revenue and Expenditure Statistics Labour Cost Survey

18. National Seminar on Developing A Program for the Implementationof the2008 SNA and Supporting Statistics in Turkey 10 September 2013 / Ankara - Turkey • Future Plans • Include all the studies in the scope of Harzemli. • Develop a software that productive units can design survey forms in a more • productive way. • This software will also enable to see the result of design immediately. • Rule will also be defined on this software more user friendly. • The vision of Harzemli Project is to transform it to an international software.

19. Akın ÖZTÜRK (Harzemli Software Development Group Leader) • Mahmut MOL (Harzemli Web Development Team Leader)