Transcript PPT - United Nations Statistics Division

National Seminar on Developing a Program
for the Implementation of the 2008 SNA and
Supporting Statistics in Turkey
Mahmut MOL
10 September 2013
Ankara - Turkey
National Seminar on Developing A Program
for the Implementation of the
2008 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.
National Seminar on Developing A Program
for the Implementation of the
2008 SNA and Supporting Statistics in Turkey
10 September 2013 / Ankara - Turkey
TURKSTAT ITC Background
DATA COLLECTION
PRODUCTION
DISSEMINATION
DDI
ETL
DDI
HARZEMLİ
SAS + SPSS
INDICATORS DB
CONTENT MANAGEMENT
Alfresco + Drupal
Official Document, WEB Content, e-mail, Forum etc.
ORCHESTRATION
BPMN 2.0 / ARIS + ACTIVITI
Production + Approval Process
National Seminar on Developing A Program
for the Implementation of the
2008 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
National Seminar on Developing A Program
for the Implementation of the
2008 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
National Seminar on Developing A Program
for the Implementation of the
2008 SNA and Supporting Statistics in Turkey
10 September 2013 / Ankara - Turkey
• Harzemli Project
National Seminar on Developing A Program
for the Implementation of the
2008 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
National Seminar on Developing A Program
for the Implementation of the
2008 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
National Seminar on Developing A Program
for the Implementation of the
2008 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 designed on 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.
National Seminar on Developing A Program
for the Implementation of the
2008 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
National Seminar on Developing A Program
for the Implementation of the
2008 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.
National Seminar on Developing A Program
for the Implementation of the
2008 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.
National Seminar on Developing A Program
for the Implementation of the
2008 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).
National Seminar on Developing A Program
for the Implementation of the
2008 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.
National Seminar on Developing A Program
for the Implementation of the
2008 SNA and Supporting Statistics in Turkey
10 September 2013 / Ankara - Turkey
• TURKSTAT Harzemli Projects Done
Harzemli Desktop projects
1.Household Labour Force Continuous Survey
2.Life Satisfaction Survey
3.Labour Cost Survey
4.ICT Usage in Households and by Individuals
National Seminar on Developing A Program
for the Implementation of the
2008 SNA and Supporting Statistics in Turkey
10 September 2013 / Ankara - Turkey
• TURKSTAT Harzemli Projects Done
Harzemli Web projects
1.Supply and Use Tables Questionaries
2.Waste Disposal and Recovery Facilities Statistics
3.Municipal Waste Statistics
4.Municipal Wastewater Statistics
5.Municipal Water Statistics
6.Environmental Revenue And Expenditure Statistics For Municipalities
7.Community Survey on ICT Usage and E-commerce in Enterprises
8.Environmental Employment and Expenditure Statistics For Governmental
Organisations/Private Provincial Administration
9.Mining Establishments Water, Wastewater and Waste Statistics
10.Environmental Expenditure Statistics for Local Administration Unions
National Seminar on Developing A Program
for the Implementation of the
2008 SNA and Supporting Statistics in Turkey
10 September 2013 / Ankara - Turkey
• TURKSTAT Harzemli Projects Done
Harzemli Web projects (continued)
11.Organized Industrial Zones Environmental Statistics
12.Waste Statistics of Health Institutions
13.Technical Training Programs Level Determination Form
14.Thermal Power Plants Water, Wastewater and Waste Statistics
15.The Community Innovation Survey
16.Non-Domestic Producer Price Index
17.Cause of Death Statistics
18.Manufacturing Industry Water, Wastewater and Waste Statistics
19.Business Sector Environmental Employment Revenue and Expenditure
Statistics
20.Labour Cost Survey
National Seminar on Developing A Program
for the Implementation of the
2008 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.
• Akın ÖZTÜRK
(Harzemli Software Development Group Leader)
• Mahmut MOL
(Harzemli Web Development Team Leader)