Transcript ECO Statistical Network Users

Statistical Center of Iran
ECO Statistical Network
(ECOSTAT)
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.
2
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
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, …)
ECO Statistical Network
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
Reporting
Tools
ETL
OLAP
ECO Data
warehouse
General View of Solution
Cnt 1
Ad-hoc
Reporting
SCI
ETL
Cnt 2
FTP-Site
Main DB
Other
Organization
Analysis
Cnt n
ECO Countries
ECO Statistical
Network Portal
8
Users with Special
Privileges
8
Data Integration(ETL)
Extract
Transform
Load
Staging DB
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
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)
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
Time-Series
Export to pdf format
Export to excel format
Variety of
Graphs and
Charts
Pie Charts
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
System Prerequirements
 Hardware resources
 Software resources
 Human resources
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
System Prerequirements
Complete set of harmonized and
updated data for all ECO member
states
(ECO Database)
Thank You
23