1 / 40

Data Mining (Finding information in Auxinfo and AuxOfficer )

Data Mining (Finding information in Auxinfo and AuxOfficer ). District 13 FLC/DLC Development Team. Data Mining. Definition

shawn
Download Presentation

Data Mining (Finding information in Auxinfo and AuxOfficer )

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. Data Mining(Finding information in Auxinfo and AuxOfficer) District 13 FLC/DLC Development Team

  2. Data Mining • Definition • “data processing using sophisticated data search capabilities and statistical algorithms to discover patterns and correlations in large preexisting databases; a way to discover new meaning in data”

  3. Data Mining • OK that was deep • Basically it’s the process of looking at • Key metrics • Analyzing the information • Looking for more information based on the analysis • Making decisions based on that to improve performance • Assessing the impact of those decisions • Bottom line… • Getting the information you need to perform your Auxiliary duties.

  4. Data Mining • Snapshots vs Trends • Measurement vs Anecdotal • Objective vs Subjective

  5. What are my resources • Auxdata • Primary Auxiliary data input application. Has many canned reports. Access can be difficult. • Auxinfo • Allows the creation of reports based on Auxdata. Access is easy. • Auxofficer • Provides member information including qualifications.

  6. What are my resources • Various other websites • National Sites (manuals, public information etc) • D13 site • Links to various sources, canned reports, Unit Officer Reports, Staff officer reports… etc.

  7. AUXINFO • Today we’ll cover AuxInfo and AuxOfficer • So what are some common requests for information?

  8. AUXINFO • What is it? • Business intelligence tool tied to AUXDATA • (COGNOS POWERPLAY) • Refreshed Weekly • Where is it? • https://www.auxinfo.uscg.gov/ • Why would I use it? • Unit, facility, and Member Activities, Status, etc • You can’t break it 

  9. HOME SCREEN

  10. AUXMIS CUBES Data from old AUXMIS system

  11. National Reports Pre-canned reports

  12. AUXDATA Cubes

  13. AUXDATA Cubes

  14. Main Screen

  15. Filters

  16. Filters

  17. Filters – What's the difference? Right Click to see options

  18. Filters – Nested Rows

  19. Filters – Nested Columns You can also do this by dragging and dropping

  20. Right Clicking! Right Click for options

  21. Toolbar

  22. HideShow Hide or Show Columns

  23. Calculation Perform arithmetic on cells

  24. Rank Rank by Column or Row

  25. Exception Highlighting Flag Ranges (Remember to select the column or row)

  26. Custom Subsets Grouping Categories

  27. Mouse Tricks

  28. It’s a drag • Drag and Drop fields to • Filter • Add columns or rows • Expand columns or row

  29. Saving your work • Export • CSV • XLS • PDF • Bookmark • Go back to it later! • Share with others • Email Considerations…

  30. Lets Try a couple reports

  31. AUXOfficer

  32. AUXOfficer • What is it? • Replacement for eDirectory • Where is it? • https://auxofficer.cgaux.org/ • Why would I use it? • Find member contact information (Nationwide) • Look up Officers (Any Unit) • Query for Qualifications • Get mailing lists

  33. Login

  34. Getting a Login

  35. Changing a Password

  36. Home Screen

  37. Things You can Do Browse National Bridge and Staff Get “Staff Lists” Look at Org Charts Browse by Unit

  38. Things You can Do Search by Last Name/ Member # or email Search by Unit/Qualification Search by Unit/Office Get Unit information Get Member Information (Contact Info/Quals/Tests Passed)

  39. Lists • Directory or “Full” List • Looks like a directory • Enhanced Email List • List of Emails with Names • Plain Email List • Just a list of Emails • Plain Email list with Comma • List of Emails separated by a comma

  40. End of Data Mining Session

More Related