This guide is intended to introduce you to Beyond 20/20 Web Data Server by carrying out a simple and hopefully typical research task using the UNIDO Industrial Statistics.

Visualise and download employment information in the motor vehicles industry for France, Germany and Italy over a 10 year period from 1992 to 2002.

It is divided into three stages:

1. Finding and selecting the data
2. Visualising the data
3. Downloading the data

Approx. time to complete: 20 minutes.

A4 worksheet version of this task can be printed in or pdf format.

For help, please contact the ESDS International team.

Stage i) Finding and selecting the data

Choose UNIDO Industrial Statistics from the 'Direct Links to data' drop down list on the ESDS International website, or via the following url - http://esds.mcc.ac.uk/wds_unido to access the UNIDO Industrial Statistics database.

Input UK HE/FE Institutional username and password in the login window. If you do not have a UK HE/FE Institutional id, please visit the login help pages within the Access and Preservation section of ESDS.

If you have not already registered with the ESDS you will then be automatically redirected to complete an online registration before being able to access the data using only your UK HE/FE Institutional username and password.

On entering the Beyond 20/20 Web Data Server site for the UNIDO data you should see a folder labeled Current databases (Edition <year>). Expand the folder to view a list of the UNIDO databases hosted by ESDS International:

• Industrial Statistics Database <year> at the 3- and 4-digit level of ISIC Code (Revision 3)
• Industrial Demand-Supply Balance Database <year> at the 4-digit level of ISIC Code (Revision 2)
• Industrial Demand-Supply Balance Database <year> at the 4-digit level of ISIC Code (Revision 3)
• Industrial Statistics Database <year> at the 4-digit level of ISIC Code (Revision 2)

Note: For further information on the countries covered, the table items and the ISIC Codes (inc. combination codes) please refer to the UNIDO Dataset user guide held on the ESDS International website.

<<top

Select the first folder - Industrial Statistics Database <year> at the 3- and 4-digit level of ISIC Code (Revision 3) – and then select the report table entitled Industrial Statistics Database at the 3- and 4-digit level of ISIC Code (Revision 3), Countries A-M and it will open in the Country dimension view to allow you to choose the country items to be viewed.

On the left hand side of the screen you will see the available dimensions under Columns, Rows and Other headings. The current dimension is highlighted in grey, for example in the screen shot above the Country dimension is highlighted and a list of the countries and areas available for selection are shown on the right hand side of the page.

Scroll down or use the search box to select France, Germany and Italy from this dimension by placing a tick in each box next to these country names.

Use the Select Items to View icon to move onto the next dimension Table. Alternatively, click directly on the Table link under the Other heading.

Select Employees by using the appropriate the tick box.

<<top

Use the 'Select Items to View' to move to the next dimension ISIC. Search for ‘motor vehicles’ and select 3410 Motor vehicles.

Use the 'Select Items to View' tool to move to the next dimension Year.

Use the Select Range tool and then select 1992 and 2002 to select the 11 year period from 1992 - 2002.

Note: There is a new profile function in Beyond 20/20. Profiles enable you to save your selections from each dimension (for example, country or series) of the database. When you return to the database you can re-activate your previously saved profiles. Selections in each dimension are saved individually so you can save selections in as many or few dimensions are you want.

For example, say you wish to select data for a number of countries in a particular database. Once you have selected your countries you can then save this selection as a named profile by clicking on the profile icon then choosing 'Save current selections as a profile' option: Beyond 20/20 will then remember the countries you have selected and store this selection as a named profile for you to use in future sessions. The procedure can be repeated for any other dimension of the database.

Each time you log on, Beyond 20/20 will recognize who you are and can retrieve your previously saved selections for that database. This means that the next time you wish to run the same query you can click on the profile icon then select 'Activate profile' to reopen your saved selections. The profiles will be saved until you choose to delete them.

You have now completed the Finding and Selecting data stage and can move on to visualising your data.

<<top

Stage ii) Visualising the data

There are two ways of visualising data in Beyond 20/20 WDS - in chart or table format.

View the report in table format by clicking the 'Show Table' button at the top of the screen.

And the Table appears:

Change the format of the table by dragging and dropping the dimension headings to new positions, as shown in the screen shot below, or by using the 'Set Dimension Order' icon.

<<top

View the report in chart format by using the 'Chart' tab at the top of the screen.

The chart below shows the number of employees in the motor vehicles industry in France, Italy and Germany over the period 1992 - 2002.

Use the 'Chart Types' icon to change chart type and the 'View printable version' icon to print the chart.

To save the chart image, use Alt + Print Screen and paste into a paint program as right clicking to 'Save picture as' only saves the chart itself and not the chart key or heading.

<<top

Stage iii) Downloading the data

Return to the Table tab to download the data to your computer. Manipulate the table into desired format by dragging and dropping the dimension headers as the table layout and contents are downloaded exactly as they appear on screen.

Use the Download icon and select your desired download format.

The rest of the process is the same as downloading any file from the web.

Congratulations you have successfully completed the UNIDO Industrial Statistics tutorial - now you are ready to do some serious work with your downloaded data!

Please see the UNIDO Industrial Statistics dataset user guide for further information on the contents of the database.

If you would like to move to another database you can select the 'Quick Links to Macro Data' drop down box at the top of the page then select the database you require.

Tested on Netscape 7 and Internet Explorer 7

Note: All Beyond 20/20 images used on this page are Copyright © Beyond 20/20 Inc. All rights reserved.

<<top