Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

A data mart for operations analysis.

M W Isken1, S J Littig, M West

  • 1Department of Decision and Information Sciences, Oakland University, USA.

Journal of Healthcare Information Management : JHIM
|July 17, 2001
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Opening the operating theatre to oncology: treatment of locally recurrent rectal cancer with peritoneal metastasis by simultaneous hyperthermic intraperitoneal chemotherapy and intraoperative electron beam radiotherapy.

Annals of the Royal College of Surgeons of England·2025
Same author

A national survey of the provision of prehabilitation for oesophagogastric cancer patients in the UK.

Annals of the Royal College of Surgeons of England·2024
Same author

Do variations in nasal irrigation recipes and storage effect the risk of bacterial contamination? - ERRATUM.

The Journal of laryngology and otology·2023
Same author

Do variations in nasal irrigation recipes and storage effect the risk of bacterial contamination?

The Journal of laryngology and otology·2022
Same author

GW150914: First results from the search for binary black hole coalescence with Advanced LIGO.

Physical review. D. (2016)·2020
Same author

A qualitative investigation of school age children, their parents and school staff on their participation in the Digital Education to LImit Salt in the Home (DELISH) program.

Health education research·2020
Same journal

Using an Evidence-Based Approach to EMR Implementation to Optimize Outcomes and Avoid Unintended Consequences.

Journal of healthcare information management : JHIM·2014
Same journal

Workflow viewpoints: Analysis of nursing workflow documentation in the electronic health record.

Journal of healthcare information management : JHIM·2010
Same journal

How to select end user clinical data entry devices. Rush University Medical Center develops tool to identify the quantity of devices needed for the implementation of a new EMR and CPOE system.

Journal of healthcare information management : JHIM·2010
Same journal

The conversion to electronic hospital notes at Mayo Clinic. Overcoming barriers and challenges.

Journal of healthcare information management : JHIM·2010
Same journal

Certification of primary care electronic medical records: lessons learned from Canada.

Journal of healthcare information management : JHIM·2010
Same journal

QRDA--technology overview and lessons learned.

Journal of healthcare information management : JHIM·2010
See all related articles

This study details a healthcare data mart designed for operations analysts, enhancing demand analysis, forecasting, and capacity planning. It supports informed decision-making for hospital operations and service system design.

Area of Science:

  • Health Informatics
  • Operations Research
  • Data Warehousing

Background:

  • Healthcare operations analysts require specialized tools for complex modeling and analysis.
  • Existing data systems often lack the specific structures needed for healthcare operations.
  • Tertiary and community hospitals face unique challenges in managing patient flow and resources.

Purpose of the Study:

  • To describe the evolution and architecture of a healthcare data mart.
  • To support modeling and analysis for demand analysis, forecasting, capacity planning, and service system design.
  • To provide a data solution tailored to the needs of healthcare operations analysts.

Main Methods:

  • Developed a data mart focusing on detailed inpatient movement.
  • Integrated outpatient data including emergency visits, surgical cases, and short-stay visits.

Related Experiment Videos

  • Incorporated complex, precalculated fields, data structures, and function libraries.

    • Main Results:

    • The data mart effectively consolidates data from diverse sources.
    • Precalculated fields and specialized structures enhance analytical capabilities.
    • The system supports detailed analysis of patient flow within hospitals.

    Conclusions:

    • The developed data mart significantly improves healthcare operations analysis.
    • Tailored data structures and precalculated fields are crucial for operations analysts.
    • Design challenges identified offer insights for the data warehouse vendor community.