FEDERAL STATE STATISTICS SERVICE (ROSSTAT)

1. FEDERAL STATE STATISTICS SERVICE (ROSSTAT) Unified information system ofstatistical data collection, processing,storage and dissemination (Rosstat UIS) Overview Elena Priakhina, Director of the Scientific - Research and Project Institute of Rosstat , Moscow

2. ROSSTAT MAIN COMPUTING CENTER ROSSTAT CENTRAL OFFICE TERRIRORIAL STATE STATISTICS OFFICES (TSO) DISTRICT STATISTICAL DIVISIONS (DSD) RESEARCH& PROJECT INSTITUTE I FEDERAL STATE STATISTICS SERVICE STRUCTURE

3. FEDERAL STATE STATISTICS SERVICE STRUCTURE Rosstat has the distributed hierarchical structure and includes: At the Federal level: • Rosstat Central Office responsible for methodologyand for the presentation of official statistical information to the government, to ministries and agencies and other users • Main computing center responsible for data collection from regional level, data processing and presentation to Rosstat Central Office • Scientific - Research and Project Institute engaged in the development of application software for all stages of technological process At regional level: • Territorial statistical offices (TSO) allocated in regions of the Russian Federation have to ensure statistical data collection, processing, storage and dissemination at the regional level At district level: • District (town) statistical Divisions of TSO are engaged mainly in statistical data collection from enterprises and organizations and presentation to regional level

4. Regional level – 83 Territorial statistical offices (TSO)District level – > 2000 District (town) statistical Divisions of TSO DSD

5. Russian Statistics today • OfficialFederal Plan of Statistical Works containsmore than 400 statistical works • More than 20 000 statistical indicators • Rosstat generates 60% of total volume of statistical information in Russia • 250 statistical forms (questionnaires) including: some 120 – annual, 60 – quarterly, 60 – monthly • Numberof units under statistical observation comprise more than3 million

6. Unified information systemof statistical data collection,processing, storage and dissemination (Rosstat UIS) Main goals • Decrease of data collection and processing period • Decrease of labor cost • Implementation of modern information technology Basic principles • Unification • Adaptability

7. Problems and Solutions

8. Main information flows of the systemof statistical data collection,processing, storage and dissemination Enterprises and organisations District level Regional level Federal level WEB CSI GU CSI GU Electronic questionnaires SDCP of district level SDCP of regional level SDCP of federal level Warehouse Warehouse Paperquestionnaires USERS USERS

9. Architectureof the systemof statistical data collection,processing, storage and dissemination(Rosstat UIS)

10. Subsystem of classifications • Data base of classifications • Data base of enterprises andorganizations • Data base of statistical indicators

11. The subsystem of data collection and processing • Unified software application for all statistical works - UnifiedSystem «STATEC» Componentfor electronic data collection from enterprises Component for reception (input), verification, processing and table generation • Metadata base • Operating data bases for statistical works ____________________________________ • DBMSMS SQL Server • Client-Server application is based on PowerBuilder • Web-applicationis based on ASP.NET

12. The subsystem of statistical information storage, presentation and dissemination • Data Warehouse (DWH) of statistical data have the same structure at federal and regional levels • DWH structure isbased on Catalog of statistical indicators (CSI) • Data marts aregenerated from DWH for different aims (data dissemination, analysis of selected branches and sectors of the economy) • Data disseminationis carried out via web-interfacewith Central statistical data base (CSDB) on web-site of Rosstat • Unified system for internal user access to DWH of statistical data is being developed now _________________________________ • DBMSMS SQL Server • Applications are based onPowerBuilder, ASP.NET

13. Federal State Statistics Service(Rosstat) SCREENSHOTS OF SUBSYSTEM

14. Statistical reports collection in electronic mode exports a report to MS Word or Adobe PDF Respondent logs in to the system saves and sends a report gets the stamp of sending selects a statistical form verifies a report fills a form (makes a report) signs a report by digital signature before sending

15. Statistical data processing Work 1 Work place for tablesgeneration Work 2 Work place for data entry Work place for verification Work 3 • Basic stages • Data input • Data control • Data processing (aggregation) • Printing output tables

16. There is ability to find value on name or code XML (SDMX) Printing from browser MS Excel Storage and presentation of statistical data Select: Macro or micro data. Catalogue of indicators corresponds to CSI. There is ability to find indicator on name or code. Set of dimensions depends on selected indicators. Values of dimensions has linear or hierarchical structure. There is ability to find а value of dimension on name or code from dictionary. Data arrangement in the output table depends on arrangement of dimensions and measure in the model.

17. Results • Unified system of data collection and processing on basis of “STATEC” is used for 400 Statistical works • Collection of statistical reports in electronic mode has been implemented for20% of reporting units • Statistical data Warehouse is being loaded with respective data

18. Federal State Statistics Service (Rosstat) THANK YOU FOR ATTENTION !