1 / 23

ECO Statistical Network (ECOSTAT)

ECO Statistical Network (ECOSTAT). Statistical Center of Iran. Definition.

moya
Download Presentation

ECO Statistical Network (ECOSTAT)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ECO Statistical Network (ECOSTAT) StatisticalCenter of Iran

  2. Definition The ECO Statistical Network collects various information of member countries and international organizations automatically, and provides an environment for data to be saved for responding to any kind of analytical queries.

  3. ECO Statistical Network Objectives • Design and implement an integrated system • Data and information management • Provide a suitable platform to respond to • any analytical queries • Provide international organization with any • interaction • No need to any special knowledge for users

  4. ECO Statistical Network Users • Ordinary users (with limited access): • Students, Researchers, International Organizations • Users with specific permission: • High ranking authorities of countries (Presidents, Ministers, Top decision makers, Politicians, …)

  5. ECO Statistical Network

  6. ECO Statistical Network Features • Access to ECO Statistical Network • View and download ECO publications • View charts & figures • General information about ECO member • countries • Comparable statistical information of ECO • member countries • Using the ECOSN facilities • Abstracts of information analysis, charts & • figures

  7. ETL Reporting Tools OLAP ECO Data warehouse

  8. General View of Solution ECO Statistical Network Portal Cnt 1 Cnt 2 Cnt n Ad-hoc Reporting SCI ETL Main DB FTP-Site Other Organization Analysis ECO Countries Users with Special Privileges 8

  9. Data Integration(ETL) Extract Transform Load Staging DB

  10. Data Transformation and Integration • Data extraction from the country member’s • folder • Checking: availability, name and format of the • data • Filtering: Is not null, greater than, less than,… • Data calculations: average, absolute value,… • Automatically mail to the country about the • problems and errors of the data • Loading data into main Database

  11. Another Solution to Data Extraction: FTP-Based Data Extraction • A ftp-site will be set up • Every country member is given a folder, • username and password • Every country member must upload its data • The uploaded data will be automatically extracted • and loaded into main database • No need to any special Hardware and Software • A web browser is enough (IE, Firefox)

  12. Analysis and Reports View data “dimensionally” • i.e. Sales by region, by channel, by time period Navigate and explore • Ad Hoc analysis • “Drill-down” from year to quarter • Pivot • Select specific members for analysis Interact with high performance • Technology optimized for rapid interactive response Easy to export any reports(pdf, excel) Time-series

  13. Time-Series

  14. Export to pdf format

  15. Export to excel format

  16. Variety of Graphs and Charts Pie Charts

  17. Exhibition of a few examples Analysis and Report FTP-Based Extraction 18

  18. SCI Commitments • Providing technical support for maintenance • of the ECO Statistical Network • Providing training services to ECO secretariat • and member countries to: • Upload data and statistical indices • Use analytical processing and ad-hoc • reporting

  19. System Prerequirements Hardware resources Software resources Human resources

  20. System Prerequirements • Hardware Resources: • Server • Network(Valid IP, FTP Site) • Software Resources: • RDBMS • JVM • Operating System (Windows or Linux) • etc • Human Resources: • Proficiency in: • Java Applications • Data Base • Data warehouse and BI • Data Integration • Operating System (esp. Linux or Unix) • Statistics

  21. System Prerequirements Complete set of harmonized and updated data for all ECO member states (ECO Database)

  22. Thank You

More Related