1 

Data Analysis Tool

Access Screen (DAT-0)

Description ScreenYou may use the Data Analysis Tool (DAT) to analyzedata submitted by the local first responder jurisdictionswithin your state. There are two ways to access theDAT from the State Administrative Agency's (SAA)Handbook.Pictured to the right is the screen for Section 10. ThreeYear Statewide Domestic Preparedness Strategy.1) You can access the DAT by clicking on the link onthe left hand side of the page. This link will be presentno matter where you are in the SAA Handbook.2) You can also access the DAT by clicking the linkthat is located inside the text of the page in Section 10.Statewide Domestic Preparedness Strategy.
1

2

34

5

6

7

Data Analysis Tool

Main Screen (DAT-1)

Description Screen1. Filter the workbooks shown by typing in all or partof the name of the workbooks you would like to see.Press “Filter” to filter the workbooks, or press “ShowAll” to return to the complete listing.2. Click on the link marked “OSLDPS_PROTO 1.State Risk Assessment” to view that workbook. Thedetailed explanation of this workbook is listed to theright of the link.3. Click on the link marked “OSLDPS_PROTO 2.State Capabilities & Needs Assessment” to view thatworkbook. The detailed explanation of this workbookis listed to the right of the link.4. Click on the link marked “OSLDPS_PROTO 3.State Equipment Projections” to view that workbook. The detailed explanation of this workbook is listed tothe right of the link.5. Click on the link marked “OSLDPS_PROTO 4.State Training Projections” to view that workbook. The detailed explanation of this workbook is listed tothe right of the link.6. Click on the link marked “OSLDPS_PROTO 5.State Technical Assistance Projections” to view thatworkbook. The detailed explanation of this workbookis listed to the right of the link.7. Click on the link marked “OSLDPS_PROTO 1.State Exercise Projections” to view that workbook. The detailed explanation of this workbook is listed tothe right of the link.
1 2 

6 

Data Analysis Tool

Main Screen (DAT-2)

Description Screen1. Press the icon above the words “New Connection”to create a new connection or log on as a different user.2. Press the icon above the words “Open Workbook”to return to the Discoverer main page.3. Press the icon above the word “Options” to changethe options for the Discoverer Viewer. See job aid(DAT-9) for instructions on changing your viewingoptions.4. Press the icon above the word “Exit” to exit theDiscoverer Viewer and return to the online DataCollection Tool.5. Press the icon above the word “Help” for moreinformation on the Oracle Discoverer Viewerapplication.6. Click the tab marked “Database Workbooks” toopen the page listing the database workbooks. If youare working in one of the worksheets, this link willreturn you to the Discoverer main page.7. Click the tab marked “Scheduled Workbooks” to goto the page listing any scheduled workbooks. See jobaid (DAT-9) for information on “ScheduledWorkbooks”.
Data Analysis Tool

Risk Assessment (DAT-3)

Description Screen1. Click the link marked “RA01-Vulnerability, Threatand Risk” to select parameters and jurisdictions for theVulnerability, Threat and Risk report.2. Click the link marked “RA02-PTEs and ThreatIncidents” to select parameters and jurisdictions for thePTEs and Threat Incidents report.3. Click the link marked “RA03-BNICE Sites” to selectparameters and jurisdictions for the BNICE sites report.4. Select jurisdictions using the scroll bar. To selectmultiple jurisdictions, press the control button whileselecting jurisdictions.5. Press the button marked “Apply Parameters” to applythe parameters selected and create a report.

5

3

2

1
Risk Assessment (DAT-3) continued

Description Screen1. The blue highlighted area describes the report that isbeing viewed (in this example, the Vulnerability, Threat,and Risk report).2. This area is the report data that results from applyingparameters from the previous screen.3. Press the link marked “Rerun Query” to rerun thequery using any edited or additional parameters.4. Press the link marked “Edit Parameters” to change oradd parameters.5. Press the link marked “Printer Friendly Version” toproduce the report in a version that will print out easily.6. Press the link marked “Export” to export the report toa different format or spreadsheet.7. Press the link marked “25 rows per page” to limit thereport to 25 rows of displayed data per page.

3 

7

2

1
Data Analysis Tool

Capabilities and Needs Assessment (DAT-4)

Description Screen1. Click the link marked “CN01-Current and RequiredTier Levels”to select parameters and jurisdictions for theCurrent and Required Tier Levels report.2. Select jurisdictions using the scroll bar on the right. To select multiple values, press “Control” whileselecting jurisdictions.3. Select the status levels you wish to include using thelisting on the right. To select both current and required,press “Control” while selecting them.4. Press the button marked “Apply Parameters” tocreate the report.

4

1
Capabilities and Needs Assessment (DAT-4) continued

Description Screen1. The blue highlighted area describes the report that isbeing viewed (in this example, the Current and RequiredTier Levels report).2. This area is the report data that results from applyingparameters from the previous screen.3. Press the link marked “Rerun Query” to rerun thequery using any edited or added parameters.4. Press the link marked “Edit Parameters” to change oradd parameters.5. Press the link marked “Printer Friendly Version” toproduce the report in a version that will print out easily.6. Press the link marked “Export” to export the report toa different format or spreadsheet.7. Press the link marked “25 rows per page” to limit thereport to 25 rows of displayed data per page.

1 3 

7

2

7
Data Analysis Tool

Equipment Projections (DAT-5)

Description Screen1. Click the link marked “EP01 - Equipment Summary”to select parameters and jurisdictions for the EquipmentSummary report.2. Click the link marked “EP02-Current and RequiredEquipment” to select parameters and jurisdictions forthe Current and Required Equipment report.3. Select jurisdictions using the scroll bar on the right. To select multiple values, press “Control” whileselecting jurisdictions.4. Select the equipment categories you wish to includeusing the listing on the right. To select multiple values,press “Control” while selecting them.5. Select projection years using the scroll bar on theright. To select multiple values, press “Control” whileselecting projection years.6. Press the button marked “Apply Parameters” tocreate the report.

6

2

1
Equipment Projections (DAT-5) continued

Description Screen1. The blue highlighted area describes the report that isbeing viewed (in this example, the Equipment Summaryreport).2. This area is the report data that results from applyingparameters from the previous screen.3. Press the link marked “Rerun Query” to rerun thequery using any edited or added parameters.4. Press the link marked “Edit Parameters” to change oradd parameters.5. Press the link marked “Printer Friendly Version” toproduce the report in a version that will print out easily.6. Press the link marked “Export” to export the report toa different format or spreadsheet.7. Press the link marked “25 rows per page” to limit thereport to 25 rows of displayed data per page.

1 7

2

7
Data Analysis Tool

Training Projections (DAT-6)

Description Screen1. Click the link marked “TR01 - Training Rollup” toselect parameters and jurisdictions for the TrainingRollup report.2. Click on the link marked “TR02 - Responder GroupSummary” to select parameters and jurisdictions for theResponder Group Summary report.3. Select jurisdictions using the scroll bar on the right. To select multiple values, press “Control” whileselecting jurisdictions.4. Press the button marked “Apply Parameters” tocreate the report.

4

2

1
Training Projections (DAT-6) continued

Description Screen1. The blue highlighted area describes the report that isbeing viewed (in this example, the Training Rollupreport).2. This area is the report data that results from applyingparameters from the previous screen.3. Press the link marked “Rerun Query” to rerun thequery using any edited or added parameters.4. Press the link marked “Edit Parameters” to change oradd parameters.5. Press the link marked “Printer Friendly Version” toproduce the report in a version that will print out easily.6. Press the link marked “Export” to export the report toa different format or spreadsheet.7. Press the link marked “25 rows per page” to limit thereport to 25 rows of displayed data per page.

1 7

2

7
Data Analysis Tool

Technical Assistance Projections (DAT-7)

Description Screen1. Click the link marked “TA01 - Current and RequiredTA” to select parameters and jurisdictions for theCurrent and Required TA report.2. Select jurisdictions using the scroll bar on the right. To select multiple values, press “Control” whileselecting jurisdictions.3. Select projection years using the scroll bar on theright. To select multiple values, press “Control” whileselecting years.4. Press the button marked “Apply Parameters” tocreate the report.

4

1
Technical Assistance Projections (DAT-7) continued

Description Screen1. The blue highlighted area describes the report that isbeing viewed (in this example, the Current and RequiredTA report).2. This area is the report data that results from applyingparameters from the previous screen.3. Press the link marked “Rerun Query” to rerun thequery using any edited or added parameters.4. Press the link marked “Edit Parameters” to change oradd parameters.5. Press the link marked “Printer Friendly Version” toproduce the report in a version that will print out easily.6. Press the link marked “Export” to export the report toa different format or spreadsheet.7. Press the link marked “25 rows per page” to limit thereport to 25 rows of displayed data per page.

3 

7 1

2

7
Data Analysis Tool

Exercise Projections (DAT-8)

Description Screen1. Click the link marked “EX01 - Current and RequiredExercises” to select parameters and jurisdictions for theCurrent and Required Exercises report.2. Select jurisdictions using the scroll bar on the right. To select multiple values, press “Control” whileselecting jurisdictions.3. Select projection years using the scroll bar on theright. To select multiple values, press “Control” whileselecting years.4. Select exercise types using the scroll bar on the right. To select multiple values, press “Control” whileselecting the types.5. Select hazard types using the scroll bar on the right. To select multiple values, press “Control” whileselecting types.6. Press the button marked “Apply Parameters” tocreate the report.

4

5

6

3

2

1
Exercise Projections (DAT-8) continued

Description Screen1. The blue highlighted area describes the report that isbeing viewed (in this example, the Current and RequiredExercises report).2. This area is the report data that results from applyingparameters from the previous screen.3. Press the link marked “Rerun Query” to rerun thequery using any edited or added parameters.4. Press the link marked “Edit Parameters” to change oradd parameters.5. Press the link marked “Printer Friendly Version” toproduce the report in a version that will print out easily.6. Press the link marked “Export” to export the report toa different format or spreadsheet.7. Press the link marked “25 rows per page” to limit thereport to 25 rows of displayed data per page.

3 

1 7

2

7
Data Analysis Tool

Options Screen (DAT-9)

Description ScreenPictured to the right is the options screen for the DAT. Usethis screen to customize your display settings and worksheetsettings in DAT.1) Click the link marked “Options” to arrive at this page. The link is on every page of the Discoverer tool.2) Click the link to move around the page, or scroll up ordown using the scrollbar to move to the area you would liketo access.3) Activate a feature of the Query Governor by clicking inthe box next to it. Deactivate a feature by clicking in itagain. These features allow you to set maximum values forhow long the system will take to generate your report. Forinstance, if you wish to abandon a query you send to theserver if the results are not returned within 3 minutes, youcould check the box next to prevent queries from runninglonger than: and then type in 180 seconds.4) Modify the settings of each active query value bychanging the number in the box to the right of the title.5) Select when you would like queries to run by clicking inthe box next to the appropriate time. The system will defaultto run queries automatically when you have completed yourquery criteria. 6) Set the number of rows per page by changing the numberin the box. This will adjust how many rows of data are oneach worksheet page. The system will default to 25 rows perpage.7) This setting allows you to assign a value to fields thatwere left blank by jurisdictions when inputting informationinto the system. The system will default to showing valuesleft blank by your jurisdictions as “null”. If you want toshow this value as zero, type that in the block. The systemwill use zero for computation of these results in the JPT.

3 4

5

6

7

2
Options Screen (DAT-9) continued

Description Screen8) Choose when you would like to use Summary Data byclicking the appropriate box. This option allows you toprocess queries more quickly by retrieving data usedfrequently from Summary Tables set up by the Discovereradministrator. 9) If you want to be sure you are using the most current datafrom the database, you may wish to fill in using summarydata only if it is a certain number of days old. For instance,you may tell the system to use summary data from the serveronly if that data is more recent than 2 days old. This willmake the system recompile the report if the data you areretrieving has not been compiled by the server within the lasttwo days. Using this feature may also lengthen the amountof time it takes to retrieve the data you are requesting.10) Enable or disable the Fan Trap by clicking theappropriate circle. A Fan-Trap helps prevent ambiguous dataresults being returned by the Discoverer Viewer. For moreinformation on Fan-Trap Detection, click on the Help link at

the top of the page. 11) Your End User Layer Access has been set by theDiscoverer administrator. If you have any questions, pleasecontact the Office of Justice Programs Help Desk at 1-888-549-9901 or send an email to: ojp@ojp.usdoj.gov

12) Click the “Apply All” button to activate the new settings

in the Discoverer Viewer.

8 9

10

11