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 Updated on: 19/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
  • 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
  • Practice Quiz - Importing fixed-width files & defining overlapping fields
  • Importing delimited files
  • Practice Quiz - Importing delimited files
  • Importing Excel files
  • 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
  • Totaling numeric fields using the TOTAL command
  • STATISTICS command
  • Section 4 | Quality
  • 4 | QUALITY
  • Isolating data using the EXTRACT command
  • Identifying records that fall within bounds using the BETWEEN( ) function
  • Identifying blank and empty field values
  • Determining if values match the expected format using the MAP( ) function
  • Identifying values missing from a sequence using the GAPS command
  • Identifying duplicate records using the DUPLICATES command
  • Section 5 | Reasonableness
  • 5 | REASONABLENESS
  • Measuring reasonableness
  • Testing the expected association between two fields
  • Recalculating values
  • Review & Course Evaluation
  • Review Quiz Overview - Preparing
  • Review Quiz - Preparing
  • Course evaluation
  • CPE exam overview & next steps
  • What's next?
  • Additional resources
  • Appendices
  • Hexadecimal to ASCII conversion table
  • Hexadecimal to EBCDIC conversion table
Completion rules
  • You must complete 90.00% of the content
  • Leads to a certification with a duration: Forever