DAD $220$ Module Five Major Activity Template

Overview

Review the scenario for this activity in the guidelines and rubric. Then complete the steps below as you work through the directions for this activity. Replace the bracketed text with your screenshots and responses to the prompts. Size each screenshot and its explanation to fit approximately one$-$quarter of the page with the description written below the screenshot. Review the Template Screenshot Example linked in the guidelines and rubric for this assignment to see an example of how screenshots for your assignment should look.

Create a Database

$1.$ Write SQL commands that capture specific, usable data that can be used in your analysis.

A$.$ Reference notes for this step: Import the CSV file into MySQL Table. Use the following line terminators when importing: $\backslash$r

$.$ Do not use IGNORE $1$ LINES for data that does not have column headers in the first row.

$2.$ Analyze the results of queries to identify specific information that can be presented in your summary.

A$.$ Sales by region:

i$.$ Analyze sales data by state to determine where the company has the largest customer base.

$[$Insert screenshot and brief explanation here.$]$

ii$.$ Analyze the data to determine the top three products sold in the United States.

$[$Insert screenshot and brief explanation here.$]$

iii. Analyze the data to determine the top three products sold in the southeastern region of the United States.

$$ Southeastern states to include in your analysis: Virginia, North Carolina, South Carolina, and Georgia

$[$Insert screenshot and brief explanation here.$]$

B$.$ Returns by region:

i$.$ Analyze the data to determine the top three products returned in the United States.

$[$Insert screenshot and brief explanation here.$]$

ii$.$ Analyze the data to determine the top three products returned in the northwestern region of the United States.

$$ Northwestern states to include in your analysis: Washington, Oregon, Idaho, and Montana

$[$Insert screenshot and brief explanation here.$]$

$3.$ Write a report to the Quantigration product manager that explains your findings in a way nontechnical stakeholders can understand and use.

A$.$ Provide an effective summary of your findings from the analysis of the sales and returns data you captured. Write at least one paragraph for each of your responses to the prompts below.

i$.$ Sales data by region: Provide a well$-$written summary of findings from your analysis in Step Two, Part A$.$

$[$Write your response here.$]$

ii$.$ Returns data by region: Provide a well$-$written summary of findings from your analysis in Step Two, Part B$.$

$[$Write your response here.$]$