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

First year of College Seminar D7 - Who is balthasar in much ado about nothing - Curse and blessing of the ghetto - Cultural Object Paper - Capability maturity model integration cmmi - Journal Article Summaries/Evaluations #1 - Plas madoc estate office - Reflection paper - Rolls wood group wellheads - Dissucion week -10 833 - Woolworths wild caught salmon - Diamond is woman's best friend - Acecqa first aid kit checklist - Get real get rich farrah gray pdf - Case study on moral status fetal abnormality - Pacific northwest enterprise risk forum - Slavin & schunk learning theories educ 500 - Fraction wall 1 to 20 - Sandler submarine explained - Naui nitrox dive tables pdf - Cases in healthcare finance 5th edition - Cold war activities worksheets - Code of ethics guiding nobility - Cryptography - Lasting impressions company case study - Geography bearings worksheet with answers - Vehicle insurance management system project - Calculate bmi in python - Business intelligence helps the cincinnati zoo work smarter - Nursing care hours per patient day calculator - An aptitude for a job implies a - Analyzing Emotional Competence - Freud erikson piaget kohlberg chart - Glencoe com sites - LMX Theory - Experiment 2: bacterial transfer to a stab tube and an agar plate - Culture and Environment Analysis - Final paper - Taking sides clashing views on political issues sparknotes - Flinder street station renovation - Contingency planning - Basic fire fighting ppt - Hospital chaplaincy training ireland - Ssaa org au win - WK5-BASIC STATISTICS Assignment: Analysis of Variance (ANOVA) - Python full course - What was the stated aim of robespierre and his supporters - How to check if a schedule is conflict serializable - Write an essay for my Africana Studies Course 3-5 pages Double Spaced - Tr 3b astra aurora project - Indiana dabney university hammond in - The musketeers season 2 episode guide - Order dulux powder coat samples - Orange brent hinds terror discontinued - Integer sequences should you believe in patterns - DQ Reply 15 634 - History eassy - Lean process improvements at cleveland clinic - Rl circuit lab report - 3 towns medical practice - Allison thiel world surf league - Reaction rates worksheet answers - Indian standard code list - Attard family crest malta - Counter argument and rebuttal worksheet - Post-Sommer - Aon hewitt graduate scheme - Curing the incurable cookbook by gary null - Classify each nutrient as a macronutrient or as a micronutrient - Prioritize and motivate your life goals in terms of marriage - The comforts of home flannery o connor sparknotes - Module 2_DisasterRecovery - Write a 3-paragraphs about the assignment. - Read article answer question 1 page - Humn 8660 - This is our story who was the killer - Switchport nonegotiate best practice - What is the iupac name for the molecule shown - Acc ethical framework - Multiple linear regression ppt - Rathke v corrections corporation of america inc - Human Resources Management - Los tres grandes diego rivera - Cu dubh translation - Assignment - Critical academic writing and multilingual students - Deism/Naturalism Paper - The Role of the DNP Scholar in Preparing for Change - Keynows - Discussion 8 - Past life regression brisbane - Erecruit nsw health dates - Developement of New Drug - How to compute total magnification in microscope - Maximum probable yearly aggregate loss - British army driving school - Spector cultural diversity in health and illness - Fisher 2900 level controller - A paper on Mercedes Benz Vision AVTR Concept, Advanced technologies & impact on Automobile industry - This is what it means to say phoenix arizona theme