The Acmeware Advisor.

Our blog is your source for timely information on MEDITECH Data Repository, SQL Server and business intelligence, quality reporting, healthcare regulatory issues, and more.

Contact us
500 characters left

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



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.


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.


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. 


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

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.

Case Study: Data Integration

novant uva logo 



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.


 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.


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.


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.