Course 1: Foundations: Data, Data, Everywhere

Question 1

Data

Answer 1

A collection of facts

Question 2

Data Analysis

Answer 2

A collection, transformation and organization of data, to draw conclusions make predictions and drive informed decision making

Question 3

Data Analyst

Answer 3

Someone who collects, transforms, and organizes data in order to drive informed decision-making

Question 4

Data Analytics

Answer 4

The science of data

Question 5

Data-driven decision-making

Answer 5

Using facts to guide business strategy

Question 6

Data ecosystem

Answer 6

The various elements that interact with one another in order to produce,
manage, store, organize, analyze, and share data

Question 7

Data science

Answer 7

A field of study that uses raw data to create new ways of modelling and understanding the unknown

Question 8

Dataset

Answer 8

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

Question 9

Analytical skills

Answer 9

: Qualities and characteristics associated with using facts to solve problems.

Question 10

Analytical Thinking

Answer 10

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

Question 11

Context

Answer 11

The condition in which something exists or happens

Question 12

Gap Analysis

Answer 12

A method for examining and evaluating the current state of a process in order to
identify opportunities for improvement in the future

Question 13

Root Cause

Answer 13

The reason a problem occurs.

Question 14

Technical Mindset

Answer 14

The ability to break things down into smaller steps or pieces and work with
them in an orderly and logical way

Question 15

Visualization

Answer 15

Refers to data visualization.

Question 16

6 Stages of Data Lifecycle

Answer 16

1. Plan
2. Capture
3. Manage
   4: Analyze
4. Archive
5. Destroy

Question 17

Plan

Answer 17

Decide what kind of data is needed, how it will be managed, and who will be responsible for it.

Question 18

Capture

Answer 18

Collect or bring in data from a variety of different sources.

Question 19

Analyze

Answer 19

Use the data to solve problems, make decisions, and support business goals.

Question 20

Archive

Answer 20

Keep relevant data stored for long-term and future reference.

Question 21

Destroy

Answer 21

Remove data from storage and delete any shared copies of the data.

Question 22

Data Strategy

Answer 22

The management of the people, processes and tools of in data analysis

Question 23

Database

Answer 23

A collection of datastored in a computer system

Question 24

Formula

Answer 24

A set of instructions used to perform a calculation using data in a spreadsheet

Question 25

Function

Answer 25

A preset command that automatically performs a specified process or task using the data in a spreadsheet

Question 26

Query Language

Answer 26

a computer programming language used to communicate with a database

Question 27

Stakeholders

Answer 27

people who invest time and resources into a project and are interested in its outcomes

Question 28

Syntax to SQL Qeuries

Answer 28

The syntax of every SQL query is the same:

Use SELECT to choose the columns you want to return.

Use FROM to choose the tables where the columns you want are located.

Use WHERE to filter for certain information.

Question 29

SELECT Syntax

Answer 29

Use SELECT to choose the Columns you want to return

Question 30

FROM Syntax

Answer 30

Use From to choose the tables where the columns you want are located

Question 31

WHERE Syntax

Answer 31

Use Where to Filter for Certain Information

Question 32

Attribute

Answer 32

A characteristic or quality of data used to label a column in a table

Question 33

Data Design

Answer 33

How information is organized

Question 34

Data Driven Decision-Making

Answer 34

Using facts to driven business strategy

Question 35

Data Visualization

Answer 35

The graphical representation of data

Question 36

Observation

Answer 36

Observation: The attributes that describe a piece of data contained in a row of a table

Question 37

Query

Answer 37

A request for data information from a table