Download
tera pams reporting n.
Skip this Video
Loading SlideShow in 5 Seconds..
TERA: PAMS Reporting PowerPoint Presentation
Download Presentation
TERA: PAMS Reporting

TERA: PAMS Reporting

159 Views Download Presentation
Download Presentation

TERA: PAMS Reporting

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. TERA: PAMS Reporting By Michael McGuire mcguire@utk.edu https://tera.usg.utk.edu/

  2. Outline • The Reporting Architecture • Selecting a Report to View • Report Interface • Viewing Report Results • Sorting Reports • Report Totals • Exporting/Analyzing Report Data

  3. The URL

  4. TERA: PAMS Reporting

  5. Selecting a report to view

  6. Selecting a report to view (2)

  7. Security Pop-up

  8. Be sure to save

  9. The Report Interface

  10. Selecting Parameters

  11. Expanding selection

  12. Short lists

  13. Typing Date

  14. Selecting Date

  15. Click View

  16. Report will build

  17. View Report

  18. Sorting the report

  19. Sorting ascending

  20. Sorting descending

  21. Multi-column sorts

  22. Resetting the sort

  23. Go to Last Page

  24. Totals in Yellow

  25. Only columns that make sense

  26. Exporting

  27. XML File

  28. CSV

  29. PDF

  30. MHTML

  31. MHTML Opened

  32. Excel

  33. TIFF

  34. Word

  35. Analyzing Report Data with Microsoft Excel • CSV is the best choice • Manipulating data in Excel

  36. CSV

  37. Pivot Tables • A pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically.

  38. Creating aPivot table (W7)

  39. Inserting Pivots

  40. Creating a Pivot Table (OS X)

  41. Default Pivot Table (OS X)

  42. Base Pivot Table (W7)

  43. Creating a chart from a pivot

  44. Creating a chart from a pivot 2