Create a filter that allows the selection of drug names and make it such a way that it will always display the top 20 drugs based on # of claims.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Task 1:

• Display top 20 drugs, sorted by # of claims.
• Which drug has the maximum numbers of claims and what was the # of the proportion of the claims in %?
• Create a filter that allows the selection of drug names and make it such a way that it will always display the top 20 drugs based on # of claims.
• On the tooltip display important information such as Drug Name, Beneficiary Count, Total Drug Cost, Total Claim Count, Cost Per Patient, Cost Per Claim
• Display numerical values to the appropriate format (e.g. currency with $, values in thousands or millions, percentage with %).

Task 2:

• Create a chart similar to above but use total drug cost instead of # of claims.
• Which drug was responsible for incurring the highest cost and how much?
• Filters, tooltip and numerical value formats should look similar to the previous view.

Tableau Rubric

Task 1	a	1
	b	.5
	c	.5
	d	.5
	e	.5
Task 2	a	1
	b	.5
	c	.5

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. 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

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme