0 - ACL Robotics → 1 - Basic Analytics

Importing & preparing data in Analytics (CPE) (ACL 103 V1 CPE)


Description

Estimated Time: 4 hours Level: Basic CPE: 4 *After passing final exam

Content
  • CPE eligibility
  • Course outline
  • Navigating this course
  • Installing software
  • Activity data files
  • CHAPTER 1 | Importing Data
  • CHAPTER 1 | IMPORTING DATA
  • Section 1 | Locating & Acquiring Files
  • 1 | LOCATING & ACQUIRING FILES
  • Locating data sources
  • Acquisition methods
  • Source file formats
  • Section 2 | Importing Files
  • 2 | IMPORTING FILES
  • Importing fixed-width files
  • Defining overlapping fields
  • VERIFY command & Activity 3.1
  • Practice Quiz - Importing fixed-width files & defining overlapping fields
  • Importing delimited files
  • Practice Quiz - Importing delimited files
  • Importing Excel files & Activity 3.2
  • Practice Quiz - Importing Excel files
  • Review Quiz - Importing
  • Chapter 2 | Preparing Data
  • CHAPTER 2 | PREPARING DATA
  • Preparing your data
  • Section 3 | Controls
  • 3 | CONTROLS
  • Counting records using the COUNT┬ácommand
  • Totalling numeric fields using the TOTAL command
  • STATISTICS command & Activity 4.1
  • Section 4 | Quality
  • 4 | QUALITY
  • Isolating data using the EXTRACT command
  • Identifying records that fall within bounds & Activity 4.2
  • Identifying blank and empty field values & Activity 4.3
  • Determining if values match the expected format using MAP( )
  • Identifying values missing from a sequence using GAPS command & Activity 4.4
  • Identifying duplicate records using DUPLICATES command & Activity 4.5
  • Section 5 | Reasonableness
  • 5 | REASONABLENESS
  • Measuring reasonableness & Activity 4.6
  • Testing the expected association between two fields
  • Recalculating values & Activity 4.7
  • Review & Course Evaluation
  • Quiz Overview - Preparing
  • Review Quiz - Preparing
  • Course evaluation
  • CPE exam overview & next steps
  • Next steps
  • Additional Resources
  • Appendices
  • Appendix - Hexadecimal to ASCII conversion table
  • Appendix - Hexadecimal to EBCDIC conversion table
Completion rules
  • You must complete 90.00% of the content
  • Leads to a certification with a duration: Forever