Statistics Canada employs the IVISION Beyond 20/20 Browser on many of its aggregate database products. This viewer provides pivoting spreadsheets, and on-the-fly mapping, graphing and exporting capabilities which allow users enhanced on-screen tailoring of data.

The following database products using IVISION softfware are available in-house at participating universities, as well as on the TDR web site:

Agricultural Census 1996, 2001
Annual Estimates of Employment, Earnings & Hours
Census 1996, 2001
Canadian Business Patterns
Criminal Justice Statistics
Econnections -1997 file only
Health Statistics at a Glance - Health Indicators
Income Trends in Canada
Labour Force Historical Review
SABAL - Small Area Business and Labour Data
United Nations Statistical Yearbook
United Nations Women's Indicators & Statistics

WORKING WITH BROWSER TABLES

The following instructions are based on the IVISION TM Browser Quickstart Guide.

Opening a Table: Web Access

1) To open a table, click on the required table from the table menu. If Beyond 2020 software is loaded on the machine you are using, the file will open.  If you are working from your own machine, download the free software from the link provided on the page.  Follow the directions given.

Table Browsing with 3 or more dimensions

1) You can browse through the items in any dimension. Select the Active Dimension by clicking on your choice of dimension in the Dimension bar (the area above the column headings). The dimension is now shown in the Active Dimension box located in the toolbar.

2) Click on the Previous Item button or the Next Item button to browse through the items in that dimension. Note that the active dimension tile shows the code or label of the item whose data is currently displayed.

3) A red dot in the upper right corner indicates that more detailed information is available in the form of a note: notes can be included at the Dimension level, Item level or Cell level. To read the note, select the area then click on the right mouse button.   Select Summary from the drop-down menu.

Displaying Alternate Item Labels

occasionally, there is more thatn one set of labels available for the items in a dimension (eg. language options). To select the next set of labels for a dimension:

1) Make dimension active by clicking on the appropriate dimension tile

2) Click on the Alternate Item Label button in the Tool bar. This will display the alternative label.  Click button again to proceed to next label option or to return to previous label.

Switching Table Dimensions

You can switch the column and row dimensions of a table by clicking and dragging the row or column and dropping it to a new location. If the column is not wide enough, simply drag it wider.  The Table will go back to its original dimension when closed.

Nesting Table Dimensions

Nesting lets you display as many dimensions as you want along the columns or rows.

1) With the left mouse button depressed, slowly drag the desired Dimension tile (one that is not already occupying a row or column) from the Dimension bar over the border of the existing headings in the column or row dimension, until a thick line (or highlight) appears.

2) Release the mouse button, and the dragged dimension will be nested.

Selecting Data from a Table

You can perform the following operations by first selecting data: display only the selected data by choosing Show from the Item menu; hide the selected data from your current view by choosing Hide from the Item menu (to display the hidden data choose Show all from the Dimension menu); chart the data; or copy your selection to the clipboard and move it to another application.

1) To select a row or column of data, click on the corresponding row or column heading.

2) To select adjacent rows or columns, drag the mouse across the row or column headings.

3) To select non-adjacent rows and/or columns, press the CTRL key while you click on the row or column headings. All of these operations can also be accessed by clicking on the right mouse button to display the shortcut menu.

Sorting Data Across a Dimension

You can sort items across a dimension to reorder the way that they are display in the table view. To sort items across a dimension:

1) Click on appropriate dimension tile to make the dimesion active

2) Click on the Sort Dimension button in the Tool bar.

If you want to sort by data values, click on the Data Field in the Sort dialogue box. Then click Increasing or Decreasing, and press OK.

OR

If you want to sort by codes or labels associated with a dimension, click on the field you want to sort by, then indicate the Sort Option and press OK.

Charting Data

1) Select the rows and/or columns that you want to chart.

2) Click on the Display Chart button in the Tool bar.

3) To change the current chart type, choose the Chart Options command from the View menu, or with the mouse pointer in the chart view, click on the right mouse button to see the Charting shortcut menu.

4) Make a selection and click on OK to return to the chart view.

Chart Browsing

The ChartBrowsing TM feature lets you create a series of charts in rapid succession. With the mouse pointer in the chart view, click on one of the headings in the title of the chart to make that dimension active. Use the Previous Item and Next Item buttons to chart the previous or next item.

Printing a Table or Chart

To print a table or chart view, select Print from the File menu or click on the Print button.

Exporting a Table

To save a table:

1) Choose Save As from the File menu

2) Specify the directory and file name you want to save it under. The default extension is .IVT. To save data in another format such as DBF (database) or WK1 (spreadsheet). all of the dimension must be nested to be included. See note below. Click on OK.

3) The BROWSER prompts you to enter summary information. Enter the Table Title and Category which will be displayed in the Find Table dialog box. If you wish, enter Keywords and Table Notes to help you fine the table later.

4) Click on OK.

NOTE:

You can save BEYOND 20/20TM table data in several other formats including Database files (*.dbf) and Worksheet files (*.wks). When saving to any non-BEYOND 20/20TM format, you'll need to nest all the dimensions along the rows or columns before you save, if you want to retain the data for all dimensions (see Nesting Table Dimensions).

Contents of this page have been reproduced from the Q-STAT:Beyond 20/20 Instruction Sheet - Working with Beyond 20/20TM Tables.

Full B2020 Manual - [PDF]

Updated 2004/05 cp