联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-21:00
  • 微信:codinghelp

您当前位置:首页 >> Database作业Database作业

日期:2024-12-12 05:13

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.


版权所有:编程辅导网 2021 All Rights Reserved 联系方式:QQ:99515681 微信:codinghelp 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。 站长地图

python代写
微信客服:codinghelp