I have database of 78706 resident incidents in aged care facilities (5 years of data). I want to to learn and implement a tool allowing analyzing these data using following attributes:
- Resident
- Date/Time
- Location
- Result
- Injury
I want to be able to get following assumptions from my system which will be passed to specialists for further research, decision making and action:
Examples of outputs:
- Most of incidents in facility A with residents X, Y and Z
- Falls occur in North Wing between 2am and 5am
- Skin tears happen during showering in facility B
- Most incidents in a facility C related to repositioning
My question is not what software package can help me but what type of statistical analysis solves this problem - regression, cluster etc.
Can you recommend some practical books for a starter too?