Learn how Northwest Acute Care Specialists (NACS) used a data warehouse and Power BI to greatly improve data visibility and generate more actionable insights.
Imagine going to a bank and waiting hours in line to see a teller to cash a check or withdraw money—today’s consumers won’t tolerate that.
Yet, that’s still the reality in much of the healthcare sector, especially in emergency rooms. Those in need of emergency services often spend hours waiting to see a doctor. This is the opposite of a patient-centric experience.
The healthcare industry struggles with adopting new technologies that can help them keep tabs on consumer expectations and avoid consistently falling short.
Northwest Acute Care Specialists (NACS) provides emergency services at seven hospitals in the greater Portland area. Its Chief Operating Officer, David Silverman, experienced this struggle up close and personal.
David has a strong background in technology, so he was painfully aware that he needed to modernize their organization’s operations. He clearly understood the root of the problem. “Our biggest challenge is that we didn’t have any access to data.”
Although NACS generates a wealth of data, existing processes were severely limiting their team’s data visibility. This lack of visibility was hindering their analytics capabilities and operational progress.
Information lived on the legacy platform of the hospital system. After treatments were complete, this legacy platform sent the records to a billing and coding company for the claims submission—a process that NACS had almost no visibility into.
NACS was often flying blind. Any information it received from the billing company would be two or three months old, and no longer actionable. The NACS team couldn’t track encounter metrics, while the static PDF from the billing company failed to provide nuanced data insights.
David needed to create an environment where his team could own and access actionable clinical and claims data. But the information resided in disparate locations, such as the EMR, billing and coding company, shift administration software, and HR system.
These sources didn’t talk to each other. David needed to pull data from all these platforms and build a centralized data warehouse to relay the information to NACS’ providers and complete the feedback loop.
Additionally, the trend toward value-based care and risk-sharing with payers meant that NACS needed to use data-driven insights to negotiate with payers and navigate new insurance models instead of taking the payers’ word for it. Meanwhile, providers wanted data about their performance to help improve patient outcomes.
NACS partnered with Skypoint Cloud to implement a smart data warehouse and build an “Encounters” datamart using Epic and LogixHealth data. The solution achieves the level of nuance and granularity it needs to meet patient and provider expectations.
The solution integrates scheduling data with billing data from LogixHealth and other internal data sources into a new cloud data warehouse (Azure SQL database). It also leverages Power BI for healthcare data analytics, tracking metrics, and evaluating performance.
The managed business intelligence solution included four work streams:
Skypoint Cloud enabled NACS to connect different data sources to generate real-time reports. The team leveraged these insights to effectively and easily evaluate both organizational and employee performance.
The solution also helped NACS uncover additional hurdles during the process. It shares information with a clinical emergency data registry (CEDR), which tracks 25 million emergency room visits a year. Skypoint Cloud helped NACS combine the data from CEDR and Epic to see how their performance stacks up nationally.
“For us at Northwest Acute Care Specialists, Power BI has been a game changer,” David said as he reflected on the change made possible by this implementation, pointing to one particularly impactful moment.
On January 1, 2023, the reimbursement process changed for all emergency care providers. NACS implemented the data warehouse two weeks before the transition. David prevented any revenue loss thanks to the ability to track the billing and coding process. This is typically not the case for most other providers, who usually experience a falloff in these situations.
By completing the feedback loop with robust visualization and reporting, David and his team now capture 60 to 70 unbilled encounters each month. These encounters would have fallen through the cracks in the past. Today, these new data insights help NACS recover significant revenue.
Most importantly, the schema helped NACS put the information in the right place within the data warehouse. This structure allowed David and his team to create meaningful visualizations to inform decisions.
The data warehouse, Power BI visualization, and automation saved David and his team hours of manual effort compiling and making sense of data from various sources.
The NACS team can easily use the registry number in NACS’ HR system, match it with the one in the EMR, and identify encounters within Epic that involve its physicians. These operational transformations are saving hundreds of hours of tedious and error-prone work each month.
“The data warehouse helps us eliminate myths and anecdotal information,” David said. “We can delve into the data, look at how other providers perform, and take any urban legend out of the discussion. The data warehouse gives us a system of truth to guide accurate and coherent decisions.”
Moving forward, David plans to collaborate with Skypoint Cloud on projects with a clinical focus, such as understanding patient demographics, procedures, and prescribing habits. Future collaborations will help connect operational metrics with clinical ones to paint a holistic picture.
“Skypoint Cloud sees our challenges with a fresh eye and shows us (and the industry) what’s possible,” David said.
“Our relationship is a true partnership. The team invested in understanding the extremely complicated medical billing process. They even went to the emergency departments to watch our providers work to design a data warehouse that meets our needs, which is critical to the project’s success.”