ITM Day 4 Business Intelligence and Business Analytics – Flashcards
Unlock all answers in this set
Unlock answersquestion
Zillow Case (Five common high-quality information and rank them in order or importance)
answer
Accuracy, Complete, Consistent, unique, timely.
question
How does Zillow uses a data-driven website to run its business
answer
keep track of inventory, transaction to others(important), interactive website constantly updated and relevant to customers.
question
Describe how Zillow uses business intelligence to create a unique product for its customers
answer
Prove info people use to support their decision-making process, can search area and list criteria that they find options that fit description.
question
Levels of Data
answer
Character and Field
question
Records
answer
Related Fields with attributes and length
question
Files
answer
grouping of records with classificaion
question
Database
answer
Integrated Collection of Logically Related Data Elements Consolidates Records Into Common Pool of Data Elements Data is independent of Application Program and Storage Device
question
Logical Data Elements from top to bottom
answer
Database, File, Record, Field, Character
question
Low Quality Information
answer
Lack of Customer satisfaction or economic loss
question
Information Quality
answer
Accurate, complete, consistent, unique, timely
question
Accurate
answer
Are value Correct (spelling)
question
Complete
answer
any values missing (Address have all needs)
question
Consistent
answer
Summary info in agreement with detailed info
question
Unique
answer
each transaction, entity, represents only once in info ( duplicate customers)
question
Timely
answer
is info current ( updated weekly, daily, hourly)
question
Database Advantages
answer
Increase Flexibility Increase Scalability and performance Decrease Redunduncy Increase Info Integrity (Quality) Increase info security
question
Scalability
answer
Refers to how well a system can adapt to increased demands
question
Performance
answer
Measure How quickly a system performs a certain process or transaction
question
Data Redundancy
answer
Duplication of data or storing the same information in multiple placess
question
Information integrity
answer
measures the quality of information
question
Integrity Constraint
answer
rules that help ensure the quality of information
question
Relational integrity constraint
answer
rule that enforces basic and fundamental info based constant
question
Password
answer
Provides authentication of the user
question
Access Level
answer
Determines who has access to the different types of information
question
Access Control
answer
Determines types of user access such as read - only access
question
Data-Driven Websites
answer
An interactive website kept constantly updated and relevant to the needs of its customers using a database.
question
Business critical integrity constraint
answer
rule enforce business rules vital to organization success and require more insight and knowledge
question
Information Cleansing
answer
a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
question
Data Warehouse
answer
a logical collection of information- gathered from many different operational databases that supports business analytics activities and decision making tasks ( composed of multiple databases)
question
Data Mining
answer
process of analyzing data to extract information not offered by the raw data alone
question
Classification
answer
assigns records to one of the predefined set of classes
question
Estimation
answer
determines the value for an unknown continuos variable behavior or estimated future value.
question
Affinity grouping
answer
determines which things go together
question
Clustering
answer
Segments a heterogenous population of records into a number of more homogenous subgroups.
