[EBTM 337] - Midterm Exam Guide - Ultimate 31 pages long Study Guide!

106 views31 pages

For unlimited access to Study Guides, a Grade+ subscription is required.

TU
EBTM 337
MIDTERM EXAM
STUDY GUIDE
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 31 pages and 3 million more documents.

Already have an account? Log in
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 31 pages and 3 million more documents.

Already have an account? Log in
Chapter 6: Data: Business Intelligence
Information Levels: Individual, Department, and Enterprise
Information Formats: Document, Presentation, Spreadsheet, Database
Information Granularities: Detail (Fine), Summary, Aggregate (Coarse)
Information Granularity- Refers to the extent of detail within the information
Transactional Information- Encompasses all of the information contained within a single
business process or unit of work, and its primary purpose is to support the performing of daily
operational tasks (i.e. airline ticket, sales receipt, and packing slip)
Analytical Information- Encompasses all organizational information, and its primary purpose is
to support the performing of managerial analysis tasks (i.e. product statistics, sales projections,
future growth, and trends)
Real-time Information- Immediate, up-to-date information
Real-time System- Provides real-time information in response to requests
Characteristics of High-quality Information:
1. Accurate
2. Complete
3. Consistent
4. Unique
5. Timely
Examples of Low Quality Information:
1. Missing Information (i.e. no first name)
2. Incomplete Information (i.e. no street)
3. Probable Duplicate Information (i.e. similar names, same address, phone number)
4. Potential Wrong Information (i.e. are the phone and fax numbers the same or is this an
error?)
5. Inaccurate Information (i.e. invalid e-mail)
6. Incomplete Information (i.e. missing area codes)
Four Primary Sources of Low-quality Information Include:
1. Customers intentionally enter inaccurate information to protect their privacy
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 31 pages and 3 million more documents.

Already have an account? Log in
2. Different entry standards and formats
3. Operators enter abbreviated or erroneous information by accident or to save time
4. Third party and external information contains inconsistencies, inaccuracies, and errors
Potential Business Effects Resulting from Low-quality Information Include:
Inability to accurately track customers
Difficultly identifying valuable customers
Inability to identify selling opportunities
Marketing to nonexistent customers
Difficulty tracking revenue
Inability to build strong customer relationships
Information is stored in databases
Database- Maintains information about various types of objects (i.e. inventory), events
(i.e. transactions), people (i.e. employees), and places (i.e. warehouses)
Database Management Systems (DBMS)- Allows users to create, read, update, and delete in a
relational database
Data Element- The smallest or basic unit of information
Data Model- Logical data structures that detail the relationships among data elements using
graphics or pictures
Metadata- Provides details about data
Data Dictionary- Compiles all of the metadata about the data elements in the data model
Entity- A person, place, thing, transaction, or event about which information is stored (the rows
in a table contain entities)
Attribute (field, column)- The data elements associated with an entity (the columns in each
table contain the attributes)
Record- A collection of related data elements
Primary keys and foreign keys identify the various entities (tables) in the database
Primary Key- A field (or group of fields) that uniquely identifies a given entity in a table
Foreign Key- A primary key of one table that appears an attribute in another table and acts to
provide a logical relationship among the two tables
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 31 pages and 3 million more documents.

Already have an account? Log in

Get access

Grade+
$10 USD/m
Billed $120 USD annually
Homework Help
Class Notes
Textbook Notes
40 Verified Answers
Study Guides
1 Booster Class