Fundamentals of Data Analytics Flashcards

Prescriptive analytics is best described as:

Answer: Recommending actions to achieve an outcome

Prescriptive analytics suggests actions to optimize a desired outcome.

What is a data warehouse primarily used for?

Answer: Centralized storage for analysis and reporting

A data warehouse centralizes integrated data optimized for analysis and reporting.

Which term describes an outlier in a dataset?

Answer: A value that differs markedly from others

An outlier is a data point that deviates significantly from the rest.

The median is preferred over the mean when data is:

Answer: Skewed or has outliers

The median resists distortion from skew and outliers better than the mean.

What does 'data governance' refer to?

Answer: Policies for data quality, security, and usage

Data governance sets policies managing data quality, security, and proper usage.

Which is a benefit of data normalization in a database?

Answer: Reduces data redundancy and improves integrity

Normalization organizes data to minimize redundancy and maintain integrity.

A histogram is most useful for showing:

Answer: The distribution of a single numeric variable

A histogram displays the frequency distribution of one numeric variable across bins.