US flag signifying that this is a United States Federal Government website  Official website of the Department of Homeland Security

Data Transformation

Data Transformation

  • Online, Self-Paced

Course Description

Once data is filtered the next step is to transform it into a usable format. In this course, you'll explore examples of practical tools and techniques for data transformation.

Learning Objectives

File Format Conversions

  • start the course
  • convert CSV data to JSON format
  • convert XML data to JSON format
  • create SQL inserts from CSV data
  • extract CSV data from SQL
  • change delimiters in a csv file from commas to tabs

Data Conversions

  • convert basic date formats to standard ISO 8601 format
  • convert numeric formats within a CSV document
  • round floating point decimals to two places within a CSV document

Optical Character Recognition

  • use optical character recognition (OCR) to extract text from a jpeg image
  • use optical character recognition (OCR) to extract text from a pdf document

Practice: Converting Dates

  • read various date formats and convert to standard compliant ISO 8601 format

Framework Connections

  • Icon that says Operate and maintain with a hammer & wrench in x shape depicted.

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.