Consider the two (2) scenarios below, and then write a 1-2 page paper using proper spelling/grammar, addressing the items below each scenario.Scenario 1Dr. Crunch is a busy orthopedist. He is increasingly challenged by his practice because he keeps working harder and still has some cash flow challenges. Dr. Crunch therefore asks a data analyst to prepare reports for his review to include:A table of his “Top 20 Procedures” – the high volume procedure codes he performed over the past 12 months.Total dollar payments received broken down by those procedures.
Based on the information provided in Scenario 1 above, address the items below:What data sources and/or data systems would you suggest that an analyst might consult to generate these reports? Briefly explain your recommendations and be as specific as possible.When Dr. Crunch gets the report, give two (2) examples of ways you think he could use the information to restructure his practice and be sure to consider comparisons with local, regional, and national data for other orthopedists.Scenario 2 Dr. Serena is a Dermatologist. She serves a varied patient clientele, both young and old. She is curious about certain skin cancer cases she has been seeing, and she is wondering if the rates differ by age group. She has asked her analyst to extract a table listing all patients she treated for skin cancers (over past 3 years) that includes:Female or maleSmoking statusAgeZip code and city of residenceSingle vs. married
Based on the information provided in Scenario 2 above, address the items below:Describe what kinds of data tables or databases would contain the information requested for Dr. Serena. Briefly explain why you chose those particular databases or tables. Be as specific as possible.Explain how the doctor could use this information in her practice in at least two (2) ways and be sure to consider quality of care, patient safety, and dermatology comparison data.