Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review
Background: Previously, our hospital manually built a static antibiogram from a surveillance system (VigiLanz) culture report. In 2019, a collaboration between the antimicrobial stewardship team (AST) and the infection control (IC) team set out to leverage data automation to create a dynamic antibio...
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Cambridge University Press
2023-06-01
|
| Series: | Antimicrobial Stewardship & Healthcare Epidemiology |
| Online Access: | https://www.cambridge.org/core/product/identifier/S2732494X23002620/type/journal_article |
| _version_ | 1797670832576659456 |
|---|---|
| author | Ashley Dauphin Christopher McCoy Robert Bowden Matthew Lee Howard Gold Ryan Chapin |
| author_facet | Ashley Dauphin Christopher McCoy Robert Bowden Matthew Lee Howard Gold Ryan Chapin |
| author_sort | Ashley Dauphin |
| collection | DOAJ |
| description | Background: Previously, our hospital manually built a static antibiogram from a surveillance system (VigiLanz) culture report. In 2019, a collaboration between the antimicrobial stewardship team (AST) and the infection control (IC) team set out to leverage data automation to create a dynamic antibiogram. The goal for the antibiogram was the ability to easily distribute and update for hospital staff, with the added ability to perform advanced tracking and surveillance of organism and drug susceptibilities for AST and IC. By having a readily available, accurate, and Clinical and Laboratory Standards Institute (CLSI)–compliant antibiogram, clinicians have the best available data on which to base their empiric antibiotic decisions. Methods: First, assessment of required access to hospital databases and selection of a visualization software (MS Power BI) was performed. Connecting SQL database feeds to Power BI enabled creation of a data model using DAX and M code to comply with the CLSI, generating the first isolate per patient per year. Once a visual antibiogram was created, it was validated against compiled antibiograms using data from the microbiology laboratory middleware (bioMerieux, Observa Integrated Data Management Software). This validation process uncovered some discrepancies between the 2 reference reports due to cascade reporting of susceptibilities. The Observa-derived data were used as the source of truth. The antibiogram prototype was presented to AST/IC members, microbiology laboratory leadership, and other stakeholders to assess functionality. Results: Following feedback and revisions by stakeholders, the new antibiogram was published on a hospital-wide digital platform (Fig. 1). Clinicians may view the antibiogram at any time on desktops from a firewall (or password)–protected intranet. The antibiogram view defaults to the current calendar year and users may interact with the antibiogram rows and columns without disrupting the integrity of the background databases or codes. Each year, simple refreshing of the Power BI antibiogram and changing of the calendar year allows us to easily and accurately update the antibiogram on the hospital-wide digital platform. Conclusions: This interdisciplinary collaboration resulted in a new dynamic, CLSI-compliant antibiogram with improved usability, increased visibility, and straightforward updating. In the future, a mobile version of the antibiogram may further enhance accessibility, bring more useful information to providers, and optimize AST/IC guidelines and education. |
| first_indexed | 2024-03-11T21:05:21Z |
| format | Article |
| id | doaj.art-1189b10c95c34b56a42d227300ff9482 |
| institution | Directory Open Access Journal |
| issn | 2732-494X |
| language | English |
| last_indexed | 2024-03-11T21:05:21Z |
| publishDate | 2023-06-01 |
| publisher | Cambridge University Press |
| record_format | Article |
| series | Antimicrobial Stewardship & Healthcare Epidemiology |
| spelling | doaj.art-1189b10c95c34b56a42d227300ff94822023-09-29T12:56:57ZengCambridge University PressAntimicrobial Stewardship & Healthcare Epidemiology2732-494X2023-06-013s34s3410.1017/ash.2023.262Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual reviewAshley DauphinChristopher McCoyRobert BowdenMatthew LeeHoward GoldRyan ChapinBackground: Previously, our hospital manually built a static antibiogram from a surveillance system (VigiLanz) culture report. In 2019, a collaboration between the antimicrobial stewardship team (AST) and the infection control (IC) team set out to leverage data automation to create a dynamic antibiogram. The goal for the antibiogram was the ability to easily distribute and update for hospital staff, with the added ability to perform advanced tracking and surveillance of organism and drug susceptibilities for AST and IC. By having a readily available, accurate, and Clinical and Laboratory Standards Institute (CLSI)–compliant antibiogram, clinicians have the best available data on which to base their empiric antibiotic decisions. Methods: First, assessment of required access to hospital databases and selection of a visualization software (MS Power BI) was performed. Connecting SQL database feeds to Power BI enabled creation of a data model using DAX and M code to comply with the CLSI, generating the first isolate per patient per year. Once a visual antibiogram was created, it was validated against compiled antibiograms using data from the microbiology laboratory middleware (bioMerieux, Observa Integrated Data Management Software). This validation process uncovered some discrepancies between the 2 reference reports due to cascade reporting of susceptibilities. The Observa-derived data were used as the source of truth. The antibiogram prototype was presented to AST/IC members, microbiology laboratory leadership, and other stakeholders to assess functionality. Results: Following feedback and revisions by stakeholders, the new antibiogram was published on a hospital-wide digital platform (Fig. 1). Clinicians may view the antibiogram at any time on desktops from a firewall (or password)–protected intranet. The antibiogram view defaults to the current calendar year and users may interact with the antibiogram rows and columns without disrupting the integrity of the background databases or codes. Each year, simple refreshing of the Power BI antibiogram and changing of the calendar year allows us to easily and accurately update the antibiogram on the hospital-wide digital platform. Conclusions: This interdisciplinary collaboration resulted in a new dynamic, CLSI-compliant antibiogram with improved usability, increased visibility, and straightforward updating. In the future, a mobile version of the antibiogram may further enhance accessibility, bring more useful information to providers, and optimize AST/IC guidelines and education.https://www.cambridge.org/core/product/identifier/S2732494X23002620/type/journal_article |
| spellingShingle | Ashley Dauphin Christopher McCoy Robert Bowden Matthew Lee Howard Gold Ryan Chapin Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review Antimicrobial Stewardship & Healthcare Epidemiology |
| title | Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review |
| title_full | Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review |
| title_fullStr | Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review |
| title_full_unstemmed | Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review |
| title_short | Creating an electronic antibiogram using visualization software: Easily updatable and removes the need for yearly manual review |
| title_sort | creating an electronic antibiogram using visualization software easily updatable and removes the need for yearly manual review |
| url | https://www.cambridge.org/core/product/identifier/S2732494X23002620/type/journal_article |
| work_keys_str_mv | AT ashleydauphin creatinganelectronicantibiogramusingvisualizationsoftwareeasilyupdatableandremovestheneedforyearlymanualreview AT christophermccoy creatinganelectronicantibiogramusingvisualizationsoftwareeasilyupdatableandremovestheneedforyearlymanualreview AT robertbowden creatinganelectronicantibiogramusingvisualizationsoftwareeasilyupdatableandremovestheneedforyearlymanualreview AT matthewlee creatinganelectronicantibiogramusingvisualizationsoftwareeasilyupdatableandremovestheneedforyearlymanualreview AT howardgold creatinganelectronicantibiogramusingvisualizationsoftwareeasilyupdatableandremovestheneedforyearlymanualreview AT ryanchapin creatinganelectronicantibiogramusingvisualizationsoftwareeasilyupdatableandremovestheneedforyearlymanualreview |