Wk 5 Discussion – Capturing and Storing Big Data [due Thurs]

Discussion TopicPost a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to the following in a minimum of 175 words:

• Describe structured, semi-structured, and unstructured data, in a Big Data context.
• Research one challenge to capturing and storing each type of data, as well as strategies available to manage the challenge.
• Explain how query optimization supports data structures.

Due Monday

Reply to at least two of your classmates. Be constructive and professional in your responses.

Wk 5 – U.S. Student Aid Data Debrief [due Mon]

Assignment Content

1. 
   The project sponsors of the U.S. Student Aid Data project want you to participate in the project debrief meeting. You are to provide information around the methodology and practices you used to develop the database and the reporting tools used to answer the project questions.
   
   Refer to the U.S. Student Aid Data assignments you completed throughout this course to prepare your debrief report. Previous assignments may need to be revised with instructor feedback.
   
   Document the following for the project sponsors:

   • An explanation of the schema selected to develop the database, including:
   • A summary of any schema discrepancies you found and how you resolved them
   • The process and considerations you used to select the best schema for the database
   • The strategy you used to optimize and incorporate best practices into the SQL used to develop the databases, including strengths and weaknesses of the techniques you used
   • The strategy used to transform from one schema to another
   • The challenges encountered while preparing the data for analysis
   • The strategy used to clean the data
   • The tools you selected for integrating various database elements, including the strengths and weaknesses of these tools
   • Screenshots, diagrams, and other images as needed to support your summary
   • Practices you will replicate or avoid in similar projects based on your experiences with this project

   Present your summary as either:

   • A 10- to 12-slide Microsoft® PowerPoint® presentation with detailed speaker notes
   • A 3- to 4-page Microsoft® Word document

   Submit your assignment.