What is the average qty in an order and the average cost

Assignment Help Computer Engineering
Reference no: EM133550646

Question: Using the data source that you built in Tableau Exercise 2, create visualizations to answer the following questions using Tableau.  For each task, create only a single visualization.  Each task is worth 6 points, 3 of which will be awarded for the correct choice of chart.

  1. What is the average Qty in an order and the average Cost of an order for each product?  The visualization should be dual axis.
  2. I am interested in comparing average cost, average gross revenue, and average net revenue for each Month and Year.  I am for example interested in seeing the difference between September 2020 and March 2021.   I should be able to change the chart by Product Name.  Use a filter, rather than a parameter.
  3. What is the average CostNet Revenue and Gross Revenue by the actual Order Date?
  4. Use a pages animation to animate the chart you created in step 2.  Make sure the animation shows the figures by Month and Year.
  5. Use a pages animation to animate the chart you created in step 3.  Make sure the animation shows the figures by the actual date of the order.
  6. What is the Total Net Revenue for Suppliers in United Kingdom and the US, and what is the contribution of each supplier to the total?
  7. What is the relationship between total cost and total net revenue for each customer?  Make sure I can easily see which customer company the information is for.  I should be able to interactively change the information by order year.  Give the worksheet with this visualization a meaningful name.
  8. What are the average cost, average net revenue, and average order gross revenue for each product and which country is the product is supplied from?  Make sure I can easily see which product the information is for.  Give the worksheet with this visualization a meaningful name.
  9. Create a parameter and a calculated field, Financial Measure, to allow the user to change the financial measure (CostGross Revenue, Net Revenue)
  10. Use a map that shows Financial Measure by Country.  The map should also include the parameter that you used in calculating the Financial Measure so that I can change the Financial Measure that is displayed on the map.

Reference no: EM133550646

Questions Cloud

List predictors of late onset generalized anxiety disorder : List 4 predictors of late onset generalized anxiety disorder. List 4 potential neurobiology causes of psychotic major depression.
Describe three complications of cancer : Describe at least three complications of cancer, the side effects of treatment, and methods to lessen physical and psychological effects.
What issues are you considering for your clinical project : Discuss specific examples of never events and their impact in your workplace. What issues are you considering for your clinical project and why?
Develop a to-do list application that allows users to add : Develop a to-do list application that allows users to add, delete, and mark tasks as completed. Implement data storage using SQLite database
What is the average qty in an order and the average cost : What is the average Qty in an order and the average Cost of an order for each product? The visualization should be dual axis
How long have you had cramps-abdominal pain and spotting : Why would you ask a pregnant woman How long have you had cramps, abdominal pain, and spotting?
Analyze your leaderships skill based on your self-assessment : Analyze your leadership's skills based on your self-assessment. C. Identify strengths and opportunities for improvement based on your self-assessment.
Compute the cube of each number and the sum of the cube : Output should be the sum of the cubes. For example if the user enters 3, the computer would sum 1 X 1 X1+ 2 X 2 X 2 + 3 X3 X 3 in the loop.
How does your competency level compare to self-assessment : Regarding the Post-TANIC Self-Assessment, how does your competency level compare to the Self-Assessment?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Give sign that could be mounted outside the store

give sign that could be mounted outside the store

  Save the punch in or punch out date

Display an input field called "Choice" to input one of the four options - Inputting an incorrect option shall display a prompt indicating that the input was invalid and to try again.

  Define ideas to prevent an administrator from hijacking

Software licensing is a major problem in cloud computing. In a 3 to 4 page paper come up with several ideas to prevent an administrator from hijacking.

  Design an epm system around flexible or inflexible elements

Is it best to design an EPM system around flexible or inflexible elements? Generally, when first developing an EPM system, do companies prefer to use formality.

  What role does reasoned paranoia play in the minded and

what is the mindset required to properly protect information? what role does reasoned paranoia play in the minded and

  Discuss suggestion for integrating coso framework compliance

The COSO framework of internal controls is practiced within companies around the world. The objectives of the COSO framework are closely related to its five.

  What are the critical aspects involved in problem definition

What are the critical aspects involved in problem definition? What are problem statements for the two Dead Fish Examples? Discuss how you arrived

  CMP4267 Computer Systems Assignment

CMP4267 Computer Systems Assignment Help and Solution, Birmingham City University - Assessment Writing Service

  Operate and perform simple os administration

Demonstrate competency in the use of a command line interface to operate and perform simple OS administration and Create programs based on incremental

  Explain how you would assess operating system requirements

Explain how you would assess the operating system requirements for virtualization if the organization wanted to virtualize 25% of physical stand-alone servers.

  What security methodologies can an organization apply

Do you believe such tools in the enterprise offer work productivity and efficiency? What security methodologies, including blockchain can an organization apply.

  Explain how you would protect against intrusion attempts

In today's world, both government and the private sector are struggling to provide a secure, efficient, timely, and separate means of delivering.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd