Name the sub-category whose profit value is least (lowest) in the year 2022

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1) Name the sub-category whose profit value is least (lowest) in the year 2022

2) Who are 25th, 50th and 100th customers from top with respect to sum of sales in 2021?

3) Show the Top 3 products with respect to sum of quantity under each segment (Total 9 products) in West region.

4) Create new order date (e.g. if current year is 2023 then make sure new order date should have 2023) and show below columns in the text table.

• Year

• Quarter

• Month

• SUM(Sales)

• YTD Sales

• QTD Sales

• MTD Sales

5) Show sub-category and region wise sum of profit in KPI indicator table as shown in below image. Use green circle for positive profit value and red circle for negative profit value.

 

6) Crete a table with customer name, first order date and last order date for each customer.

 

7) Create a pie chart showing Top 50 customers Vs Other customers with respect to sum of sales shown in below image.

 

8) Create a table with columns such as category, sub-category in rows and region in columns with total sales and total profit shown for each region along with grand total and percent of pane total sorted by sum of sales in descending manner as shown in below image.

 

9) Create the parameter with name as View by. Use three values in parameter i.e. Region, Category and Sub-category. If user selects any value then show the sum of sales with respect to the value chosen in parameter as a bar chart. E.g., If user selects category then show category wise sales. Make sure to edit the worksheet title w.r.t. View by value.

10) Show the Top N customers with respect to sum of quantity. The value N should be user-entered. Edit the title accordingly.

11) Answer in brief.

• What is Replace References in tableau?

• How to handle the NULL values for measures?

 

 

12) Analyse the purchasing capacity of customers by creating the bins of sales with bins size as 10. Show the bar chart of count of sales vs bins. The labels outside the bar chart should be shown in this format: 1,398 (13.7%). Note that if any count of sales value is blank/null value then the bar chart should show 0

 

13) Show the country wise, region wise, state wise and city wise sum of sales in a table by creating the hierarchy starting with country. Colour the sum of sales based on following conditions.

 

• Green: Values > 100000

• Orange: Between 10000 and 100000

• Red: Values < 10000

 

14) Make a group of Acco, 3M, Samsung, Apple, Xerox products. (For remaining products include in others folder). Display each group as average discount percentage.

 

15) Show the average sales for each year and each month. Show the overall average sales of all the months using reference line and highlight those months for which the sales value is more than overall average sales value.

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of