Browser DLI Western Training ACCOLEDS Grant MacEwen University - - PDF document
Beyond 20/20 Beyond 20/20 TM Browser DLI Western Training ACCOLEDS Grant MacEwen University Edmonton, Alberta November 27, 2013 1 Course Topics: Basic Functional and Language features Moving Dimensions to rows and columns
Beyond 20/20
Beyond 20/20
Census Training Services
1-1
DLI Western Training – ACCOLEDS Grant MacEwen University Edmonton, Alberta November 27, 2013
1
Basic Functional and Language features Moving Dimensions to rows and columns Editing items in a dimension Exporting data to other applications Editing data label sets Sorting data and adding Sub-totals Creating charts Some calculations on table data
2
Beyond 20/20
Beyond 20/20
Census Training Services
1-2
Simple user interface Rapid creation of new tables from
multidimensional data tables
Rapid switching between languages Exports to other applications
3
In this section our objectives are:
Find and open tables Search for tables
4
Beyond 20/20
Beyond 20/20
Census Training Services
1-3
In the Find window:
Specify the directory containing the B20/20
tables.
Highlight categories to display all files (tables) for
those categories.
Highlight a table. Use Summary button to display
all the table information plus the Table Notes.
Open and View the highlighted table with the OK
button.
If needed use the Search feature to find
specified tables.
5
The Find window on
Beyond 20/20 allows
quick browsing of a data directory.
OR
Use the Search button to find tables matching special user input criteria.
Products
Tables
Search
Open directory to locate B20/20 file
Directory
6
Beyond 20/20
Beyond 20/20
Census Training Services
1-4
Text to Find in the
(Text is not case sensitive) Title/Description Notes Dimension/Source
Field Names
Codes Labels .
7
Our objectives are:
Learn more Beyond 20/20 terminology Understand contents of the Menus Learn how tables appear in the table view Learn what dimensions are Move dimensions around to change the table
view
8
Beyond 20/20
Beyond 20/20
Census Training Services
1-5
Item = Category/Stub Dimension = Variable/Stubset Tile = Dimensions not in the table
(parked on the tile bar)
Summary = Table Special Notes
9
Table Title Column Item Labels Dimension Tiles Row Item Labels Data Cells
10
Beyond 20/20
Beyond 20/20
Census Training Services
1-6
Contains the
general information about a table
It can include:
Table title in full Census year Notes Table statistics
11
It may also
describe how the data were collected and special notes and anomalies in the data
12
Beyond 20/20
Beyond 20/20
Census Training Services
1-7
File Edit View Dimension Item Window Help
13
Indicators for number of items: (Highlighted) Showing / Total in the dimension
Cell Name
Language Indicator
14
Beyond 20/20
Beyond 20/20
Census Training Services
1-8
Nesting is defined as one variable
crossed with another
View more than one dimension along
columns or rows
It involves positioning a dimension tile
the column or row dimension
15
Drag and drop the dimension tile onto the
top or bottom of the border or column headings to nest along the rows
Drag and drop the dimension tile onto the
to nest along the columns
16
Beyond 20/20
Beyond 20/20
Census Training Services
1-9
17 18
Beyond 20/20
Beyond 20/20
Census Training Services
1-10
The Table View can be changed by:
Changing the language of the table*. F9 Using other label sets. Dragging dimension tiles to Rows or
Columns
Nesting dimension tiles
*Note: The F9 key changes only the table language while the icon changes both the tool and the table language.
19
Open the 98F0312XCB11041 table Place Geography in the rows Place Legal Marital Status in the columns Nest Years under Geography Change the Geography label set to geocodes (01
and 10)
Change the table language to French
20
Beyond 20/20
Beyond 20/20
Census Training Services
1-11
Our objectives are to learn:
How dimensions not in the columns or rows affect the
table counts
How to display only selected items of a dimension
21
Counts in the table
are determined by:
dimensions in the rows
and columns and by
dimensions not in the
rows and columns
In this table all counts
are for female since that is the active item
22
Beyond 20/20
Beyond 20/20
Census Training Services
1-12
Changing a Dimension’s Active Item
dimension, then
to cycle through the items.
dimension is then indicated by:
item label on the ‘parked’ tile
the table when the dimension is in the row or columns.
23
How to Customize the View of a Table Using HIDE and SHOW
HIDE removes selected items from a view
SHOW keeps only selected items in a view
SHOW ALL and RESET clears the HIDE or SHOW
REVERSE shows the hidden items
24
Beyond 20/20
Beyond 20/20
Census Training Services
1-13
Open the 97F0009X2001043 table (Employment
Income Groups)
Place Geography in the rows SHOW only the counts for Canada, Manitoba,
Saskatchewan, Alberta and BC.
REVERSE the Geography dimension to show the
25
In this section our objectives are to:
Create B20/20 Worksheets Export tables to other applications or save as
customized B20/20 tables
Copy and Paste into other applications
26
Beyond 20/20
Beyond 20/20
Census Training Services
1-14
Worksheets are temporary views that:
permit fast copying of a Read-only table, allow customizing of the table, can be saved as a permanent file type.
27
In the View menu,
select Worksheet
In the View
Worksheet window include the dimensions not in the table if desired.
(Note the datapoints
computed.)
Select OK
28
Beyond 20/20
Beyond 20/20
Census Training Services
1-15
Save your table as an .ivt file to retain
multidimensionality and compatibility with Beyond 20/20 browser.
Remember that the saved table will be
minus hidden items.
29
Nest all dimensions you want to export Arrange table view as it should appear Export to EXCEL using .xls or .csv Export to ACCESS as .dbf or .csv
30
Beyond 20/20
Beyond 20/20
Census Training Services
1-16
Save As Exports data in these
formats:
*.ivt Beyond 20/20 compatible file type *.xls Excel Worksheet [available in version 6.0 +] *.csv Comma-separated value *.txt Text file *.htm HTML Files [available in version 6.0 +] *.wks WKS worksheet *.wk1 WK1 worksheet *.dbf dBASE File *.tsd Aremos TSD
31
Select the columns and rows to copy
using the control click technique.
Use <control C>
Open the target application, e.g. EXCEL Paste (<control V>) the data.
32
Beyond 20/20
Beyond 20/20
Census Training Services
1-17
In this section our objectives are to:
Edit item labels of a dimension Create a new label set (field) for a dimension Import labels
33
If table is read-only make a worksheet of
it.
Highlight the Dimension. Click Display Active Dimension on the icon
toolbar.
Select the item label to edit. Press the F2 key. Edit the label and press Enter.
34
Beyond 20/20
Beyond 20/20
Census Training Services
1-18
Highlight the Dimension to modify. Click Display Active Dimension icon on the
icon toolbar.
From the Dimension menu select Add Field. In the Add Field window specify the name,
type, and language of the new field.
In the Dimension window enter new item
labels using F2.
35
A set of labels can be created outside of Beyond 20/20 and then imported as a .csv file.
Step 1 Open the
Dimension and add a new label field (Chart Labels in this example).
Step 2 Create an Excel
file of the new label (Chart Labels) and the lookup field (Code). Make sure the lookup field and new label field are the same.
Continued…
36
Beyond 20/20
Beyond 20/20
Census Training Services
1-19
Step 3 Import the
new labels into the
the Input Filename.
Continued…
37
Continued…
Step 4 Select the
.csv file to import and the lookup field (Code in this example).
Here is the result of the Import
38
Beyond 20/20
Beyond 20/20
Census Training Services
1-20
The field name for the new labels in the .csv file
labels must be identical to the new field name in the dimension.
A field must be selected and copied to the .csv file to
act as a lookup field to control the position of the imported labels.
The lookup field name and labels must be identical
between the dimension and the .csv file.
The .csv file must have the same number of labels as
the lookup field.
39
In this section our objectives are to:
Search the labels for a name. Search the data by specifying a value range. Sort the data or labels.
40
Beyond 20/20
Beyond 20/20
Census Training Services
1-21
Highlight the dimension. Use the Search icon or from the Dimension
menu choose Search.
Select the field which has the item labels. Type in the text to find. Select Find Next to move the cursor to the item or select Reduce to show only the findings.
41
Highlight the dimension. Put the cursor in the data row or column which are to
be searched.
Open the Search window and select the Data field. Enter the data range Min’ and/or Max’ values. Select Reduce to show only the findings.
42
Beyond 20/20
Beyond 20/20
Census Training Services
1-22
How to Sort the Dimension Labels
Highlight the dimension. Use the Sort icon
menu choose Sort.
Select the field which
contains the item labels.
Select one of the sort options. Click Ok.
43
Highlight the dimension. Put the cursor in the
data row or column to be sorted.
Open the Sort window
and select the data field.
Select one of the
44
Beyond 20/20
Beyond 20/20
Census Training Services
1-23
In this section our objectives are
to:
Create groups Calculate totals on groups Position the group within the item list
45
Properties of Beyond 20/20 Groups
Groups cannot be created on Read-only tables. Primarily used for inserting sub-totals. Groups can hold simple sums or be calculated from a
formula or can represent a hierarchy of their items.
Status bar indicates the type of group highlighted. Default group position is at end of a dimension. Groups can be inserted into new items.
46
Beyond 20/20
Beyond 20/20
Census Training Services
1-24
Highlight row or
column items to be grouped.
From the Item menu
choose Define Group.
47
Specify the Group
Code and Group Type.
Click OK. Select Yes to
calculate now
48
Beyond 20/20
Beyond 20/20
Census Training Services
1-25
New group
appears at the end of the items in the dimension.
49
Maximum 16 characters for Group Code Total sums the highlighted items whose codes are
displayed
50
Beyond 20/20
Beyond 20/20
Census Training Services
1-26
In these sections our objectives
are:
Understand the chart view Create and customize charts
51
A Chart contains:
Table title Data representations Vertical axis (auto-
scaled)
Horizontal axis (with
item labels)
A Legend when multiple
dimensions are charted.
Title and list of the
52
Beyond 20/20
Beyond 20/20
Census Training Services
1-27
Highlight the desired Row and Column items
using the control click technique.
Click on the Chart icon
OR
From the View menu choose Chart.
53
Legends are created when multiple items are selected
for charting.
Legends can be dragged by click and hold to different
positions in the chart view.
When multiple columns are selected column labels
appear in the legend.
When multiple rows are selected OR multiple columns
and rows are selected, row labels appear in the legend.
54
Beyond 20/20
Beyond 20/20
Census Training Services
1-28
Click the right mouse
button with the cursor in the Chart window.
OR
From the VIEW menu
choose Chart Options.
Then in the Chart
Options window select the type of chart and click OK.
55
Distributions are percentages of a total. For example the question “What percentage of the
total population does each age group represent?” could be answered by a distribution calculation on the Age dimension in Beyond 20/20.
56
Beyond 20/20
Beyond 20/20
Census Training Services
1-29
Data Distributions in Beyond 20/20
Based on the current table view. (hidden items will
not be included.)
Calculated on the cells in rows, columns, and/or the
whole table.
Calculation produces a new table view with a new
dimension tile called Distributions.
Distribution tile can show original cell counts. New table view can include the dimensions on the tile
bar.
57
After calculating distributions or opening a table
which has fractional results (an average for example) you can specify the display of decimal places in a B20/20 view.
From the View menu select Decimals. Choose the number of decimals. Note: that data not having fractional values will be
displayed with decimal zeros.
58
Beyond 20/20
Beyond 20/20
Census Training Services
1-30
How to browse, search for, and open tables. How to change the language and label sets. How to move and nest dimensions. How dimensions not in the table effect data. How to Hide / Show items in a dimension. How to Save your tables in other formats.
59
How to edit and add label sets to a Dimension. How to Search and Sort the data. How to create and use Groups. How to Chart table data. How to create and use Distributions.
60
Beyond 20/20
Beyond 20/20
Census Training Services
1-31
This ends the course
61