Get this course

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: 10/02/2022 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
  • SUMMARIZE command
  • CROSSTAB command
  • STRATIFY command
  • AGE command
  • Section 2 | Reordering Records
  • 2 | Sorting and 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
  • Combining tables horizontally using RELATIONS command
  • How RELATIONS matches records
  • Combining tables horizontally using JOIN command
  • How JOIN matches records
  • Comparing & planning JOIN vs. RELATIONS
  • Review & Course Evaluation
  • Quiz Overview - Analyzing
  • Review Quiz - Analyzing
  • Course evaluation
  • CPE exam overview & next steps
  • What's next?
  • 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 certificate with a duration: Forever
Back