Data Warehouse Solutions for The Affordable Care Act

The Institute of Healthcare Improvement (IHI) has suggested that a triple aim approach will enable healthcare organizations to achieve the Affordable Care Act (ACA) objectives and get the best Data Warehouse Solutions. The Tribble aim approach is summarized as

  • Improve the patient experience of care (including quality and satisfaction)
  • Improve the health of populations
  • Reduce the per capita cost of healthcare

The affordable care act requires Healthcare Organizations to increase productivity and quality of care while simultaneously reducing cost. There are many incentives and mandates put in place to get these healthcare organizations to comply with the affordable care act, however, complying with this rule presents a tough challenge to health practitioners and organizations. 

Data Warehouse

In order to implement the triple aim approach, healthcare organizations must first redesign their current system to fit the following

  • focus on individuals and families
  • redesign primary care services and structures
  • focus on population health management
  • implement a cost control platform and
  • achieve system integration and execution

Health systems need to install the appropriate data warehouse so they can store and mine their data appropriately. This is relevant because an enormous amount of data is needed to achieve triple aim. In installing the best and appropriate data warehouse, health organizations should redesign this data warehouse for healthcare specific needs. The old approach of clustering reports together from different sources is time-consuming and inefficient. The better approach is relying on complete and accurate information from across the enterprise-wide data ecosystem and this approach requires a healthcare-specific data warehouse.

In case you were wondering how necessary installing the triple threat is, here’s some data to reiterate how necessary and important installing it is.

Data Warehouse

A 2014 report from the Commonwealth Fund reveals that the U.S. healthcare system is the most expensive in the world. The U. S healthcare system also ranks last in access, efficiency, and equity in comparison to 10 other nations in the world. Considering the importance of healthcare as a basic human right this is a particularly disturbing statistic for a country that claims to be the greatest country in the world. In addition, a 2013 report from the Centers for Disease Control and Prevention (CDC) states that personal healthcare expenditures in the United States total $2.3 trillion, with expenditures for hospital care accounting for 31.5 percent and physician and clinical services accounting for 20 percent of all national healthcare expenditures.

The current administration’s handling of healthcare with a proposed healthcare bill that’s ludicrous, to say the least, hugely opportunistic of the low and middle class and blatantly cruel. This new act will make these already terrible statistics much worse. Yet despite the high cost of U.S. healthcare and proposed an increase, Americans are not any healthier than citizens of other industrialized nations, nor do they enjoy greater longevity. Consider these facts about the costs of healthcare and mortality:

  • The 2013 report U.S. Health in International Perspective compared the life expectancy of Americans to the citizens of 17 high-income peer countries from Western Europe, Australia, Japan, and Canada. The findings showed that life expectancy for American males ranks last, and life expectancy for American females ranks next to last.
  • Preterm-related causes of death accounted for 35 percent of infant deaths in 2009 as stated on the CDC website.
  • At least 44,000 and perhaps as many as 98,000 Americans die in hospitals each year as a result of medical errors according to the book To Err Is Human: Building a Safer Health System.
  • Medicare could save at least $12 billion per year by reducing preventable readmission cases that are readmitted within 30 days according to the 2007 report to Congress Promoting Greater Efficiency in Medicare.


To give an idea, the top 10 nations with the best healthcare ranking are; Australia, Canada, France, Germany, the Netherlands, New Zealand, Norway, Sweden, Switzerland, and the United Kingdom.

Healthcare Data Warehouse Demands are Unique

Data Warehouse

It isn’t hard to see how a data warehouse designed for another industry may fall short to the needs demanded of the healthcare profession. Subsequent generations of clinical data warehouses have provided the more robust expediencies with facets that are unique to the medical fields that employ them. Just as expected, the technology within the data warehouses is growing each year and helps to provide better and faster results.

Along with improvements in data warehousing, there has been an ever-increasing amount of statistical data that needs to be collected, organized and re-distributed. These higher expectations come from external sources as well as from all internal departments at a healthcare-oriented business. One challenge is that the information that each group provides is not formatted the same, or located in the same areas within the warehouse.