1 / 44

TERA: PAMS Reporting

TERA: PAMS Reporting. By Michael McGuire mcguire@ utk.edu https:// tera.usg.utk.edu /. Outline. The Reporting Architecture Selecting a Report to View Report Interface Viewing Report Results Sorting Reports Report Totals Exporting/Analyzing Report Data. The URL. TERA: PAMS Reporting.

yuma
Télécharger la présentation

TERA: PAMS Reporting

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. 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

More Related