Management
Chrisyanqu
MIS302-HWK3.docx
Management Information Systems
1. RFM Analysis:
a) Download the RFM Data on Cougar Course. It has data of 40 transaction record done by 10 different customers. Try to compile the data and complete the following RFM Report Table.
|
|
R |
F |
M |
|
Andrew |
|
|
|
|
David |
|
|
|
|
Dennis |
|
|
|
|
Eric |
|
|
|
|
Janet |
|
|
|
|
Katheleen |
|
|
|
|
Kathy |
|
|
|
|
Marcia |
|
|
|
|
Mary |
|
|
|
|
Moses |
|
|
|
b) Pick any two customers and explain how the two were doing and any efforts should be made to improve the situation.
2. Pivot Table:
Now, think: the data shown was sum of the rating, does that make sense? Which other function should make sense? Create a pivot table showing Vendor ratings by year so management could review, which vendor got a higher rating in 2018 than 2017, and which ones rating dropped? Paste your pivot table below.
<paste your pivot table here>
3. (Optional but Strongly Recommended!!)Data Visualization in Tableau:
Download and install Tableau Desktop on your computer. Follow the instruction in “Tableau Coffee Chain Data Case Study.pdf” and paste your results below.
<Paste the png file your created in step 1 here>
<Paste the png file your created in step 2 here>
<Paste the png file your created in step 3 here>
<Paste the png file your created in step 4 here>
<Paste the png file your created in step 5 here>
8
