1 / 60

Discoverer Web for AQS

Discoverer Web for AQS. Goals for this class. Introduce Discoverer Plus Learn About the Data in AQS Practice Finding Data Using Discoverer Have Fun!. What is Discoverer?.

Anita
Download Presentation

Discoverer Web for AQS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Discoverer Web for AQS

  2. Goals for this class • Introduce Discoverer Plus • Learn About the Data in AQS • Practice Finding Data Using Discoverer • Have Fun!

  3. What is Discoverer? • A business intelligence tool for customizable queries, reporting, analysis, and Web publishing from Oracle Corporation • A retrieval only tool that works on a relational database

  4. AQS How does this work? End User Layer

  5. What Can Discoverer Produce? • Data Listing Reports • Cross-Tabulation Reports (Pivot Tables) • Graphs & Charts

  6. Key Terminology Interface to database = End User Layer Grouping of Tables = Business Area Group of worksheets = Workbook

  7. What you need • AQS userid and password • Java-enabled Web browser (Sun Java 1.5 update 11 recommended) • url: https://iasint.rtpnc.epa.gov/discoverer/plus

  8. How To Build a Query in Discoverer • Connect • Choose a Layout • Select Items • To Display • To Filter By • Specify Totals and other Calculations (Optional) • Specify Sorting (Optional) • Specify Run-Time Parameters (Optional) • Run Report

  9. The REAL Way to Build a Query… • FORM A GOOD QUESTION!! • Understand the Data You Need to Answer the Question

  10. Your Business Areas AQS basic AQSprod • Business areas are composed primarily of views (i.e., combinations of tables) in the aqsprod database as described in the Data Dictionary • Reference tables (e.g., States, Parameters, Units) • Raw data and other additional folders in AQSprod

  11. Annual Summaries Sites Monitors Why is the EUL Necessary?

  12. Data Model for AQS

  13. Data Model for AQS, cont’d

  14. Data Model for AQS, cont’d

  15. Starting Discoverer Plus https://iasint.rtpnc.epa.gov/discoverer/plus

  16. Create a Connection

  17. Create a Connection, cont’d

  18. Successful connection

  19. Create/Open a Workbook

  20. Creating a New Workbook • Use the Workbook Wizard • Start with a simple goal in mind – e.g., Find the states in your region

  21. Selecting Items • AQS basic is the simplest Business Area • Scroll through list of folders • Expand a folder to see its items

  22. Selecting Items, cont’d • Highlight items and move them to the Selected side by clicking on the right arrow

  23. Conditions

  24. Conditions, cont’d

  25. Conditions, cont’d

  26. Calculations

  27. Calculations, cont’d

  28. Table Layout Click and drag headings to desired order

  29. Table Layout, cont’d

  30. Sorts

  31. Results

  32. Formatting

  33. Parameters

  34. Parameters, cont’d

  35. The Same Results

  36. Exercise 1 • Connect to Discoverer. • Create a new workbook using the AQS basic business area to show all states within your EPA region. • Rearrange the order of columns. Make EPA Region column 1. • Sort by EPA Region, then State Abbreviation. Change to a group sort on EPA Region. • Center headings for all columns. (Extra credit if you can find where to do this for all headings at once.) • Add a title. • Add a count of states by Region.

  37. Exercise 1: Sample Results

  38. Exercise 2 • List all the parameters (pollutants) measured at site 06-001-0007 • Modify #1 to include only parameters being sampled since 2003 • Modify #1 to show sampling end dates

  39. Exercise 2 Results All parameters at site All parms since 2003 All parms w/end date

  40. Exercise 3 • Identify all active sites in your state that do not have the standard coordinate fields populated. • Add a title. • Include a count of the number of sites by county and a grand total for the state.

  41. Exercise 3 sample results

  42. Other Views - Crosstab

  43. Other Views - Crosstab, cont’d

  44. Other Views - Crosstab, cont’d

  45. Graphs

  46. Export Options

  47. Other Output Options

  48. Saving a Workbook

  49. Opening a Workbook

  50. Sharing a Workbook

More Related