class 7(chap6). Data Business Intelligence

Question 1

3 levels of data

Answer 1

individual / department / enterprise

Question 2

4 formats of data

Answer 2

document / presentation / spreadsheet / database

Question 3

3 granularities of data

Answer 3

detail(fine)
summary
aggregate

Question 4

A type of data that encompasses all of the data contained within a single business process or unit of work
what is this and what is this primary purpose?

Answer 4

Transactional data
- operational tasks

Question 5

encompasses all organizational data
primary purpose is to support the performing of managerial analysis tasks

Answer 5

analytical data

Question 6

explain data integrity issues

Answer 6

issue which occurs when a system produces incorrect, inconsistent, or duplicate data

Question 7

the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, and suppliers that are commonly integrated across organizational systems

Answer 7

Master Data Management MDM

Question 8

what is data validation?

Answer 8

testing or evaluating data if it is compliance with data governance polices to ensure correctness of data

Question 9

what maintains data about various types of objects, events, people, and places

Answer 9

database

Question 10

a system that allows users to create, read, update, and delete data in a relational database

Answer 10

database management system DBMS

Question 11

smallest/basic unit of data

Answer 11

data element

Question 12

logical data structures that detail the relationships among data elements using graphics/pictures

Answer 12

data model

Question 13

details about data

Answer 13

metadata

Question 14

complies all of the metadata about the data elements in the data model

Answer 14

data dictionary

Question 15

the row of the data table

Answer 15

entity

Question 16

the column, field of the data table

Answer 16

attribute

Question 17

a collection of related data elements

Answer 17

record

Question 18

a field that uniquely identifies a given entity in a table

Answer 18

primary key

Question 19

a primary key of one table that appears in another table and provide a logical relationship among the two tables

Answer 19

foreign key

Question 20

limitations of Excel as a database

Answer 20

1. only one user can access at a time
2. rows & columns are limited
3. column width is limited to 255 characters
4. sheets in a workbook is limited by the available memory
5. cannot handle multiple data types easily ex, pictures

Question 21

how well a system can adapt to increased demands

Answer 21

scalability

Question 22

how quickly a system performs a certain process/transaction

Answer 22

performance

Question 23

what is data redundancy?

Answer 23

the duplication of data/storing the same data in multiple places

Question 24

what it the problem of data redundancy?

Answer 24

inconsistency

Question 25

what is data integrity?

Answer 25

it is what measures the quality of data

Question 26

what is Business Intelligence?

Answer 26

data that is organized and connected for easier analysis to find
: new opportunities
: ID strengths/weakness
: inefficient business processes and hidden patterns

Question 27

where does the ‘extend of data transformation into information’ happen?

Answer 27

data warehouse

Question 28

the function of the data warehouse

Answer 28

provide overall business function
(support decision making without disrupting the day-to-day operations)

Question 29

real-life examples of business intelligence

Answer 29

1. hotels: pricing when high demand
2. grocery store - real-time

Question 30

purpose of data warehouse

Answer 30

to aggregate data for decision-making

Question 31

collection of data from various sources for the purpose of data processing

Answer 31

data aggregation

Question 32

what is ETL that is used in data warehousing

Answer 32

extracting external data
transformation of it to the enterprise definition
loading it to the data warehouse

Question 33

what is the common term for the representation of multidimensional data

Answer 33

data cube

Question 34

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

Answer 34

business intelligence dashboards

Question 35

what is ‘distributed computing’?

Answer 35

processes and manages algorithms across many machines in a computing environment

Question 36

records classified and summarized transactional data

Answer 36

ledger

Question 37

a type of distributed ledger, consisting of blocks of data that maintain a permanent and tamper-proof record of transactional data

Answer 37

blockchain

Question 38

what is ‘proof-of-work’ used in blockchain

Answer 38

it is an essential process performed to create a new group of blocks on the distributed ledger/blockchain

the consensus mechanism

Question 39

two primary goals of ‘proof-of-work’

Answer 39

1. verify the legitimacy of a transaction / avoid double-spending
2. create new digital currencies by rewarding miners for performing the previous task

Question 40

the first block created in the blockchain

Answer 40

genesis block

Question 41

the block’s unique identifier like a fingerprint

any change changes this

Answer 41

hash