0 - ACL Robotics → 1 - Basic Analytics

Analyzing data in Analytics (CPE) (ACL 104 V1 CPE)


Description

Estimated Time: 3 hours Level: Basic CPE: 3 *After passing final exam Updated on: 28/02/2018 Field of study: Computer software and applications Location: Not applicable

Content
  • CPE eligibility
  • Course outline
  • Navigating this course
  • Installing software
  • Activity data files
  • Analyzing data
  • Section 1 | Grouping Data
  • 1 | GROUPING DATA
  • CLASSIFY command & Activity 5.1
  • SUMMARIZE command & Activity 5.2
  • CROSSTAB command
  • STRATIFY command
  • AGE command & Activity 5.3
  • Section 2 | Reordering Records
  • 2 | Reordering records using Quick Sort, SORT, and INDEX
  • Section 3 | Isolating Data
  • 3 | Isolating data using the EXTRACT command
  • Section 4 | Combining Data
  • 4 | COMBINING DATA
  • Stacking tables vertically using APPEND & Activity 5.4
  • Combining tables horizontally using RELATIONS command
  • How RELATIONS matches records & Activity 5.5
  • Combining tables horizontally using JOIN command
  • How JOIN matches records & Activity 5.6
  • Comparing & planning JOIN vs. RELATIONS
  • Review & Course Evaluation
  • Quiz Overview - Analyzing
  • Review Quiz - Analyzing
  • Course evaluation
  • CPE exam overview & next steps
  • Next steps
  • Additional resources
  • Appendices
  • Appendix - Stacking tables vertically using EXTRACT/APPEND
  • Appendix - Resolving varying field lengths using EXPORT/APPEND
Completion rules
  • You must complete 90.00% of the content
  • Leads to a certification with a duration: Forever