One source serving multiple needs

1
One source serving multiple needs

• Easing the data collection of recurrent users
• OECD Expert Group on Statistical Data and
  Metadata Exchange 1-2 April 2004
• Annegrete Wulff
• Statistics Denmark

2
Some Dissemination Principles
StatBank is the place for all official statistics
New figures are released 930 am to all users -
in all media
www.dst.dk is the access point to dissemination
3
Data Warehouse
4
Consistent Metadata

• Centralized
• variables
• values
• unit
• by/and
• time
• template for quality declaration

• Decentralized
• contents
• footnote
• contact person
• quality declaration

5
(No Transcript)
6
Release of Data

• Once a day at 930 am
• Subject matter division
• load data
• check data
• Databank unit
• designs system for systematic error checking
• Error handling procedure

7
1,000 matrices in Danish and English

• 1,2 million retrievals

65 only on screen 6 in maps
HTML table on screen
Downloads of a file
80 downloads in Excel 13 downloads in
PC-AXIS 7 downloads in other formats
8
From StatBank to GESMES

• First time...
• 1. Start StatBank Web interface on the Intranet
  Application Server
• 2. Select the relevant part of the matrix for
  Gesmes/TS output
• 3. Save the query and select Gesmes/TS
• 4. Fill in Gesmes information in form (as defined
  by Eurostat) and Save
• When new figures are ready...
• 1. Update SumDataBase as usual with data and
  release date
• Dont worry about the rest.

9
Receipt of data

• Registered /non-registered users
• Ad hoc use
• retrieve a table 1.2 million
• present it on screen 65
• Repeated use
• saved query
• data shoot
• any format
• Excel web queries
• GESMES/TS
• XML
• Documentation
• footnotes
• declaration of contents
• links

10
International reporting
Eurostat
GESMES Excel Excel web queries csv View on
StatBank PC-AXIS
OECD
IMF
ECB
UN