Turing data into information and further to knowledge and wisdom is essential for any organization to perform better in today’s era. Healthcare industry is not an exception, but it demands more of data transformation than any other industry. “Analysis Paralysis” is the term, which is often used to relate or define the data chaos situation. Clinical Decision Support and Clinical Business Intelligence are the approaches which capitalize the wealth amount of the data collected. Consolidation of fragmented data from different sources to have a holistic view and analysis is the fundamental idea behind Data Warehouse. This intention behind this research is to compare and analyze the suitability of different Data Warehouse architectures for healthcare domain focusing on the data utilization output, such as healthcare Business Intelligence and Clinical Decision Support.