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

The support consists of a solid red brass - Aloe vera wikipedia shqip - Withdraw without academic penalty uts - Writing Assignment - Thapar university fee structure - Case Study Analysis IT - Area director visit report - Cigweld 200 ac dc - Conceptual artists reacted to the expanding art market by - The lais of marie de france analysis - Briefly describe how supportive and interpersonal psychotherapies are similar - In the 1830s paris was - 50 strategies for teaching english language learners pdf - Why chinese mothers are superior by amy chua pdf - Newtonian reflecting telescope diagram - Ea cricket 2002 cheats - Strategic plan part iii balanced scorecard and communication plan - About Artificial Intelligence - Software project management multiple choice quiz - Salomon v salomon and company ltd - CASE STUDY 2 (no plagiarism) - Lockout energy source isolation placards - Book fair report writing - Components to building an effective and successful csirt team - Owasp stands for - Analyzing pro forma statements xyz company - Joboutlook gov au career quiz - Sapling homework answers organic chemistry - 1/8 bsp tapping drill - Postgraduate nursing scholarships australia - Lyrics black eyed peas where is the love - Assignment: Academic Success and Professional Development Plan Part 3: Strategies to Promote Academic Integrity and Professional Ethics - Monica diaz and michael naranjo - Groups in action evolution and challenges workbook answer key - Australian institute of loss adjusters - Indian bean tree crossword clue - Ethica and Legal Aspects of Nursing Practice DQ 1 student reply Lisney Caraballo - 6 3 skills practice similar triangles answers - George orwell homage to catalonia pdf - Qiba professional year brisbane - Eudaimonistic model - Delimitation of the study example - Lusus naturae margaret atwood full text - 90 day notice to vacate nsw - Mse 227 lab - Csia 310 final project incident response exercise & report - Quotes from on the waterfront - Dataflux data management studio download - Capacitive power supply with bridge rectifier - White collar crime - Repeated melodic pattern crossword - Professor Development - Case Study Mr. M - Rectangular to polar complex numbers calculator - Culture and imperialism summary - How do you force an african violet to bloom - Cs2 - Pros and cons of repeated measures design - Office 2016 integrated applications project 2 word access excel - Ashford university academic integrity policy - How do information systems eliminate the problems of information silos - Advantage air return air grille - Neil milburn barratt homes - Strategic positioning attempts to achieve sustainable competitive advantage by - Which of the following are standout traits of a change-resistant culture - Which of the following correctly portrays a bank's balance sheet? - Suspended ceiling tiles screwfix - Grams per litre to moles per litre - __7_8_6__ +91-8529590991 Husband Wife Problem Solution Molvi ji - Communication in Organizations - Colonial mutual life assurance society limited unclaimed monies - How to create a scenario summary report in excel 2016 - Diaphragm pump princess auto - Naplan withdrawal form 2021 - Please determine the tax consequences of the following transactions - Alcoa fastening systems aerospace - Cookie chronicles accounting - Silhouette cameo failed to locate framework dll - Commercial research firms like ac nielsen and - Spencers sexology bath bombs amazon - Preterite ar verbs worksheet answers - St andrews tennis club - The standard unmodified audit report - 4 functions of nonverbal communication - Dekalb county housing authority - Cisco vpc nexus 9000 - Contar (1) contamos (2) (3) juegas (4) juegan mostrar (5) mostramos (6) (7) empiezas (8) empiezan - Moseley x ray experiment - Norse gods and goddesses and their symbols - Racketeer stud ball magnet lowe's - Waren sports supply balance sheet - Super size me answers - Lincoln david herbert donald sparknotes - Assignment 4 mobile devices and self service e commerce - Oxford brookes university library - Cause and effect diagram generator - Discussion 4 - Reserved for Hifsa - Tensho kotai jingu kyo - HR: Post and responses - Take a break!