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

Jack daniels family of brands 5pk

18/11/2021 Client: muhammad11 Deadline: 2 Day

Topic:Tableau Assignment

Evidence of Significant and Authentic Learning Cover Sheet

Assignment #3

Instructions: This assignment is a follow-up on the in-class activity we did over the HUB analytics files. Please complete the assignment using Tableau, and create a story in your Tableau file using visuals you created, and provide answers/explanations for each visual in the Tableau story. Submit your Tableau document in “twbx” format to the “ESL3” folder under the Assignments tab of D2L. Follow this naming convention for your files: "ESL3-ACCT4550-FirstNameLastName.twbx". Example "ESL3-ACCT4550-SunayMutlu.twbx".

Assignment Description: Bibitor, LLC asked you to complete due diligence on their wine and spirits business. Bibitor has 79 retail locations with approximately $484 million in sales. Their CFO is at the forefront of data analytics and created a Storyline the company uses for making decisions about their stores. To facilitate the investigation, you have Bibitor’s sales file with more than 13 million records (SalesFINAL6302019) and their purchase price file (2019PurchasePricesJun ) with the cost of each inventory item. Traditional spreadsheets cannot process all of the data, requiring the use of Tableau to complete your due diligence.

The Bibitor, LLC CFO is interested in differences between wine and spirits across the entire organization. She wants to know the differences in Sales Dollars and Quantities between the two categories, popular bottle sizes for wine and spirits, and the most popular vendor for wine and spirits. She is also interested in certain information at the Store level of detail.

Required:

Assist the CFO in creating Worksheets and Dashboards to answer these questions:

1- What is the total Sales Dollars and percentage breakdown of wine and spirits?

Hint: Use the Classification and Sales Dollars to separate the sales based on wine and spirits. Convert the data into a Pie Chart (Show Me Tab) and the Analysis Tab to convert data to percentages.

2- What is the most popular Size for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)? Provide the CFO with some reasons why this is important for managing the business.

3- Who is the most popular Vendor for wine and for spirits based on Sales Dollars and Quantity (include the total Sales Dollars and Quantity in your answer)? Provide the CFO with some reasons why this is important for managing the business.

4- Which Stores have the highest and lowest weighted average sales price for wine and spirits? How does the weighted average sales price compare to a simple average of Sales Prices for SKUs (Brands) in each Store? What does a large difference between the simple average and the weighted average mean?

Hint: Create a Calculated Field (Analysis Tab) and label it Average Sales Price. To accomplish this, drag the Sales Dollars pill divided by Quantity pill. You should see the Average Sales Price pill. Drag the Average Sales Price pill into columns and convert the variable from “SUM” to “AVG” by using the Dropdown Menu on the Pill . Drag the Classification pill into the Filter Card to help you determine the Average Sales Price for wine versus spirits.

5- What seasons/months are sales the highest and lowest? Provide the CFO with some reasons why this is important for managing the business.

6- Import the “2019PurchasePricesJun” file into Tableau and calculate a new attribute using measures from both files, such as COGS. Use a Scatter Graph on Tableau to tabulate the relationship between your new attribute and another attribute.

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:

Supreme Essay Writer
Online Assignment Help
Quality Assignments
Essay & Assignment Help
Best Coursework Help
Coursework Helper
Writer Writer Name Offer Chat
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$49 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$47 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$40 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$30 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$34 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$40 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

Comparative System - Khufu cause of death - Comparing mitosis and meiosis worksheet key - Community Outbreak - Head start health advisory committee - Victimology 4 questions - Www bankmuscat com online banking - Campbellsville university dso - Impact of discrimination on individuals of multiracial backgrounds - A midsummer night's dream project - First article inspection procedure - Digital wwnorton little seagull 3 - Sears appliance repair 93 w campbell rd rotterdam - Wave on a string simulation answers - Patagonia culture case study - Uky download microsoft office - Stock owned in affiliated companies balance sheet - Hazpak risk assessment tool - Adversarial Collaboration - Save sam lab answer key - Presented below are three independent situations - Queen elizabeth speech at tilbury rhetorical analysis - Veltri corporation is working on its direct - Simquick manual - Examine the geologic cross section below - Grantham university store - Non inverting op amp cutoff frequency - Unisa leave of absence - Which of the following examples best reflects an attitude as a learning outcome? - Pay for Performance (P4P) - L oreal marketing case study - Ikea self service concept - International microwave power institute - Heavy letters in arabic - Internship weekly journal example - Paper introduction - Which of the following metals can react with water - Unspoken feelings goonie squad lyrics - Data profiling and cleansing - United States Government Accountability Office website for Key Issues - Course Project Week 4 Outline - Casey nelson is a divisional manager - Test for fe3+ ions - Psychotherapy With group - MKT 630 IP2 - Literacy Period Summations - An outward shift of the production possibilities frontier represents - Ac relay coil snubber - Netwitness investigator download - Abercrombie and fitch racial discrimination - My opinion 2 - Fama french three factor model excel - Cisco lisp vm mobility - Powerade bridge seats busch stadium - Abl online money transfer - Takemoto corporation borrowed - Incremental analysis is most useful - Cardiac Physiology: Electrical Activity - Gary hamel core competencies - Synchronous motor and generator - Deliverable 4 - Evaluating Financing Strategies/ EXCEL FILE AND EMAIL - Glb Ethics - Bureau veritas rules for the classification of steel ships - Week 2 ORG400 - 1984 reading guide questions and answers - Wk 3 - Effective Advertising Campaign Paper - Audio Visual Presentation: - Research Paper: Proposal - Global studies program freiburg - 500 words essay - 4 - Marketing and Promotion Strategy - Cloud Computing Discussion 3 - The girl who can ama ata aidoo theme - Project Outline - Chapter 3 lord of the flies summary - Bsbitu101a operate a personal computer assessment - Week 8 Jacob Watt - Gas laws pre lab answers - Contributing pigment in hair color - Khan academy piecewise functions - The gettysburg address multiple choice questions answers - Company karma hummel - What should kimi ford recommend regarding an investment in nike - I need 8500 words article in mirai virus and IOT and solutions - 3 layers of heart muscle - Biochemistry lab report - Www apple com legal warranty - Samsung model ln t4061f recall - Uttermost tam champagne pressed 30 x 40 wall mirror - Nursing care plan book online free - The government has set a price floor on bread - A & d window cleaning performed $450 of services - Supplier information form template - Jack and rochelle chapter summary - Sianne ngai ugly feelings - Excel: Short-Term Finance - Is rubbing alcohol homogeneous or heterogeneous - Case 20 coral bay hospital - Strategies and games theory and practice pdf - Bromination of acetanilide and aniline lab report