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  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 1-1 Census Training Services

Beyond 20/20 Beyond 20/20 Browser Benefits  Simple user interface  Rapid creation of new tables from multidimensional data tables  Rapid switching between languages  Exports to other applications 3 The Find Dialog Box  In this section our objectives are:  Find and open tables  Search for tables 4 Beyond 20/20 1-2 Census Training Services

Beyond 20/20 How to Find a Table  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 How to Search for a Table The Find window on  Products Beyond 20/20 allows quick browsing of a data directory. OR Search Tables Use the Search  button to find tables matching special user input criteria. Open directory Directory to locate 6 B20/20 file Beyond 20/20 1-3 Census Training Services

Beyond 20/20 The Search Window Options  Text to Find in the options (Text is not case sensitive)  Title/Description  Notes  Dimension/Source Field Names  Codes  Labels . 7 Browser Overview  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 1-4 Census Training Services

Beyond 20/20 Beyond 20/20 Terminology  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 1-5 Census Training Services

Beyond 20/20 Table Summary  Contains the general information about a table  It can include:  Table title in full  Census year  Notes  Table statistics 11 Table Summary  It may also describe how the data were collected and special notes and anomalies in the data 12 Beyond 20/20 1-6 Census Training Services

Beyond 20/20 Menu Bar  File  Edit  View  Dimension  Item  Window  Help 13 Status Bar Indicators for number of  items: (Highlighted) Showing / Total in the dimension Cell Name  Language Indicator  14 Beyond 20/20 1-7 Census Training Services

Beyond 20/20 Nesting  Nesting is defined as one variable crossed with another  View more than one dimension along columns or rows  It involves positioning a dimension tile over the border of existing headings in the column or row dimension 15 Nesting  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 outer or inner border of the row headings to nest along the columns 16 Beyond 20/20 1-8 Census Training Services

Beyond 20/20 17 18 Beyond 20/20 1-9 Census Training Services

Beyond 20/20 Arranging your Table View  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 Exercise  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 1-10 Census Training Services

Beyond 20/20 Customizing Tables  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 All Dimensions Affect Table Data  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 of the Sex dimension 22 Beyond 20/20 1-11 Census Training Services

Beyond 20/20 Changing a Dimension’s Active Item 1. Highlight the  dimension, then 2. Use the arrow buttons  to cycle through the items. 3. Active item of the  dimension is then indicated by: item label on the ‘parked’  tile or the cursor position in  the table when the dimension is in the row or 23 columns. 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 1-12 Census Training Services

Beyond 20/20 Exercise  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 other provinces and territories 25 Saving Customized Tables  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 1-13 Census Training Services

Beyond 20/20 Beyond 20 / 20 Worksheets  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 How to Create a Worksheet  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 1-14 Census Training Services

Beyond 20/20 Saving Customized Table Views as a Multidimensional Files  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 Exporting your Customized Tables to Other Applications  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 1-15 Census Training Services

Beyond 20/20 Beyond 20/20 Output Formats  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 How to Copy and Paste Data into Other Applications  Select the columns and rows to copy using the control click technique.  Use < control C > or from the Edit menu use “ Copy ”  Open the target application, e.g. EXCEL  Paste (< control V >) the data. 32 Beyond 20/20 1-16 Census Training Services

Beyond 20/20 Changing Labels on Dimensions  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 Editing Existing Item Labels  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 1-17 Census Training Services

Beyond 20/20 Adding a New Label Set  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 Importing a New Label Set 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. 36 Continued… Beyond 20/20 1-18 Census Training Services

Beyond 20/20 Importing a New Label Set  Step 3 Import the new labels into the Dimension. Select the Input Filename. 37 Continued… Importing a New Label Set  Step 4 Select the .csv file to import and the lookup field (Code in this example). Here is the  result of the Import 38 Continued… Beyond 20/20 1-19 Census Training Services