phone icon 781.329.4300  ¦  Message us  ¦ Customer support login

Case Study: Power BI at NVRH


hospital logo

Power BI is the latest enterprise business intelligence platform from Microsoft. With Power BI's beautiful and dynamic data visualization tools, unlock the informatics potential of MEDITECH Data Repository in ways not before possible. To learn more, read our case study from Northeastern Vermont Regional Hospital, who use Power BI with their MEDITECH Expanse system.

Case Study: Conversion to Expanse

  anderson hospital logo

 

Background

Anderson Healthcare has served the Illinois communities of Madison and Macoupin counties since 1977 and continues its commitment to providing residents with the highest quality of advanced medical care. A 154-bed inpatient hospital, critical access hospital, rehab institute, surgery center and outpatient acute care facility offer patients cutting-edge medical diagnostics that are not often found in a local community setting using the MEDITECH Expanse electronic health record platform.

Situation

The leadership at Anderson Healthcare committed to upgrading their MEDITECH EHR to the Expanse platform in 2018. Having been on Client/Server for nearly 20 years, they had created a large inventory of NPR and Data Repository SQL reports that would be affected by the new data architecture in Expanse. Early in the process, Anderson Hospital recognized that they did not employ the necessary resources to rewrite their comprehensive library of reports.

Assessment

Anderson Healthcare has been an Acmeware Partnership Program client since 2010, and a OneView Quality Reporting customer since 2013. When Anderson determined that they needed outside assistance to develop the new reports, they turned to their trusted partner Acmeware. Using OneTrac, their proprietary report inventory and project management tool to identify and prioritize the data objects that would need updating, Acmeware evaluated 2,619 reports and data objects for conversion to Expanse. During the prioritization process we determined that 152 reports could be retired with the remainder needing to be rewritten for Expanse. 

Results

Starting in January 2019 and working through December 2020, all the NPR and Data Repository reports and stored procedures were rewritten. While Acmeware was initially engaged to convert over 1,700 DR SQL stored procedures, another third-party resource was employed to convert the 858 NPR reports. By May of 2020, Anderson decided their NPR resource was not meeting their expectations and Acmeware was asked to finish the NPR report conversions. Acmeware’s expertise and catalog of existing reports resulted in fast and accurate deployment of the complete library of new reports ahead of the Expanse go-live and on budget.

 


mike ward 100x100

While we work with many vendors, Acmeware has come to be a true partner. Since 2013, they've been an integral part of our IS department through their Partnership Program. Their Data Repository expertise has been invaluable.

– Mike Ward, Anderson Hospital Chief of IT

Case Study: Data Repository Services

beth israel lahey health
 
Background

In March 2019, Beth Israel Lahey Health was formed by the merger of Lahey Health and Beth Israel Deaconess Medical Center, serving Boston and the greater Boston area. The BID Community Hospitals (composed of Beth Israel Deaconess Hospitals in Milton, Needham, and Plymouth) long-time MEDITECH systems, upgraded to Expanse in late 2018, and then in the fall of 2020 implemented MEDITECH’s Ambulatory product. Beth Israel Deaconess Community Hospitals (now part of Beth Israel Lahey Health) have been clients of Acmeware since 2013 when Milton Hospital engaged Acmeware for Partnership Program support and for OneView (quality reporting) in 2014.

Situation

When it came time for the Community Hospitals to augment the database administrator services that are critical to operations, BID elected to leverage their Acmeware Partnership Program and entrust Acmeware to focus on the health of their MEDITECH Data Repository and reporting services.

After the conversion to Expanse, BID began experiencing disk space problems. In our experience, initial reporting environment setup performed by third party vendors frequently results in suboptimal configuration, requiring post-implementation reconfiguration and corrective action to optimize the client’s reporting environment, including the Data Repository. 

Assessment

Upon investigating BID’s systems, Acmeware found the disk capacity and associated issues were due to improper setup of their DR server which required correction to avoid potential negative operational impact. Acmeware informed BID of the cause of the problem and the potential long-term impact if no action were taken, along with specific corrective action recommendations. We then developed a plan to work collaboratively to remediate the issues, including changing properties of drives, reorganizing types of files in accordance with MEDITECH best practices, and planning for associated downtime.

Results

BID Community hospitals have a strong IT staff that relies on Acmeware’s depth of database and server administration experience to supplement their capabilities and bandwidth. The space remediation plan was successfully implemented by BID and Acmeware staff, resulting in the optimization of the reporting services and servers. BID is pleased with Acmeware’s Data Repository support and ongoing maintenance services, and Acmeware continues to monitor and safeguard the DR and reporting environment.


jeanette currie

We are thrilled with our partnership with Acmeware. Data and analytics are key to our business and our ability to provide top quality healthcare to our communities. So many people rely on timely and accurate data, it is a foundational part of our Information Technology infrastructure. Acmeware helps us both proactively and reactively to keep our tremendous data environments running smoothly. They are an integral part of our team!

– Jeannette Currie, BID Community Hospitals CIO

Case Study: Data Integration

novant uva logo 

 

Background

Novant Health UVA Health System Culpeper Medical Center serves the greater Culpeper, Virginia community and surrounding areas. The campus in is home to a 70-bed, community hospital, Family Birth Center and 24/7 emergency department, and is complemented by additional outpatient services in other northern VA towns, as well as the Novant Health UVA Health System Haymarket Medical Center. Culpeper Medical Center is a longtime MEDITECH MAGIC customer.

Situation

 Culpeper Medical Center sought to increase operational efficiency, reduce operating costs, and enhance comparison reporting with other hospitals in the Novant system (which use Epic) by targeting financial and clinical data to be compared across disparate EHR’s. The goal was to accomplish this through the development and automation of data export packages.

Assessment

Culpeper has been an Acmeware Partnership Program client since 2004, and a OneView Hospital Quality Reporting customer since 2017. When Culpeper determined they needed outside assistance to develop the desired data export packages and logic, they turned to Acmeware who evaluated the various data integration specifications and facility’s needs from a data compatibility perspective.

Results

Acmeware built several data export projects, extracting data from Culpeper’s Magic 5.67 system to feed a range of financial and clinical vendor systems. Wherever possible, data movement packages were automated for improve client workflow. The projects include:

  • Syntellis: Axiom (BAR Reconciliation/Cost Accounting)
  • Syntellis: Kauffman (AP/GL Reconciliation) AOIC (Integration for Radiology)
  • Vizient (clinical data)
  • NRC Health (custom survey)
  • Periodic reporting to HHS

The data export projects are running smoothly as Acmeware continues to assess and refine them for optimal efficiency. Culpeper continues to leverage their investment in the MEDITECH system to automate and achieve greater efficiencies from integration with third-party vendor systems.