CompTIA Data+

Welcome

Download your free study guide

Exam Tips

How to Use the Lab Environment

Lab: Exploring the Lab Environment

Checkpoint: Introduction

Data Schemas

Relational Databases

Non-relational Databases

Comparing Database Types

Data Normalization

Database Relationships

Referential Integrity

Data Denormalization

Hands-on with Data Schemas

Lab: Navigating and Understanding Database Design

Checkpoint: Data Schemas

Data Systems

Data Processing Types

Data Warehouse

Data Warehouse Schemas

Data Lakes

Changing Dimensional Data

Hands-on with Data Systems

Checkpoint: Data Systems

Data Types

Quantitative & Qualitative

Data Field Types

Converting Data

Lab: Understanding Data Types and Conversion

Data Structures

Data File Formats

Lab: Working with Different File Formats

Data Languages

Hands-on with Data Types

Lab: Understanding Data Structure and Types and Using Basic Statements

Checkpoint: Data Types

Data Acquisition

Extracting Data

Transforming Data

Loading Data

Application Programming Interface (API)

Web Scraping

Machine Data

Public Databases

Survey Data

Sampling and Observation

Hands-on with Data Acquisition

Lab: Using Public Data

Checkpoint: Data Acquisition

Cleansing and Profiling Data

Data Profiling Steps

Data Profiling Tools

Lab: Profiling Data Sets

Redundant and Duplicated Data

Lab: Addressing Redundant and Duplicated Data

Unnecessary Data

Missing Values

Lab: Addressing Missing Values

Invalid Data

Meeting Specifications

Data Outliers

Hands-on with Cleaning and Profiling Data

Lab: Preparing Data for Use

Checkpoint: Cleansing and Profiling Data

Data Manipulation

Recording Data

Derived Variables

Value Imputation

Aggregation and Reduction

Data Masking

Transposing Data

Appending Data

Hands-on with Data Manipulation

Lab: Recoding Data

Checkpoint: Data Manipulation

Performing Data Manipulation

Data Blending

Parsing Strings

Date Manipulation

Conditional Logic

Aggregation Functions

System Functions

Hands-on with Performing Data Manipulation

Checkpoint: Performing Data Manipulation

Querying & Filtering Data

Querying Data

Join Types

Lab: Working with Queries and Join Types

Filtering Data

Parameterization

Indexing Data

Temporary Tables

Subsets of Records

Query Execution Plan

Hands-on with Querying & Filtering Data

Lab: Building Queries and Transforming Data

Checkpoint: Querying & Filtering Data

Types of Analysis

Determining the Analysis Type

Exploratory Analysis

Performance Analysis

Gap Analysis

Trend Analysis

Link Analysis

Hands-on with Analysis

Checkpoint: Types of Analysis

Descriptive Statistical Methods

Central Tendency

Lab: Using the Measures of Central Tendency

Dispersion

Standard Deviation

Z-score

Distribution

Frequency

Percentages

Confidence Interval

Hands-on with Descriptive Statistical Methods

Lab: Use Measures of Variability

Checkpoint: Descriptive Statistical Methods

Inferential Statistical Methods

T-Tests and P-Values

Hypothesis Testing

Chi-Square

Regression Analysis

Correlation

Hands-on with Inferential Statistical Methods

Lab: Analyzing Data

Checkpoint: Inferential Statistical Methods

Visualization Types

Pie Chart

Tree Map

Column and Bar Charts

Line Chart

Combining Charts

Scatter Plot and Bubble Chart

Lab: Building Basic Visuals to Make Visual Impact

Histogram

Waterfall

Geographic Maps

Lab: Building Maps with Geographical Data

Heat Maps

Word Clouds and Infographics

Hands-on with Visualization

Checkpoint: Visualization Types

Creating Reports

The Audience

Data Sources

Data Models

Data Fields

Data Delivery

Reporting Frequency

Report Types

Lab: Using Visuals to Tell a Story

Hands-on with Creating Reports

Lab: Building an Ad Hod Report

Checkpoint: Creating Dashboards

Dashboard Development

Data Filtering

Lab: Filtering Data

Data Tables

Dashboard Design

Documenting Dashboards

Documentation Elements

Report Elements

Dashboard Optimization

Deploying Dashboards

Hands-on with Creating Dashboards

Labs: Designing Elements for Dashboards

Labs: Visualizing Data

Checkpoint: Creating Dashboards

Data Governance

Data Lifecycle

Data Roles

Regulations and Compliance

Data Classification

Access Requirements

Data Retention and Destruction

Data Processing

Data Security

Data Access

Data Storage

Entity Relationships

Hands-on with Data Governance

Lab: Understanding Security Requirements for Protecting Information

Checkpoint: Data Governance

Data Quality

Quality Checks

Quality Dimensions

Quality Rules and Metrics

Data Validation

Automated Validation

Data Verification

Master Data Management (MDM)

Streamlining Data Access

Hands-on with Data Quality

Checkpoint: Data Quality

Data Analytic Tools

Data Languages

Data Transformation Tools

Data Visualization Tools

Statistical Tools

Reporting Tools

Platform Tools

Checkpoint: Data Analytic Tools

BONUS: Conclusion

CompTIA Data+ (DA0-001) Practice Exam