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

Two assignments due tomorrow before 11:59 pm - A streetcar named desire study guide answers - On january 1 2017 simon company - When i heard the learn d astronomer summary - Actron air reset controller - The management of zigby manufacturing prepared - 73.6 kg in lbs - When entering foreign markets basic entry choices include - Torque detail mirror shine - Grace to you sermon - Active leaders need self confidence because - Professional communication part 1 content review answer key - Cmit 425 risk assessment paper - Regional ring road hyderabad - Relationship Challenges - Examples of social cohesion in australia - William perry's scheme of intellectual and ethical development - Week 10 - Help 1 - Wjec geology mark schemes - Ab inbev and sabmiller merger analysis - During the renaissance the unusual practice of shaving eyebrows - Blanka dobrynin - The necklace part 2 - Internal research and external research - Unqualified legal practice queensland - Exp 105 week 3 chapter quiz - Discussion - Damiens food pantry wareham ma - What does faber mean when he says books have pores - Swales discourse community summary - 7b film for ray - What adjustment is made for underapplied overhead - Hipaa includes in its definition of research activities related to - Brave new world character worksheet answers - Mount alexander shire council ceo - Mcgraw hill marketing simulation answers - Young writers monster poetry - Mandy patinkin artis naples january 19 - What does orchard grass look like - B2b sales strategy ppt - Apex pro mxr 100 - Acme bathroom exhaust fans - DISCUSSION - Most informational reports are written - River system worksheet answers - Busschaert racing pigeons for sale - The brand called you peter montoya pdf - Rage guest programmers list - Construction of unit hydrograph - Calvary chapel miami beach - Marilyn hughes vsim documentation - Romeo and juliet short answer questions - Marketing Strategies - Arabic numbers 1 20 - Introduction to criminal justice 9th edition bohm pdf - Australian core skills framework practice test - Quick release knot cattle - Caltex oil lube guide - Stephen king my creature from the black lagoon analysis - Case study 3 - Final Paper - Cloud in a bottle experiment hypothesis - HRM 522 - Graphs for qualitative data - Dry storage in flight kitchen - Summation of forces in tennis - 47 bus timetable newcastle - Why did kathy experience the altered sensation - How to cite mbti results in apa format - Data-driven decision making - Patrick inc makes industrial solvents - Only when you let her go - I need 2 replies , 200 words each on Society for Human Resource Management (SHRM) - Reflection paper - The case of the pricing predicament - 2.2 3 quiz understand journalism as persuasion - As nzs 1801 1997 - Sydney po box postcode - Duck's change curve model - Clipsal light switch installation instructions - Joy luck club questions - Mitel mivoice business brochure - Sample phd interview questions and answers - Southern cross school of distance education ballina - Milgram experiment ethical concerns - Dr selsick insomnia clinic - Kaplan psychiatric nursing integrated - Design a Survey Questionnaire for your study - Nfpa 99 nurse call systems - Www mbgnet net desert - Physics color worksheet answers - O full of scorpions is my mind dear wife analysis - Management - Learning style inventory k 2 - Diablo 2 waypoints act 5 - IoT report using thingsboard platform - Budgeting and finance - Rnib college loughborough staff - Walmart organizational chart