Data Management and Analysis Lecture Review

A set of vocabulary flashcards covering statistics, ETL processes, data storage systems, and database management concepts.

Statistics + logic

Used to generate useful information from data.

ETL planning

A process used to avoid bandwidth issues.

Hadoop vs ETL

Involves processes across multiple servers.

Data mining purpose

To uncover patterns to predict trends, including future patterns and predictive analytics.

Data lake

A storage repository containing raw data and allowing for flexible analysis.

Normalization

A technique used to remove redundancies within a database.

DBMS

A system that controls the database.

Data warehouse purpose

To retrieve organizational data.

Data governance

The management practice that results in updated + clean data.