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

Cha cha cha sx licor de tequila

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

Topic:Tableau Assignment

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:

Finance Professor
Assignment Helper
Quick Mentor
Assignment Hut
Homework Tutor
Instant Homework Helper
Writer Writer Name Offer Chat
Finance Professor

ONLINE

Finance Professor

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$41 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$19 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$15 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$19 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$32 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

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.

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

Job Cost Accounting - Trends of information system infrastructure - Sisters of divine providence pool - Letter of support from parent company - Assumptions in truss analysis - Shogun finance ltd v hudson - How to write a research paper ppt - Who is mr underwood in to kill a mockingbird - Hands-on information security lab manual - Proj 587 week 5 case study - Netwitness categorizes and organizes traffic so that: - What is veracity in nursing ethics - Iboard allied american university - Pbhe - Sas enterprise miner variable roles - Forecasting attendance at swu football games - Transition to Graduate Study - MGT 365 Week 9 Discussion - Post And Response - Master test plan vs detailed test plan - Assignment 6 - Mixtures can be uniform called - Ob - What is the average value of a loyal customer vlc - Babysitter - What are the four strategic alternatives - 2,000 words on research methodology - Discussion science report example - Quicksilver outer barrier reef - Mod 12 synchronous counter - Saf t intima change - For a constant returns to scale production function - Umd duo activation code - Economic function of profits and losses - Nobody gets in to see the wizard meaning - Cultural Approaches to Organizational Communication - Quality Decision Making: Cost-Benefit Analysis ( No Plagiarism) - Bridge to terabithia script - Timeline of significant labor legislation passed in the 20th century - Peer Reviewed article for recurrent UTI - Research Paper - Advanced panel and paint palmerston north - Discussion board - Phone plans $0 upfront - Daily illini salary guide 2012 - Air conditioner service company profile - My personal interest essay - The combining form encephal o means - Agilent intuilink waveform editor - Answer key gattaca movie assignment answers - The art of composing printed material from letterforms is called - How are daoist ideals expressed through art offer several examples - Marketing and operations management at ikea - Public and private families an introduction 7th edition pdf - Anz credit card hotline - Soap note template nurse practitioner - Dr borade the villages fl - Dr jeremy mcanulty credentials - Can you feel the - 2 bampton lane ballajura - Problem 6 3a perpetual alternative cost flows lo p1 - Need Response 2 to below discussion-price to earnings - What is plumbus used for - Coca cola integrated marketing communication case study - Gattaca movie questions biology - The beautiful struggle analysis - Holly bush nursery leicester - A merchandiser's purchases are equivalent to a manufacturer's - Thompson smarter than you think - What is needed to determine a facility's cmi - Ministry of education directory - Winchester college oxford university - Nursing research proposal hand hygiene - Relax company statement of financial position - Advanced diploma of legal practice rmit - Example of justice in nursing - Econ 213 problem set 1 - Presentation handout template word - Ge tetra contour installation instructions - Consent form for recording interview - Strategic management text & cases 9th edition - Acc pre assessment - Conceptual physics homework help - Arcview 3.2 download full free - Rush limbaugh simplisafe nra - Aha moment examples notice and note - Scully corporation's comparative balance sheets are presented below - How many earths would we need quiz - California business law and legal environment 5th edition - Westwood one minute addition and subtraction test - Api 20e analytical profile index database - Dataflux data management studio download - Shadow health mental health documentation - Op - Management - Risk control self assessment checklist for nurse practitioners - Nasa acoustic test chamber - 60601 2 edition 4 - Math 144 worksheet 2 - Linuxzoo net tutorials - Ballymena livestock market report