Refers to the extent of detail within the information (Fine and detailed or course and abstract).
Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks.
Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks.
Immediate, up-to-date information.
Provide real-time information in response to requests.
When the same data element has different values.
Information Integrity Issues
Occur when a system produces incorrect, inconsistent, or duplicate data.
Is there an incorrect value in the information?
Is a value missing from the information?
Is aggregate or summary information in agreement with detailed information?
Is the information current with respect to business needs?
Is each transaction and event represented only once in the information?
Refers to the overall management of the availability, usability, integrity, and security of company data.
Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
Database Management System (DBMS)
Creates, reads, updates and deletes data in a database while controlling access and security.
Query By Example Tool (QBE)
Helps users graphically design the answer to a question against a database.
Structured Query Language (SQL)
Asks users to write lines of code to answer questions against a database.
Data Element (Data Field)
The smallest or basic unit of information.
Logical data structures that detail the relationships among data elements using graphics or pictures.
Provides details about data.
Compiles all of the metadata about the data elements in the data model.
Relational Database Model
Stores information in the form of logically related two-dimensional tables.
Relational Database Management System
Allows users to create, read, update, and delete data in a relational database.
Stores information about a person, place, thing, transaction, or event.
Attributes (Columns or fields)
Data element associated with an entity.
A collection of related data elements .
A field that uniquely identifies a given record in a table.
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
Physical View of Information
Deals with the physical storage of information on a storage device.
Logical View of Information
Focuses on how individual users logically access information to meet their own particular business needs.
The duplication of data, or the storage of the same data in multiple places.
A measure of the quality of information.
Rules that help ensure the quality of information.
Relational Integrity Constraints
Rules that enforce basic and fundamental information based constraints.
Defines how a company performs certain aspects of its business and typically results in either yes/no or true/false answers.
Business Critical Integrity Constraints
Enforce business rules vital to an organization’s success and often require more insight and knowledge than relational integrity constraints.
The person responsible for updating and maintaining website content.
Includes fixed data incapable of change in the event of user action.
Includes data that change based on user action.
An area of a website that stores information about products in a database.
Data Driven Website
An interactive website kept constantly updated and relevant to the needs of its customers using a database.
A logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
Inconsistent Data Definitions
Every department had its own method for recording data so when trying to share information, data did not match and users did not get the data they really needed.
Lack of Data Standards
Managers need to perform cross-functional analysis using data from all departments, which differed in granularities, formats, and levels.
Poor Data Quality
The data, if available, were often incorrect or incomplete. Therefore, users could not rely on the data to make decisions.
Inadequate Data Usefulness
Users could not get the data they needed; what was collected was not always useful for intended purposes.
Ineffective Direct Data Access
Most data stored in operational databases did not allow users direct access; users had to wait to have their queries or questions answer by MIS professionals who could code SQL.
Extraction, Transformation, and Loading (ETL)
A process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads into a database warehouse.
Contains a subset of data warehouse information.
The common term for the representation of multidimensional information.
Information Cleansing or Scrubbing
A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete data.
Data Quality Audits
Completed by companies to determine the accuracy and completeness of its data.
The process of analyzing data to extract information not offered by the raw data alone.
Data Mining Tools
Use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.
Assigns records to one of a predefined set of classes.
Determines values for an unknown continuous variable behavior or estimated future value.
Determines which things go together.
Segments a heterogenous population of records into a number of more homogenous subgroups.
Data that is already in a database or a spreadsheet.
Data that does not exist in a fixed location and can include text documents, PDFs, voice messages, emails, and so on.
Analyzes unstructured data to find trends and patterns in words and sentences.
Analyzes unstructured data associated with websites to identify consumer behavior and website navigation.
A technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far part from one another as possible.
Reveals the relationship between variables along with the nature and frequency of the relationships.
Market Basket Analysis
Analyzes such times as websites and checkout scanner information to detect customer’s choices of products and services and for inventory control, shelf-product placement, and other retail and marketing applications.
Performs such functions as information correlations, distributions, calculations, and variance analysis.
Time stamped information collected at a particular frequency.
Predictions based on time series information.
Accessing large amounts of data from different management information systems.
Displays information graphically so it can be easily understood.
Describes technologies that allow users to “see” or visualize data to transform information into a business perspective.
Data Visualization Tools
Move beyond excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more.
Business Intelligence Dashboards
Track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis.