[SOLVED] using SQL to answer analytical questions

Objective:
Students will query the Northwind database (already provided on canvas – Northwind_DB.sql) using SQL to answer analytical questions. The resulting tables will be exported to Tableau for visualization.

Instructions

1. Database Setup:

o Import the provided Northwind database schema into your MySQL environment.

2. SQL Queries:

o Use SQL to answer the following analytical questions. Save your queries and export the resulting tables to .csv format.

3. Tableau Visualization:

o Import the .csv files into Tableau.

o Create appropriate visualizations to interpret and present your findings for each question.

o Create a dashboard to present your charts.

o Save your Tableau workbook and submit it along with the .csv files.

4. Submission Requirements:

o SQL scripts for each query.

o Exported .csv files for each question.

o Tableau workbook with your visualizations.

Questions

1. Sales Analysis by Country

Write a query to calculate the total sales (Quantity × Price) for each country.

2. Top Customers by Revenue

Identify the top 10 customers by total revenue (Quantity × Price).

3. Monthly Sales Trends

Analyze monthly sales trends by aggregating total sales (Quantity × Price) for each month.

4. Best-Selling Products

Find the top 5 products with the highest quantity sold.

5. Employee Sales Contribution

Calculate the total sales contributed by each employee.

Deliverables

1. SQL scripts for all five questions. (1 .sql file in which you will write answers to all 5 questions).

2. A Tableau workbook (.twbx file).

To export the result tables from SQL

1. Right-click anywhere in the Results Grid.

2. Select Export Results from the context menu.

3. In the Save File dialog box:

· Choose a location to save the file.

· Name the file (e.g., sales_by_country.csv).

· Ensure the file type is set to .csv (Comma-Separated Values).

· Click Save.