Assessment 4 Instructions: Data Mapping and Final DMGP
Create a data map that depicts enterprise architecture, data integration, and use of multiple data sources. Write a final data management and governance plan (4-5 pages) that enables a health care organization to manage and govern its data, along with a 1-page executive summary.Data mapping processes are vital for health care organizations to do all of the following:
Determine organizational data needs.
Identify how data interacts within multiple sources.
Maintain data integrity.
Data maps are a road map to data collection, retrieval, and storage. They support data quality, integration, strategy, process improvement for patient outcomes, and business intelligence practices. Business intelligence, the practice that uses tools to analyze data for reporting, begins by identifying data sources. Ultimately, good business intelligence depends on good data and clearly defined mechanisms that spell out how data from one system maps to another. Working with multiple data sources or systems is often challenging for health care organizations. IT departments in the health care industry are responsible for making sure an infrastructure is in place to support multi-source integration and systems communications. As you are the Privacy and Security Manager for Independence Medical Center, your boss, the CIO, has asked you to construct a data map for the organization. This data map needs to take into account relevant data management and governance best practices for data retrieval and storage. After creating your data map, you will also compile a final data management and governance plan (DMGP), including a one-page executive summary.
DEMONSTRATION OF PROFICIENCY
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:
Competency 3: Analyze the impacts of data warehousing.
Describe data warehousing and its importance in enterprise architecture.
Compare and contrast the advantages and disadvantages of implementing a data warehouse.
Competency 4: Analyze effects of database design and architecture in integrating and using various data sources.
Create a data map demonstrating enterprise architecture, data integration, and use of multiple data sets.
Explain architecture’s influence on data-sharing and reporting tasks.
Communicate professionally in a health care environment.
Create clear, well-organized, professional documents that are generally free of errors in grammar, punctuation, and spelling.
Follow APA style and formatting guidelines for citations and references.
To successfully complete this assessment, you will need to revisit the work you did in your first three assessments:
Assessment 1: You wrote a recommendation to create a DMGP framework for Independence Medical Center. You also created a diagram to visually represent your proposed framework.
Assessment 2: You defined data elements and formats that support enterprise information management and data integration in an Excel spreadsheet. You also wrote a data discovery report that identified the data quality issues Independence Medical Center was experiencing and recommended strategies for addressing and preventing them from occurring in the future.
Assessment 3: You created a data integration strategy map that illustrated a strategic framework, accountability, and quality and control mechanisms. You also wrote a workplace brief to accompany the strategy map that provided a data integration strategy for Independence Medical Center.
You will be incorporating elements from each of these three assessments into this final assessment. You will not simply copy and paste your first three assessments to create this one. Instead, you will need to selectively decide which elements from the first three assessments to incorporate into this one. You will be condensing the most critical information to carry forward.
For this assessment, you are preparing for a meeting with your boss, the CIO. He appreciates all of the work you have done to date. He is now asking you to compile all of your previous findings into a final data governance and management plan (DMGP). He has also asked you to prepare a one-page executive summary that concisely highlights Independence Medical Center’s background information, identified problems, recommendations, and conclusions.You realize that as part of your DMGP, you also need to create a data map to illustrate Independence Medical Center’s data sources, collection points, and storage systems. Your data map will serve as the prototype for the ongoing definition of organizational data needs and data integrity requirements.This assessment consists of these three parts:
Final data management and governance plan (DMGP).
As a best practice, please complete these three parts in the order listed above. Note: Typically reviewers read the executive summary before reading the final DMGP. However, typically writers prepare the DMGP first. Once they have prepared the longer plan, they cull information from it to prepare the executive summary. That is why the sequence listed above is the recommended order for you to complete the three parts to this assessment.
Part 1: Data Map
Create a data map that depicts enterprise architecture, data integration, and use of multiple data sources.
Be sure that your data map shows how the various systems match to each other and how they exchange patient information.
Use the information from your data discovery report and Independence Medical Center’s core data set (Assessment 2) and your data integration strategy map (Assessment 3) to create Independence Medical Center’s model data map.
You may use any tool (Excel, Word, Visio, PowerPoint, et cetera) you wish to create your data map.
Part 2: Final Data Management and Governance Plan (DMGP)
In your 4–5 page final data management and governance plan, be sure to address all of the following headings and answer all of the questions underneath each heading:
Data Management and Governance Framework (1/2 page).
What are the three or four most important takeaways you want the CIO to remember about the:
DMGP structure you are recommending Independence Medical Center adopt?
Specific ways the DMGP structure will help Independence Medical Center manage and govern data from multiple sources?
Note: Assessment 1 is the source of this information.
Data Discovery (1/2 page).
What are Independence Medical Center’s three or four major data quality and data formatting issues you uncovered?
Which two or three of your recommendations will have the most impact on addressing Independence Medical Center’s data quality and data formatting issues?
Note: Assessment 2 is the source of this information.
Data Integration (1 1/2 pages including your data integration strategy map).
What are Independence Medical Center’s two to three most significant data quality and integration issues that influence database design and architecture?
What are the most salient points about your integration strategy that you want the CIO to remember?
Note: Assessment 3 is the source of this information.
Data Map Narrative (2 pages).
Be sure the narrative accompanying your data map answers these questions:
What is data warehousing? Why is it important in enterprise architecture?
What are the advantages and disadvantages of implementing a data warehouse?
What is data architecture’s influence on internal and external data-sharing and reporting tasks?
Include your data integration strategy map with your narrative.
Conclusion (1 to 2 paragraphs).
What are the two or three most critical points you want the CIO to remember about Independence Medical Center’s final DMGP?
Part 3: Executive Summary
In your 1–2 page executive summary (preferably one page), summarize the most critical issues covered in your final DMGP. In shorthand fashion, break your summary down into three main parts:
Background information about Independence Medical Center, including how its DMGP can help the Center achieve its strategic priorities.
Data quality and integration issues uncovered during this course-long investigation.
Recommendations and conclusions.
Length: Data map; 4–5 page final DMGP; 1 page executive summary.
Format: Times Roman, 12 point type.
APA: Follow APA style and formatting guidelines for citations and references. Include a separate References page.
Writing: Create clear, well-organized, professional documents that are generally free of errors in grammar, punctuation, and spelling.
Resources: Data Mapping
Health Care Administration Undergraduate Library Research Guide.
Consult this guide as needed to conduct independent research on course topics. This resource will direct you to scholarly, peer-reviewed, and authoritative resources.
Three Levels of Data Modeling | Transcript.
Resources: Master Patient Data
Dooling, J. A., & Downing, K. (2014). Ensuring data integrity through a clean master patient index. Journal of AHIMA, 85(3), 46–47.
Just, B. H., Marc, D., Munns, M., & Sandefer, R. (2016, Spring). Why patient matching is a challenge: Research on master patient index (MPI) data discrepancies in key identifying fields. Perspectives in Health Information Management, 1–20.
Nelson, M. L. (2015). The “keys” to help solve patient data matching. Journal of AHIMA, 86(8), 28–30.
Tools and Methods of Mapping Master Data | Transcript.
Resources: Data-Driven Approach
Dooling, J. A., Houser, S. H., Mikaelian, R., & Smith, C. P. (2016). Transitioning to a data-driven, informatics-oriented department. Journal of AHIMA, 87(10), 58–62.