Health data warehouse brings transparency and real time intelligence for health services research users.

Davlyatov, Ganisher; Borkowski, Nancy; Feldman, Sue; Qu, Haiyan; Burke, Darrell; Bronstein, Janet; Brickman, Andrew Health Information Technology Adoption and Clinical Performance in Federally Qualified Health Centers, Journal for Healthcare Quality: September/October 2020 – Volume 42 – Issue 5 – p 287-293


A national sample (N = 982) of federally qualified health centers (FQHCs) for the period 2011–2016 was examined regarding the relationship between the age and extent of health information technology (HIT) use and clinical performance. We found that each additional year of HIT use was associated with an approximate 4 percent increase in both process and outcome measures of clinical performance. Furthermore, FQHCs that fully adopted HIT had 7 percent higher clinical performance on hypertension control than those that did not adopt HIT. This study’s findings can assist stakeholders to make informed decisions for improving care and sustaining a competitive advantage.


This paper described a design process for creating a data warehouse that includes the most frequently used databases in health services research.


The design is based on a conceptual iterative process model framework that utilizes the sociotechnical systems theory approach and includes the capacity for subsequent updates of the existing data sources and the addition of new ones. We introduce the theory and the framework and then explain how they are used to inform the methodology of this study.


The application of the iterative process model to the design research process of problem identification and solution design for the Healthcare Research and Analytics Data Infrastructure Solution (HRADIS) is described. Each phase of the iterative model produced end products to inform the implementation of HRADIS. The analysis phase produced the problem statement and requirements documents. The projection phase produced a list of tasks and goals for the ideal system. Finally, the synthesis phase provided the process for a plan to implement HRADIS. HRADIS structures and integrates data dictionaries provided by the data sources, allowing the creation of dimensions and measures for a multidimensional business intelligence system. We discuss how HRADIS is complemented with a set of data mining, analytics, and visualization tools to enable researchers to more efficiently apply multiple methods to a given research project. HRADIS also includes a built-in security and account management framework for data governance purposes to ensure customized authorization depending on user roles and parts of the data the roles are authorized to access.


To address existing inefficiencies during the obtaining, extracting, preprocessing, cleansing, and filtering stages of data processing in health services research, we envision HRADIS as a full-service data warehouse integrating frequently used data sources, processes, and methods along with a variety of data analytics and visualization tools. This paper presents the application of the iterative process model to build such a solution. It also includes a discussion on several prominent issues, lessons learned, reflections and recommendations, and future considerations, as this model was applied.