Chapter 7 - Accessing Organizational Information - Data Warehouses

Data Cycle Analysis

collect - identify data sources

analyze - ask right questions

communicate - influence and persuade

visualize - craft your data story

Organizational Problems

data rich

lack of information

lack of business intelligence

inability to tell the story the data and resulting information creates

Data Warehousing

a logical collection of information

gathered from - all internal organizational databases, any external industry databases

used to support business analysis activities and decision-making tasks

primary purpose - aggregate data throughout an organization into a single repository for decision-making purposes

Data Aggregation

collection of data from various sources for the purpose of data processing

Extraction, Transformation, and Loading (ETL)

of info. from internal and external databases

of the info. using a common set of enterprise definitions

the information into the data warehouse

Data Mart

contains a subset of data warehouse info

Data Cube

the common term for the representation of multidimensional data

Data Lake

a storage repository holding vast amounts of raw data in its original format until the business needs it

Data Cleansing or Scrubbing

a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete data

Dirty Data

erroneous or flawed data

duplicate

incorrect

inaccurate

non-formatted

business rule violation