Main Menu

• Home
  • Why Power BI is the best reporting platform for DR
  • The Importance of Data Governance
  • Optimize your MIPS Cost Category Score
• Services
• Quality
• Solutions
• The Hub
• Education
• About
• Contact
• New user registration

About Us

• About us
• Careers
• How we work
• Our team

The Hub

• Advisor
  • Quality
    • Electronic Case Reporting
    • 2023 IPPS Proposed Rule
    • 2023 QPP Proposed Rule
    • 2023 OPPS Proposed Rule
    • 2023 IPPS Final Rule
    • 2023 IPF PPS Final Rule
    • 2022 Quality Reporting Requirements for Inpatient Psychiatric Facilities
    • SAFER Guides-Contingency Planning
    • 2023 QPP Final Rule
    • 2023 OPPS Final Rule
    • New Requirements to Reduce Health Care Disparities
    • Palliative Care vs. Hospice Care
    • 2024 IPF PPS Proposed Rule
    • 2024 IPPS Proposed Rule
    • 2024 OPPS Proposed Rule
    • 2024 QPP Proposed Rule
    • 2024 IPF PPS Final Rule
    • 2024 IPPS Final Rule
    • The Importance of Mapping for Quality
    • 2024 QPP Final Rule
    • 2024 OPPS Final Rule
    • Navigating Antimicrobial Use and Resistance Reporting
  • Data Repository
    • Power BI
      • Microsoft Power BI and DR
      • Connecting to DR with Power BI
      • Data Models in Power BI
      • Why Power BI is the Best Reporting Platform for DR #1
    • Data Repository System Tables
    • Clean TSQL Formatting
    • Accessing Data Across SQL Servers
    • Where's the Data?
    • Primary Keys in Data Repository
    • Management Studio Shortcuts
    • When to Build a Data Mart
    • Multi-value Parameters in SQL Server Reporting Services
    • Why Data Repository is Different
    • Using URLs in SQL Server Reporting Services
    • Using URLs in SQL Server Reporting Services - Part 2
    • Optimal DR tempdb configuration
    • SQL Server User-defined Functions
    • Why SourceID is Important in DR
    • SQL Server User-defined Functions II
    • Report and Data Validation
    • So You Want a Barcode...
    • The Importance of DR Maintenance
    • Working with Precision in T-SQL
    • Nonclustered Indexes in Data Repository
    • EHR Downtime Insights
  • General
    • The Value of Validating eCQM Data
    • Know Your Data
    • Emergency Preparedness in Healthcare
    • External Links in MEDITECH
    • MUSE Views Podcast
  • Case study
    • Case Study: Data Integration
    • Case Study: Data Repository Services
    • Case Study: Conversion to Expanse
    • Case Study: Power BI at NVRH
    • Case Study: Downtime Defender
  • Archive
    • 2019 IPPS Final Rule
    • 2019 MIPS Final Rule
    • 2019 IPPS Proposed Rule
    • 2018 MIPS Overview
    • 2019 Promoting Interoperability
    • 2020 IPPS Proposed Rule
    • 2020 IPPS Final Rule
    • 2020 MIPS Final Rule
    • 2021 IPPS Proposed Rule
    • 2021 IPPS Final Rule
    • 2021 QPP Proposed Rule
    • 2021 QPP Final Rule
    • 2022 IPPS Proposed Rule
    • 2022 QPP Proposed Rule
    • 2022 IPPS Final Rule
• DR Network
  • SSRS report
    • Patient Account Financial Summary
    • Average Census by Hour
    • Inpatient Readmissions
    • Patient Account Charges by Category
    • Medication Administrations by Patient Account
    • Census by Location
    • Payment Summary by Insurance
    • Current Inpatient Medication Administrations by Location
    • Charge Summary by Department and Category
    • Current Inpatients with Last Visit
    • Lab Results by Patient Account
    • Lab Results for Current Inpatients
    • Bad Debt Accounts by Date
    • Current Inpatients with Last Vital Signs
    • Current Inpatient Orders by Provider
    • Current Inpatient Orders
    • Current Inpatients without Admit Order
    • Census by Attending Provider
    • Coded Allergies by Patient
    • Allergies by Patient
    • Charge Codes and Bills
    • Current Inpatient IV Information
    • All Patients with Home Medication
    • Cancelled Appointments
    • COVID-19 Dashboard
    • Patient Dashboard
    • Discharged Patients by Date
    • Surgery Dashboard
  • TSQL code
    • Clinic and Hospital Matching Charges
    • Parse Name (function)
    • Convert CDS Response to DateTime (function)
    • Proper Case (function)
    • Convert MT Time to Datetime (function)
    • Age in Years (function)
    • Age in Years and Months (function)
    • Age in Months and Days (function)
    • Get end of day (function)
    • Compare DR Schemas
    • Patient Providers by Discharge Date
    • Report Server Usage
    • Find DR Dependencies
    • Inpatient ADM Clinical Queries
    • Age intervals (function)
    • Search DR Metadata by Name
  • RD and NPR
    • Patient Wristband
    • NPR Report List (MAGIC)
    • NPR Report List (CS)
  • DR Network
• Events
  • MUSE
  • Quality Series
  • Training
  • User Group
• News
  • Acmeware & Cloudwave Announce DR & SQL Support Services
  • Acmeware Achieves 100% MIPS Submission Success
  • eCQM Submission Success
  • Acmeware Achieves 100% Submission Success
  • Acmeware Launches Redesigned Website
  • Acmeware Announces IT Staff Augmentation Services
  • Acmeware Unveils Free COVID-19 Dashboard
  • Acmeware Launches Live Online Training
  • Acmeware Leads the Way in Data Analytics
  • Acmeware Announces Downtime Defender
  • Security Announcement: Log4j Vulnerability
  • Positioned for Success in 2023
  • Acmeware President Announces Retirement Plans
  • Joel Benware Named President of Acmeware
  • Empower by Acmeware Revolutionizes Healthcare Data Analytics
  • Acmeware Joins MEDITECH Alliance Program
• Power BI alias

Professional Services

• Custom reporting
• Data integration
• DR support
• EHR conversion
• Expanse migration
• Staff augmentation

Solutions

• Downtime Defender
• Empower
• Empower Self-Demo
• OneLink
• Partnership program
• ViewPoint

Contact us

• Contact form - DD demo
• Message confirmation
• Opt-out form
• Contact form - Empower
• Contact form - training
• Contact form - Power BI training

Education

• Live online classes
• MUSE Conference
• Power BI training
• Training videos
• MUSE Conference 2022
• MUSE Conference 2023

General

• Privacy policy
• Sitemap
• Terms of use