Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Tableau Assignment BUSI 650 – Business Analytics The provided dataset “Walmart Sales” contains the sales for different categories of products (i.e., Furniture, Office Supplies, and Technology) across...

1 answer below »



Tableau Assignment
BUSI 650 – Business Analytics
The provided dataset “Walmart Sales” contains the sales for different categories of products (i.e.,
Furniture, Office Supplies, and Technology) across with the profit, the quantity sold along with
the geographical location of the sales (Country, state, city, and postal code). Use the data provided
to create a profit dashboard using Tableau that contains the following:
a) A histogram of the profit, marginal profit, sales and discount per category and sub-
category.
) A weekday and monthly sales trends.
c) A geographical representation of the profit for the cities.
d) A geographical representation of the profit for the states.
e) A histogram for the quantity of the returned items, showing the return reasons.
f) An interactive profit dashboard (i.e., dynamic filtering applied)
g) A filter on the side for the following:
i. Order date (Yearly)
ii. City
iii. Product category
iv. Product sub-category
h) Create story telling about the business performance, highlighting the important things
obtained from the analysis.
i) Based on the previous analysis, which provinces are not generating revenue? What is the
easons behind this?
j) Based on the previous analysis, what are the reasons behind the losses in Roseville city
and how that can be mitigated? Support your answers with Tableau analytics.
k) Based on the previous analysis, how we can maximize the profit in San Antonio City?
Support your answers with Tableau analytics.
Submission Format: answers in PDF/ MS word file, and the original Tableau files.

Sheet1
    order_id    order_info_id    order_id_number    return_reason    order_date    order_weekday    order_month    ship_date    ship_mode    product_id    days_to_ship    category    sub_category    product_name    unit_cost    sales    sales_volume    profit    profit_margin    quantity    discount    discount_over_30    region_id    postal_code    city    state     sub_region    salesperson    customer_id    customer_name    segment    Country
    AE XXXXXXXXXX    AE-2019    1231682    Not Returned    12/18/19    Wednesday    December    12/23/19    Second Class    TEC-MOT XXXXXXXXXX    5    Technology    Phones    Motorola Headset, VoIP    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.33    0.34%    4    0.4    1    1488    47374    Richmond    Indiana    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    1263608    Not Returned    12/26/19    Thursday    December    12/31/19    Second Class    OFF-AVE XXXXXXXXXX    5    Office Supplies    Binders    Avery Binder Covers, Recycled    $ XXXXXXXXXX    $ 3.43    Low    $ 0.33    9.62%    1    0.4    1    1488    78745    Austin    Texas    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    303016    Not Returned    12/18/19    Wednesday    December    12/23/19    Second Class    TEC-MOT XXXXXXXXXX    5    Technology    Phones    Motorola Headset, VoIP    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.33    0.34%    4    0.4    1    1488    52402    Cedar Rapids    Iowa    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    304471    Not Returned    12/27/19    Friday    December    12/31/19    Second Class    TEC-MOT XXXXXXXXXX    4    Technology    Phones    Motorola Headset, VoIP    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.33    0.34%    4    0.4    1    1488    60653    Chicago    Illinois    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    3123605    Not Returned    11/30/19    Saturday    November    12/5/19    Second Class    OFF-ROG XXXXXXXXXX    5    Office Supplies    Storage    Rogers File Cart, Industrial    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.28    0.66%    1    0.35    1    1488    55901    Rochester    Minnesota    Central United States    Annelise Williams    PG-8820    Patrick Gardner    Consumer    United States
    AE XXXXXXXXXX    AE-2019    3179243    Not Returned    11/18/19    Monday    November    11/19/19    Second Class    TEC-MOT XXXXXXXXXX    1    Technology    Phones    Motorola Headset, VoIP    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.33    0.34%    4    0.4    1    1488    75220    Dallas    Texas    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    3323423    Not Returned    12/6/19    Friday    December    12/11/19    Second Class    OFF-ELD XXXXXXXXXX    5    Office Supplies    Storage    Eldon Lockers, Blue    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.28    0.47%    1    0.35    1    1488    78745    Austin    Texas    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    3371820    Not Returned    12/26/19    Thursday    December    12/31/19    Second Class    OFF-ELD XXXXXXXXXX    5    Office Supplies    Storage    Eldon Lockers, Blue    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.28    0.47%    1    0.35    1    1488    49505    Grand Rapids    Michigan    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    350473    Not Returned    3/25/19    Monday    March    3/29/19    Same Day    OFF-HON XXXXXXXXXX    4    Office Supplies    Labels    Hon Color Coded Labels, Adjustable    $ XXXXXXXXXX    $ 6.43    Low    $ 0.24    3.73%    2    0.3    0    1488    78577    Pha
    Texas    Central United States    Annelise Williams    JD-5790    John Dryer    Consumer    United States
    AE XXXXXXXXXX    AE-2019    4073208    Not Returned    1/13/19    Sunday    January    1/18/19    Second Class    OFF-TEN XXXXXXXXXX    5    Office Supplies    Storage    Tenex Folders, Blue    $ XXXXXXXXXX    $ 6.97    Low    $ 0.28    4.02%    1    0.35    1    1488    52402    Cedar Rapids    Iowa    Central United States    Annelise Williams    MY-7380    Maribeth Yedwab    Corporate    United States
    AE XXXXXXXXXX    AE-2019    4135578    Not Returned    3/22/19    Friday    March    3/23/19    Same Day    OFF-HON XXXXXXXXXX    1    Office Supplies    Labels    Hon Color Coded Labels, Adjustable    $ XXXXXXXXXX    $ 6.43    Low    $ 0.24    3.73%    2    0.3    0    1488    78745    Austin    Texas    Central United States    Annelise Williams    JD-5790    John Dryer    Consumer    United States
    AE XXXXXXXXXX    AE-2019    4220600    Not Returned    3/24/19    Sunday    March    3/26/19    Same Day    OFF-HON XXXXXXXXXX    2    Office Supplies    Labels    Hon Color Coded Labels, Adjustable    $ XXXXXXXXXX    $ 6.43    Low    $ 0.24    3.73%    2    0.3    0    1488    77095    Houston    Texas    Central United States    Annelise Williams    JD-5790    John Dryer    Consumer    United States
    AE XXXXXXXXXX    AE-2019    4244209    Not Returned    12/18/19    Wednesday    December    12/20/19    Second Class    OFF-ROG XXXXXXXXXX    2    Office Supplies    Storage    Rogers File Cart, Single Width    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.28    0.66%    1    0.35    1    1488    47201    Columbus    Indiana    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    447833    Not Returned    12/26/19    Thursday    December    12/26/19    Second Class    OFF-AVE XXXXXXXXXX    0    Office Supplies    Binders    Avery Binder Covers, Clear    $ XXXXXXXXXX    $ 3.16    Low    $ 0.33    10.44%    1    0.4    1    1488    75023    Plano    Texas    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    4984367    Not Returned    12/10/19    Tuesday    December    12/11/19    Second Class    OFF-ELD XXXXXXXXXX    1    Office Supplies    Storage    Eldon Lockers, Blue    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.28    0.47%    1    0.35    1    1488    48310    Sterling Heights    Michigan    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    5077525    Not Returned    12/6/19    Friday    December    12/8/19    Second Class    OFF-AVE XXXXXXXXXX    2    Office Supplies    Binders    Avery Binder Covers, Recycled    $ XXXXXXXXXX    $ 3.43    Low    $ 0.33    9.62%    1    0.4    1    1488    53209    Milwaukee    Wisconsin    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    5351828    Not Returned    11/19/19    Tuesday    November    11/21/19    Second Class    OFF-AVE XXXXXXXXXX    2    Office Supplies    Binders    Avery Binder Covers, Clear    $ XXXXXXXXXX    $ 3.16    Low    $ 0.33    10.44%    1    0.4    1    1488    52302    Marion    Iowa    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    5740368    Not Given    12/30/19    Monday    December    1/1/20    Standard Class    OFF-BIC XXXXXXXXXX    2    Office Supplies    Art    BIC Pencil Sharpener, Water Color    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.33    0.43%    8    0.4    1    1488    60174    Saint Charles    Illinois    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    5941050    Not Given    11/27/19    Wednesday    November    11/30/19    Second Class    OFF-ELD XXXXXXXXXX    3    Office Supplies    Storage    Eldon Lockers, Blue    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.28    0.47%    1    0.35    1    1488    62301    Quincy    Illinois    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AE XXXXXXXXXX    AE-2019    633725    Not Given    12/28/19    Saturday    December    1/2/20    Second Class    OFF-AVE XXXXXXXXXX    5    Office Supplies    Binders    Avery Binder Covers, Recycled    $ XXXXXXXXXX    $ 3.43    Low    $ 0.33    9.62%    1    0.4    1    1488    77803    Bryan    Texas    Central United States    Annelise Williams    GH-4665    Greg Hansen    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1011961    Not Given    11/30/19    Saturday    November    12/5/19    Standard Class    TEC-STA XXXXXXXXXX    5    Technology    Machines    StarTech Phone, Red    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.24    0.17%    2    0.3    0    1488    47905    Lafayette    Indiana    Central United States    Annelise Williams    DR-2940    Daniel Raglin    Home Office    United States
    AG XXXXXXXXXX    AG-2019    1031598    Not Given    5/4/19    Saturday    May    5/6/19    Second Class    TEC-CIS XXXXXXXXXX    2    Technology    Phones    Cisco Signal Booster, with Caller ID    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.07%    1    0.15    0    1488    60653    Chicago    Illinois    Central United States    Annelise Williams    CR-2820    Cyra Reiten    Home Office    United States
    AG XXXXXXXXXX    AG-2019    1110396    Not Given    1/3/19    Thursday    January    1/6/19    Same Day    OFF-STI XXXXXXXXXX    3    Office Supplies    Supplies    Stiletto Shears, High Speed    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.10%    1    0.1    0    1488    75220    Dallas    Texas    Central United States    Annelise Williams    IL-5100    Ivan Liston    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1153827    Not Given    2/3/19    Sunday    Fe
uary    2/4/19    Second Class    OFF-ROG XXXXXXXXXX    1    Office Supplies    Storage    Rogers Box, Wire Frame    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.05%    4    0.1    0    1488    48234    Detroit    Michigan    Central United States    Annelise Williams    CA-2310    Christine Abelman    Corporate    United States
    AG XXXXXXXXXX    AG-2019    1231908    Not Given    1/23/19    Wednesday    January    1/24/19    Standard Class    FUR-RUB XXXXXXXXXX    1    Furniture    Furnishings    Ru
ermaid Door Stop, Durable    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.12%    1    0.1    0    1488    49505    Grand Rapids    Michigan    Central United States    Annelise Williams    JG-5160    James Galang    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1275697    Not Given    12/13/19    Friday    December    12/14/19    Standard Class    TEC-STA XXXXXXXXXX    1    Technology    Machines    StarTech Calculator, Durable    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.24    0.15%    4    0.3    0    1488    78745    Austin    Texas    Central United States    Annelise Williams    YS-11880    Yana Sorensen    Corporate    United States
    AG XXXXXXXXXX    AG-2019    1310837    Not Given    6/10/19    Monday    June    6/15/19    Second Class    OFF-FEL XXXXXXXXXX    5    Office Supplies    Storage    Fellowes Trays, Blue    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.02%    4    0.1    0    1488    60653    Chicago    Illinois    Central United States    Annelise Williams    DL-2865    Dan Lawera    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1352224    Not Given    5/15/19    Wednesday    May    5/20/19    Second Class    TEC-CIS XXXXXXXXXX    5    Technology    Phones    Cisco Signal Booster, with Caller ID    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.07%    1    0.15    0    1488    75220    Dallas    Texas    Central United States    Annelise Williams    CR-2820    Cyra Reiten    Home Office    United States
    AG XXXXXXXXXX    AG-2019    1366085    Not Given    10/16/19    Wednesday    October    10/21/19    Standard Class    TEC-SHA XXXXXXXXXX    5    Technology    Copiers    Sharp Copy Machine, Color    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.19    0.04%    2    0.25    0    1488    48234    Detroit    Michigan    Central United States    Annelise Williams    CC-2100    Chad Cunningham    Home Office    United States
    AG XXXXXXXXXX    AG-2019    1400544    Not Given    1/29/19    Tuesday    January    1/29/19    Standard Class    FUR-SAU XXXXXXXXXX    0    Furniture    Bookcases    Sauder Classic Bookcase, Pine    $ XXXXXXXXXX    $ XXXXXXXXXX    High    $ 0.19    0.02%    2    0.25    0    1488    47374    Richmond    Indiana    Central United States    Annelise Williams    SB-10170    Sarah Bern    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1557147    Not Given    1/11/19    Friday    January    1/15/19    First Class    OFF-AME XXXXXXXXXX    4    Office Supplies    Envelopes    Ames Peel and Seal, Recycled    $ 5.25    $ XXXXXXXXXX    Low    $ - 0    0.00%    1    0.05    0    1488    76706    Waco    Texas    Central United States    Annelise Williams    PO-8865    Patrick O'Donnell    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1588096    Not Given    5/23/19    Thursday    May    5/27/19    Standard Class    FUR-DEF XXXXXXXXXX    4    Furniture    Furnishings    Deflect-O Light Bulb, Erganomic    $ 7.04    $ XXXXXXXXXX    Low    $ 0.05    0.28%    1    0.1    0    1488    49201    Jackson    Michigan    Central United States    Annelise Williams    CL-2565    Clay Ludtke    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1635797    Not Given    2/3/19    Sunday    Fe
uary    2/8/19    Same Day    OFF-FIS XXXXXXXXXX    5    Office Supplies    Supplies    Fiskars Shears, High Speed    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.10%    1    0.1    0    1488    53209    Milwaukee    Wisconsin    Central United States    Annelise Williams    PO-8865    Patrick O'Donnell    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1691731    Not Given    9/11/19    Wednesday    September    9/15/19    Second Class    OFF-AVE XXXXXXXXXX    4    Office Supplies    Binders    Avery Binder, Recycled    $ 5.30    $ XXXXXXXXXX    Low    $ 0.10    0.75%    1    0.15    0    1488    55407    Minneapolis    Minnesota    Central United States    Annelise Williams    CD-2790    Cynthia Delaney    Home Office    United States
    AG XXXXXXXXXX    AG-2019    179206    Not Given    4/24/19    Wednesday    April    4/25/19    Second Class    OFF-ROG XXXXXXXXXX    1    Office Supplies    Storage    Rogers Folders, Single Width    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.04%    4    0.1    0    1488    79424    Lu
ock    Texas    Central United States    Annelise Williams    BD-1605    Brian Dahlen    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1957110    Not Given    8/31/19    Saturday    August    9/1/19    Second Class    OFF-IBI XXXXXXXXXX    1    Office Supplies    Binders    Ibico Binder, Recycled    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.63%    1    0.15    0    1488    46203    Indianapolis    Indiana    Central United States    Annelise Williams    CC-2220    Chris Cortes    Consumer    United States
    AG XXXXXXXXXX    AG-2019    1958395    Not Given    5/16/19    Thursday    May    5/16/19    Second Class    OFF-TEN XXXXXXXXXX    0    Office Supplies    Storage    Tenex Folders, Wire Frame    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.22%    1    0.1    0    1488    60653    Chicago    Illinois    Central United States    Annelise Williams    SL-10155    Sara Luxemburg    Home Office    United States
    AG XXXXXXXXXX    AG-2019    2056925    Not Given    10/28/19    Monday    October    11/2/19    Second Class    OFF-WIL XXXXXXXXXX    5    Office Supplies    Binders    Wilson Jones Binder, Clear    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.40%    2    0.15    0    1488    77095    Houston    Texas    Central United States    Annelise Williams    JL-5835    John Lee    Consumer    United States
    AG XXXXXXXXXX    AG-2019    2066119    Not Given    7/8/19    Monday    July    7/11/19    Standard Class    TEC-PAN XXXXXXXXXX    3    Technology    Machines    Panasonic Receipt Printer, Wireless    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.24    0.10%    2    0.3    0    1488    65807    Springfield    Missouri    Central United States    Annelise Williams    DL-2865    Dan Lawera    Consumer    United States
    AG XXXXXXXXXX    AG-2019    2198541    Not Given    9/7/19    Saturday    September    9/11/19    Second Class    TEC-NOK XXXXXXXXXX    4    Technology    Phones    Nokia Office Telephone, Cordless    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.15%    1    0.15    0    1488    48234    Detroit    Michigan    Central United States    Annelise Williams    CD-2790    Cynthia Delaney    Home Office    United States
    AG XXXXXXXXXX    AG-2019    2231275    Not Given    8/28/19    Wednesday    August    8/29/19    Second Class    TEC-MEM XXXXXXXXXX    1    Technology    Accessories    Memorex Mouse, USB    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ - 0    0.00%    2    0.05    0    1488    78521    Brownsville    Texas    Central United States    Annelise Williams    CD-2790    Cynthia Delaney    Home Office    United States
    AG XXXXXXXXXX    AG-2019    2332510    Not Given    12/1/19    Sunday    December    12/6/19    Second Class    OFF-TEN XXXXXXXXXX    5    Office Supplies    Storage    Tenex Shelving, Wire Frame    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.09%    1    0.1    0    1488    77095    Houston    Texas    Central United States    Annelise Williams    MS-7980    Michael Stewart    Corporate    United States
    AG XXXXXXXXXX    AG-2019    2333770    Not Given    6/22/19    Saturday    June    6/27/19    Second Class    TEC-APP XXXXXXXXXX    5    Technology    Phones    Apple Headset, with Caller ID    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.14%    1    0.15    0    1488    77642    Port Arthur    Texas    Central United States    Annelise Williams    AM-360    Alice McCarthy    Corporate    United States
    AG XXXXXXXXXX    AG-2019    2383697    Not Given    10/16/19    Wednesday    October    10/17/19    Standard Class    TEC-SHA XXXXXXXXXX    1    Technology    Copiers    Sharp Copy Machine, Color    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.19    0.04%    2    0.25    0    1488    52402    Cedar Rapids    Iowa    Central United States    Annelise Williams    CC-2100    Chad Cunningham    Home Office    United States
    AG XXXXXXXXXX    AG-2019    2384745    Not Given    5/12/19    Sunday    May    5/16/19    Standard Class    OFF-KIT XXXXXXXXXX    4    Office Supplies    Appliances    KitchenAid Refrigerator, White    $ XXXXXXXXXX    $ 1,052.16    High    $ 0.28    0.03%    2    0.35    1    1488    68104    Omaha    Ne
aska    Central United States    Annelise Williams    CL-2565    Clay Ludtke    Consumer    United States
    AG XXXXXXXXXX    AG-2019    2424042    Not Given    10/14/19    Monday    October    10/16/19    Second Class    OFF-WIL XXXXXXXXXX    2    Office Supplies    Binders    Wilson Jones Binder, Clear    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.40%    2    0.15    0    1488    60440    Boling
ook    Illinois    Central United States    Annelise Williams    JL-5835    John Lee    Consumer    United States
    AG XXXXXXXXXX    AG-2019    2448243    Not Given    8/18/19    Sunday    August    8/23/19    Second Class    OFF-AVE XXXXXXXXXX    5    Office Supplies    Binders    Avery Binder, Recycled    $ 5.30    $ XXXXXXXXXX    Low    $ 0.10    0.75%    1    0.15    0    1488    60653    Chicago    Illinois    Central United States    Annelise Williams    CD-2790    Cynthia Delaney    Home Office    United States
    AG XXXXXXXXXX    AG-2019    2455899    Not Given    12/15/19    Sunday    December    12/15/19    Standard Class    TEC-STA XXXXXXXXXX    0    Technology    Machines    StarTech Calculator, Durable    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.24    0.15%    4    0.3    0    1488    60188    Carol Stream    Illinois    Central United States    Annelise Williams    YS-11880    Yana Sorensen    Corporate    United States
    AG XXXXXXXXXX    AG-2019    2534608    Not Given    8/7/19    Wednesday    August    8/7/19    Standard Class    TEC-OKI XXXXXXXXXX    0    Technology    Machines    Okidata Inkjet, Wireless    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.24    0.08%    1    0.3    0    1488    53711    Madison    Wisconsin    Central United States    Annelise Williams    HR-4830    Harold Ryan    Corporate    United States
    AG XXXXXXXXXX    AG-2019    261749    Not Given    9/19/19    Thursday    September    9/19/19    Second Class    OFF-IBI XXXXXXXXXX    0    Office Supplies    Binders    Ibico Binder, Recycled    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.63%    1    0.15    0    1488    48601    Saginaw    Michigan    Central United States    Annelise Williams    CC-2220    Chris Cortes    Consumer    United States
    AG XXXXXXXXXX    AG-2019    2728572    Not Given    5/25/19    Saturday    May    5/28/19    Second Class    OFF-TEN XXXXXXXXXX    3    Office Supplies    Storage    Tenex Folders, Wire Frame    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.22%    1    0.1    0    1488    73120    Oklahoma City    Oklahoma    Central United States    Annelise Williams    SL-10155    Sara Luxemburg    Home Office    United States
    AG XXXXXXXXXX    AG-2019    2963245    Not Given    10/29/19    Tuesday    October    11/2/19    Standard Class    OFF-STA XXXXXXXXXX    4    Office Supplies    Art    Stanley Canvas, Blue    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.10%    2    0.15    0    1488    68025    Fremont    Ne
aska    Central United States    Annelise Williams    DR-2940    Daniel Raglin    Home Office    United States
    AG XXXXXXXXXX    AG-2019    3032982    Not Given    5/16/19    Thursday    May    5/19/19    Second Class    OFF-WIL XXXXXXXXXX    3    Office Supplies    Binders    Wilson Jones Binder Covers, Clear    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.47%    2    0.15    0    1488    60543    Oswego    Illinois    Central United States    Annelise Williams    CL-2565    Clay Ludtke    Consumer    United States
    AG XXXXXXXXXX    AG-2019    3063469    Not Given    3/7/19    Thursday    March    3/9/19    Second Class    OFF-ELD XXXXXXXXXX    2    Office Supplies    Storage    Eldon Lockers, Wire Frame    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.05    0.03%    1    0.1    0    1488    78550    Harlingen    Texas    Central United States    Annelise Williams    AC-420    Alyssa Crouse    Corporate    United States
    AG XXXXXXXXXX    AG-2019    3078752    Not Given    11/30/19    Saturday    November    12/3/19    Second Class    OFF-WIL XXXXXXXXXX    3    Office Supplies    Binders    Wilson Jones Binder, Clear    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.10    0.40%    2    0.15    0    1488    68025    Fremont    Ne
aska    Central United States    Annelise Williams    JL-5835    John Lee    Consumer    United States
    AG XXXXXXXXXX    AG-2019    321771    Not Given    2/16/19    Saturday    Fe
uary    2/21/19    Second Class    TEC-SAN XXXXXXXXXX    5    Technology    Accessories    SanDisk Mouse, USB    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ - 0    0.00%    1    0.05    0    1488    54703    Eau Claire    Wisconsin    Central United States    Annelise Williams    AC-420    Alyssa Crouse    Corporate    United States
    AG XXXXXXXXXX    AG-2019    3234894    Not Given    2/5/19    Tuesday    Fe
uary    2/10/19    Standard Class    FUR-HON XXXXXXXXXX    5    Furniture    Chairs    Hon Bag Chairs, Red    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ 0.14    0.16%    2    0.2    0    1488    55901    Rochester    Minnesota    Central United States    Annelise Williams    IL-5100    Ivan Liston    Consumer    United States
    AG XXXXXXXXXX    AG-2019    3236544    Not Given    11/9/19    Saturday    November    11/10/19    Standard Class    TEC-BRO XXXXXXXXXX    1    Technology    Copiers    Brother Wireless Fax, Laser    $ XXXXXXXXXX    $ 1,515.24    High    $ 0.19    0.01%    4    0.25    0    1488    79907    El Paso    Texas    Central United States    Annelise Williams    RD-9660    Robert Dilbeck    Home Office    United States
    AG XXXXXXXXXX    AG-2019    3261303    Not Given    9/11/19    Wednesday    September    9/14/19    Second Class    TEC-MEM XXXXXXXXXX    3    Technology    Accessories    Memorex Mouse, USB    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ - 0    0.00%    2    0.05    0    1488    46142    Greenwood    Indiana    Central United States    Annelise Williams    CD-2790    Cynthia Delaney    Home Office    United States
    AG XXXXXXXXXX    AG-2019    3407916    Not Given    1/12/19    Saturday    January    1/15/19    First Class    OFF-AME XXXXXXXXXX    3    Office Supplies    Envelopes    Ames Peel and Seal, Recycled    $ 5.25    $ XXXXXXXXXX    Low    $ - 0    0.00%    1    0.05    0    1488    77095    Houston    Texas    Central United States    Annelise Williams    PO-8865    Patrick O'Donnell    Consumer    United States
    AG XXXXXXXXXX    AG-2019    3416342    Not Given    3/24/19    Sunday    March    3/29/19    Same Day    OFF-STO XXXXXXXXXX    5    Office Supplies    Fasteners    Stockwell Paper Clips, Bulk Pack    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ - 0    0.00%    2    0.05    0    1488    78207    San Antonio    Texas    Central United States    Annelise Williams    AC-420    Alyssa Crouse    Corporate    United States
    AG XXXXXXXXXX    AG-2019    347262    Not Given    8/30/19    Friday    August    9/4/19    Second Class    TEC-MEM XXXXXXXXXX    5    Technology    Accessories    Memorex Mouse, USB    $ XXXXXXXXXX    $ XXXXXXXXXX    Low    $ - 0    0.00%    2    0.05    0    1488    75220    Dallas    Texas    Central United States    Annelise Williams    CD-2790    Cynthia Delaney    Home Office    United States
    AG XXXXXXXXXX    AG-2019    3495968    Not Given    12/21/19    Saturday    December    12/22/19    Standard Class    TEC-BRO XXXXXXXXXX    1    Technology    Copiers    Brother Wireless Fax,
Answered Same Day Jun 19, 2022

Solution

Suraj answered on Jun 19 2022
92 Votes
Tableau Assignment
BUSI 650 – Business Analytics
Solution:
h)
In this section we will explain the insights gained from the interactive dashboard created for the Walmart Sales data.
From the histograms created we can see that; the maximum sales are for the office supplies for storage subcategory. Also, the maximum discount offers for the Binders sub category under the office supplies.
The maximum profit gained for storage under the office supplies category of value $2139. Also, technology factor has loss of value $3840.
The maximum profit margin gained in the office supplies for labels sub-category. Also, there is some sort of loss also in some sub-categories.
Also, the sales are increasing month by month. We can see there are minimum sales in the month of Fe
uary and maximum sales are in the November month and after it the cycle will repeated again.
We can also see that maximum sales happened on Tuesday and minimum sales on Friday.
From the geographical map view graph created we can see that maximum profit gained city is Chicago...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here