MIS EXAM 2 CHAPTER #13 DATA
MINING QUESTIONS AND ANSWERS
Which databases are not used, used, and shared to a web service? - Answer-
Legacy = source = not used
Transactional and operational = used
Application = where you're sharing data to a web service
Market-basket analysis - Answer-how many times certain products are bough
together (i.e. a shopping cart, or a netflix queue)
RFM Analysis - Answer-Recency (how recently a customer ordered
1= most recent purchase (top 20%)
5= least recent purchase
+
Frequency (how frequently a customer orders)
1 = most frequent (top 20%)
5 = least frequent
+
Money (how much a customer spends per order)
1 = biggest spenders (top 20%)
5 = smallest spenders
Know the issues that need to be addressed in order to design, develop, deploy, and
maintain data warehouses and data marts - Answer-Data relevance
Data sourcing
Data quantity
Data hosting
Data governance
Understand how Walmart has leveraged information technology to become the
world's largest retailer - Answer-Data-driven value chain: automatic inventory
reordering, scheduling and delivery which keeps shelves stocked and inventories at
a minimum.
Data mining prowess: mines its mother lode of data to get the right product mix
under different environmental conditions, also predicts operational forecasts.
Data sharing: shares data with suppliers so they too can become more efficient,
decreasing prices even more.
Uses loss leaders -- sale on cold medicine
Uses cross-selling and upselling -- sale on cold medicine will generate sales in
tissues, aspirin, chicken soup, etc
Responds great to disaster -- i.e. Hurricane Katrina - allow autonomy for store
managers
MINING QUESTIONS AND ANSWERS
Which databases are not used, used, and shared to a web service? - Answer-
Legacy = source = not used
Transactional and operational = used
Application = where you're sharing data to a web service
Market-basket analysis - Answer-how many times certain products are bough
together (i.e. a shopping cart, or a netflix queue)
RFM Analysis - Answer-Recency (how recently a customer ordered
1= most recent purchase (top 20%)
5= least recent purchase
+
Frequency (how frequently a customer orders)
1 = most frequent (top 20%)
5 = least frequent
+
Money (how much a customer spends per order)
1 = biggest spenders (top 20%)
5 = smallest spenders
Know the issues that need to be addressed in order to design, develop, deploy, and
maintain data warehouses and data marts - Answer-Data relevance
Data sourcing
Data quantity
Data hosting
Data governance
Understand how Walmart has leveraged information technology to become the
world's largest retailer - Answer-Data-driven value chain: automatic inventory
reordering, scheduling and delivery which keeps shelves stocked and inventories at
a minimum.
Data mining prowess: mines its mother lode of data to get the right product mix
under different environmental conditions, also predicts operational forecasts.
Data sharing: shares data with suppliers so they too can become more efficient,
decreasing prices even more.
Uses loss leaders -- sale on cold medicine
Uses cross-selling and upselling -- sale on cold medicine will generate sales in
tissues, aspirin, chicken soup, etc
Responds great to disaster -- i.e. Hurricane Katrina - allow autonomy for store
managers
