Popular model have dropped based upon data analysis

Assignment Help Basic Computer Science

Reference no: EM132393391

The purpose of this assignment is to analyze data and use it to provide stakeholders with potential answers to a previously identified business problem.

For this assignment, continue to assume the role of a data analyst at Adventure Works Cycling Company. Evaluate the data associated with the drop in sales for the popular model "LL Road Frame-Black 60." Provide a hypothesis on what could be contributing to the falling sales identified in the initial business problem presented by your manager.

In 250-500 words, share these recommendations in a Word document that addresses the following.

1. Summary of the business problem including the requestor who initially brought the problem to you.

2. Summary of the data that were requested and how they was obtained.

3. Discussion of the limitations of the available data and ethical concerns related to those limitations.

4. Hypothesis of why sales of the popular model have dropped based upon data analysis. Reference the Excel file that summarizes the data findings that resulted from your queries.

5. Recommendations for addressing the business problem.

6. In addition to the report, the manager has requested that you submit the Excel files summarizing the data findings that resulted from your queries.

7. The manager has also requested that you update the ERD you created in the Topic 5 assignment to include the tables generated as a result of the joins completed in the Topic 6 assignment. The ERD should clearly document the work stream and relationships.

Compile the updated ERD, Excel data file, and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor.

Reference no: EM132393391

Questions Cloud

Discuss how the security flaw is manifested : Describe the security flaw, and discuss how the security flaw is manifested. Discuss how viruses, adware, spyware, and malware would impact your organization.

Licensed clinical psychologist : For example, if you are going to graduate school to become a licensed clinical psychologist, how will this information help your clients?

What brain structure is affected in amnesia patients : What brain structure is affected in amnesia patients (the type of amnesia where they cannot create new explicit memories)?

Explain treatment approach : Explain Treatment Approach, Methods & Practice Techniques for trauma therapy

Popular model have dropped based upon data analysis : Hypothesis of why sales of the popular model have dropped based upon data analysis. Reference the Excel file that summarizes the data findings

Psychological disorders or mental distress : Question: Not really sure how to approach this assignment. Just needing some type of guidance to began this assignment.

Outline some of the software development policies : Outline some of the software development policies in terms of security and discuss how it could be implemented in an organization.

What you have learned about the history of veiling : Explain your understanding of veiling and hijab prior to reading the book. Then summarize what you have learned about the history and significance of veiling.

Best practices in managing changes to windows systems : Discuss the best practices in managing changes to windows systems and applications, and relate it to Deming Cycle.

User Account

All Pages