User login
BACKGROUND
As of May 2023, the Veterans Affairs (VA) National Precision Oncology Program (NPOP) has provided somatic molecular testing for nearly 36,000 Veterans with cancer. Automated tools to monitor test use (locally and nationally) have only been available for NGS testing in advanced stage lung and prostate cancer. To better track utilization of NPOP supported testing across all cancer indications, and to support strategies to promote wider adoption, we developed an automated data architecture to monitor program operations. Here, we describe the development of the NPOP data mart and summarize the core components of the NPOP Somatic Molecular Testing dashboards.
METHODS
SQL Server Integration Services was used to build the backend data mart, which required the ingestion of vendor-specific XML data and subsequent harmonization with data found in the VA’s Corporate Data Warehouse (CDW). The NPOP somatic testing dashboards, developed using Power BI, are securely hosted in the cloud, and accessible through SharePoint.
DATA ANALYSIS
The NPOP dashboard suite displays key measures using descriptive statistics, including counts, proportions, means, medians, and standard deviations. To support the visualization of comparisons we leveraged stacked and clustered bar charts, and violin plots.
RESULTS
The NPOP data mart refreshes nightly providing users with near real-time data. The NPOP somatic testing dashboards include an all vendor combined report and sub-reports organized by vendors: Foundation Medicine, Personalis, and Personal Genome Diagnostics and Tempus. All reports contain four views with the ability to toggle between tests ordered or completed. For current NPOP vendors, patient level data and turnaround time views were developed. Data are stratified by test category (i.e., NGS Solid, NGS Liquid, Heme, IHC) and can be viewed longitudinally (i.e., across time) and filtered by test date, VA facility, patient demographics, and cancer characteristics (diagnosis, stage). To date, over 50,000 tests have been ordered (90% through Foundation Medicine).
IMPLICATIONS
The NPOP data mart and operational dashboards synthesizes vast amounts of data into a visually consumable format that supports monitoring the uptake and variation of somatic molecular testing services being offered across the VA.
BACKGROUND
As of May 2023, the Veterans Affairs (VA) National Precision Oncology Program (NPOP) has provided somatic molecular testing for nearly 36,000 Veterans with cancer. Automated tools to monitor test use (locally and nationally) have only been available for NGS testing in advanced stage lung and prostate cancer. To better track utilization of NPOP supported testing across all cancer indications, and to support strategies to promote wider adoption, we developed an automated data architecture to monitor program operations. Here, we describe the development of the NPOP data mart and summarize the core components of the NPOP Somatic Molecular Testing dashboards.
METHODS
SQL Server Integration Services was used to build the backend data mart, which required the ingestion of vendor-specific XML data and subsequent harmonization with data found in the VA’s Corporate Data Warehouse (CDW). The NPOP somatic testing dashboards, developed using Power BI, are securely hosted in the cloud, and accessible through SharePoint.
DATA ANALYSIS
The NPOP dashboard suite displays key measures using descriptive statistics, including counts, proportions, means, medians, and standard deviations. To support the visualization of comparisons we leveraged stacked and clustered bar charts, and violin plots.
RESULTS
The NPOP data mart refreshes nightly providing users with near real-time data. The NPOP somatic testing dashboards include an all vendor combined report and sub-reports organized by vendors: Foundation Medicine, Personalis, and Personal Genome Diagnostics and Tempus. All reports contain four views with the ability to toggle between tests ordered or completed. For current NPOP vendors, patient level data and turnaround time views were developed. Data are stratified by test category (i.e., NGS Solid, NGS Liquid, Heme, IHC) and can be viewed longitudinally (i.e., across time) and filtered by test date, VA facility, patient demographics, and cancer characteristics (diagnosis, stage). To date, over 50,000 tests have been ordered (90% through Foundation Medicine).
IMPLICATIONS
The NPOP data mart and operational dashboards synthesizes vast amounts of data into a visually consumable format that supports monitoring the uptake and variation of somatic molecular testing services being offered across the VA.
BACKGROUND
As of May 2023, the Veterans Affairs (VA) National Precision Oncology Program (NPOP) has provided somatic molecular testing for nearly 36,000 Veterans with cancer. Automated tools to monitor test use (locally and nationally) have only been available for NGS testing in advanced stage lung and prostate cancer. To better track utilization of NPOP supported testing across all cancer indications, and to support strategies to promote wider adoption, we developed an automated data architecture to monitor program operations. Here, we describe the development of the NPOP data mart and summarize the core components of the NPOP Somatic Molecular Testing dashboards.
METHODS
SQL Server Integration Services was used to build the backend data mart, which required the ingestion of vendor-specific XML data and subsequent harmonization with data found in the VA’s Corporate Data Warehouse (CDW). The NPOP somatic testing dashboards, developed using Power BI, are securely hosted in the cloud, and accessible through SharePoint.
DATA ANALYSIS
The NPOP dashboard suite displays key measures using descriptive statistics, including counts, proportions, means, medians, and standard deviations. To support the visualization of comparisons we leveraged stacked and clustered bar charts, and violin plots.
RESULTS
The NPOP data mart refreshes nightly providing users with near real-time data. The NPOP somatic testing dashboards include an all vendor combined report and sub-reports organized by vendors: Foundation Medicine, Personalis, and Personal Genome Diagnostics and Tempus. All reports contain four views with the ability to toggle between tests ordered or completed. For current NPOP vendors, patient level data and turnaround time views were developed. Data are stratified by test category (i.e., NGS Solid, NGS Liquid, Heme, IHC) and can be viewed longitudinally (i.e., across time) and filtered by test date, VA facility, patient demographics, and cancer characteristics (diagnosis, stage). To date, over 50,000 tests have been ordered (90% through Foundation Medicine).
IMPLICATIONS
The NPOP data mart and operational dashboards synthesizes vast amounts of data into a visually consumable format that supports monitoring the uptake and variation of somatic molecular testing services being offered across the VA.