SQL query interview question

Closed Posted 1 year ago Paid on delivery
Closed

Logistics: The following slides give brief background to the case and outline an analytic task. You should also have received an Excel file containing supporting data for your analysis. Please notify us immediately if you are missing the Excel file or encounter any technical difficulties. You will complete this task on your own time and will discuss your response with your interviewer the next day. Please email us your response ahead of your interview. Things to note: This case will primarily assess your analytic and coding skills, but it’s also designed to be fun and informative to help you better understand the work we do on a regular basis. You will have a full day to complete the task at your own pace; however, the task is designed to be completed in ~1 hour. Please do not feel compelled to spend significantly more time. We cannot guarantee real-time responses to content or analytics questions you may have about the case. We advise that you make reasonable assumptions and explain your assumptions to your interviewer. BMC values integrity: Please ensure that your work is your own. This is a simulation of a task you would be expected to complete with minimal guidance upon arrival at BMC. However, you are free to consult outside references (websites, textbooks) to aid in your analysis (this would be true in the job, too!) but note that you will have to explain your process, findings, and code to an interviewer. Our Medical Director wants to design an initiative to address the high inpatient spend we observe and close our medical expense deficit. She has come to you for more insight on our inpatient stays. Specifically, she has requested the following (your task): Among the inpatient (IP) stays1, design and conduct an analysis specifically for ACO members to: Perform descriptive analysis of the inpatient stays for ACO members and the ACO members themselves Identify the cost drivers2 of the inpatient stays for ACO members Calculate the readmission rate (readmission definition: an admission that occurs within a 30 day period after a prior inpatient discharge) for the ACO [Optional: identify any statistically significant disparities you observe in the data, if any] For the descriptive analysis and cost drivers, she has left the choice of variables up to you to determine what is most important In the Excel file that accompanies these slides, we have provided a (sample) medical claims dataset containing information on inpatient stays for members across multiple products (includes ACO and non-ACO) and a roster of ACO members Please choose a coding language (e.g. R, SAS, SQL, etc) and write down your code. Note: you are free to use Excel to complete the analysis, but you must write up the code you would have used in your software of choice Output your findings into tables or charts to present to your interviewer

SQL Database Administration MySQL Statistics Database Programming

Project ID: #36153559

About the project

11 proposals Remote project Active 11 mos ago

11 freelancers are bidding on average £4/hour for this job

AbdulBasitAli045

Dear Client. When it comes to your project, i am expert. I will provide you 100% satisfaction work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accurately and More

£4 GBP / hour
(85 Reviews)
5.5
maverickindia

Hi there! My name is Nikhil and I'm from Indore, India. I understand you need a writer capable of doing this task and I'm confident that my team is the perfect fit for the job. With 18 experienced members and extensive More

£5 GBP / hour
(14 Reviews)
4.6
Valuesolutions

‌Hello, ‌ ‌I hope this finds you well. I have just seen your project requiring; ‌ ‌I believe that my 8-year experience in this field is what you need right away. Avoid the headache of looking further. ‌ ‌Let's save tim More

£4 GBP / hour
(12 Reviews)
4.7
ExpertLive

SQL query interview question I have Master degree with 6 years of writing experience and I can manage thousands of words with "Premium Quality" on daily basis, I will provide you Turnitin report as a guarantee of plagi More

£4 GBP / hour
(1 Review)
1.9
soniayt7

Hhi I am experienced in this and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy

£4 GBP / hour
(1 Review)
1.3
sersebasti

Ok - l would like to take the test. If you agree please let me know date time you will send me the test and I will let you know if I can be available. Regards - Sergio

£4 GBP / hour
(0 Reviews)
0.0
CRATIC

I really like SQL I'll know to figure it I am specialist a few years with ORACLE, POSTGRESS SQL AND MYSQL

£4 GBP / hour
(0 Reviews)
0.0
nikisolanki22

I am having proficiency in writing query. I am having experience in working with postgre sql. I wanna work with database and it seems interesting after reading the description.

£3 GBP / hour
(0 Reviews)
0.0
fkaifee3

I have a working of 4 years in data analytics field in top MNC Companies. Hands On experience with real time data supported with complete analysis to granular level

£4 GBP / hour
(0 Reviews)
0.0
Haaljarrah19

Welcome I have certification in mysql ind i can work with you and provide help you can contact me for more information

£4 GBP / hour
(0 Reviews)
0.0
greatpawan

I am currently working as a data analyst. writing SQL queries is my day-to-day job. I have a total experience of 2 years since day 1 i am writing SQL queries.

£3.92 GBP / hour
(0 Reviews)
0.0