1.Completeness, consistency, accuracy, timeliness, uniqueness
INCORRECT
No answer given
THE ANSWER
Common characteristics of high-quality information
2.Rules that enforce basic and fundamental information-based constraints. e.g. not allowing someone to order
zero pounds of raw materials from a supplier
INCORRECT
No answer given
THE ANSWER
Relational integrity constraints
3.Reveals the relationship between variables along with the nature and frequency of the relationships.
INCORRECT
No answer given
THE ANSWER
Associated detection
4.Analyzes unstructured data associated with websites to identify consumer
behavior and website navigation.
INCORRECT
No answer given
THE ANSWER
Web mining
5.Analyzes unstructured data to find trends and patterns in words and sentences.
INCORRECT
No answer given
THE ANSWER
Text mining
Extent of detail within information
Common types of information
1. Level 2. Format 3. Granularity
Different Information levels
1. Individual 2. Department 3. Enterprise
Different information formats
1. Documents 2. Presentation 3. Spreadsheet 4. Database
Different Information Granularities
1. Detail 2. Summary 3. Aggregate
Traits of Value Information
Type Timeliness Quality Governance
All information contained within single business process or unit of work and primary purpose is to support daily operational tasks (Sales receipt, Airline ticket, Packing slip)
All organizational information and primary purpose is to support performing of managerial analysis task (Product statistics, Sales projections, Future growth, trends)
Immediate up to date info
Real time information in response to requests
Information inconsistency
same data element has different values
Information Integrity issues
when system produces incorrect, inconsistent or duplicate data
5 common characteristics of high quality info
accuracy, completeness, consistency, uniqueness, timeliness
Overall management of the availability, usability, integrity, and security of company data
maintains info about various types of objects, people, places, events
Database management system DBMS
creates, reads, updates & deletes data in a database while controlling access and security.
Helps users graphically design answer to question against database
Structured Query Langauge
asks users to write lines of code to answer questions against database
the smallest or basic unit of information. It can include a customer’sname, address, email, discount rate, preferred shipping methods, product name,quantity ordered, and so on
logical data structures that detail the relationships among dataelements using graphics or pictures
Provides details about data
compiles all of metadata about the data elements in data model
Relational database model
stores info in form of logically related two dimensional tables
Relational management System
allows users to create, read, update, and delete data
stores information about person, place, thing, transaction or event
data elements associated with entity
collection of related data elements
field that uniquely identifies given record
Primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between two tables
Relational database for business advantages
Increased Flexibility Increased scalability and performance Reduced information redundancy Increased Information integrity Increased Information security
deals with physical storage of info on storage device
focuses on how individual users logically access information to meet their own particular business needs
duplication of data or storage of same data in multiple places
measure of quality of info
rules help ensure quality of info 1. relational 2. business critical
Relational integrity constraints
rules that enforce basic and fundamental information-based constraints. (not allow someone to create an order for a nonexistant customer)
how company performs certain aspects of its business and typically results in either yes/ no or true/false
Business-Critical Integrity and constraints
enforce business rules vital to an organizations success and often require more insight and knowledge
a person responsible for creating the original website content
person responsible for updating and maintaining website content
fixed data incapable of change in event of user action
- includes data that change based on user actions
area of a website that stores info about products in a database
interactive website that constantly updates and stays relevant to the needs of customers using a database
website owners can make changes without relying on MIS professionals; users can update data-driven website with little or no training
Easy to Store Large Amounts of Data
Data-driven websites can keep large volumes of information organized, templates, reliability and scalability.
easy to eliminate human errors
data driven websites trap data-entry errors, eliminating inconsistencies while ensuring all information is entered correctly
logical collection of information gathered from many different operational databases that supports business analysis activities and decision making tasks
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 it into a data warehouse. Then sends it to data mart
contains subset of data warehouse information
Representation of multidimensional information
Information Cleansing or Scrubbing
process that weeds out and
fixes or discards inconsistent, incorrect, or incomplete information
occurs during ETL process, and then again once information is in the data warehouse
determines the accuracy and completeness of data
process of analyzing data to extract info not offered by raw data alone
variety of techniques to find patterns and relationships in large volumes of information that predict future
- already in a database or a spreadsheet
do not exist in fixed location and can include text documents, PDF, voice messages, emails and so on
Text Mining (Data Mining)
Analyzes unstructured data to find trends/patterns in words/sentences
analyzes unstructured data associated with websites to identify consumer behavior and website navigation
technique used to divide info sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and different groups are far apart as possible
Reveals the relationship between variables with the nature and frequency of the relationships.
Items such as websites and checkout scanner information detect customers buying behavior and predict future behavior by identifying affinities among customer choices of products and services
Performs such functions as information correlations, distributions, calculations, and variance analysis
Time-staped information collected at a particular frequency
predictions based on time series information
accessing large amounts of data from different management information
displays info graphically so it can be easily understood
describes technologies that allow users to see or visualize data to transform information into business perspective
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