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

Once upon a vine enchanted woods bubbly limited release

25/10/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:

Math Exam Success
Study Master
Essay Writing Help
A+GRADE HELPER
Buy Coursework Help
WRITING LAND
Writer Writer Name Offer Chat
Math Exam Success

ONLINE

Math Exam Success

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

$15 Chat With Writer
Study Master

ONLINE

Study Master

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

$19 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$49 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$43 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework 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.

$15 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

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

Jb hi return policy - Confederate flag color meaning - Apple's future case study solution - Www factmonster com history - Worksafe victoria job safety analysis worksheet - Act 4 scene 2 taming of the shrew - Co 3+ electron configuration - Equivalent markup on selling price - Trisomy 13 karyotype notation - Notetaking - Reverse hierarchical diffusion ap human geography - Perception errors in organisational behaviour - Ford and the world automobile industry in 2015 case analysis - Great ziggurat of ur - Personal swot analysis assignment - College algebra - Should cost be a factor in carmex prices - A mother's love poem for son - Web server plugin for websphere application server - Three levels of prevention for lyme disease - Warlow v harrison case brief - Why are sound waves in air characterized as longitudinal - Case Study - Side bridge cable row - Protocol - What is an ado - Thermo king alarm code 89 - Hsc in the holidays uts - Brief reflections on childhood trauma and society bruce d perry - Chemicals melting point tells you - How to pronounce paulo freire - Nursing - Education Policy - Movies and meaning 6th edition - Where did tim burton grew up - Examples of limitations in studies - Land use planning ppt - Walker and avant concept analysis steps - Middle of the road management definition - 2/23 ferguson avenue labrador - Genogram explanation - Seventh day adventist church fundamental beliefs - Lina purchased a new car for use - Eurotherm 3216 factory reset - Realidades 3 capitulo 3 - Business of Sport - Kfc rules and regulations - Talk for writing biography - Usd to sgd spot rate - To kill a mockingbird scout quotes with page numbers - 2page Of Essay - Trot and canter pole distances - Nhs lanarkshire staff bank law house - Who were the leaders of the prison reform movement - Prince fusion elite 19mm table tennis table - Essay Due - Organizational behavior self reflection paper - The legacy of ancient greece and rome answer key - Plant tissue concept map - Discussion - Electrical current in a metal wire involves the flow of - Taboo delicacies - 4 5 minute speeches - The cay chapter 11 - Ati active learning template nursing skill example - Dna restriction enzyme simulation answers - Is was a helping or linking verb - Project management at arnold palmer hospital case study - QUALITATIVE And QUANTITATIVE Journal Article (1 Paper Each) - Wk 3, IOP 470: DR 1 - Counseling - Bobbie ann mason shiloh pdf - Response - Cold heat cordless soldering pen - Application to general manager - Playground duty policy nsw - The radicalism of the american revolution pdf - Gas cutting process ppt - 735 Wk 12 DQ 2 - Environmental Factors and Health Promotion Presentation: Accident Prevention and Safety Promotion for Parents and Caregivers of Infants - FIN/571: Corporate Finance - ISI - Discussion 5 - Atkins or fadkins answers part 3 - A class divided study - Astro unl edu naap hr animations hr html - Billy elliot ending scene - BI: Week 4 Assignment - Marketing dis4 - Define the term cliché penn foster - Robert drewe shark net - Student exploration calorimetry lab answers activity b - 978 0 393 63168 5 - Cement sheet flooring installation - DQ Date - How did archimedes find the density of the crown - Blue sky project case study - Middle Adulthood Health, Demography, and Social Work Practice - Nrma accident report form - Examples of infinite games - Contemporary chinese studies nottingham