Assessment 4 Instructions: Data Reporting and Management
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.
Introduction
Working with multiple data sources creates challenges for many health care organizations. In this final component of
your Data Management and Governance Plan, you will construct a data map to meet organizational needs for data
use and integrity and to facilitate necessary reporting. In addition, you will compile a report to support the use of
data mapping for effective retrieval and storage processes.
Preparation
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
You wilsltbraeteingcyomrpaopratthinagt perloevmideendtsafrdoamtaeiancthegorfatthioensesttrharteeegyasfsoersIsnmdeepntesnidnetonctehiMs feindaicl aalssCeesnstmeer.nt. 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.
Instructions
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:
Data map.
2. Final data management and governance plan (DMGP).
3. Executive summary.
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:
Framework for Data Management and Governance Plan (Assessment 1): Data users, data organization,
and data processes.
Data Discovery Report and Independence Medical Center’s Core Data Set (Assessment 2): Data sets
and data elements.
Data Integration Strategy Map (Assessment 3): Integration strategies.
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.
Additional Requirements
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.
Competencies Measured
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.
9/29/22, 10:54 PM Assessment 4 Instructions: Data Reporting and Management &…
https://courserooma.capella.edu/webapps/blackboard/content/listContent.jsp?course_id=_382027_1&content_id=_11714695_1 4/4
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.