In part one of this blog I wrote about why I think Microsoft Power BI is a superior data analysis and reporting platform for MEDITECH Data Repository compared to SQL Server Reporting Services. In this second part of a a two-part analysis, I continue the discussion by reviewing the user presentation and interactivity experience.

I’ve been working with MEDITECH Data Repository since 2000. That’s longer than I care to note, but I still remember when SQL Server Reporting Services was first included with SQL Server, in version 2000: after struggling to find an easy way for our small hospital to share DR data and reports without having budget dollars for software like Crystal Reports, suddenly we could share it on our intranet. 

A Guide to Meeting Promoting Interoperability Program Requirements

As the healthcare landscape evolves, so do the requirements for quality reporting. One such significant change for hospitals and critical access hospitals (CAHs) in the upcoming year (CY 2024) is the mandatory requirement of the Antimicrobial Use and Resistance (AUR) Surveillance measure under the Public Health and Clinical Data Exchange Objective in the Medicare Promoting Interoperability (PI) Program. 

CMS recently published the CY 2024 Outpatient Prospective Payment System (OPPS) Final Rule, which finalized changes for the Hospital Outpatient Quality Reporting (OQR) Program. In the final rule, CMS finalized modifications to three measures and finalized the adoption of two measures in the OQR Program. These modifications aim to further meaningful measurement and reporting of the quality of care provided in the outpatient setting. For the full text of the rule, see the Federal Register.

CMS recently published the CY 2024 Quality Payment Program (QPP) Final Rule which included numerous updates to MIPS Value Pathways (MVPs) and Merit-based Incentive Payment System (MIPS). For the full text of the rule, see the Federal Register.

If your electronic Clinical Quality Measure (eCQM) performance numbers do not reflect your workflow and are not what you would expect them to be, then it’s likely that you have mapping inaccuracies. What is data mapping, and why is it important for accurately calculating quality measure data?

CMS recently published the FY 2024 Inpatient Prospective Payment System (IPPS) Final Rule which includes several changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare Promoting Interoperability (PI) Program for eligible hospitals (EHs) and critical access hospitals (CAHs). For the full text of the rule, see the Federal Register.

CMS recently published the FY 2024 Inpatient Psychiatric Facilities Prospective Payment System (IPF PPS) Final Rule which finalized changes to the Inpatient Psychiatric Facility Quality Reporting (IPFQR) program. All IPFs, which include psychiatric hospitals and psychiatric units of an acute care hospital or critical access hospital, paid under the IPF PPS must meet IPFQR reporting requirements. For the full text of the proposed rule, see the Federal Register.

CMS recently published the CY 2024 Quality Payment Program (QPP) Final Rule which included numerous updates to MIPS Value Pathways (MVPs) and Merit-based Incentive Payment System (MIPS). For the full text of the rule, see the Federal Register.

CCMS recently released the CY 2024 Outpatient Prospective Payment System (OPPS) Proposed Rule, which included proposals for the Hospital Outpatient Quality Reporting Program (OQR) Program.For the full text of the rule, see the Federal Register.

What are indexes? Simply put, indexes in a SQL Server database are structures that speed up data access from tables and views. There are two types of indexes: clustered and nonclustered. Since any database table can only have a single primary key (therefore, a single clustered index), nonclustered indexes are what we as developers and analysts can optionally use to improve query performance. 

For many people in a hospital environment, using a PC for most of the day means navigating through MEDITECH applications and menus as part of the usual routine. Inevitably however, none of us can do our job without a browser and the Internet. Fortunately for most MEDITECH users (sorry for those of you still using MAGIC), there’s a nifty utility built into MEDITECH that can be custom configured to make web URLs available right from your menu: External Links.