Intro to Business Information Systems: Ch 7

Question 1

data point

Answer 1

an individual item on a graph or chart

Question 2

Data Analysis Cycle

Answer 2

Identify data sources (collect)
Ask the right questions (analyze)
Influence and persuade (communicate)
craft your data story (visualize)

Question 3

data set

Answer 3

an organized collection of data

Question 4

comparative analysis

Answer 4

compares two or more data sets to identify patterns and trends

Question 5

competitive monitoring

Answer 5

a company keeps tabs on its competitors activities on the web using software that automatically tracks all competitors website activities such as discounts or new products

Question 6

raw data

Answer 6

data that has not been processed for use

Question 7

source data

Answer 7

identifies primary location where data is collected

Question 8

data aggregation

Answer 8

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

Question 9

reasons business analysis is difficult from operational databases

Answer 9

inconsistent data definitions, lack of data standards, poor data quality, inadequate data usefulness, ineffective direct data access

Question 10

data warehouse

Answer 10

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

Question 11

layers of a data warehouse

Answer 11

1. extraction, transformation, and loading or the integration layer
2. data warehouse layer
3. data mart layer

Question 12

extraction, transformation, and loading (ETL) or integration layer

Answer 12

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

Question 13

data warehouse layer

Answer 13

layer that stores data from every source system over time which is designed for query and analysis

Question 14

data mart layer

Answer 14

contains a subset of data warehouse data which is a more functional focus that the data warehouses operational focus

Question 15

integrations - the primary goal of data warehouses

Answer 15

allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems

Question 16

application integration

Answer 16

integration of a company’s existing management information system

Question 17

data integration

Answer 17

integration of data from multiple sources that provide a unified view of all data

Question 18

backward integration

Answer 18

sends information entered into a given system automatically to all upstream systems and processes

Question 19

forward integration

Answer 19

sends information entered into a given system automatically to all downstream systems and processes

Question 20

common data repository

Answer 20

allows every department of a company to store and retrieve information in real time allowing information to be more reliable and accessible

Question 21

data cube

Answer 21

common term for representation of multidimensional data

Question 22

data lake

Answer 22

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

Question 23

dirty data

Answer 23

erroneous or flawed data

Question 24

data cleansing or scrubbing

Answer 24

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

Question 25

data quality audits

Answer 25

determines the accuracy and completeness of data