Computers and Technology, 19.02.2021 17:00 mariaf0203

SQL Competency

In this project, you will demonstrate your mastery of the following competency:

Analyze the results of queries constructed to address data requirements
Scenario

The product manager of Quantigration has asked your data analytics team for a report summarizing your analysis of the return merchandise authorizations (RMAs) that have been received. These are the same data sets that you have already been working with. Your report should focus on summarizing the analysis and presenting your findings to the product manager.

Directions

RMA Report
In your report on the findings of your analysis, respond to the managerâ€™s requests to summarize the data you have been working with to identify key information that will be of value to the company when developing future business strategies to streamline operations. Remember, not everyone who reviews this report will have a technical background.

Begin by writing SQL commands to capture usable data (which you have preloaded into Codio) for your analysis. Specifically, the product manager wants you to investigate and analyze the following:
Analyze the frequency of returns by state, and describe your findings in your report.
Analyze the percentage of returns by product type and describe your findings in your report.
In your report, summarize your analysis of the data youâ€™ve captured. Include screenshots of the results of each query. When summarizing results, you may want to consider the following questions:
How does the data provide the product manager with usable information?
What are the potential flaws in the data that has been presented?
Are there any limitations on your conclusions, or any angles you havenâ€™t considered?
Clearly communicate your findings to stakeholders.
Make sure that all parts of your report are written in a way that very clearly explains the necessary information.
What to Submit

To complete this project, you must submit the following:

Data Analysis RMA Report
Submit a report for the product manager summarizing the results of your analysis. Your report will address the analysis that you have conducted. Provide screenshots of your SQL queries and their resultant output following the same instructions for capturing screenshots that you were given in previous assignments. Lastly, provide a brief summary in which you report on the findings of your analysis. Any references must be cited in APA format.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 21:00, Paulalex8765

Select all that apply. what types of documents can be created using word-processing software? business newsletters letters of application presentation slideshows customer databases

Answers: 1

continue

Computers and Technology, 21.06.2019 21:00, kitkatwolf

Analyze the following code. int x = 1; while (0 < x) & & (x < 100) system. out. println(x++); a. the loop runs forever. b. the code does not compile because the loop body is not in the braces. c. the code does not compile because (0 < x) & & (x < 100) is not enclosed in a pair of parentheses. d. the numbers 1 to 99 are displayed. e. the numbers 2 to 100 are displayed.

Answers: 3

continue

Computers and Technology, 23.06.2019 11:30, talyku7131

Me dangers of social media and the internetexplain what each means: 1) social media and phones have become an addiction.2) outside people have access to you all the time.3) cyberstalking4) cyberbullying5) catphishing6) viruses7) identity theft8) credit card fraud9) hacking10) money schemes

Answers: 1

continue

Computers and Technology, 24.06.2019 01:00, arturocarmena10

The initial tableau of a linear programming problem is given. use the simplex method to solve it. x 1 x 2 x 3 s 1 s 2 z 1 2 4 1 0 0 8 3 4 1 0 1 0 10 minus3 minus12 1 0 0 1 0 the maximum is nothing when x 1equals nothing, x 2equals nothing, x 3equals nothing, s 1equals3, and s 2equals0. (be sure to simplify to lowest terms if necessary.)

Answers: 2

continue

You know the right answer?

SQL Competency

In this project, you will demonstrate your mastery of the following comp...