CompTIA Data+: Data Manipulation Techniques

CompTIA    |    Intermediate
  • 14 videos | 1h 29m 31s
  • Includes Assessment
  • Earns a Badge
Rating 4.1 of 7 users Rating 4.1 of 7 users (7)
Data rarely comes in perfect form and often requires manipulation in order to make it truly meaningful. Without the ability to manipulate data, you often cannot extract full meaning from it. In this course, you will explore techniques for manipulating data, beginning with recoding data, derived variables, and data merging and blending. Then you will perform a data merge and a data blend and dig into concatenation and appending. Next, you will focus on imputation, reduction, and aggregation. Finally, you will learn how and why to transpose datasets, how to achieve standardized data formats using data normalization, and how to parse and manipulate strings. This course can be used to prepare for CompTIA Data+ (DA0-001) exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify recoding numeric and categorical data and related data manipulation techniques
    Outline the characteristics of derived variables and related data manipulation techniques
    Describe the characteristics of data merging and blending and related data manipulation techniques
    Perform a data merge
    Perform a data blend
    Perform concatenation and appending
  • Define imputation and its role in data manipulation
    Outline reduction and aggregation and their role in data manipulation
    Identify data transposition and its role in data manipulation
    Transpose data in microsoft excel
    Describe techniques for data normalization
    Parse strings and manipulate strings
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 19s
    Learn how to identify recoding numeric and categorical data and related data manipulation techniques. FREE ACCESS
  • Locked
    3.  Derived Variables
    4m 36s
    After completing this video, you will be able to outline the characteristics of derived variables and related data manipulation techniques. FREE ACCESS
  • Locked
    4.  Data Merging and Blending
    7m 55s
    Upon completion of this video, you will be able to describe the characteristics of data merging and blending and related data manipulation techniques. FREE ACCESS
  • Locked
    5.  Performing a Data Merge
    7m 39s
    During this video, you will learn how to perform a data merge. FREE ACCESS
  • Locked
    6.  Performing a Data Blend
    5m 41s
    Find out how to perform a data blend. FREE ACCESS
  • Locked
    7.  Performing Concatenation and Appending
    5m 48s
    In this video, discover how to perform concatenation and appending. FREE ACCESS
  • Locked
    8.  Imputation
    8m 2s
    After completing this video, you will be able to define imputation and its role in data manipulation. FREE ACCESS
  • Locked
    9.  Reduction and Aggregation
    4m 35s
    Upon completion of this video, you will be able to outline reduction and aggregation and their role in data manipulation. FREE ACCESS
  • Locked
    10.  Data Transposition
    6m 29s
    After completing this video, you will be able to identify data transposition and its role in data manipulation. FREE ACCESS
  • Locked
    11.  Transposing Data in Excel
    6m 3s
    In this video, you will learn how to transpose data in Microsoft Excel. FREE ACCESS
  • Locked
    12.  Data Normalization
    6m 56s
    Upon completion of this video, you will be able to describe techniques for data normalization. FREE ACCESS
  • Locked
    13.  Parsing and Manipulating Strings
    13m 45s
    Discover how to parse strings and manipulate strings. FREE ACCESS
  • Locked
    14.  Course Summary
    43s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analysis Types & Techniques
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)
Course CompTIA Data+: Understanding Data
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)
Course CompTIA Data+: Data Governance
Rating 4.9 of 10 users Rating 4.9 of 10 users (10)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA Data+: Data Visualization Dashboards
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
Course Finetuning your ChatGPT Prompts
Rating 4.5 of 446 users Rating 4.5 of 446 users (446)
Course CompTIA Data+: Data Quality & Master Data Management
Rating 4.3 of 14 users Rating 4.3 of 14 users (14)