Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Tableau global superstore returns

22/04/2021 Client: muhammad11 Deadline: 2 Day

MKT 356 Take Home Midterm Exam Spring 2018 Instructions: 1. Open notes/book, but independent work is required. You may work with other students on this exam. However, each individual must turn in their own exam. Plagiarism will result in a mark of zero for the exam, and will be reported to the department. 2. Please support your claims with proper charts or exhibits – remember you are talking to a business audience. If you show a chart that is with too much information or not readable, no marks can be given. One or two charts are expected for each question, except for Part B q1 and q2 (For these two questions, you may just say “Done. See sheet2 in the file xxx.xlsx.”). 3. An appendix of how you construct each exhibit is required. An example of such appendix is on Canvas. Please put the appendix at the end of your word document. 4. Your work is due 5pm 3/20/2018 on Canvas. Please submit a word document (put the Appendix mentioned above at the end of the document – don’t put them in the text), and other supporting twb files and/or excel files. Please save your Tableau charts as images and paste them in the proper places in your word file. I will be grading your word file ONLY. 5. No re-do is allowed for the Midterm Exam. Using the global_superstore.xls data (the “Orders” sheet, unless instructed otherwise), answer the following questions. Part A [50 marks]: Compare profitability for the Africa, LATAM, and the US market. 1. Describe what this dataset is all about. (It is about How many consumers’ purchasing records, where, when, and in what product categories?) (5 marks) 2. Comment on the overall profit of these markets. Together with their sales, what would you say? (5 marks) 3. Now add product category information to the picture. Comment on profitability again. (5 marks) 4. Take the US market as an example, see whether your comments in question 3 would apply on a year to year basis or not. What do you say now? (5 marks) 5. Bring variable “Discount” to the picture. Do you see discount done differently in these markets, in each category? (5 marks) 6. Bring variable “Shipping Cost” to the picture. Please comment on how shipping cost may affect profitability in each category. (5 marks) 7. Now Open the data in Excel. In the “Orders” sheet, create a new column, and call it Returned. Use the vlookup function, and the OrderID as identifier, to bring in information for “whether the order is returned or not” from the “Returns” sheet. Then create a blank Tableau workbook and connect the data again. Compare two economic aspects of the returned orders to those that are not returned. Comment on the results. [Hint: you may consult hw3.] (15 marks) 8. Based on what you have observed so far, can you make some conjectures and recommendations for each market, in terms of how we may improve its profitability? Please support your claims with facts that you commented on previously. (5 marks) Part B [40 marks]: RFM is commonly used in marketing, retail and professional services industries to assess customer value. The general idea behind the analysis can be summarized as: Recency: People who have purchased recently from you are much more likely to respond to a new offer than someone who you haven’t sold to in a long time. Frequency: People who shop frequently at your store are more likely to respond to new offers than less frequent buyers. Monetary: People who spend more money at your store are more likely to show interest in new offers. They are defined as: Recency: How long ago did the customer make a purchase (usually measured by days)? Frequency: How many purchases has the customer made (during the last year or other time period)? Monetary Value: How much has the customer spent in total (in given time period)? 1. Please set 2014 data aside, and use 2011-2013 data (the end of year 2013 as cutoff point for recency), and compute the RFM for each customer. Your resulting database is one with 795 customers and four variables: Customer Name, Recency, Frequency, and Monetary. (5 marks) 2. For each of the R, F and M variable, create a code for each customer by first sorting the variable, and then assigning group membership 3 (the most recent/most frequent/spent the most), 2, or 1 to each customer. The three groups are equal size (in this case, 1/3, 1/3, and 1/3). Now your RFM database has 6 variables (with customer names, it would be 7 columns). And you can bring total profit for each customer in (the 8th column) to add additional information for the analysis below. (5 marks) 3. For each of the R, F and M variable, analyze profit by groups. Did you see a descending order of profit for group 3, 2 and 1 in year 2011-2013? (15 marks) 4. Repeat what you did in question 3 using profit of 2014. Now, out of the R, F and M variable, which one do you think have the most importance in predicting outof-sample profitability? (5 marks) 5. Use the concatenate function in Excel or in Tableau to create a three digit code: The first digit for R, The second digit for F, The last digit for M Every customer is either a 333, 332, 331, …, down to 111---altogether 27 RFM cells.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Class Engineers
Financial Solutions Provider
Quick Mentor
Helping Hand
Smart Accountants
Unique Academic Solutions
Writer Writer Name Offer Chat
Top Class Engineers

ONLINE

Top Class Engineers

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$15 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

Give me a chance, i will do this with my best efforts

$15 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$49 Chat With Writer
Helping Hand

ONLINE

Helping Hand

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$19 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$33 Chat With Writer
Unique Academic Solutions

ONLINE

Unique Academic Solutions

Give me a chance, i will do this with my best efforts

$19 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Chuck e cheese segment - How markets allocate resources - American History Paper - Cism job practice areas - T2 t1 p2 p1 r cp - Tate and lyle maple syrup morrisons - Medical surgical case studies, nursing diagnoses and interventions - Bank account double entry - Juan hola linda qué tal las clases - Essay about using phones in school - Ready player one theme essay - Assignment - Contractible auxiliary examples - The owl poem by ruskin bond lyrics - Impediments to problem solving - Cnn student news host - Consumer meaning food chain - The 8th habit website - WEEK 6 DISCUSSION 2071 MICRBIOLOGY LAB - Whipps cross gynaecology department - Early years planning cycle resource - Paper2go com case 5.2 - Knee voltage of led - Push and pull supply chain - 5e lesson plan lab safety - Enos printing corp uses a job order cost system - Hei spark tester napa - Scaruffi boards of canada - Percent relative average deviation - Factor tree of 60 - How vitamins and minerals/trace elements affect health/human body ? - The hierarchical data model was developed in the _____. - Mayeroff caring ingredients - Conformational analysis of cyclohexane ppt - Case synopsis----quick finish in 4 hours - Two different stock exchanges in the united states - Based on your experiences, as well as the chapter information, what are some good “rules of thumb” for conducting successful performance appraisal interviews? - Class3d1 - My antonia answer key - Essays - The basic measure of mass in the metric system - Week 6 capstone project care plane part 2 - Duct mounted hepa filter - Pressure Ulcer Case Study - How to cite aca code of ethics 2014 - HSCI 430 - The merry family jan havicksz steen - Effective strategies for teaching science vocabulary - Health talk in community health nursing - Education and Income Inequality Microeconomics - How to write a proposal and annotated bibliography - Fundamentals of internet networking concepts - Comparative text response structure - Medical referral letter template - Two fold serial dilution - Prestige auto parts taren point - Delrin 500p material properties - Berkhamsted recycling centre opening hours - Module 11 Assignment - Easy Computer Paper - Equilibrium of a rigid body lab answers - A pressure cooker has the lid screwed on tight - Rwandan genocide and collective memory - Primate societies are complexly organized this means - Creative senior project ideas - Sears appliance repair 93 w campbell rd rotterdam - Nursing interventions for kawasaki disease - English is a crazy language richard lederer summary - Audiofile engineering sample manager - Neal st medical centre gisborne - Carroll's three stratum theory of intelligence - NURS-6050N-66/NURS-6050C-66-Policy & Advocacy - Discussion Board 5.2: Nothing About Us Without Us - Https fakenumber org generator mobile - Week 7 - Current industrial award for teacher aides queensland - Green words magic 100 - Limitations of mckinsey 7s model - Grow fast or die slow - Another word for firstly secondly thirdly - Five oaks kennels capenhurst - Performance Management - Urolift cpt - Please explain to the class what "A polynomial of odd degree with real coefficients has at least one real zero" means. - Minimum cash balance in cash budget - Final Draft Essay - Emai lab submission form - Five food groups worksheet - Iep goal bank pdf - Discussion responses - Ib english paper 1 exemplar - Istr credits hack crack tool zip - Api 20e quick index booklet - Upside of irrationality pdf - Political lens of the us constitution - Below are departmental income statements for a guitar manufacturer - The lowest animal story - Iddp structured thinking process - Different between permutation and combination - Project management 8.21 answers