A4JJ

Tableau 1 Total Points: 15 Submit Pages 4 and 5 Filled in with Data and provide the supporting screenshots We will use the Tableau software to work on this assignment. Tableau is used to perform visual analysis for databases. We will connect to the database sample: Coffee Chain . The database has the following tables: Dimension Table: 1. Location 2. Dimension Table: Product 1

3. Fact Table The fact table fields are: 2

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 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 $199 Caffe Latte Espresso California $233 Caffe Mocha Espresso Illinois $362 Chamomile Herbal Tea Iowa $362 Columbian Coffee Massachusetts $778 Darjeering Tea Nevada $362 Decaf Espresso Espresso California $362 Decaf Irish Cream Coffee Illinois $207 Earl Grey Tea Iowa $331 Green Tea Tea Oregon $180 Lemon Herbal Tea New York $536 Mint Herbal Tea Nevada $207 Regular Espresso Espresso New York $646 4. Which product type (Coffee/ Espresso/ Herbal Tea/ Tea) in which market (east/ west/south/central) has the maximum inventory? (2 Points) 4

Hint: product type in columns and market and inventory in rows. Find out the maximum inventory. Product Type Market Inventory Herbal Tea East 5,121 Tea West 8,252 Coffee South 1,898 Herbal Tea Central 1,898 5. Type Decaf has maximum sales in which State? (1 points) Hint: Type and state in columns and sales in rows. Find out the maximum sales for decaf. Type State Sales Decaf New York $796 5