Exam Slides 1-33

Question 1

business analytics is the use of…(5)

Answer 1

data
info tech
stat analysis
quantitative methods
math/computer-based models

Question 2

business intelligence

Answer 2

tech-driven process; analysis + presenting actionable info to help managers (etc) make informed decisions

descriptive analysis + diagnostic analysis

Question 3

descriptive analysis answers…

Answer 3

what happened?

Question 4

diagnostic analysis answers…

Answer 4

why did it happen?

Question 5

categorical

Answer 5

no inherent order
ex. brown, black

Question 6

ordinal

Answer 6

clear ranking
ex. pant size 0, 2, 4

Question 7

ratio

Answer 7

true zero point with meaningful ratios
ex. weight, height

Question 8

interval

Answer 8

equal intervals but no true zero point
ex. temperature

Question 9

reliability

Answer 9

data is accurate + consistent

Question 10

validity

Answer 10

data correctly measures what it is supposed to measure

Question 11

ex. a tire pressure gage that consistently reads several pounds below the true level (reliable? valid?)

Answer 11

not reliable, but valid

Question 12

ex. # of calls to a customer service desk might be counted correctly each day, but may be used to assess customer dissatisfaction (reliable? valid?)

Answer 12

reliable, but not valid

Question 13

ex. a survey question that asks a customer to rate the quality of the food in a restaurant as a measure of satisfaction (reliable? valid?)

Answer 13

neither reliable nor valid – diff customers will have diff exp; if intent is to measure satisfaction, that will include more than quality of food

Question 14

problem solving process w/ data mining (4)

Answer 14

1. use large amounts of data
2. examine large-scale datasets to find links b/w variables
3. using already collected data/analyses to see if links can be found
4. allows formation of hypotheses

Question 15

architecture of an ERP system (draw it)

Answer 15

refer to slide 12

Question 16

an ERP is designed to process ________ ___________ __ ____ ____, working from a _____ database

Answer 16

business transactions in real time,
single

Question 17

____ _______ ________ may be added to facilitate queries, but not originally built into an ERP system

Answer 17

data warehouse software

Question 18

(T/F) without standard terminology, integration is impossible, ex. what is a product? a unit of measure?

Answer 18

true

Question 19

an ERP requires… (4)

Answer 19

• capacity for transaction processing
• consistent # across all applications
• software that is multifunctional, integrated, and modular
• routine decision making

Question 20

what it means to sell to a company with an ERP system: what is the process, the action, and the modules updated:

become a vendor
financial and purchasing module
get added to approved vendor list

Answer 20

become a vendor –> process
get added to list –> ERP action
financial/purch module updated –> modules updated

Question 21

database developers/programmers

Answer 21

create the databases/tables
usually from a separate software company, ex. SAP

Question 22

database administrator, DBA

Answer 22

installs software on a database, maintains database, gives security access

Question 23

analyst, MIS or Supply Chain

Answer 23

designs and executes ‘Select’ queries to database but does NOT change information in any way

Question 24

5-6 command SQL queries
Select
Count
Where
Like
And/Or

Answer 24

• get data out of table
• make sure you’re not selecting a million rows to slow down the system
• filter the results
• get a partial response
• combine multiple filters

Question 25

5 common SQL queries
Between
<>
Order by
Select, followed by column name
Round

Answer 25

• for data ranges, ex. month, quarter
• select a value NOT equal to
• sort the results a certain way
• select only certain columns
• calculate a new field and round results

Question 26

3 common SQL queries

Inner Join
Left Outer Join

Answer 26

• simple connection of 2 tables, what they have in common
• returns everything (what two tables have in common and what they don’t) on the left, returning uncommon info as NULL
  ex. connecting customers and orders; if a customer has not ordered anything it will still be returned w/ NULL

Question 27

call references can be ________ or ________. using a dollar sign before a row/column creates an ________ reference.

Answer 27

relative; absolute
absolute

Question 28

using a $ before a ROW label keeps…
using a $ before a COLUMN label keeps…
using a $ before BOTH keeps…

Answer 28

• the reference fixed to the row, allows column reference to change if formula is copied to another cell
• reference fixed to the column, allows row reference to change
• reference to the exact cell no matter where formula is copied

Question 29

=COUNTA

Answer 29

counts # of nonblank cells

Question 30

=COUNTBLANK

Answer 30

counts blank cells

Question 31

=COUNTIFS

Answer 31

finds # of cells within multiple ranges that meet specific criteria for each range

Question 32

what is the difference between a NULL, a blank cell, and a 0 in excel?

Answer 32

null- excel doesn’t have NULL function, so a completely blank cell
blank- empty/blank
0- value of zero