Exam Slides 1-33 Flashcards
business analytics is the use of…(5)
data
info tech
stat analysis
quantitative methods
math/computer-based models
business intelligence
tech-driven process; analysis + presenting actionable info to help managers (etc) make informed decisions
descriptive analysis + diagnostic analysis
descriptive analysis answers…
what happened?
diagnostic analysis answers…
why did it happen?
categorical
no inherent order
ex. brown, black
ordinal
clear ranking
ex. pant size 0, 2, 4
ratio
true zero point with meaningful ratios
ex. weight, height
interval
equal intervals but no true zero point
ex. temperature
reliability
data is accurate + consistent
validity
data correctly measures what it is supposed to measure
ex. a tire pressure gage that consistently reads several pounds below the true level (reliable? valid?)
not reliable, but valid
ex. # of calls to a customer service desk might be counted correctly each day, but may be used to assess customer dissatisfaction (reliable? valid?)
reliable, but not valid
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?)
neither reliable nor valid – diff customers will have diff exp; if intent is to measure satisfaction, that will include more than quality of food
problem solving process w/ data mining (4)
- use large amounts of data
- examine large-scale datasets to find links b/w variables
- using already collected data/analyses to see if links can be found
- allows formation of hypotheses
architecture of an ERP system (draw it)
refer to slide 12
an ERP is designed to process ________ ___________ __ ____ ____, working from a _____ database
business transactions in real time,
single
____ _______ ________ may be added to facilitate queries, but not originally built into an ERP system
data warehouse software
(T/F) without standard terminology, integration is impossible, ex. what is a product? a unit of measure?
true
an ERP requires… (4)
- capacity for transaction processing
- consistent # across all applications
- software that is multifunctional, integrated, and modular
- routine decision making
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
become a vendor –> process
get added to list –> ERP action
financial/purch module updated –> modules updated
database developers/programmers
create the databases/tables
usually from a separate software company, ex. SAP
database administrator, DBA
installs software on a database, maintains database, gives security access
analyst, MIS or Supply Chain
designs and executes ‘Select’ queries to database but does NOT change information in any way
5-6 command SQL queries
Select
Count
Where
Like
And/Or
- 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
5 common SQL queries
Between
<>
Order by
Select, followed by column name
Round
- 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
3 common SQL queries
Inner Join
Left Outer Join
- 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
call references can be ________ or ________. using a dollar sign before a row/column creates an ________ reference.
relative; absolute
absolute
using a $ before a ROW label keeps…
using a $ before a COLUMN label keeps…
using a $ before BOTH keeps…
- 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
=COUNTA
counts # of nonblank cells
=COUNTBLANK
counts blank cells
=COUNTIFS
finds # of cells within multiple ranges that meet specific criteria for each range
what is the difference between a NULL, a blank cell, and a 0 in excel?
null- excel doesn’t have NULL function, so a completely blank cell
blank- empty/blank
0- value of zero