Datasource Consulting partners with top healthcare provider to implement an External Encounter Data Mart (EEDM), giving business users streamlined access to more accessible, accurate data while automating business processes and accelerating operations.
With more than 550,000 members across Colorado, this leading healthcare provider is committed to delivering high-quality patient care while also providing an enhanced patient experience.
The organization’s “Triple Aim” mission – improving health, managing costs, and delivering an enhanced patient experience is achieved by managing inpatient care costs and all activities for hospitals, physicians, and technical services. Meeting the organization’s strategic goals leads to the collection of a tremendous amount of data. Data assets include everything from patient records, compliance documentation, and financial reporting, to metrics and data regarding patient wait times, satisfaction, and more.
The organization’s existing data environment was built using a client-server architecture with tools like SAS and Excel. While this data system was functional, it was also manually intensive and limited in scope. The original data asset system was developed by an individual and therefore any changes or additional reporting requests had to go through a single point of contact. Custom reports had to be built individually. This homegrown system accessed several SAS datasets that were then shared with users.
The Datasource Consulting team met with key stakeholders to identify technical Enterprise Data Management (EDM) requirements and sync those with strategic business objectives. After a vendor-neutral assessment, Datasource recommended the implementation of an External Encounters Data Mart (EEDM).
Working in close collaboration with business partners, Datasource met with users within the organization to better understand their needs and to outline precisely how data within the organization should be shared and leveraged across the enterprise.
After the evaluation, Datasource consultants created a new, comprehensive data model following best practices in acquisition, integration, and presentation (mart) design. They also created a complete solution roadmap, spanning solution implementation, deployment, and user adoption. The roadmap included strategies for:
- Architecture Development
- Data Integration
- Improving Data
- Quality & Reliability
- Master Data Management
- Reporting & Analytics
- Program Management
- Data Governance
Datasource worked closely with the health care provider to build a strong data infrastructure and process to manage both the data model (CA/ERwin) and ETL practices (Informatica PowerCenter). They also focused on data integration priorities to allow users to effectively analyze and collaborate on enterprise data. Datasource created logic to support case analytics to provide more meaningful financial insight.
This capability allows users to combine and evaluate multiple visits or encounters by a single patient. Qualified users within the organization can now analyze the entire patient experience, from the initial patient intake to the final outcome. This capability helps the team to focus on providing a high-quality patient experience and deliver continuity of care.
Smarter data integration for smarter financial analysis. Datasource worked with stakeholders to determine how to best integrate data to provide a timely and comprehensive view into the organization’s financial delivery process. The team standardized the presentation layer on a Cognos platform to give users:
- Easy access to detailed external cost information
- New case logic for better analysis
- Standardized front-end interface familiar to users
- Data tied to actuarial estimates
For the EEDM rollout, Datasource consultants provided user testing, developed the training program, established support procedures and documentation, and briefed the offshore product support team. Today the EEDM gives users access to high-quality data to make more informed decisions much more quickly, which included:
- A sustainable, adaptive data mart that can grow with the organization
- A standardized Cognos presentation layer that allows users to traverse between financial and external cost data
- Enhanced logic supporting visibility into exhaustive integrated claims detail
- Validation back to Sarbanes-Oxley compliant (SOX) financial data
- Ability to analyze claims data across a range of dimensions by provider, patient, market, service line, etc.
- Access to an integrated Business Glossary