Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
- Summary of the business problem including the requestor who initially brought the problem to you.
- Summary of the data that were requested and how they was obtained.
- Discussion of the limitations of the available data and ethical concerns related to those limitations.
- 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.
- Recommendations for addressing the business problem.
- In addition to the report, the manager has requested that you submit the Excel files summarizing the data findings that resulted from your queries.
- 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started