You are a newly appointed CEO for a regional hospital near San Diego. Turns out the hospital is struggling with low days cash on hand, high staff turnover, increased LOS, high readmissions, increasing costs, process inefficiencies and poor quality among other issues. Appy analytical results from a HCAI dataset to make a decision/provide solution for one problem at your hospital to attempt to turn things around.
Some considerations:
What data is available on the HCAI website?
What does HCAI stand for and what was the prior name?
What data topics are available? Hint: https://hcai.ca.gov/data-and-reports/Links to an external site.
What questions can these data answer and how does it facilitate decision making?
What additional data would you request from your data team and how would you ensure high data quality of the raw data and quality of the analysis? What should the team do with erroneous or outlier data?
Please include attached excel file with formatted analysis / dashboard and/or tableau along with summary of analysis and recommendations. Suggested to provide descriptive statistics, inferential statistics, data formatting, charts and conclusions. Be sure to include specific source citation of your data and any data manipulations.