Visualization of Services Availability: Building Healthy Communities

  • Waqar Haque
  • Bonnie Urquhart
  • Emery Berg
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 276)


Business Intelligence techniques have been applied to data related to healthcare infrastructure. Data visualization has eliminated tedious analysis of legacy reports and provides mechanism for optimally aligning resources with the needs. Once the data from disparate sources is cleansed and integrated into a data warehouse, the OLAP (Online Analytical Processing) cube allows slicing along multiple dimensions determined by key performance indicators representing population and patient profiles together with complex management groups. In addition, comparison, availability, service levels and community health reports are also generated on demand. All reports can be drilled down for navigation at a finer granularity. The use of mapping tools, customized shape files and embedded objects further augments the navigation. Finally, web forms provide a mechanism for remote uploading of data and transparent processing of the cube.


Business Intelligence Healthcare Informatics Services Availability Data Visualization 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Microsoft Corporation: Business Intelligence, (accessed 2013)
  2. 2.
    Microsoft Corp.: The Offical Microsoft ASP.NET Site, (accessed 2013)
  3. 3.
    Larson, B.: Mircosoft SQL Server 2008 Delivering Business Intelligence. McGraw-Hill Companies (2009)Google Scholar
  4. 4.
    Cantrill, S.: Computers in Patient Care: The Promise and the Challenge. Communications of the ACM 53(9), 42–47 (2010)CrossRefGoogle Scholar
  5. 5.
    Pine, M., Sonneborn, M., Schindler, J., Stanek, M., Maeda, J., Hanlon, C.: Harnessing the Power of Enhanced Data for Healthcare Quality Improvement: Lessons from a Minnesota Hospital Association Pilot Project. Journal of Healthcare Management 57(6), 406–418 (2013)Google Scholar
  6. 6.
    Haque, W., Edwards, J.: Ambulatory Care Sensitive Conditions: A Business Intelligence Perspective, York, pp. 31–39 (2012)Google Scholar
  7. 7.
    Olszak, C., Batko, K.: The use of business intelligence systems in healthcare organizations in Poland. Computer Science and Information Systems, 969–976 (2012)Google Scholar
  8. 8.
    Starfield, B., Shi, L., Macikno, J.: Contribution of Primary Care to Health Systems and Health. Milbank Quarterly 83(3), 457–502 (2005)CrossRefGoogle Scholar
  9. 9.
    Lasser, K., Himmelstein, D., Woolhandler, S.: Access to Care, Health Status, and Health Disparities in the United States and Canada: Results of a Cross-National Population-Based Survey. American Journal of Public Health 96(7), 1300–1307 (2006)CrossRefGoogle Scholar
  10. 10.
    Sanmartin, C., Berthelot, J.-M., Ng, E., Murphy, K., Blackwell, D., Gentleman, J., Martinez, M., Simile, C.: Comparing Health And Health Care Use In Canada And The United States. Health Affairs 25(4), 1133–1142 (2006)CrossRefGoogle Scholar
  11. 11.
    Lurie, N., Dubowitz, T.: Health Disparities and Access to Health. The Journal of the American Medical Association 297(10), 1118–1121 (2007)CrossRefGoogle Scholar
  12. 12.
    Mäntyselk, P., Halonen, P., Vehviläinen, A., Takala, J., Kumpusalo, E.: Access to and continuity of primary medical care of different providers as perceived by the Finnish population. Scandinavian Journal of Primary Health Care 25(1), 27–32 (2007)CrossRefGoogle Scholar
  13. 13.
  14. 14.
    Team, Quantum GIS Development: Quantum GIS Geographic Information System, (accessed 2013)

Copyright information

© Springer International Publishing Switzerland 2014

Authors and Affiliations

  1. 1.University of Northern British ColumbiaPrince GeorgeCanada
  2. 2.Northern HealthPrince GeorgeCanada

Personalised recommendations