Like most organizations, The Children's Hospital of Philadelphia (CHOP) generates a lot of data of varying types, from clinical to staffing and operations. However, these datasets are separated, preventing effective analytics. To improve workforce management and care delivery, CHOP's Nursing department collaborated with the Data & Analytics team to create a dashboard-based platform for analyzing workforce metrics and patient outcomes, aiding nursing leaders in decision-making. This project involved multiple phases with contributions from Nursing, Data & Analytics, CHOP's Data Trust Office, and Human Resources. Key performance indicators were identified, and a variety of data sources were aggregated to provide a comprehensive view of the nursing enterprise. The resulting platform offers automated, current, and reliable analytics on various aspects, including nursing demographics, education, survey results, staffing actuals by job group, and patient and family experience data. The platform's usability was assessed using a modified Health Information Technology Usability Evaluation Scale survey, with a 29% response rate primarily from senior directors and managers. The findings showed high usability and satisfaction, indicating the dashboard is a valuable decision-support tool. Lessons learned include the need for analytics education for nurses and mid-managers, the inclusion of critical nursing-specific metrics (and development of the data pipelines making them possible), and the integration of multidisciplinary team metrics for comprehensive nursing analytics.
Keywords: Analytics; Business Intelligence; Dashboard; Decision-Making; Nursing; Usability.