Abstract
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.
Keywords
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Microsoft Corporation: Business Intelligence, http://www.microsoft.com/en-us/bi/ (accessed 2013)
Microsoft Corp.: The Offical Microsoft ASP.NET Site, http://www.asp.net/ (accessed 2013)
Larson, B.: Mircosoft SQL Server 2008 Delivering Business Intelligence. McGraw-Hill Companies (2009)
Cantrill, S.: Computers in Patient Care: The Promise and the Challenge. Communications of the ACM 53(9), 42–47 (2010)
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)
Haque, W., Edwards, J.: Ambulatory Care Sensitive Conditions: A Business Intelligence Perspective, York, pp. 31–39 (2012)
Olszak, C., Batko, K.: The use of business intelligence systems in healthcare organizations in Poland. Computer Science and Information Systems, 969–976 (2012)
Starfield, B., Shi, L., Macikno, J.: Contribution of Primary Care to Health Systems and Health. Milbank Quarterly 83(3), 457–502 (2005)
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)
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)
Lurie, N., Dubowitz, T.: Health Disparities and Access to Health. The Journal of the American Medical Association 297(10), 1118–1121 (2007)
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)
BCStats: Translations and Data Sets, http://www.bcstats.gov.bc.ca/StatisticsBySubject/Geography/TranslationsDataSets.aspx (accessed 2013)
Team, Quantum GIS Development: Quantum GIS Geographic Information System, http://www.qgis.org/ (accessed 2013)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Haque, W., Urquhart, B., Berg, E. (2014). Visualization of Services Availability: Building Healthy Communities. In: Rocha, Á., Correia, A., Tan, F., Stroetmann, K. (eds) New Perspectives in Information Systems and Technologies, Volume 2. Advances in Intelligent Systems and Computing, vol 276. Springer, Cham. https://doi.org/10.1007/978-3-319-05948-8_34
Download citation
DOI: https://doi.org/10.1007/978-3-319-05948-8_34
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-05947-1
Online ISBN: 978-3-319-05948-8
eBook Packages: EngineeringEngineering (R0)