Data Analytics - Course 1 Terms

What are analytical skills?

qualities and characteristics associated with using facts to solve problems

What is analytical thinking?

The process of identifying and defining a problem, then solving it using data in an organized, step-by-step manner

What is an attribute in data?

a characteristic or quality of data use

What is a business task?

The question or problem that data analysis resolves for a business

What does context mean in data analysis?

The condition in which something exists or happens.

What is data?

A collection of facts.

What is data analysis?

The collection, transformation, and organization of data to draw conclusions, make predictions, and guide decisions.

Who is a data analyst?

Someone who collects, transforms, and organizes data to support conclusions and informed decisions

What is data analytics?

The science of data

What is data design?

How information is organized

What is data-driven decision-making?

Using facts to guide business strategy.

What is a data ecosystem?

The elements that interact to produce, manage, store, analyze, and share data.

What is data science?

A field of study that uses raw data to model and understand the unknown.

What is a data strategy?

The management of people, processes, and tools used in data analysis.

What is data visualization?

The graphical representation of data.

What is a database?

A collection of data stored in a computer system.

What is a dataset?

A collection of data that can be manipulated or analyzed as one unit

What is fairness in data analysis?

A quality of analysis that does not create or reinforce bias

What is a formula in a spreadsheet?

A set of instructions used to perform a calculation.

What is a function in a spreadsheet?

A preset command that automatically performs a specified task.

What is gap analysis?

A method for evaluating a process's current state to identify improvement opportunities.

What is oversampling?

Increasing the sample size of nondominant groups to better represent them in data.

What is an observation in data?

The attributes describing a piece of data in a row of a table.

What is a query?

A request for data or information from a database.

What is a query language?

A programming language used to communicate with a database.

What is a query language?

A programming language used to communicate with a database.

What is a root cause?

The reason why a problem occurs.

What is self-reporting in data collection?

A technique where participants provide information about themselves.

Who are stakeholders?

People who invest in and care about a project's outcome.

What is Structured Query Language (SQL)?

A programming language used to communicate with a database.

What is a spreadsheet?

A digital worksheet used for organizing and analyzing data.

What is a technical mindset?

The ability to break things down into smaller, logical steps.

What is a visualization?

A graphical representation of data (also called data visualization).

What are the six phases of the data analysis process

ask, prepare, process, analyze, share, act

What do data analysts do when they (ask)?

understand the business challenge or question

What do data analysts do when they (prepare)?

find and collect relevant data to answer the question

What do data analysts do when they (process)?

clean and organize the data

What do data analysts do when they (analyze)?

perform calculations and analysis to discover insights

What do data analysts do when they (share)?

communicate findings to stakeholders

What do data analysts do when they (act)?

use insights to make decisions or take action

What are the three core components of a basic SQL query?

SELECT, FROM, and WHERE

Where does the SELECT clause do in SQL?

It specifies the columns to retrieve from a table

What does the FROM clause do in SQL?

It indicates the table where the data is located

What does the WHERE clause do in SQL?

It filters the query results based on specified conditions