Hostname: page-component-848d4c4894-sjtt6 Total loading time: 0 Render date: 2024-06-22T01:55:01.688Z Has data issue: false hasContentIssue false

401 Creating a Dashboard to Increase Efficiency in Tracking and Reporting on Research Data Requests

Published online by Cambridge University Press:  24 April 2023

Abigail Nerogic
Affiliation:
Wake Forest School of Medicine
Virginia Lawson
Affiliation:
Wake Forest School of Medicine
Larisa Rodgers
Affiliation:
Wake Forest School of Medicine
Rights & Permissions [Opens in a new window]

Abstract

Core share and HTML view are not available for this content. However, as you have access to this content, a full PDF is available via the ‘Save PDF’ action button.

OBJECTIVES/GOALS: The purpose of the project was to create a Tableau dashboard to track metrics on requests for research data at Atrium Health Wake Forest Baptist. The objectives included: 1) define and identify request fulfillment metrics, 2) build a dashboard to capture metrics, and 3) integrate the dashboard into metrics tracking and reporting activities. METHODS/STUDY POPULATION: Project managers and team leaders in the Office of Informatics collaborated to determine which measures would be most relevant and impactful to report on. Metrics that were collected included: total count of tickets fulfilled over time, number of tickets currently open, sum of outstanding quoted hours, quoted hours vs. actual hours needed to fulfill ticket, and hours billed. Tableau's direct connection feature was used to extract the Trac ticket data from its Postgres database and the dashboard was published to Tableau Server. After the initial draft was created, several rounds of revisions were made as new data insights were discovered through further investigation of the data. RESULTS/ANTICIPATED RESULTS: Each morning, Tableau Server runs an automatic refresh of the data. On the dashboard homepage, users can see a quick view of all available metrics; to minimize noise, only the current statuses, active tickets, and stats for the most recent monitoring periods are displayed. Many of the charts give the user the option to link out to a page with related supplemental information (historic data, ticket status history, etc.). With the help of the dashboard, project managers and team leaders can now monitor how long tickets are in each status, increase quote accuracy using the hours quoted and hours billed charts, and examine ticket complexity over time. DISCUSSION/SIGNIFICANCE: Prior to dashboard creation, metrics were sparse and difficult to assemble. By providing information on the quantity, size, and complexity of data requests, the dashboard enables the Office of Informatics to monitor how the process is functioning overall, make informed decisions about resource allocation, and provide quick interventions.

Type
Research Management, Operations, and Administration
Creative Commons
Creative Common License - CCCreative Common License - BYCreative Common License - NCCreative Common License - ND
This is an Open Access article, distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives licence (https://creativecommons.org/licenses/by-nc-nd/4.0/), which permits non-commercial re-use, distribution, and reproduction in any medium, provided the original work is unaltered and is properly cited. The written permission of Cambridge University Press must be obtained for commercial re-use or in order to create a derivative work.
Copyright
© The Author(s), 2023. The Association for Clinical and Translational Science