Question
Using the data source that you built in module 3, create visualizations using Tableau to answer the following questions. 1. What is the average Qty
Using the data source that you built in module 3, create visualizations using Tableau to answer the following questions.
1. What is the average Qty in an order and the average Gross Revenue 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. I am for example interested in seeing the difference between September and March. I should be able to change the chart by Product Name. Use a filter, rather than a parameter.
3. What is the average Cost, Net 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.
5. Use a pages animation to animate the chart you created in step 3, use OrderDate as the basis for the animation, but make sure the animation shows the figures by the actual date of the order.
6. What is the Total Net Revenue for Suppliers in Jamaica and Italy, and what is the contribution of each supplier to the total?
7. What is the relationship between average cost and average net revenue for each customer? Make sure I can easily see which customer 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 (Cost, Gross 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started