eco statistical network (ecostat)
DESCRIPTION
ECO Statistical Network (ECOSTAT). Statistical Center of Iran. Definition. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/1.jpg)
ECO Statistical Network (ECOSTAT)
Statistical Center of Iran
![Page 2: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/2.jpg)
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.
Definition
2
![Page 3: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/3.jpg)
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
![Page 4: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/4.jpg)
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, …)
![Page 5: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/5.jpg)
ECO Statistical Network
![Page 6: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/6.jpg)
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
![Page 7: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/7.jpg)
ETLETL
ECO Data warehouseECO Data
warehouse
Reporting Tools
OLAP
![Page 8: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/8.jpg)
8 8
General View of Solution
Cnt 1
Cnt 2
Cnt n
SCI
Other Organization
ECO Countries
Users with Special Privileges
ETL
FTP-Site Main DB
ECO Statistical Network Portal
Ad-hoc Reporting
Analysis
![Page 9: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/9.jpg)
Data Integration(ETL)
Extract Transform Load
Staging DB
![Page 10: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/10.jpg)
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
![Page 11: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/11.jpg)
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)
![Page 12: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/12.jpg)
Analysis and ReportsView 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
![Page 13: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/13.jpg)
Time-Series
![Page 14: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/14.jpg)
Export to pdf format
![Page 15: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/15.jpg)
Export to excel format
![Page 16: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/16.jpg)
Variety of Graphs and
Charts
Pie Charts
![Page 17: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/17.jpg)
![Page 18: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/18.jpg)
18
Exhibition of a few examplesExhibition of a few examples
18
Analysis and Report
FTP-Based Extraction
![Page 19: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/19.jpg)
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
![Page 20: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/20.jpg)
System Prerequirements
Hardware resources Software resources Human resources
![Page 21: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/21.jpg)
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
![Page 22: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/22.jpg)
System Prerequirements
Complete set of harmonized and updated data for all ECO member
states
(ECO Database)
![Page 23: ECO Statistical Network (ECOSTAT)](https://reader035.vdocuments.us/reader035/viewer/2022081419/56814f73550346895dbd2692/html5/thumbnails/23.jpg)
23
Thank You