Suppose, as manager of a chain of stores, you would like to use sales transactional data to analyze the effectiveness of your store's advertisements: In particular, you would like to study how specific factors influence the effectiveness of advertisements that announce a particular category of items on sale. The factors to study are: the region in which customers live, and the day-of-the-week, and time-of-the-day of the ads. Discuss how to design an efficient method to mine the transaction data sets and explain how multidimensional and multilevel mining methods can help you derive a good solution.

Suppose, as manager of a chain of stores, you would like to use sales transactional data to analyze the effectiveness of your store's advertisements: In particular, you would like to study how specific factors influence the effectiveness of advertisements that announce a particular category of items on sale. The factors to study are: the region in which customers live, and the day-of-the-week, and time-of-the-day of the ads. Discuss how to design an efficient method to mine the transaction data sets and explain how multidimensional and multilevel mining methods can help you derive a good solution.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 4.1CTQ

See similar textbooks

Similar questions

A manager of a chain of 20 Sports Bars would like to be able to predict daily revenue for each restaurant based on several factors. Recognizing that each sports bar is different, the manager assigns each an id number from 1 to 20 . What is the problem with including that id number as an attribute in a model to predict daily revenue?
Do you run your own business or have access to business data? If yes let’s brainstorm about data you would want to collect. Store daily sales in a table like below. Observation Date Sales In Dollars 1 6/30/2021 2512.30 2 7/1/2021 2945.12 Etc. This works if you are selling a single product, or if you want to aggregate all products into one. Aggregation is useful in analysis, but personally I believe it is better to gather data at its lowest form and then aggregate. Suppose you are doing analysis for a simple bakery. By simple I mean a small menu of items, see the table below. Product Acronym Large Loaf (Swiss bread 2 lb. loaf) LL Small Loaf (Swiss bread 1 lb. loaf) SL Banana Bread BB Banana Nut Bread BNB Oatmeal raisin Cookies (1 dozen) OR Chocolate Chip Cookies (1 dozen) CCC Cinnamon Roll (each) CR Relevant information, to start, would include. Product sold (prod), price of the product (p), quantity…
Suppose I had a data set with twenty-dimensional data, each dimension of which was uniformly and independently randomly distributed. Would running Principal Component Analysis (PCA) help reduce the dimensions of this data set? Why or why not?
Consider the following scenario: you are the database administrator for the iTunes store. When it comes to predicting which musicians and movies will sell the most tickets next year, what methods do you recommend using predictive analysis?
Question # 3. Association learning CLO-3,4, PLO-1,2,3, C-1,2,3 14 How many number of rules can be made from the dataset which is given in Table 3? Identify those item sets from which rules can be made. Also define the criteria of selection Calculate the Support value of {Ketchup and Soda} and find the confidence value of all rules which can be possible by this item set. Table 3. Transaction ID Items 1 Ketchup, Hamburgers, Soda 2 Cereal, Milk, Diapers, Bread 3 Hot dogs, ketchup, Soda, Milk 4 Greeting card, Cake, Soda 5 Greeting Card, Cake, Milk, Cereal
A clustered bar chart to examine the method of payment by customer type A chart to examine whether the relationship between net sales and age depends on the marital status of the customer Customer Type of Customer Items Net Sales Method of Payment Gender Marital Status Age 1 Regular 1 39.50 Discover Male Married 32 2 Promotional 1 102.40 Proprietary Card Female Married 36 3 Regular 1 22.50 Proprietary Card Female Married 32 4 Promotional 5 100.40 Proprietary Card Female Married 28 5 Regular 2 54.00 MasterCard Female Married 34 6 Regular 1 44.50 MasterCard Female Married 44 7 Promotional 2 78.00 Proprietary Card Female Married 30 8 Regular 1 22.50 Visa Female Married 40 9 Promotional 2 56.52 Proprietary Card Female Married 46 10 Regular 1 44.50 Proprietary Card Female Married 36 11 Regular 1 29.50 Proprietary Card Female Married 48 12 Promotional 1 31.60 Proprietary Card Female Married 40 13 Promotional 9 160.40 Visa Female Married 40 14 Promotional 2…
A car dealership sells both new and used cars and provides two types of maintenance: repair and service to customers. It wants to track its customers, their cars, and type of maintenance performed on each car. Given that a customer can purchase multiple new and used cars from this dealership and seek both types of maintenance, how will you illustrate this scenario using an ERD and EER combination? Include additional attributes and subtype discriminators as needed. Any many-to-many relationships identified during the construction of the ERD/EER should be split into pairs of 1:M relationships with primary and foreign keys clearly defined. MS Visio should be used to complete this assignment. Upload a pdf version of the file in Canvas. Attributes of Customer include Customer ID, Name, Address (Street, City, State, Zip), and Phone. Attributes of New car include VIN, make, model, year, color, MSRP, and asking price. Attributes of Used car include VIN, make, model, year, color, asking price,…
For instance, if you are starting a media firm and want to hire graphic designers and media producers, you will have to go through the process of employee recruitment. Make a list of the equipment that will be provided to the personnel in each department, and provide a justification for why they need it. In what ways do they ensure the safety of their data while it is being backed up?
Use the Excel template VLC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $200 per visit, the frequency of repurchase is 7 times per year, the contribution margin is 23 percent, and the average customer defection rate is 19 percent?
Read the case study given below and answer ALL the questions given at theend of the case.Big Data Trends In HealthcareSince people are becoming more and more conscious about their health andwell-being, they are investing more in better tools and applications to monitortheir health and are making regular trips to the doctor for check-ups of followups. Because of this, as well as the many, many cases of illnesses and injuries,there is a constant flow of information when it comes to the healthcare industry.Since this data pertains to people’s lives, it is highly sensitive and must behandled with care.By carefully recording, storing, reading, and analyzing medical data, there havebeen many positive developments in the industry. They will continue to happenif everything is managed well. There is a need to focus heavily on factual dataor evidence to ensure that the patients are being looked after well, receive theright diagnosis and treatment, and that there are no unnecessary expenses.Some…
Read the case study given below and answer ALL the questions given at theend of the case.Big Data Trends In HealthcareSince people are becoming more and more conscious about their health andwell-being, they are investing more in better tools and applications to monitortheir health and are making regular trips to the doctor for check-ups of followups. Because of this, as well as the many, many cases of illnesses and injuries,there is a constant flow of information when it comes to the healthcare industry.Since this data pertains to people’s lives, it is highly sensitive and must behandled with care.By carefully recording, storing, reading, and analyzing medical data, there havebeen many positive developments in the industry. They will continue to happenif everything is managed well. There is a need to focus heavily on factual dataor evidence to ensure that the patients are being looked after well, receive theright diagnosis and treatment, and that there are no unnecessary expenses.Some…
You are part of a data science team tasked with building a model to predict the probability that a customer who is emailed an online coupon will purchase the product. You will need to show the results to members of the sales team who have little knowledge of data mining vocabulary or techniques. Which technique would be most appropriate to communicate your results to the sales team? A) Linear model B) Support vector machine C) Logistic regression D) Tree induction