Data Management And Analytics

Question 1

A fact, an occurrence, and instance or otherwise measurable observation including numerical digits, text, images, videos, recordings:

Answer 1

Data

Question 2

The corporate accumulation of massive amounts of data that can be used for data analytics

Answer 2

Big data

Question 3

What are the five dimension of data (five V’s):

Answer 3

Volume
Velocity
Variety
Veracity
Value

Question 4

This V of big data represents the quantity or amount of data points or the size of the data

Answer 4

Volume

Question 5

This V of big data refers to the speed of data accumulation or data processing

Answer 5

Velocity

Question 6

This V of big data represents the range of data type being processed or analyzed

Answer 6

Variety

Structured data - defined organizational format that has specific parameters (telephone numbers)
Semi-structured data - hybrid of structured and unstructured data (comma-separated values file)
Unstructured data - a format that does not have predefined parameters and lacks organization

Question 7

This V of big data represents the reliability, quality, or integrity of the data. Processes should be implemented so that duplicate fields missing fields, incorrect formats or characters are removed.

Answer 7

Veracity

Question 8

This V of big data refers to the insights big data can yield. Not all data will translate to actionable insights, so it is important to understand the question or business problem that needs solved before blindly looking at data.

Answer 8

Value

Question 9

Data can be stored in a variety of ways, but one of the most efficient and effective methods for many use cases is to store data in a what? These allow data to be stored in different tables and are linked through relationships using key fields.

Answer 9

Relational database

Question 10

In tables, a column is what?it describes the properties desired to be known about each entry

Answer 10

Attributes

Question 11

In a table, a row is what? It contains information about one entry within that table.

Answer 11

Records

Question 12

The intersection of a column and row (attribute and record)

Answer 12

Field

Question 13

Two main types of database keys are:

Answer 13

Primary key

Foreign key

Question 14

A unique identifier for one specific row within a table, can be made up of one or more attributes

Answer 14

Primary keys

Question 15

Attributes in one table that are also the primary key in another table. For example, the customer ID may be the primary key in the customer table; however, it is a foreign key in the sales table.

Answer 15

Foreign key

Question 16

Two types of database views:

Answer 16

Logical database view

Physical database view

Question 17

Represents the type of data that is tired in a database and it intended o explain the contents as well as structure of a database to users.

Answer 17

Logical database view

Question 18

Represents how the data is actually stored, processes, and or accessed within a database:

Answer 18

Physical database view

Question 19

Involves steps such as:
Determine the desired output 
Remove inaccurate data
Address missing fields
Remove sensitive information not needed
Ensure proper formatting, etc.

Answer 19

Cleaning data

Question 20

This process ensures data is not lost or inappropriately modified during the cleaning process. May only require a visual review or may require a statistical test

Answer 20

Validating data

Question 21

The process that can supplement or enhance data in a way that adds value to the existing data points

Answer 21

Manipulating data

Question 22

A repository f transactional data from multiple sources and is often a source for data warehouses

Answer 22

Operational data store (ODS)

Question 23

Very large data repositories that are centralized and utilized for reporting and analysis rather than for transaction purposes

Answer 23

Data warehouse

Question 24

Like a data share house but is more focused on a specific purpose such as marketing, logistics, etc.

Answer 24

Data mart

Question 25

Similar to a data warehouse, but it contains both structured and unstructured data with data mostly in its raw or natural data format.

Answer 25

Data lake

Question 26

A storage requirement that means each table must have a unique primary key as a record identifier

Answer 26

Entity integrity

Question 27

A storage requirement that notes a change to a primary key in one table must also cause a change to any related foreign key in a table that it is linked.

Answer 27

Referential integrity

Question 28

Four categories of data analytics:

Answer 28

Descriptive analytics - describing or explaining what has occurred
Diagnostic analytics - diagnosing or explaining why it occurred
Predictive analytics - predicting what will occur
Prescriptive analytics - prescribing what could or should occur

Question 29

Best to show quantitative trends over time

Answer 29

Line charts

Question 30

Best at showing comparisons

Answer 30

Column chart

Question 31

Best at showing additional details of a column chart

Answer 31

Stacked column chart

Question 32

Best at showing relationships between two variables

Answer 32

Scatter plots

Question 33

Best at showing lower and upper extremes, quartiles, and median data points

Answer 33

Boxplots

Question 34

Best at showing frequency

Answer 34

Dot plots

Question 35

Best at showing proportions of a whole value as a percentage

Answer 35

Pie charts

Question 36

Best at showing underlying foundations or building blocks that go into achieving a task or plan

Answer 36

Pyramid

Question 37

Best at showing a process hat has beginning and ending steps and a series of steps in between

Answer 37

Flowcharts

Question 38

Best at showing the cumulative effect of a series of data point that make up a whole

Answer 38

Waterfall chart

Question 39

Best at showing key events or milestones

Answer 39

Directional charts