SECRETARIAT OF THE PACIFIC COMMUNITY REGIONAL MEETING OF

SECRETARIAT OF THE PACIFIC COMMUNITY REGIONAL MEETING OF HEADS OF PLANNING AND HEADS OF STATISTICS (HOPS) (Noumea, New Caledonia, 12 -16 July 2010) Data Dissemination Day 5 5. 2 - Data Quality 5. 1 – DATA ACCESSIBILITY 5. 3 - Data Dissemination James Hemphill Web Developer/Data Dissemination Specialist Statistics and Demography Programme

Data Quality July 16 th 10. 00 – 12. 00 Session 5. 2 Pacific DATA QUALITY PRISM Redevelopment Plans for 2010 and Beyond TABLE-BUILDER INTRO Beyond 2020 – Mark Feary Redatam – Alehandra French Polynesia

Data Accessibility July 16 th 10. 00 – 10. 45 Session 5. 2 a Pacific DATA ACCESSIBILITY 3 Quotes of the Original Purpose of PRISM 1. “The concept of PRISM is, simply, to give NSOs the tools and the skills to develop, publish and maintain their own Internet websites containing key statistical indicators, statistical summaries, reports, concepts definitions and other documentation for the statistical indicators”. 2. “Benefits are an improved data dissemination service, more responsive to user needs, and a higher profile, reduced workload, and improved access to data for the NSOs”. 3. “to contribute to better informed policy and decision making in the Pacific region in order to reduce poverty in the Pacific Island countries and territories (PICTs)”.

Data Accessibility July 16 th 10. 00 – 10. 45 Session 5. 2 a A short history of PRISM 1. From 2002 to September 2004 the project was funded by DFID. This first phase was very successful with PRISM leading to 14 NSOs publishing Internet websites, bringing the number of NSOs in the region with websites to 19. 2. Funding was then taken over by Aus. AID which allowed the project to continue to September 2007. During this phase, further improvements and enhancements have been achieved to NSO websites through the training and technical assistance activities of the PRISM Manager, complemented by other Statistics Programme activities. 3. Support for the ongoing third phase has been provided by SPC to fund the PRISM Manager (Raymond Vuti) position to update the SPC PRISM website and the regional information system. With Raymond’s departure, the position of ‘PRISM Manager’ is no more, with James taking up the responsibilities of PRISM as the new ‘Web Developer/Data Dissemination Specialist’

Data Accessibility July 16 th 10. 00 – 10. 45 Session 5. 2 a PRISM and its Evolving Role Original Role Ongoing and Future Role Set up NSO websites Provide training in Frontpage 2003 Develop regional tables Publish regional tables on PRISM Collate publications Enhance existing websites Provide training in CMS Quality checks on regional tables Increase functionality for dissemination

3 Main Objectives for PRISM 2010: Information Gathering and PRISM Healthcheck 1. Maintain and build strong relationships with the PICTs and SPC Programmes, to ensure maximum involvement with the Project, and timely collection/delivery of accurate data. 2. To construct a robust centralized database with standardized schemas, from which users can pull custom information in a variety of formats. 3. Focus on PRISM usability and design, to allow users to access information with minimal training. Use of a modern CMS such Joomla, Drouple, Wordpress or Dot. Net. Nuke… Training Schedule and Release Program

1. Maintain and build Strong Relationships by: 1. Regular email contact with PRISM Development News , and regular invitations for feedback. 2. Ensuring an efficient methodology is in place for collection and delivery of the core and non-core indicators. 3. Developing and maintaining verbal and in-person relationships wherever possible. Forums (e. g. PACPRISM) Social Networks Steering Groups SPC Section Meetings Progress Reports Involve as many specialists as possible to add value to the data and enable us to not only provide data but also to advise on usability

2. Centralization of Data. 1. The proposition is to have a database hosted at SPC to which other countries feed into via standard schemas and formats 2. Countries can still take snapshots so they can work with local data 3. Centralization will provide flexibility for multiple front-ends to be developed (websites, applications, etc. ) from the same data 4. Missing data can be tracked via alerts 5. Improve data reliability and accuracy 6. Improve overall trust of PRISM Database Design Normalization Backups and Security Clear Schema Requirements Include Spatial Data

2. Construct a robust centralized database: PRISM DB to WEB PRISM WEBSITE NSO Website Text/CSV Files Charts and Graphs NSO Website PDF Reports Data Visualization and File Downloads Meta. Data/Micro. Data Charts and Graphs Publications and Articles PRISM DB NSO Standard Data Input NSO DB DB

3. Increase PRISM Usability and Design by: Introducing some or all of the following: 1. 2. 3. 4. 5. 6. 7. Map Driven Interface Customizable Look-and-Feel Simplified Menu Bar Multiple export formats Interactive Bar Charts and Tables of Info Use of Imagery/Photography Option to Register and receive PRISM/SDP update emails Analyzing PRISM workflows – ensuring these are supported by Design

Design Inspiration 1: Use of Map Navigation http: //planet-connect. org/internship-colunteer/map Other Examples: http: //apps. nowwhere. com. au/Stats. NZ/Maps/default. aspx http: //www. newcaledonia. com. au/discover/map/

Design Inspiration 2: Use of clear panels and Photography http: //www. dfid. gov. uk/

Design Inspiration 3: Use of clear panels and Photography http: //www. oxfam. org/

Design Inspiration 4: Use of clear panels and Photography http: //www. worldpulse. com/

Design Inspiration 5: United Nations http: //www. unric. org

What is Joomla and why use it? 1. Joomla helps you build your own website 2. Joomla is: – – 3. An open-source content management system Easy to use, flexible and secure Free! Widely used You have complete control over content

What’s a content management system (CMS)? 1. Like a library – manages information on your website 2. Can store everything – data, photos, articles, videos… 3. You choose if/when you want information to appear on your site 4. Can define who can edit/add/access information via user roles JOOMLA! Wordpress Drupal Dot. Net. Nuke

Who uses Joomla? • The United Nations • Governments • Universities • Organisations • Business • The SPC www. unric. org http: //oman. org. au http: //www. kalselprov. go. id http: //www. lincoln. ox. ac. uk/ http: //www. refedd. org/ http: //www. mitsubishi. pl/ http: //www. epicier-bio. fr/ http: //www. spc. int/

http: //www. spc. int/prism

Action! Develop and Publish a Fresh Web Banner to show clear contact Information Publish ‘a few’ RECENT publications and/or reports And some ‘latest news’ items Use this Initial Contact as a spring-board for dealing with switching to Joomla, country data gaps, and training

? Table Builder? Custom Results Control Large Datasets Cross Tabulation

Data Accessibility July 16 th 10. 45 – 11. 00 Session 5. 2 b Table Builder – 3 Examples Laurent Pellet, French Polynesia