msis2013 by jonathan challener update on the activities of the oecd"s statistical information...
TRANSCRIPT
![Page 1: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/1.jpg)
MSIS2013By Jonathan Challener
UPDATE ON THE ACTIVITIES OF THE OECD"S
STATISTICAL INFORMATION SYSTEM
COLLABORATION COMMUNITY
![Page 2: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/2.jpg)
Who we are?
OECD
AUSTRALIAN BUREAU OF STATISTICS
EUROPEAN COMMISSION
INTERNATIONAL MONETARY FUND
ITALIAN NATIONAL INSTITUTE OF STATISTICS
STATISTICS ESTONIA
STATISTICS NEW ZEALAND
UNESCO INSTITUTE FOR STATISTICS
UNIVERSITY OF MANCHESTER
![Page 3: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/3.jpg)
Interested?
INSEE
National Bank of Belgium
"Rich in functionalities and easy to use"
"Built for ENDUSERS"
"Very good process automation options"
"Modern user interface and functionality"
"Good perspective"
"Develop our own tool will take a long time and a lot of resources"
"Other similar available tools seem to no longer be improved or have blocking limitations"
"To be part of a collaboration community"
![Page 4: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/4.jpg)
Why collaborate?
![Page 5: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/5.jpg)
Why collaborate?
Co-producing and co-developing state-of-the-art StatisticalInformation Systems by leveraging on community capacities.
Sharing of experiences, knowledge and best practices throughmultilateral collaboration and building of a collective capacity.
Enabling innovation at an optimal cost in a minimal time with all
members benefiting from each other in terms of ideas and methods.
Provide a platform for Open Data projects as identified as a priority for major member countries.
Implementing standards (SDMX) for data sharing across organisations in order to improve data accessibility and quality, and reduce costs.
![Page 6: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/6.jpg)
Why collaborate?
![Page 7: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/7.jpg)
On what?
.Stat is the central repository ("warehouse") where validated statistics and related metadata are stored.
It provides the sole and coherent source of statistical data and related metadata for an organisation"s statistical data
sharing, publication and electronic dissemination processes.
![Page 8: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/8.jpg)
.Stat positioning in SIS
![Page 9: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/9.jpg)
.Stat architecture
Flexible multi-dimensional datasetsStructured for human consumptionFlexible access rights
Referential metadata, flags, 2 languagesHierarchical and common dimensions
SQL Server db with star schema, .NetWeb services, web and other client applications
Autonomous data ownersLoosely coupled, platform independentPriority to extractions
![Page 10: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/10.jpg)
.Stat key components• Theme navigation & search• Flexible data tables,
selection and view options• Interactive graphs• Default and personal
queries• Excel, CSV, PC-Axis exports
Web browser
• V2.0 and partly 2.1• SOAP + REST• DSD, MSD, Generic Data,
Compact Data, generic Metadata
• Authentication, Streaming
SDMX
• Synchronised transactional 24/7 data loads
• XML + CSV• E-mail notification• Optional user-friendly GUI
Entry gate, DPI
• .Stat Populator• DotStatGet tool suite• Direct SQL access
Internal access
![Page 11: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/11.jpg)
How?
![Page 12: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/12.jpg)
Community enablers
Governance,
process and
funding
Members and
culture
Tools and technolog
y
![Page 13: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/13.jpg)
Strategic 5 year directions
Community framework
100% community consensusupdated yearly; renewed every 5y
MOU
Bilateral agreement between "x" and OECD
Intellectual
property
100% OECD but made available for use by community
Governance
model
100% OECD with community validation
Community
yearly
workplan
100% communityconsensus
OECD
yearly
workplan
100% OECD shared with community
![Page 14: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/14.jpg)
Community activities
Strategic level Management level
Operational/Technical level
Installation and supportIntegration of other
toolsPrepare SoW for GP
Acceptance of GP deliverables
Prepare MOUPrepare Grant request
Sign off SoW for GPOn-demand meetings
Sign off MOUSign off Grant
Sign off governance model
Sign off the 5 year strategic roadmap and
its yearly update
Sign off yearly workplanMonitor ongoing
progress (Quarterly reviews…)
Prepare Governance model, Strategic
roadmap
Bilateral activities plan Community activities
![Page 15: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/15.jpg)
Supporting activities
Application Lifecycle managementSource code management in TFS, quality assurance, SCRUM
Technical support networkInstall package, collaboration portal (documentation, discussions), capacity building
Management meetingsQuarterly management meetings, frequent developer meetings
Annual workshopsCollaboration partners, Interested and industry experts, interactive sessions
Global development partnerSupport, maintenance and development
![Page 16: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/16.jpg)
Funding model
OECD Workplan
SIS-CC coordination
& support
OECD Contribution
Standard financial contribution by SIS-CC members
SIS-CC Community
Workplan
Ad-hoc financial or in-kind contribution by
SIS-CC members
![Page 17: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/17.jpg)
Contributing to product roadmap
Option 0: SIS-CC Member contributes in-kind through onsite or remote developments
Option 1: SIS-CC members contributes in-kind through direct contract with OECD Global Partner
Option 2: SIS-CC Member contributes financially through OECD funding
![Page 18: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/18.jpg)
ACHIEVEMENTS TO DATE
![Page 19: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/19.jpg)
….. more to follow soon:- UIS.Stat, - EC.Stat, - ES.Stat (Estonia)- …..
.Stat World Wide platform
![Page 20: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/20.jpg)
• Security enhancements• 3-tier architecture and 2 new web services• SDMX-RI prototype integration• New interface design• New data structure• Support of Time Series IDs• Support Non-calendar year based reporting• Unit and Powercode management• Management of sparse datasets• Improved installation package• Search API to connect to 3rd party engine• Open data web services
.Stat enrichment
![Page 21: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/21.jpg)
• As part of the 2012 workshop a process was initiated to define a JSON format based on SDMX by the SDMX-TWG– This year we launched the very first "BETA"
API using an early implementation of SDMX-JSON
http://oe.cd/OpenDataAPI/
Community leveraging
![Page 22: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/22.jpg)
The results speak for themselves
![Page 23: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/23.jpg)
Open Data API initiative for developers
INEGIhttp://www3.inegi.org.mx/rnm/sdmx
OECDhttps://c9.io/h4mu/sdmx-json-apps/workspace/memory/memory.html
UIShttp://www.uis.unesco.org/das/Country/OdataTest
DRASTIC DATAhttp://www.drasticdata.nl/ProjectOECD/
![Page 24: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/24.jpg)
Directions for the .Stat roadmap
![Page 25: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/25.jpg)
NON REUSABLE
REUSABLE
![Page 26: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/26.jpg)
sdmx-json
odataSVGSearch
![Page 27: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/27.jpg)
![Page 28: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/28.jpg)
The same language said differently
![Page 29: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/29.jpg)
![Page 30: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/30.jpg)
CAPACITY TO SCALE
![Page 31: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/31.jpg)
![Page 32: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/32.jpg)
Continue to enhance the user experience
![Page 33: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/33.jpg)
FRAMEWORK EVOLUTIONS
![Page 34: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/34.jpg)
• Put in place 5 year strategic directions:– roadmap, community vision, architecture,
business vision, and industrialisation
• Create an architecture group to drive technical and business architecture
• Introduce a Bi-annual workplan, reviewed annually
• Explore future directions for plug and play architecture and international positioning
Framework evolutions
![Page 35: MSIS2013 By Jonathan Challener UPDATE ON THE ACTIVITIES OF THE OECD"S STATISTICAL INFORMATION SYSTEM COLLABORATION COMMUNITY](https://reader035.vdocuments.us/reader035/viewer/2022081515/56649cea5503460f949b517f/html5/thumbnails/35.jpg)
Further information
Questions?
Email:
or