basic data munging and analysis questions to test your skills in understanding and interpreting a new data set

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

In this challenge, there are two parts:

1. **Data summarization** -- basic data munging and analysis questions to test your skills in understanding and interpreting a new data set, work with and combine data sources, and summarize results

2. **Open-ended recommendation** -- an open-ended question where you will develop recommendation about how to prioritize Chronic Kidney Disease (CKD) and End Stage Kidney Disease (ESKD) members for interventions to reduce inpatient admissions, and develop a 1-page executive summary to communicate your recommendation and any supporting data. 

### Data Summarization Questions

Please see below for additional detail on identifying CKD and ESKD members in the dataset.

* How many total CKD and ESKD members are there in the data across all years?  How many members are there by kidney disease stage (e.g., CKD Stage 1, CKD Stage 2, CKD Stage 3, CKD Stage 4, CKD Stage 5, and ESKD)?

* How many admissions did CKD and ESKD members have in 2019, by kidney disease stage?

* What was the total paid amount for admissions for CKD and ESKD members in 2019, by kidney disease stage?

* What are the most common co-morbid chronic conditions for CKD and ESKD members?  No need to break out by kidney disease stage. Chronic conditions may be identified using the flags on the beneficiary summary file.

### Open-ended Recommendation Question

Imagine you are tasked with developing a strategy to reduce inpatient admissions among the CKD and ESKD population.  In developing an effective inpatient admission reduction strategy, one of the keys is determining how to prioritize patients for targeted interventions by care team members. A wide variety of factors may be used for determining prioritization, and your job will be to make a recommendation about what factors should be used to prioritize members.

Please create a 1-page (maximum) executive summary describing your approach to prioritizing CKD and ESKD members for interventions to reduce inpatient admissions and the "why" behind your recommendation. You may include supporting data and charts on up to 2 additional pages, however these are strictly optional.

You are expected to use the included data to support your recommendation. You may also include additional subject area expertise or additional third-party research outside of the data to support your recommendation (e.g., literature, white papers, news articles, etc.) however you are not required to do so.

 

Attachments:

Expert's Answer

701 Times Downloaded

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