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

3526 islay lane crete il

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

Topic:Tableau Assignment

Instructions

I have attached all the instructions below in the attached file. After doing 1-6 we need to create a story mode and answer what is in the directions.

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:

Solutions Store
Coursework Assignment Help
Calculation Guru
Academic Master
Buy Coursework Help
Homework Tutor
Writer Writer Name Offer Chat
Solutions Store

ONLINE

Solutions Store

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

$39 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$15 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

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

$34 Chat With Writer
Academic Master

ONLINE

Academic Master

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

$34 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

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.

$39 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$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

Friedel crafts acylation lab report - Voiced alveolar lateral liquid - Pearl products limited of shenzhen china manufactures and distributes - Chapter 21 accounting for leases solutions - Abc catch up harrow - The contorted realm map - Assignment - NCM512 Negotiation Strategies - Beer mechanics of materials 6th solutions chapter 3 - English 9 - We even got a secret handshake - Gunpowder plot poem vernon scannell - Conflict of interest management plan template - How to make a codebook for a survey - Standard reduction potential of ag - Case Study. At least 3 pages in APA format with at least 2 references. - Dulux self destruct exterior house - Outer worlds force schematics orson or gladys - Hozier tickets bethlehem wind creek event center november 16 - Effectiveness - Math 221 week 4 lab - Therapeutic effects of faradic current - Fish attracting devices nsw - Incident report for lost item - How did op art reflect 1960s culture - Reflection in Action - Specific heat of aluminum - Myer estee lauder gift with purchase 2020 - Vaccination argumentative essay - Alcoa foundation grant application - Get the gringo soundtrack culero - Discussion question - Urgent 3 - What is the height of table quiz - Https hbr org video 5236216251001 what makes a leader - Radio shack surveyor drone troubleshooting - Distance from home to 2nd base - Griffith uni assignment extension - Music coordinator action plan - An unknown group 1 metal carbonate - How to make a parachute out of a grocery bag - Wechsler preschool and primary scale of intelligence - Essay - Piece of land surrounded by water on three sides - Bsbhrm506 manage recruitment selection and induction processes answers - Transition to Adulthood - My crew my dogs set rules set laws lyrics - Law and economics 6th edition pdf - Tvsp package sa 2021 - Amylase lock and key - +91_9414601882**vashikaran lOvE prOblEm sOlutiOn baba ji in ujjAin, gwAliOR - Summary for reading (MUSIC essay) - Support community participation and social inclusion - Http www netmba com strategy matrix bcg - Managing organizational behavior 2nd edition pdf - Menu sales mix analysis - Bushfire management overlay yarra ranges - Experimental variables worksheet answers biology - Patient clinician communication basic principles and expectations apa citation - Johar town lahore directions - Burwood council e waste - ENTR 5155 Resume - Daniel teutul orange county ironworks - Is forum shopping ethical busi 301 - Bay city company's fixed budget performance report for july follows - Kfc owner in pakistan - The project communications management knowledge area maps to the - Business letter asking for information - Fifth third bank cocoa beach fl - Inventory management system report - Research paper progress report 800 words + 4 APA refernces + palagrisim report - Give me liberty 5th edition pdf - English 102 - Ispm 15 certificate validity - Case Study Analysis IT - CS week 13 discussion - Letter to king george iii from colonists - Https mail luminad com ired - It's no laughing matter analyzing political cartoons - History - Romanticism in frankenstein chapter 6 - Irc irc rizon net 4chan - Jaworski's ski store is completing the accounting process - 4 wire proximity sensor wire color code - Accounting project 1 answers - A bar magnet is cut in half as shown - Kansas city zephyrs case solution - A terre wilfred owen analysis - How to report confidence intervals apa - What is racemization in organic chemistry - A spherical concave mirror has a radius - Half wave and full wave diode rectifier experiment - Disadvantages of longwall mining - Perdue chicken ethical - Patrick inc makes industrial solvents - Pasteur chose the latin root word for virus meaning - 325 - Voltage comparator using transistor - Wyches fine porcelain & furniture - Steps to writing a grant proposal hsm 270