A Brief “How-to” Essay with Commentary
By Staff Reporters
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
Filed under: "Doctors Only", Information Technology, Practice Management | Tagged: health information technology, Heath Data Warehouse | 2 Comments »