patterns in the data which could be used for informed
decision making and better patient care. For instance,
an important observation was the incorrect estimate
of length of stay and resources in acute care. This
results in unforeseen burden on the healthcare system.
To rectify this problem, a predictive model was built
to estimate the resources more accurately at the time
of admission. This provides a data-driven approach to
resource allocation. The quality of life metrics assist
in early detection of conditions thus affording the
opportunity for addressing situations before they
progress to an unmanageable state. The patient
journey gives a synopsis of the time and resources
that are required by patients as they transition from
homecare to long-term care.
ACKNOWLEDGEMENT
This research was funded by a grant from BC
Academic Health Science Network (AHSN) under
Strategy for Patient-Oriented Research (SPOR)
(Methods Cluster) and resulted in training of more
than a dozen HQPs. In addition, we acknowledge our
patient partners (B. Baker, G. Kramer, I. Muturi, S.
Prior, and C. Zannon) who remained engaged
throughout this research and provided valuable
feedback.
REFERENCES
Cepiou-Martin, M., Tam-Tham, H., Patten, S., Maxwell, C.
J., & Hogan, D. B. (2016, Apr.). Predictors of long-term
care placement in persons with dementia: A systematic
review and meta-analysis. International Journal of
Geriatric Psychiatry, 31(11), 1151-1171.
Cerner. (n.d.). Retrieved March 21, 2022, from
https://www.cerner.com/
Discharge Abstract Database Metadata (DAD). (n.d.).
Retrieved March 21, 2022, from https://www.
cihi.ca/en/discharge-abstract-database-metadata-dad/
Dixon, B. E., Grannis, S. J., Tachinardi, U., Williams, J. L.,
McAndrews, C., & Embi, P. J. (2020). Daily
Visualization of Statewide COVID-19 Healthcare Data.
2020 Workshop on Visual Analytics in Healthcare, 1-3.
Freeman, S., Hajime, K., Satoru, E., & Masahiro, K. (2009).
Understanding the Oldest Old in Northern Japan: An
Overview of the Functional Ability and Characteristics
of Centenarians. Geriatrics & Gerontology
International, 10(1), 78-84.
IBM. (n.d.). SPSS Modeler. Retrieved from http://www-
01.ibm.com/support/docview.wss?uid=swg27050406
IBM. (n.d.). Watson Studio. Retrieved from
https://cloud.ibm.com/catalog/services/watson-studio
interRAI. (n.d.). Speaking One Language for High Quality
Care Worldwide. Retrieved 4 2, 2022, from
https://interrai.org/
Khalifa, M., & Zabani, I. (2016). Utilizing health analytics
in improving the performance of healthcare services: A
case study on a tertiary care hospital. Journal of
Infection and Public Health, 9(4), 757-765.
McCormick Home. (n.d.). CIHI Quality Indicators.
Retrieved March 21, 2022, from https://www.
mccormickcaregroup.ca/mccormick-home/resident-
care/cihi-quality-indicators-nov-2016/
MEDITECH EMR Software. (n.d.). Retrieved March 21,
2022, from https://ehr.meditech.com/
Menon, A., Aishwarya, M. S., Joykutty, A. M., Av, A. Y.,
& Av, A. Y. (2021). Data Visualization and Predictive
Analysis for Smart Healthcare: Tool for a Hospital.
IEEE Region 10 Symposium, 1-8.
Microsoft. (n.d.). ASP.NET Overview. Retrieved May 19,
2022, from https://docs.microsoft.com/en-us/aspnet/
overview
Microsoft. (n.d.). SQL Server 2019. Retrieved May 19,
2022, from https://www.microsoft.com/en-ca/sql-
server/sql-server-2019
Microsoft. (n.d.). SQL Server Data Tools. Retrieved May
19, 2022, from https://docs.microsoft.com/en-
us/sql/ssdt/sql-server-data-tools?view=sql-server-
ver15
Microsoft. (n.d.). What is SQL Server Reporting Services.
Retrieved May 19, 2022, from https://docs.mic
rosoft.com/en-us/sql/reporting-services/create-deploy-
and-manage-mobile-and-paginated-reports?view=sql-
server-ver15
Monsen, K. A., Bae, S. -H., Zhang, W., & Radhakrishnan,
K. (2016, July). Visual analytics for pattern discovery
in home care. Applied Clinical Informatics, 7
(3), 711-
730.
Morris, J. N., Fries, B. E., Steel, K., Ikegami, N., Bernabei,
R., Carpenter, G. I., . . . Topinková, E. (1997).
Comprehensive Clinical Assessment in Community
Setting: Applicability of the MDS-HC. Journal of the
American Geriatrics Society, 45(8), 1017-1024.
Morris, J. N., Hawes, C., Fries, B. E., Phillips, C. D., Mor,
V., Katz, S., . . . Friedlob, A. S. (1990, June). Designing
the National Resident Assessment Instrument for
Nursing Homes. The Gerontologist, 30(3), 293-307.
Procura Home Health Software. (n.d.). Retrieved March
21, 2022, from https://www.alayacare.com/procura
QGIS. (n.d.). Retrieved May 19, 2022, from
https://qgis.org/en/site/