A4SHS

.docx

School

Lamar University *

*We aren’t endorsed by this school

Course

5360

Subject

Marketing

Date

May 9, 2024

Type

docx

Pages

4

Uploaded by HighnessDoveMaster921 on coursehero.com

Using Tableau answer the following questions: 1. Which product type (Coffee/ Espresso/ Herbal Tea/ Tea) yields the maximum profit in each market size (major/small)? (2 points) Hint: drag and drop product type and market size from dimensions to columns and drag and drop profit from the fact table (measures) to rows. Go to Label > Show Mark Labels. Product Type Market Size Profit Coffee Major 53,001 Herbal Tea Small 34,418 2. Which product type (Coffee/ Espresso/ Herbal Tea/ Tea) yields maximum sales in each market (east/ west/south/central)? (4 points) Hint: product type in columns and market and sales in rows. Find out the maximum sales in each region. To clear rows and columns, drag and drop the fields to their original place. Product Type Market Sales Coffee East 56,641 Herbal Tea West 72,288 Espresso South 44,990 Coffee Central 69,080 1
3. Which product (Amaretto, Columbian, Cafe Latte, etc.) and product type (Coffee/ Espresso/ Herbal Tea/ Tea) give the maximum profit in which State (California, Florida, Texas, Connecticut, etc.)? (6 points) Hint : product and product type in columns and state and profit in rows. Find out the maximum profit by clicking on the tallest bar graph. Product Product Type State Profit Amaretto Coffee Colorado $3,410 Caffe Latte Espresso California $4,497 Caffe Mocha Espresso Illinois $6,575 Chamomile Herbal Tea Iowa $6,577 Columbian Coffee Massachusetts $12,489 Darjeering Tea Nevada $6,580 Decaf Espresso Espresso California $6,580 Decaf Irish Cream Coffee Illinois $3,463 Earl Grey Tea Iowa $5,624 Green Tea Tea Oregon $2,726 Lemon Herbal Tea New York $6,092 Mint Herbal Tea Nevada $3,457 Regular Espresso Espresso New York $7,589 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help