title: A Multidimensional Data Warehouse for Community Health Centers.
abstract: Community health centers (CHCs) play a pivotal role in healthcare delivery to vulnerable populations, but have not yet benefited from a data warehouse that can support improvements in clinical and financial outcomes across the practice. We have developed a multidimensional clinic data warehouse (CDW) by working with 7 CHCs across the state of Indiana and integrating their operational, financial and electronic patient records to support ongoing delivery of care. We describe in detail the rationale for the project, the data architecture employed, the content of the data warehouse, along with a description of the challenges experienced and strategies used in the development of this repository that may help other researchers, managers and leaders in health informatics. The resulting multidimensional data warehouse is highly practical and is designed to provide a foundation for wide-ranging healthcare data analytics over time and across the community health research enterprise.
authors.affiliation: Department of BioHealth Informatics, Indiana University, Indianapolis, IN.
authors.forename: Kislaya
authors.initials: K
authors.lastname: Kunjan
authors.affiliation: Department of BioHealth Informatics, Indiana University, Indianapolis, IN; Parkview Research Center, Fort Wayne, IN.
authors.forename: Tammy
authors.initials: T
authors.lastname: Toscos
authors.affiliation: Department of Mechanical and Industrial Engineering, Northeastern University, Boston, MA.
authors.forename: Ayten
authors.initials: A
authors.lastname: Turkcan
authors.affiliation: Department of BioHealth Informatics, Indiana University, Indianapolis, IN.
authors.forename: Brad N
authors.initials: BN
authors.lastname: Doebbeling
mesh_terms: D003151:Community Health Centers; D000073458:Data Warehousing; D057286:Electronic Health Records; D006801:Humans; D007196:Indiana; D008490:Medical Informatics