Designed a new Enterprise Data Warehouse and reporting system to identify quality gaps and improve patient care.

At a glance:

We are working with a local community health care organization, Sea Mar Community Health Centers, to leverage technology to improve patient care. Sea Mar CHC provides many services (health care, pharmacy, dental, and other services) to the community. We’re helping to build a data warehouse that will enable them to get a full picture of a client’s health; fully informed health care providers can better serve patients.

Customer Challenge

Sea Mar CHC needed a system to look at client records across the full set of services they provide; data stayed within the system for an individual clinic (for example, health clinics did not have access to dental records). They wanted a data warehouse to track patient and clinic information and to build reports used to improve patient care, clinic performance, and billing.

Approach and Solution:

We utilized the Microsoft BI stack as the foundation for a Sea Mar’s new enterprise data warehouse. We

  • Built a comprehensive data model and custom ETL processes to integrate data from four different EHR systems.
  • Worked with clinic managers and the technology team identify areas to improve efficiency in clinic management and billing.
  • Built new advanced visualizations using Power BI to enable data-driven decision making

Value and Benefits - “the wins”

We’re helping Sea Mar to improve health outcomes for their patients by:

  • Improving patient management with near real-time information has improved health outcomes.
  • Improved efficiency in the billing process for government paid clients
  • Identifying areas for clinic improvement via clinic data across all of Sea Mar operations.
  • Supporting the growth of Sea Mar with scalable data and reporting solutions.

About Sea Mar Community Health Centers:

Sea Mar Community Health Centers is a community-based organization committed to providing quality, comprehensive health, human, housing, educational and cultural services to diverse communities, specializing in service to Latinos in Washington state.