DATA ARCHITECTURE AND DESIGN PLAN – Homework Help

Introduction

Once you have completed the needs analysis for your selected environment or scenario, the next step is to design the data architecture for the existing and new data identified in the needs analysis. This is a higher level than a database design, but it still requires a thoughtful design created with the end analytics and reporting needs in mind.

In the workplace, the purpose of a data architecture and design plan is to document the overall plan for the data sources, processing, storage, and outputs at an environment, scenario, or project level. This would then be split or funneled into a more detailed database or data structure models and extract transformation and load designs.

This assignment will build on the work you completed in the first assignment, and should include adjustments, edits, and additions to the needs analysis conducted as part of that assignment, based on new information you’ve gathered since then. In addition, it will include a more detailed architecture and design for the data itself (at a data source level, not individual field or table-level). Once the needs analysis is conducted, new and existing data identified, and an architecture design drafted for the environment, the final step will be including data governance and security considerations and designs, as well as metadata design. These will be completed and added to the full project as part of your final assignment for the course.

Instructions

Write a 4–6 page paper in which you describe your selected environment or scenario, summarize the results of your needs analysis, and draft a design for the data architecture needed to address the questions or problems identified using the existing and new data identified during the needs analysis. Include the following in your paper:

1. Describe your selected environment or scenario.
2. Describe the questions and problems that will be addressed with the data.
3. Identify the stakeholders involved with collecting, preparing, storing, analyzing, and using or consuming the data.
4. Describes all data sources (both existing and data that doesn’t exist but should start to be collected) that will be used to address the questions and problems identified.
5. Summarize the needs analysis you conducted for the previous assignment.
6. Describe your proposed data architecture design, including input data sources, data storage, and outputs (reports, analysis, et cetera).
7. Include a data architecture design diagram to visually represent your proposed data architecture design for the environment or scenario that you selected.

Additional Requirements

• Times New Roman font, no larger than 12 point.
• 4–6 pages of content, double-spaced, in addition to a title page, reference page, and appendix.
• Format of the paper should include the following headings:

• • Introduction.

• • • Overview of the paper and the environment or scenario.
  • Environment/Scenario.
  • Problems to Be Addressed.
  • Data Sources.
  • Needs Analysis Summary.
  • Data Architecture and Design Summary.

• • • This section should include your data architecture and design diagram.
  • Summary and Conclusion.
  • References.
  • Appendix.
• Include at least three reputable resources to support your ideas. Include a reference page.
• Follow APA rules for citing sources that support your analysis and conclusions.