Case Study “The need for a Data Warehouse” You work in the Informatics Departmen
ID: 126849 • Letter: C
Question
Case Study
“The need for a Data Warehouse”
You work in the Informatics Department of a very large reputable multi-site healthcare system that consists of 5 acute care hospitals, over one hundred physician offices, and fifteen walk in clinics. You have an integrated state of the art EMR that operates at all sites. The EMR interfaces with many of the different separate IT systems in clinical areas throughout the system. Administration and the Board feel that the reporting capabilities in the EMR are UNDERUTILIZED. There still seems to be a lot of data that is being produced from the IT systems in the clinical areas and there is an unproven concern that some of the monthly data may be incorrect. The system Information Governance Committee feels that there is a strong need for a data warehouse within the organization. They feel the information could be properly stored, validated and protected within a Data Warehouse. It would also be helpful to have the data from a historical perspective for trending and strategic decision making purposes.
1. You are tasked with developing a 3 to 4 page paper for the Information Governance Committee that substantiates the need for a data warehouse at your healthcare system.
2. Please include what you feel are the benefits for this data warehouse and how you feel it should be structured.
3. You will need to communicate who should “own and manage” the data warehouse
4. How you feel changes to the data should be made and who should approve what data is housed within the warehouse.
Please use at least four professional references for this assignment.
You recently took an Enterprise Information Governance class at a prestigious University in your area that covered data warehouses and you feel that you are indeed a subject matter expert in this area.
Explanation / Answer
1- Health care governments live or die founded on the excellence of the information their bests use to make tactical, occupational and clinical results. And that information from hospital acquired contamination charges and patient consummation notches, to Medicare repayment heights come from loads of unequal causes crosswise the society.
The character of data ascendency, which methods data as a calculated strength, is to safeguard the honesty of all this data and evidence, enterprise varied, is safe and precise. Info supremacy does will alteration how we achieve and use info, making a modest benefit in the marketplace for those who do it well. The performs of info supremacy admit the bang of statistics in health care due to the arrival of electronic health records and pathway the total charge of possession for data, which is mounting exponentially.
Hospital representatives should work with elder management to ensure that the group has an inclusive data ascendency plan in place. Challenges in organizations to measure their data veracity are seen. For instance, leading an evaluation of all the information on how many mothers delivered babies in their capability in an assumed year will prove how shared data faults may be. The odds are high, it is said, and that a man’s designation would be registered amongst those of the moms. If unassuming mistakes, such as this one are mutual, as suggested, it’s relaxed to envisage how all of a health care government’s info is at danger for covering mistakes. With proper provision, info supremacy can bond the openings among the essential to speech directive and lawsuit risk, the essential to produce augmented sales and income, and the essential to cut costs and develop well-organized. When done correct, info supremacy definitely influences each surface of the commercial.
Certainly, health care administrations contract with tests posed by risk and rule every day, chiefly as EHRs develop the standard under central commands, like the expressive use EHR Incentive Package. While EHRs grip the possible to make health care more well-organized, upsurge patient appointment and loan data analytics competences, EHRs need watchfulness to defend the information from privacy openings and data entrance mistakes.
2- A data warehouse can be used to achieve the succeeding tasks:
Path, accomplish and recover corporate presentation.
Observe and adapt a marketing movement.
Evaluation and enhance logistics and processes.
Upsurge the competence and efficiency of creation organization and growth.
Enquiry, join and admission dissimilar info culled from manifold sources.
Achieve and improve customer relations.
Prediction future development, requirements and deliverables.
Rinse and progress the excellence of your organization's information.
By enquiring and examining data in the data warehouse, administrations can recover processes and allow more well-organized business procedures, thereby cumulative income and levitation profits.
3- The choice to acquisition and device a data warehouse is typically ended by a line-of-business decision-making or an elevated IT policymaking in teamwork with appearances of business. The project to shape a data warehouse includes manifold individuals, counting occupational subject-matter specialists, data designers, database superintendents, coders and SQL query specialists, sideways with project bosses.
4- The ongoing organization of the data warehouse characteristically cascades to the file management component, maybe increased by data architects and presentation forecasters. But it's the line-of-business workers who are the conclusion operators of the data warehouse. After a commercial viewpoint, a data warehouse stage can bring a practical method to opinion the past deprived of moving the daily processes of the business. By enquiring and examining information in the data warehouse, administrations can recover operations and allow more well-organized business procedures, thus cumulative revenue and levitation of revenues.