Intro to Business Information Systems: Ch 7 Flashcards
data point
an individual item on a graph or chart
Data Analysis Cycle
Identify data sources (collect)
Ask the right questions (analyze)
Influence and persuade (communicate)
craft your data story (visualize)
data set
an organized collection of data
comparative analysis
compares two or more data sets to identify patterns and trends
competitive monitoring
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
raw data
data that has not been processed for use
source data
identifies primary location where data is collected
data aggregation
collection of data from various sources for the purpose of data processing
reasons business analysis is difficult from operational databases
inconsistent data definitions, lack of data standards, poor data quality, inadequate data usefulness, ineffective direct data access
data warehouse
logical collection of data gathered from many different operational databases that supports business analysis activities and decision tasks
layers of a data warehouse
- extraction, transformation, and loading or the integration layer
- data warehouse layer
- data mart layer
extraction, transformation, and loading (ETL) or integration layer
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
data warehouse layer
layer that stores data from every source system over time which is designed for query and analysis
data mart layer
contains a subset of data warehouse data which is a more functional focus that the data warehouses operational focus
integrations - the primary goal of data warehouses
allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems
application integration
integration of a company’s existing management information system
data integration
integration of data from multiple sources that provide a unified view of all data
backward integration
sends information entered into a given system automatically to all upstream systems and processes
forward integration
sends information entered into a given system automatically to all downstream systems and processes
common data repository
allows every department of a company to store and retrieve information in real time allowing information to be more reliable and accessible
data cube
common term for representation of multidimensional data
data lake
storage repository that holds vast amount of raw data in original format until the business needs it
dirty data
erroneous or flawed data
data cleansing or scrubbing
process that weeds out, fixes, and discards inconsistent, incorrect, or incomplete information
data quality audits
determines the accuracy and completeness of data