Data Terms

Question 1

Information in it’s raw form, such as numbers, text, images, videos, that is collected, stored, and processed for analysis.

Answer 1

Data

Question 2

Data that follows a predefined format. For example, database tables and data that is stored in tables in Excel files would both be structured data.1”

Answer 2

Structured Data

Question 3

Data that doesn’t follow a predefined format. Examples would be server log files and emails.

Answer 3

Unstructured Data

Question 4

Extremely large and complex datasets that require specialized tools and techniques for storage, processing, and analysis, often characterized by the “3 V’s”: volume, velocity and variety.

Answer 4

Big Data

Question 5

An organized collection of data, typically stored and accessed electronically from a computer system. It is structured to allow efficient storage, retrieval and management of information.

Answer 5

Database

Question 6

A documentation that provides a comprehensive description of the data elements, including their definitions, data types, formats, and relationships, used in a database or a data system.

Answer 6

Data Dictionary

Question 7

Data Warehouse

Answer 7

A central repository that stores large amounts of data from different sources, typically used for data analysis, reporting, and decision- making purposes.

Question 8

The process of extracting data from multiple sources, transforming it into a consistent format, and loading it into a data warehouse or another data repository for analysis.

Answer 8

ETL (Extract, Transform, Load)

Question 9

The framework, policies, and procedures that ensure the quality, consistency, integrity, and security of data across an organization, including data standards, data management practices, and data security protocols.

Answer 9

Data Governance

Question 10

The protection of personal or sensitive information from unauthorized access, use, or disclosure, in compliance with relevant laws, regulations, and organizational policies, to ensure data security and privacy.

Answer 10

Data Privacy

Question 11

The process of examining, evaluating, and interpreting data to derive insights, identifying patterns, and make informed decisions.

Answer 11

Analysis

Question 12

(also called descriptive statistics) Type of analysis that focuses on describing and summarizing data, typically through statistical measures such as mean, median, mode, standard deviation, and visualizations like charts and graphs.

Answer 12

Descriptive Analysis

Question 13

(Also called inferential statistics) The type of analysis that involves making predictions and drawing conclusions from data based on statistical techniques, such as hypothesis testing, regression analysis, and confidence intervals.

Answer 13

Inferential Analysis

Question 14

The use of graphical representations, such as charts, graphs, and maps, to visually display data in a way that is easy to understand and interpret.

Answer 14

Data Visualization

Question 15

The process of identifying and correcting errors, inconsistencies, and inaccuracies in data, including missing values, duplicate entries, and formatting issues, to ensure data quality and reliability.

Answer 15

Data Cleansing

Question 16

The process of discovering patterns, trends, and relationships in large datasets using various techniques, such as clustering, classification, and association analysis, to extract valuable insights.

Answer 16

Data Mining