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
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.