chapter 7.1

challenges in business

--collecting data --Discerning patterns and meaning in data --responding to the resultant data

data point

an individual item on a graph or a chart

BI can help managers with _______ monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

competitive

examples of how different industries use business intelligence include:

~Airlines: Analyze popular vacation locations with current flight listings. ~Banking: Understand customer credit card usage and nonpayment rates. ~Health care: Compare the demographics of patients with critical illnesses. ~Insurance: Predict claim amounts and medical coverage costs. Law ~enforcement: Track crime patterns, locations, and criminal behavior. ~Marketing: Analyze customer demographics. ~Retail: Predict sales, inventory levels, and distribution. Technology: Predict hardware failures.

Choose three reasons why operational systems are not appropriate for business analysis.

-operational systems are not integrated - information from other operational applications is not included - operational information is mainly current

What is the common term for the representation of multidimensional data?

Data Cube

What is a process that extracts data from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse?

Extraction, transformation, and loading

A data ______ audit determines the accuracy and completeness of its data.

Quality

What identifies the primary location where data is collected?

Source Data

data cube

The common term for the representation of multidimensional data

3 Layers of a Data Warehouse

__ETL or integration layer: Extraction, transformation, and loading (ETL) is a process that extracts data from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse. __Data warehouse layer: This layer stores the data from every source system over time. The data warehouse is designed for query and analysis rather than for transaction processing and stores data from source systems and external systems. __Data mart layer: A data mart contains a subset of data warehouse data. To distinguish between data warehouses and data marts, think of data warehouses as having a more organizational focus and data marts as having a functional focus. Imagine a marketing representative requiring data from production, sales, and weather reports. This person would not typically have access to these operational or source systems. The data warehouse can pull the data from the source systems, cleanse it, and compile it in a data mart for the marketing representative to analyze.

competitive monitoring

a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

data warehouse

a logical collection of data-gathered from many different operational databases- that supports business analysis activities and decision-making tasks.

what is a dimension

a particular attribute of data

Data cleansing or scrubbing

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

Data lake

a storage repository that holds a vast amount of raw data in its original format until the business needs it

data map

a technique for establishing a march, or balance, between the source data and target data warehouse.

Data-driven decision management

an approach to business governance that values decisions that can be backed up with verifiable data.

dataset

an organized collection of data

comparative analysis

can compare two or more datasets to identify patterns and trends.

A(n) ___ analysis can compare two or

comparative

What can compare two or more data sets to identify patterns and trends?

comparative analysis

What occurs when a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products?

competitive monitoring

relational database

contains data in a series of two-dimensional tables

what process has raw data undergone

cooked data

what does each layer of big data represent

data according to an additional dimension

Data _______ is the collection of data from various sources for the purpose of data processing.

data aggregation

What is the collection of data from various sources for the purpose of data processing?

data aggregation

What is an approach to business governance that values decisions that can be backed up with verifiable data?

data driven decision management

Question Mode Multiple Choice Question Data ______ is the common term for the representation of multidimensional data.

data lake

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

data map

what alerts managers to inconsistencies or help determine the cause and effects of enterprise-wide business decisions.

data map

what data technique identifies data shortfalls and recognizes data issues

data map

What contains a subset of data warehouse data?

data mart

raw data

data that has not been processed for use

Data-driven _______ management is an approach to business governance that values decisions that can be backed up with verifiable data.

decision

data quality audits

determine the accuracy and completeness of its data

Dirty Data

erroneous or flawed data

Source data

identifies the primary location where data is collected.

what does source data include?

invoices, spreadsheets, time sheets, transactions, and electronic sources such as other databases.

A data _______ contains a subset of data warehouse data.

mart

what does organizational data include

structured data, unstructured data,

Data Aggregation

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

What is the success of the data-driven approach reliant upon

the quality of the data gathered and the effectiveness of its analysis and interpretation.

Key Idea within data warehousing

to collect data from multiple systems in a common location that uses a universal querying tool. This allows operational databases to run where they are most efficient for the business, while providing a common location using a familiar format for the strategic or enterprise-wide reporting data.

What is the primary purpose of data warehouse

to combine data, more specifically, strategic data, throughout an organization into a single repository in such a way that the people who need that data can make decisions and undertake business analysis.

example of data aggregation

to gather data about particular groups based on specific variables such as age, profession, or income.

examples of unstructured data

voice mail customer phone calls, text messages, videoclips, numerous new forms of data, such as tweets from twitter.

Is big data multi-dimensional

yes, it contains layers of columns and rows