• Extract, Transform, and Load (ETL) Process: Describe the ETL process.
  • Describe the ETL process as it relates to your proposal to close the gap. Describe what data needs to be extracted, how the data could be transformed to meet future needs, and where the data will be loaded for storage.
• Sensitive or Confidential Information Handling: Write a summary for the handling of sensitive or confidential information.
  • The storage, handling, and manipulation of confidential or sensitive information is an important part of data handling projects.
    • Identify if there is or could be sensitive or confidential information contained in your organizational problem, and describe how sensitive information will be handled.
    • Identify the sources of the above information and any regulatory considerations in using that information.
• Production and Testing Environments: Identify appropriate use of production and testing environments needed for the data project.
  • Explain why using sandbox environments is important to the preservation of data integrity.
• Additional Data Resources: Justify the need for additional data resources, defending the need for any resources that seem currently out of the scope of the project.

What to Submit

To complete this project, you must submit the following:

Gap Analysis Submit your completed gap analysis matrix using the Gap Analysis Template.

Presentation and Presentation Speaker Notes

• Presentation: Submit your presentation using the Project Two Presentation Template. Your presentation should be 12 to 15 slides in length. Include speaker notes for each presentation slide. Any sources should be cited according to APA style.

Supporting Materials

The following resource supports your work on the project:

Spreadsheet: Kansas City and Warehouse Data Set Use this spreadsheet to access data for Project Two.

Document: Kansas City Monthly Totals Use this spreadsheet to access data for Project Two.