Building a Modern Electronic Heath Data Warehouse

A Brief “How-to” Essay with Commentary

By Staff Reporters

Join Our Mailing List 

According to a Standish Group survey, more than 70% of Health Information Technology applications go over budget and time and medical data warehouse applications are no exception. However, if you adopt a process, an oriented development approach and implement a rigorous project management discipline, your increase the likelihood that your medical data warehouse will be effective.

Key Steps

This is a simplified list, but reveals some of the key steps needed to build a medical data warehouse.

  • Extracting data from the data sources – can be very challenging as data might reside on different systems and this forces you to prioritize what data you want and what role that plays in your patient relations management decision-making. This step involves moving data from the source (for example to your Web site) to a central location (e.g. your marketing data mart).
  • Transforming the data – a key activity after data extraction.  This is critical to have cleaner data and involves modification, enhancement or elimination of data based on the job instructions.
  • Loading the transformed data into a dimensional database.
  • Building reports for decision makers (e.g. this could be a report for your marketing management outlining the analysis of your latest patient acquisition campaign).

Assessment

The first 3 steps – Effective data extract, transform and load (ETL) processes represent the number one success factor for your medical data warehouse project and can absorb up to 70 percent of the time spent on a typical warehousing project.

Conclusion

Your thoughts and comments on this ME-P are appreciated. Feel free to review our top-left column, and top-right sidebar materials, links, URLs and related websites, too. Then, subscribe to the ME-P. It is fast, free and secure.

Link: http://feeds.feedburner.com/HealthcareFinancialsthePostForcxos

Speaker: If you need a moderator or speaker for an upcoming event, Dr. David E. Marcinko; MBA – Publisher-in-Chief of the Medical Executive-Post – is available for seminar or speaking engagements. Contact: MarcinkoAdvisors@msn.com

OUR OTHER PRINT BOOKS AND RELATED INFORMATION SOURCES:

LEXICONS: http://www.springerpub.com/Search/marcinko
PHYSICIANS: www.MedicalBusinessAdvisors.com
PRACTICES: www.BusinessofMedicalPractice.com
HOSPITALS: http://www.crcpress.com/product/isbn/9781466558731
CLINICS: http://www.crcpress.com/product/isbn/9781439879900
ADVISORS: www.CertifiedMedicalPlanner.org
BLOG: www.MedicalExecutivePost.com

 

Product DetailsProduct DetailsProduct Details

%d bloggers like this: