CIS Vocab Chpt. 8

Culture - BI

A key responsibility of executives is to shape and manage corporate culture. The extent to which the BI attitude flourishes in an organization depends in large part on the organization's culture.

Data Warehouse

A logical collection of information- gathered from many different operational databases- that supports business analysis activites and decision-making tasks

Dimension

A particular attribute of information

Extraction, Transformation, and Loading (ETL)

A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse

Information Cleansing or Scrubbing

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

Informing

Accessing large amounts of data from different management information systems

Data Visualization

Allows users to see or visualize data to trnasform information into a business perspective

The Solution: _______ ______

Business Intelligence

Cube

Common term for the representation of multidimensional information

Data Mart

Contains a subset of data warehouse information

To perform data mining users need ______-_______ _____

Data-Mining Tools

Businesses face a ______ explosion with digital _______, _______ inboxes and broadband connections. The amount of data generated is _______ each year. Some believe it will soon _______ ______.

Data/Images/Email Doubling Double monthly

The Problem: ______ Rich and ______ Poor

Data/Information

Why is the ability to look at information based on different dimensions critical to a businesses success? Ans: The ability to look at information from _________ _________ can add tremendous _________ _________. By slicing-and-dicing the information a business can uncover great _________ _________.

Different Dimensions/ Business Insight Unexpected Insights

Infographics

Displays information graphically

Finding the answers to tough business questions allows a business to gain valuable insight into such things as: Where the business _____ ____ . Where it ____ _____ . And where it _____ ____ in the ____ _____ .

Has Been Is Now Will Be/ Near Future

An organization must maintain _____-_______ _____ in the data warehouse

High-Quality Data

Business Intelligence

Information that people use to support their decision-making efforts

What is the primary difference between a database and data warehouse? The primary difference between a database and a data warehouse is that a database stores ___________ for a _______ ________ , whereas a data warehouse stores ________ from ________ ________ , or _______ applications, and ______ _______ such as industry information. This enables ________-________ analysis, ___________ analysis, _______ analysis, etc., all from a ______ ________. Data warehouses support only ________ processing (OLAP)

Information/ Single Application/ Information/ Multiple Databases/ Multiple/ External Information Cross-Functional/ Industry/ Market/ Single Repository Analytical

The Primary Purpose of a Data Warehouse is to aggregate _______ throughout an organzation into a ______ __________ for ______-________ purposes

Information/ Single Repository/ Decision-Making

The ETL process gathers data from the _______ and _________ databases and passes it to the ______ _________. The ETL process also gathers data from the ______ _______ and passes it to the ________ _______.

Internal/External/ Data Warehouse Data Warehouse/Data Marts

Each ______ in a data warehouse or data mart represents information according to an additional _______. Dimensions could include such things as: Products Promotions __________ Category ___________ Stock price Date _________ Weather

Layer/ Dimension Stores Region Time

Technology- BI

Most significant enabler of Business Intelligence Doing sophisticated analyses today that were unavailable to the largest organizations a generation ago

Examples of Information Cleansing or Scrubbing *Contact Information in an _________ system * __________ Customer name from Operational Systems

Operational Standardizing

Improving the _______ of _______ ______ has a direct impact on _____ and _____

Quality Business Decisions Costs/ Revenue

Information Cleansing allows an organization to fix these types of inconsistences and cleans the data in the data warehouse Missing _______ or _______ _________ Records ________ Keys or other ________ data __________ Relationships or References _________ Data

Records/Attributes Redundant Missing/Required Erroneous Inaccurate

BI enables business users to receive data for analysis that is: _______ ________ ________ Easily __________

Reliable Consistent Understandable Manipulated

Data Visualization Tools

Sophisticated Analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more.

Data mining can begin at a _________ information level (_______ ________) and progress through increasing levels of ______ (_______ ________), or the reverse (________ _______) Data-mining tools include ______ tools, ________ tools, ________ ______ tools, ________ tools, and _______ agents

Summary/ Coarse Granularity/ Detail/ Drilling Down/ Drilling Up Query/Reporting/Multidimensional Analysis/ Statistical/ Intelligent

Principle BI Enablers Include

Technology People Culture

Data Mining

The process of analyzing data to extract information not offered by the raw data alone

Business Intelligence Dashboards

Track corporate metrics allowing users to manipulate data for analysis

Databases contain information in a series of ______-__________ tables. In a data warehouse and data mart, information is ____________, it contains ________ of _______ and ________.

Two-Dimensional Multidimensional/ Layers/ Columns/ Rows

People -BI

Understanding the role of people in BI allows organizations to systematically create insight and turn these insights into actions.. Organizations can improve their decision making by having the right people making the decisions.

Data-Mining Tool

Uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making