1 / 19

Nesstar Publisher Training

Nesstar Publisher Training. Trainers: Carol Perry, University of Guelph Ernie Boyko, Carleton University Ontario DLI Training Guelph University, Guelph, ON April 10-11 , 2006. Outline. Overview The basics Getting Ready Opening your file Adding tags Templates Managing the server

mauli
Download Presentation

Nesstar Publisher Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nesstar Publisher Training Trainers: Carol Perry, University of Guelph Ernie Boyko, Carleton University Ontario DLI Training Guelph University, Guelph, ON April 10-11 , 2006

  2. Outline • Overview • The basics • Getting Ready • Opening your file • Adding tags • Templates • Managing the server • Publishing your file

  3. Nesstar - an overview Metadata and data editing/transformation Data and metadata retrieval and display Extract Metadata and data input Publisher End-user clients Load and manage Retrieve Internet

  4. Nesstar Publisher • Nesstar Publisher is the ETL (Extract, Transform, Load) tool of the Nesstar product suite. It enables you to: • extract data and metadata from a variety of sources, systems and formats • clean, change, edit and extend the data and metadata, and • publish data and metadata to a Nesstar Server • Can also be used to manage the content on a Nesstar server • Can be used independently of the Nesstar System as a general data/metadata entry and editing tool

  5. Nesstar Publisher cont. • The Publisher supports: • micro-data (e.g. survey-data) • hierarchical data (e.g. household studies) • aggregated data (multidimensional tables or cubes) • additional information objects (e.g. reports, factsheets, pictures) to be stored on a Nesstar server Today we will be working with micro-data

  6. Preparing & publishing micro-data Meta- data Data Nesstar Publisher Server NSD- stat file Hierarchical Publisher

  7. What do we mean by data? • Tabular data • Indicators • Time series • Maps • Survey data • Non-data resources • Documents • Pictures All stored with descriptive information

  8. Metadata • What is metadata? Basically defined as ‘data about data’ • Aim of metadata is to make a resource ‘findable’ and ‘manageable’ and to enable the effective, efficient and accurate use of data resources • Within the Nesstar system - metadata added by using templates

  9. Metadata standards supported by Nesstar Publisher • DDI (http://www.icpsr.umich.edu/DDI) “Enables the effective, efficient and accurate use” of data resources • Dublin Core (http://uk.dublincore.org/) “A standard for cross-domain information resource description” • e-Government Metadata Standard (e-GMS) (http://www.govtalk.gov.uk/) “To ensure maximum consistency of metadata across public sector organisations”

  10. Importing / Exporting of data Formats for: Import:Export: • DDI document *.xml • SPSS: *.sav, *.por, *.sps *.sav, *.por, *.sps • SAS: *.sp1 *.sas (syntax) • Stata: *.dta (STATA 7 & STATA 8) *.dta • Statistica: *.sta *.sta • NSDstat: *.nsf *.nsf • dBase: *.dbf *.dbf • DIF: *.dif *.dif • Fixed Format ASCII *.dat • Delimited text: *.txt, *.csv *.txt • PC-Axis *.px

  11. Demonstration • First steps • SPSS • Importing files

  12. SPSS Files – First Things First • Nesstar assumes you have a clean SPSS file. This is NOT always the case. • If you need to re-import your data, you will lose any work done in Nesstar • To avoid this, you should make sure to check the following:

  13. Make sure that: The respondents have an id variable All the variable labels and value labels are correct All the missing values have been declared All the recoded variables are correct The weight has been turned OFF SPSS Checklist

  14. Variable level metadata • Variable labels can easily be added/edited • Category labels can easily be added/edited • Identify ‘Weight’ variables • Add question text and variable notes: • to each variable separately • to a block of variables

  15. Variable Groups • Useful for grouping together variables that relate to the same topic or theme • A hierarchy of groups can be created, e.g. topics within a ‘Self-completion’ section • Variables can belong to more than one group • Groups can be arranged in any order • Information about that group can be added, e.g. a group definition Advantages: • Make it easier for end-users to navigate the dataset • Reduce the load time of a dataset when published

  16. Manage Server • Provides the means to link to Nesstar Servers to enable publishing • Enables the data publisher to manage the resources on a Nesstar server so that they can then: • Create new catalogues then name and describe them • Reorganise the catalogue hierarchy • Add files to a catalogue • Move files between catalogues • Delete files and catalogues

  17. Publishing • Add a Nesstar Server using the Server-URL, or locating the Server directory on a LAN, and entering an appropriate username and password • Can publish to a Nesstar Server over a local area network (LAN) or over the Internet • Able to publish to multiple Servers in a single operation • Options to publish ‘data and metadata’, ‘metadata only’ or to ‘Republish’

  18. Templates in Nesstar • Templates contain default information that can be reused if you are importing a series of surveys. • This saves having to re-enter the same information over and over and over and over

  19. The Statistics Canada Template

More Related