For this assignment, continue to assume the role of a data analyst at Adventure Works Cycling Company.
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Intermediate Accounting
ISBN: 978-0176509736
10th Canadian Edition, Volume 1
Authors: Donald Kieso, Jerry Weygandt, Terry Warfield, Nicola Young,
Posted Date: