Transcript Design and establish the portal of ECO Statistical Network

Statistical Center of Iran
ECO Statistical Network
Agenda
•Problem Definition
Problems
The Solution Definition
•The Solution Description
Pilot Plan
Exhibition of a few examples
The Problems
•Static & dispersed web site
•Manually collection data structure
•Inconsistent data
•Different physical frameworks and formats
•Difficulty in analyze
•Need to data management
•Need to management in inconsistent and conflict data
•Growing volume of data
3
ECO Statistical Network Objectives
•Design and Implement an Integrated system
•Data and Information Management
•Provide a suitable platform to respond for any
analytical queries
•Provide any Interactions with International
organization
•Present variety of reports in differenent formats
(pdf, excel)
•No need to any Special knowledge for users
•Publish all information and Analysis on a portal
A need …
Need to all existent data about a special subject
Cross-check and transformation of all statistical data to a unified and integrated
Template through which all decision-makers needs are satisfied.
ECO Member’s Statistics
Decision
Makers
Integration
International
Organizations’ Statistics
Statistical Center Of Iran
Definition
The ECO Statistical Network collect 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.
6
Design and establish the portal of ECO Statistical Network
The Portal of ECO Statistical Network
ECO Statistical Network is constructed by
Database Office
Facilities
•Access to ECO Statistical Network
•View and Download ECO Publications
•View the Chart & Figures
•General Information about ECO member
countries
• Comparable Statistical Information of ECO
member countries
•Using the ECO Statistical Network facilities
•Abstracts of information analysis, Charts &
figures
Portal Menus
• About ECO Statistical Network
oAbout
oBenefits
oManual
oProblem Solving
 About ECO
o Brief Introduction
o Activities
o Objectives
• Member Countries
o General Information
o Focal Points
• Statistical
o General Information
o Population growth rate
o Total labor force
o Unemployment rate
o GDP at current price
o GDP per capita
o GDP growth rate
o Public sector revenues
o Composition of GDP by sectors
Portal Icons
•
•
•
•
•
•
Publication
Upcoming Event
ECO Statistical Network Facts & Figures
ECO Links
Trade & Investment Directorate
Samples of Analysis & Time Series
Design and Establish ECO Statistical Network Database
Reporting
Tools
ETL
OLAP
ECO Data
warehouse
Data Integration(ETL)
Extract
Transform
All these processes are done
automatically in Statistical
Center Of Iran
Load
Staging DB
Data Transformation and Integration
•Data Extraction from the country member’s folder
•Checking: existing, name, format
•Filtering: Is not null, greater than, less than, includes
•Data calculations: average, absolute value, arctangent,
natural logarithm
•Mail to the country about the problems and error
•Loading to main Database
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)
Integrated
Savings
Application
Current
Accounts
Application
Loans
Application
Subject = Customer
ECO Statistical Network
Subject Oriented
Equity
Plans
Savings
Shares
Loans
Operational Systems
Insurance
Customer
Product, Sales
Information
ECO Statistical Network
Subject Area
Non Volatile
Load
Operational Databases
ECO Statistical Network
Database
INSERT
Read
UPDATE
DELETE
Read
Time Variant
Data is stored as a series of snapshots, each representing a
period of time.
Time
Data
01/97
Data for January
02/97
Data for February
03/97
Data for March
ECO Statistical Network
Data Cubes
22
Analysis
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
Pilot Plan
•Data extraction from http://www.ecosecretariat.org/
•Categorized as a few segments (Population, Financial
Intermediation,…) based on Iran Statistical yearbook
•Loading to main database
•Designing and Publishing 6 Data Cubes
Time-Series
Export to pdf format
Export to excel format
Variety of
Graphs
and Charts
Pie Charts
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
30
Users with Special
Privileges
30
Exhibition of a few examples
Financial Intermediation Cube
Storage, Transport Cube
31
31
Main objectives of ECO Statistical Network
•Information Dissemination of statistical data of
countries, presents the provision of different
subjects, meetings, conferences
•Presents Analytical Processing and Reporting facilities
ECO Statistical Network Users:
•Ordinary Users(Limited Access):
Students, Researchers, International Organizations
•Users with specific permission:
High ranking authorities of countries
(Presidents, Ministers, Top Decision
Politicians, …)
Makers,
How To Start:
Statistical Center of Iran can instruct countries
member to
•Uploading data and statistical indices
•Using analytical processing and ad-hoc
reporting
Thank You
35