Support our online development, and advance our onground research initiatives in free market economics, as we seek to showcase the brightest Next-Gen minds.
THE ME-P DISCLAIMER: Posts, comments and opinions do not necessarily represent iMBA, Inc., but become our property after submission. Copyright © 2006 to-date. iMBA, Inc allows colleges, universities, medical and financial professionals and related clinics, hospitals and non-profit healthcare organizations to distribute our proprietary essays, photos, videos, audios and other documents; etc. However, please review copyright and usage information for each individual asset before submission to us, and/or placement on your publication or web site. Attestation references, citations and/or back-links are required. All other assets are property of the individual copyright holder.
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
Share this:
Filed under: "Doctors Only", Information Technology, Practice Management | Tagged: health information technology, Heath Data Warehouse | 2 Comments »
The Leading Business Education Network for Doctors, Financial Advisors and Health Industry Consultants 