Visual Dashboard: Performing Statistical Analyses with Visual Tools

Read an Epi Info^TM 7 Project File

1. Execute the Set a Data Source option using one of the first three steps previously noted (click Set a Data Source now arrow, click the Set a Data Source icon, or right click and select Set a Data Source). The Select Data Source dialog box appears.
2. From the Database Type drop-down list, select Epi Info 7 Project.
3. Click Browse next to the Data Source field. The Epi Info 7 Project folder will appear.
4. Browse for the project file you would like to read into Visual Dashboard. If your projects are in folders, you will have to first open the correct folder and then open the desired project (.PRJ) file. Some sample projects, such as Ecoli.PRJ, are included with the installation of Epi Info™ 7.
5. Click Open.
6. The Data Source Explorer box populates with a list of all the forms that are associated with the project. Select a form.
7. Click OK. The record count and data source appear in the toolbar at the top right of the Visual Dashboard canvas.
8. Click OK. The “Processing Finished” message appears, indicating that the system has cached the data locally. Data from the two tables can now be used for analysis.

Read a Microsoft Excel File

1. Click on the Set a Data Source now arrow. The Select Data Source dialog box appears.
2. From the Database type drop-down list, select either MS Excel 97-2003 Workbook or MS Excel 2007 Workbook.
3. Click Browse next to the Data Source field. The Open Existing File dialog box will appear.
4. Enter the filename and path to open your workbook or click Browse to search for the MS Excel workbook (.xls or .xlsx).
5. Click Open. The First row contains header information checkbox is selected by default. If this option is unchecked, data will import without column headings.
6. Click OK. Select a worksheet from the list provided in the Data Source Explorer window.
7. Click OK. The record count and data source appear in the menu bar at the top right of the Visual Dashboard canvas.

Read a Microsoft Access File

1. Click on the Set a Data Source now arrow. The Select Data Source dialog box appears.
2. From the Database Type drop-down list, select either MS Access 2002-2003 (.mdb) or MS Access 2007(.accdb).
3. Click Browse next to the Data Source field. The Open Microsoft Access File dialog box will appear.
4. Enter the filename and path to open your file or click Browse to search for the MS Access file (.mdb or .accdb). If the file is password protected, enter the password.
5. Click OK.
6. Select a data table from the list provided in the Data Source Explorer window.
7. Click OK. The record count and data source appear in the menu bar at the top right of the Visual Dashboard canvas.

Read a CSV (ASCII) File

1. Click on the Set a Data Source now arrow. The Select Data Source dialog box appears.
2. From the Database Type drop-down list, select CSV File.
3. Click Browse next to the Data Source field.
4. Click Browse in the Flat File location dialog box to search the directory.
5. Select the directory containing the CSV file to be read.
6. Click OK. Note that the First row contains header information box is checked by default. If the first row of the file does not contain header information, deselect the checkbox. If this option is unchecked, data will be imported without column headings.
7. Select the file name from the list provided in the Data Source Explorer window.
8. Click OK. The record count and data source appear in the menu bar at the top right of the Visual Dashboard canvas.

Read a Microsoft SQL Server Database

Note: You must have Microsoft SQL Server installed on your computer or you must have access to a server over a network to perform this function.

1. Click on the Set a Data Source now arrow. The Select Data Source dialog box appears.
2. From the Database Type drop-down list, select Microsoft SQL Server Database.
3. Click Browse next to the Data Source field.
4. The Connect to SQL Server database dialog box opens. Specify the Server name and Database name to connect to a SQL Server database.
5. The Use Windows Authentication radio button is selected by default. You can use SQL Server Authentication by checking the corresponding radio button and then entering Login and Password credentials.
6. Click OK.
7. From the list provided in the Data Source Explorer, select a data table.
8. Click OK. The record count and data source appear in the menu bar at the top right of the Visual Dashboard canvas.

Read a MySQL Server Database

Note: You must have MySQL Server installed on your computer or you must have access to a server over a network to perform this function.

1. Click on the Set Data Source arrow. The Select Data Source dialog box appears.
2. From the Database Type drop-down list, select MySQL Database.
3. Click Browse next to the Data Source field.
4. The Connect to MySQL database dialog box appears. Enter the Server name, Database name, Username and Password to connect to the MySQL database. You can select < Browse for more > from the Server name drop-down list to select a MySQL server instance in your network.
5. Click OK.
6. From the list provided in the Data Source Explorer, select a data table.
7. Click OK. The record count and data source appear in the menu bar at the top right of the Visual Dashboard canvas.

Add a Related Data Source

Analysis in Visual Dashboard may be performed on data from multiple data sources. The Add a Related Data Source option links tables or forms using a common identifier. The form/table to be linked requires a key field to relate the records of the forms/tables together. If the forms were created in Form Designer, Visual Dashboard can establish a relationship by using the Global Record ID (GLOBALRECORDID)of the first form and the Foreign Key (or [FKEY) (] column of the related form as the key fields. The example below demonstrates how to add a related data source.

Epi Info™ 7 contains a related database in the Sample.PRJ file with two forms: The form named Surveillance is the primary or parent form. It has three related or child forms named RHepatitis, RLyme, and RMeningitis. In the example below, we relate the Surveillance parent form to its child form, RHepatitis.

1. Follow the steps to Set a Data Source and select the Sample.PRJ Data Source. Open Surveillance.
2. Right click on the canvas and select Add related data source. The Select Data Source dialog box opens.
3. Follow the steps to Set a Data Source and select the Sample.PRJ Data Source again.
4. Select RHepatitis from the list of forms in the Data Source Explorer. The Child Key Field drop-down list populates.
5. From the Parent Key Field drop-down list, select GlobalRecordId.
6. Select FKEY from the Child Key Field drop-down list. FKEY is the Foreign Key in the child form that matches the GlobalRecordId of the record in the parent form.
7. Check the “Use Unmatched (ALL)” checkbox to include all records from the primary form whether or not there are matching records in the related data source. Uncheck the “Use Unmatched (ALL)” checkbox to force the resulting data to include only those records represented by keys that match in both tables.
8. Click OK. The “Processing Finished” message appears, indicating that the system has cached the data locally. Data from the two tables can now be used for analysis.
   Note: You can only perform a one-to-one analysis with a related table in Visual Dashboard. To perform a one-to-many analysis, please see the Classic Analysis section of this user guide.

    

   

   Figure 8.99: Add Related Data Source dialog box