• Online, Self-Paced
Course Description

Data integration is the last step in the data wrangling process where data is put into its useable and structured format for analysis. In this course, you'll explore examples of practical tools and techniques for data integration.

Learning Objectives

Introduction to Data Integration

  • start the course
  • use csvjoin to concatenate CSV data
  • use the cat function to concatenate separate logs into a single file
  • sort lines in a text file
  • merge separate xml files into a single schema
  • aggregate data from a CSV file into a table of summarized values
  • normalize data from unstructured sources
  • denormalize data from a structured source
  • use pivot tables to cross tabulate data
  • insert missing values in a data set

Practice: Joining CSV Data

  • use csvjoin to merge two compatible CSV documents into one

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.