ICT Strategy for Production, Dissemination, and Data Warehouse in Official Statistics

1. Meeting on the Management of Statistical Information Systems (MSIS 2010) (Daejeon, Republic of Korea, 26-29 April 2010) NIS ICT Strategy in the Production of Official Statistics, Dissemination and Data warehouse byPanhara OUKCHAY Deputy Director of ICT Department, National Institute of Statistics, Ministry of Planning, Cambodia

2. Content I. Introduction ICT Strategy in the Production, Dissemination of Official Statistics A. Standardized Network B. Data Storage C. Software D. Dissemination E. Data Warehouse F. Backup G. Staffing III. Conclusion

3. I. Introduction Decentralized statistical system: NIS compiles and consolidates statistics provided by decentralized offices and also collects primary data. New recently reorganization of NIS (June 2009): To meet the increasing demand of wide range of statistics of good quality. ICT department is one of the news department that just established. The ICT Strategy for the NIS is very importance. There exists a need for NIS to modernize and extend its ICT to secure timely and accurate statistics serving governmental and the public.

4. II. ICT Strategy in the Production, Dissemination of Official Statistics Standardized Network - A new physical network design for NIS has been elaborated. - The servers type of the NIS Domain are: 1. Domain Controller 2. Database Servers 3. File Servers 4. Communication Servers 5. Backup Servers 6. Application Servers

5. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) Data Storage A Client/Server based DBMS like MS SQL Server: A few factors to take into consideration on which DBMS to use: - Data integrity – Security - Performance - Backup and Maintenance - Data Warehousing Microsoft SQL Server contains a complete storage solution for an organization like NIS with the following components: - Storage Engine - Data Extraction, Transformation and Load (ETL) tools - Data Mining - Data Warehousing - Strong Access Security System

6. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) C. Software : The number of different software should be minimized. Based on the fact that the software should be recommended for the NIS: - Statistical software – Stata, SPSS - Tabulation and dissemination tools – SPSS, Excel SuperCROSS, MS SQL Server, CAMInfo,... - Office software – Microsoft Office, Open Office (KH) - Software Development tools – VB6, VB.Net and CSPro - Antivirus Software: Symantec Antivirus, Trend Micro Antivirus Corporation Edition

7. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) D. Data Dissemination: NIS is using tools below to disseminate its products to all type to users: - A Dynamic Website http://www.nis.gov.kh (May2009)

8. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) - Censuses Results On-Line

9. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) - The National Data Archive Software (NADA) and Toolkit : (Web based application tool): Various surveys documentation (Meta Data)

10. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) - Statistical Data and Metadata Exchange (SDMX): NIS is planning to implement the SDMX standards for exchanging data and metadata. - SuperCROSS (Data warehouse): this solution is very useful within organization network especially all subject matter teams (internal use). Later on in next step we are planning to establish this into the government network and and web as tabulation and dissemination tool (SuperWEB).

11. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t)

12. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) - CAMInfo (the localized version of DevInfo)

13. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) E. Data warehouse: - DBMS : MS SQL Servers - SuperSTAR families software suit (SuperCROSS, SuperSERVER, SuperCHANNEL, SuperWEB, SuperTABLE)

14. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) F. Backup : Regular backup of server drives should be carefully planned and reliable equipment using. A network backup plan is always important to make a plan for back up system. - Types of Backup . Normal Backup . Copy Backup . An incremental backup . A Differential Backup . A Daily backup

15. II. ICT Strategy in the Production, Dissemination of Official Statistics (con’t) G. Staffing : A statistical agency like NIS the ultimate goal is to ensure IT competence on all levels in order to be self-reliant. Five areas of interest will be identified with different demands on IT skills: - Day-to-Day word processing and spreadsheet handling - LAN operation and maintenance - Database design, maintenance and administration - Statistical tabulation and analysis - In-House Application Development

16. III. Conclusion Statistical agencies must recognize that the ICT Strategy needs to support the key priorities in the most cost-effective manner and must also understand the risks and challenges of ICT Strategy because it is a very importance role in its production of official statistics. It is long-run strategy plan due the NIS has a very limit of human resources, So capacity building for ICT staffs is needed to be done through daily job and in-house training. All ICT staffs of NIS should have general knowledge of each area but have near specialist competence in their own field to achieve this goal substantial training within the ICT-field is necessary.