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

Grand macnish 150th anniversary scotch

05/12/2021 Client: muhammad11 Deadline: 2 Day

Topic:Tableau Assignment

ACCT 4550 – Accounting Data Analytics

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:

Ideas & Innovations
Instant Assignment Writer
Helping Engineer
Smart Tutor
Write My Coursework
24/7 Assignment Help
Writer Writer Name Offer Chat
Ideas & Innovations

ONLINE

Ideas & Innovations

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

$17 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

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

$42 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$22 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

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

$50 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$36 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment 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.

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

Global supply chain management v2 simulation answers - Logos in jfk inaugural address - Interagency collaboration when conducting a legal search - Warr company is considering a project - Key concepts of confucian ethics - Construction of unit hydrograph - Epass nt schools net - Assignment 2: Economic Approaches in the Age of Industrialization (1870-1940) - Simple commission calculation program part 3 - Gym full body workout plan pdf - One way design psychology - Engineering - What does homework soundtrack mean - Mcgellin v mount king mining - Daikin field settings table brc1e62 - Washington square dr sloper quotes - Health Issues related to Weight - Pathophysiology ( Discussion Board) # Anemia - Which number produces a rational number when multiplied by 0.25 - Ofdm channels docsis 3.1 - Why do crickets chirp more at higher temperatures - Medial meniscus tear old icd 9 cm code - Mankiw chapter 14 solutions - Josquin des prez music style - Fedex locations west chester pa - Dhl global forwarding liverpool - Activity based costing and Master budgeting - Purchase Evaluation - Suncorp wealth cash management account - St andrews school of modern languages - Choose two of the personal essays (PDFs) we have discussed in class to synthesize into an argument of your choosing. - How many pounds is 250g - Http www codeblocks org downloads - A puma at large answers - Nurse practitioner fnp cover letter - Star wars the rise of skywalker amc eden prairie - A fantastic cave with odysseus and calypso - New 2/2 - Why is the stock market booming - Explorations conducting empirical research in canadian political science pdf - Ap stats chapter 3b answer key - Organizational analysis assignment - Epidemiology Case 1 Part 2 - Movement joints in blockwork - Is no2f polar or nonpolar - Father john misty net worth - Summary - Branston fruity sauce waitrose - Understanding by design wiggins and mctighe 2005 apa citation - Identity authority and learning to write in new workplaces - Research Paper: Big Data and the Internet of Things - CHEMISTRY LAP - Toyota car recall case study - Bit stuffing in hdlc - St james episcopal church warrenton va - 108 - Msc computer science middlesex university - Mildura visitor information centre - Global economic crisis speech - Assignment 9/7/20 1 - Animal crossing new leaf duplication glitch solo - Any Cap/Hat Digitizer Here? - Management functions assignment - Woody allen short story madame bovary - Understanding Terms - Human pedigree analysis problem sheet answers - Introducingnt com - Genius gluten free pain au chocolat - Ultraviolet catastrophe simple explanation - Submis assignment 2 eco - What is the volume of a cuboid - Occupational therapy observation assessment - Personal Narrative - Car loan repayment calculator moneysmart - 1890 guy metals drive hammond wi 54015 - Travel machine wayne toups cruise - Ordinary annuity and annuity due difference - Business studies operations strategies essay - Please read carefully - Fogg diary of a sociopath review - Pandora jewelry competitive advantage - 24 hrs from now - Reflection - Pacific trails resort case study chapter 6 css - Oxidation reduction reactions lab answers - Bottling industry five forces analysis - Knight frank finance esher - Is mgbr2 a strong electrolyte - Menston and guiseley practice - Royal north shore private maternity - I need 2500 words report on Fashion Business Model Research - Dual 7 segment display circuit - Need an essay - Penetration Testing Report - Follower seamus heaney analysis - Harron homes thornberries matlock - Clean room cleaning sop - Fife council employee local discounts - 201 640 7980 - What is statutory reporting in australia