Question

In: Math

Can someone please explain these steps from this data description All of Bubba Gump’s data has...

Can someone please explain these steps from this data description

All of Bubba Gump’s data has recently been integrated in a data warehouse. That enterprise data warehouse was built specifically to support data mining initiatives like the one you have been assigned to conduct, by consolidating data from multiple operations and channels in one place and integrating the data across sources for a complete view of the customer experience. For the first time, Bubba Gump analysts can link sales transactions to specific customers at specific restaurants, for example. It also means that you can link customer transactions across channels; that is, for any given customer, you can link to both their restaurant purchases, their online purchases, and (in some cases) their purchases from third-party retail partners.

You have been selected to develop and execute the data mining analysis plan for Bubba Gump’s customer analysis project. Your project will be the first major data mining project conducted against the new Bubba Gump data warehouse. Because Bubba Gump’s data was not previously integrated in a single data warehouse, company leadership has never been able to analyze its customers across their complete experience. In other words, customer restaurant purchases, online purchases, and third-party retailer purchases could not be analyzed together previously; each channel had to be analyzed separately.

As a first step, a sample of 500 customers has been selected from the analytics data warehouse and given a survey in exchange for purchase credits at one of Bubba Gump’s sales channels. The survey sample was selected from the universe of customers who have made purchases from at least one Bubba Gump outlet (restaurant, web store, etc.). Responses to various customer satisfaction questions were recorded, and historical purchase information has been extracted from the data warehouse for each customer in the sample.

To answer these questions I am having trouble to know what these questions wants if it is ok can someone please explain this to me thank you.

Your task is to analyze the survey responses to understand whether there are natural “clusters” within Bubba Gump’s customer population. You are then to
create a visualization of this survey data that describes Bubba Gump’s customers across any dimensions that define those subgroups.
Your Assignment
In your response, address the following critical elements:
Analysis Tools
What data mining tools will you use to perform the analysis?

Why these particular ones?


Data Visualizations
What data visualizations will you use in your report, and why?


Research Question
What is the specific research question that needs to be addressed?

What research question will you work from in order to analyze the given data for meaningful
patterns?
Research Measurement
How will you determine if your research question was answered or if your hypothesis-generation was successful?

How will you measure progress?

Follow-Up Questions
What are cogent follow-up questions or explorations that should follow from your initial research?
Research and Support
Are there any published sources or other resources that address your line of inquiry? Where do they fall short? How will they help guide your analysis?

Solutions

Expert Solution

ANSWER:

In previous phase Bubba Gump Shrimp be doing the analysis unconnectedly for all its commerce lines i.e. offline restaurants, online services and third party retailers. So, the customers were not interlinked with every additional in all 3 categories. It may be probable that the “same customers” availed the check from all 3 channels but Bubba Gump would never know this insight about its customers because the channels were not organized according to their previous methodology.

So, they misused their style by keeping all the data in a data-warehouse.

Current Phase of Analysis:

At the present, next onto the current phase, we have statistics from all 3 major categories store in a well arrange scheme or we can state the data is now in regular form where the profit of such form is that:

1. We can simply map individuals ‘same customers’ who are availing our defense force from different channels. For example: Suppose there is a customer named “xyz” and he/she availed services from all 3 sectors i.e. one business from each ‘offline restaurants’, ‘online services’ and ‘third party retailers’, now depending on consumers details in each category we can map his/her all the transactions under his/her unique ‘CustomerID’ using the power of data warehousing, so instead of having 3 different transactions in which we didn’t knew that whether these 3 dealings belong to the same customer or not which was the case in previous style. So, once we do this type of map we will get to know about our customers and can prioritize our customer base consequently.

2. since the sales of Bubba Gump have decline in last 2 years, to examine the sales data and to figure out the potential explanation we can opt for a data mining system called Time Series Analysis, as the name suggest examine the data with deference to time. Because there was a decline in sales for last 2 years, we can look out at the factor due to which this declination is happen. A person can look at the present trend, or can look at cyclic disturbance in the data i.e. something like a produce which Bubba Gump is offering for last 5 years but had gone out of tendency for last 2 years so there is no logic in continuing with that result as it is out of trend instead of that they can look for a product related to their product by doing a promote research and the one which is in fashion.

3. Talking about the ‘data mining technique’ that can be used to separate out the customer base into “High Priority”, “Medium Priority” and “Low Priority” customers is usually known as   
RFM-Analysis, it stands for Recency Frequency Monetary-Analysis.

(i) RFM (Recency, Frequency and Monetary): model is widely applied in many practical areas, mostly in direct market. By adopt RFM model, decision makers can efficiently identify priceless consumers and then develop effectual marketing strategy.

(ii) Integration of RFM analysis and data mining technique provide helpful in order for present and new customers. cluster based on RFM attribute provides more behavioral knowledge of customers’ actual selling levels than other cluster analyses. Classification rules discovered from customer demographic variables and RFM variables provides useful information for managers to predict future customer behavior such as how recently the customer will probably purchase, how often the purchaser will purchase, and what will the value of his/her purchase.

4. Using a sample of their 500 customers that they collected from different sources, they can run above RFM analysis to form out their high priority and low precedence customers and finally take actions on them for that reason by giving some discount coupon and all to maintain a good bond with the customers.


Related Solutions

Hi all, Can someone please answer this question. Please, list all steps! thanks! Machines A and...
Hi all, Can someone please answer this question. Please, list all steps! thanks! Machines A and B are mutually exclusive and are expected to produce the following real cash flows:       Cash Flows ($ thousands) Machine C0 C1 C2 C3 A –102 +112 +123 B –122 +112 +123 +135       The real opportunity cost of capital is 12%.    a. Calculate the NPV of each machine. (Do not round intermediate calculations. Enter your answers in dollars not in thousands, e.g....
Hi all, Can someone please answer this question with all steps! Thank you! As a result...
Hi all, Can someone please answer this question with all steps! Thank you! As a result of improvements in product engineering, United Automation is able to sell one of its two milling machines. Both machines perform the same function but differ in age. The newer machine could be sold today for $69,500. Its operating costs are $22,600 a year, but in five years the machine will require a $18,700 overhaul. Thereafter operating costs will be $31,300 until the machine is...
Hi all, Can someone please answer this question. Please list all steps! Thanks! Consider the following...
Hi all, Can someone please answer this question. Please list all steps! Thanks! Consider the following projects: Cash Flows ($) Project C0 C1 D –10,300 20,600 E –20,300 35,525 Assume that the projects are mutually exclusive and that the opportunity cost of capital is 9%. a. Calculate the profitability index for each project. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project Profitability Index D E b-1. Calculate the profitability-index using the incremental cash flows. (Do...
Can someone please explain to me the steps in journalizing events in accounting and then turning...
Can someone please explain to me the steps in journalizing events in accounting and then turning them into income statements. Like which assets and liabilities are credits and which are debits?
Hi all, Can someone please answer this question. Please, list all steps. Thanks! Mr. Art Deco...
Hi all, Can someone please answer this question. Please, list all steps. Thanks! Mr. Art Deco will be paid $150,000 one year hence. This is a nominal flow, which he discounts at a nominal discount rate of 8%. PV = $150,000 / (1 + .08) = $138,889 The inflation rate is 5%.    Calculate the PV of Mr. Deco’s payment using the equivalent real cash flow and real discount rate. (You should get exactly the same answer as he did.)...
Can someone please explain how to do the steps for this? I already have part a...
Can someone please explain how to do the steps for this? I already have part a completed but I need help with b-e. Thank you. Problem 1: (a) What is spurious regression? Explain. (b) Assuming , randomly generate 1000 observations of variables X and Y using the following equations: Report the graphs of X and Y. (c) Run the regression: and report the estimated results. (d) What did you expect about the magnitudes and R-square? How are the estimated values...
Hi all, Can someone please answer this question. Please list steps! Thanks! You have the chance...
Hi all, Can someone please answer this question. Please list steps! Thanks! You have the chance to participate in a project that produces the following cash flows: Cash Flows ($) C0 C1 C2 3,900 5,100 –10,900 a. The internal rate of return is 14.13%. If the opportunity cost of capital is 14%, what is the NPV of the project? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to 2 decimal...
Hi all, Can someone please answer this question. Please list steps! Thanks! Consider the following cash...
Hi all, Can someone please answer this question. Please list steps! Thanks! Consider the following cash flows: Cash Flows ($) C0 C1 C2 −8,450 6,200 21,400 a. Calculate the net present value of the above project for discount rates of 0, 50, and 100%. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) NPV @ 0% $ NPV @ 50% $ NPV @100% $ b. What is the IRR of the project? (Do not round...
Can someone please explain the big O [ Data Structures ]. Also, is there a shortcut...
Can someone please explain the big O [ Data Structures ]. Also, is there a shortcut (a hint) on how I can know which one is it? Like O(1), O(n)... Thank you!
Can someone please explain rotational motion?
Can someone please explain rotational motion?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT