M4 Data Management and Analytics

Question 1

5 Dimension of Big Data “Five Vs)

Answer 1

1.) Volume
2.) Velocity - spread of data
3.) Variety
4.) Veracity - reliability, integrity, etc.
5.) Value

Question 2

How are regional databases and tables linked?

Answer 2

Key fields (primary and foreign)

Question 3

attributes in one table that are also primary keys in another table

Answer 3

Foreign key

Question 4

Process which data is captured from its source and transferred to an organization’s custody so that it can then be further analyzed

Answer 4

ETL Extract Transform Load

Question 5

process of taking raw data, identifying tends and then transforming that knowledge into insights that can help solve complex business problems

Answer 5

Data Analytics

Question 6

4 Types of Data Analytics from least value/complex to most

Answer 6

1.) Descriptive (what happened)
2.) Diagnostic (why it happened)
3.) Predictive analytics (Forward)
4.) Prescriptive (forward)

Question 7

Type of data visualizations: graphical displays that show lower and upper extremes, lower and upper quartiles, as well as the median data point

Answer 7

Boxplots

Question 8

Type of data visualizations: show the cumulative effect of a series of data points that make up a whole

Answer 8

Waterfall chart