Determining Community Health Status Priorities in an Online Analytic Processing (OLAP) Environment

Supplementary Files

Figure.1 Health Outcome Category Selection
Figure2. Criteria Wighting Combination No.1
Figure 3. Criteria Wighting Combination No.2
Figure 4. Criteria Weighting Combination No.3

How to Cite

Studnicki, J., & Fisher, J. W. (2013). Determining Community Health Status Priorities in an Online Analytic Processing (OLAP) Environment. Online Journal of Public Health Informatics, 5(2).


Introduction: The determination of priorities is an essential component of community health status assessment. Yet, there is an acknowledged need for a systematic method which will utilize data in standardized comparisons to yield priorities based on objective analyses. Method: We have deployed a web-based system with: a flexible online analytic processing (OLAP) interface; multiple sources of event-level data conformed to common definitions in a data warehouse structure; and, centralized technical infrastructure with distributed analytical capabilities. The PRIORITIZATION TOOL integrated into the system takes full advantage of the granularity of multidimensional sources of data to: apply a series of defined objective criteria; vary the weight of those criteria and detect the reordering of the rankings in real-time; and, apply the prioritization algorithm to different categories of health status outcomes. Results: In our example, mortality outcomes for Miami-Dade County, Florida, were considered with three different weighting combinations of the four primary ranking criteria. The resultant analyses return markedly different mortality priority rankings based upon the selection and weighting of the criteria. Conclusion: Rankings of community health outcomes based on a static set of criteria with fixed weighting factors may not provide sufficient information necessary for priority setting and may, in fact, be misleading.
Authors own copyright of their articles appearing in the Online Journal of Public Health Informatics. Readers may copy articles without permission of the copyright owner(s), as long as the author and OJPHI are acknowledged in the copy and the copy is used for educational, not-for-profit purposes. Share-alike: when posting copies or adaptations of the work, release the work under the same license as the original. For any other use of articles, please contact the copyright owner. The journal/publisher is not responsible for subsequent uses of the work, including uses infringing the above license. It is the author's responsibility to bring an infringement action if so desired by the author.