Introduction to Data Science and Excel Data Management

This flashcard set covers the fundamental concepts of data science, analysis terminology, Excel data visualization tools, and table manipulation techniques including sorting and filtering.

Data analysis

The process of finding patterns, evaluating cause and effect, and making estimations from data by applying a logic-based approach such as statistical analysis.

Data mining

The process of analyzing large amounts of data to find patterns and correlations.

Benchmarking

The practice of comparing business operations baselines or competitors to evaluate performance.

Data science

A field where scientists work with large structured and unstructured datasets using scientific methods and processes to discover insights to inform critical decisions.

R Project for Statistical Computing (R)

A tool used by data scientists for conducting advanced statistical analysis.

Python

A tool used for taking a programmatic approach to advanced data analysis with large data sets.

Data Visualization

The act of using visual elements such as charts, graphs, and maps to analyze data, find patterns, and report insights gleaned from data.

Visual Processing Speed

The rate at which humans process visual data compared to other forms, which is approximately $60,000$ times more quickly.

Charts

Excel options, such as bar and pie charts, which graphically represent data and relationships.

PivotTables

Excel objects that allow for the manipulation of data by rotating or turning large amounts of data into summaries that show insights.

Geospatial visualizations

Visualizations that show geographic data on maps to gain insights into how geographic location relates to data.

Dashboards

Tools that combine charts, PivotTables, and geospatial visualizations to correlate and show relationships in data.

Table

A dataset composed of contiguous rows and columns that Excel treats as a single, independent object.

Sorting

The process of reordering worksheet data based on defined criteria, such as alphabetically or from highest value to lowest value.

Filtering

The process of removing from view any data entries that do not match some specified criteria.

$$=$$

An operator that filters data based on an exact content match.

$$<$$

An operator that filters for numerical or date and time values that are less than the defined criteria.

$$>$$

An operator that filters for numerical or date and time values that are greater than the defined criteria.

$$<=$$

An operator that filters for numerical or date and time values that are less than or equal to the defined criteria.

$$>=$$

An operator that filters for numerical or date and time values that are greater than or equal to the defined criteria.

$$<>$$

An operator that filters for numerical, textual, or date and time values that are not equal to the defined criteria.

$$?$$

A wildcard operator that serves as a substitute for a single character in a search.

$$*$$

A wildcard operator that serves as a substitute for multiple characters in a search.