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