Answered step by step
Verified Expert Solution
Link Copied!

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.

  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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald Kieso, Jerry Weygandt, Terry Warfield, Nicola Young,

10th Canadian Edition, Volume 1

978-1118735329, 9781118726327, 1118735323, 1118726324, 978-0176509736

More Books

Students also viewed these Databases questions

Question

What is memory?

Answered: 1 week ago

Question

Find an equation of the given line. Slope is -2; x-intercept is -2

Answered: 1 week ago

Question

=+b. Examine the chart in part (a) for any out-ofcontrol points.

Answered: 1 week ago