Lab 2 Data Request Form - Sales & Products Analysis

Requestor Name: Lê Anh Tuấn Requestor Contact 0901305642 Number: Requestor Email
tuanle.31221025205@st.ueh.edu.vn Address:
Please provide a description of the information needed (indicate which tables and which fields you require): Sales data: - Sales orders - Products - Customers
What will the information be used for? Internal analysis Frequency (circle one) One-Off Annually Termly Other: Format you wish the Spreadsheet Text File data to be delivered in Word Document Other: (circle one): Request Date: 20/03/2025 Required Date: 27/03/2025 Intended Audience: Customer (if not requestor): Lab 2-2 Part 1 2-2MA OQ1: 3 Table:
- Finished_Goods_Products - Sales_Order_Lines
- Shipping_Cost from Sales_Order
OQ2: 569 rows were loaded for the Sales_Order query
OQ3: 6 rows were loaded for the Finished_Goods_Products Lab 2-2 Part 2 2-2MB 2-2 MC
OQ1: The total sales volume for Imperial Stout in January 2020 was 692
OQ2: The total sales volume for all products in January 2020 was 2295
OQ3: Imperial IPA is the worst sales performance Lab 2-3 2-3MA 2-3 MB
OQ1. 235630 rows were appear in cleaned dataset
OQ2. 19 columns were appear in cleaned dataset Lab 2-4 2-4MA 2-4 MB
OQ1: The maximum loan amount that was approved for borrowers from PA is 35000
OQ2: The average interest rate assigned to a loan to an approved borrowers from PA is 14%
OQ3: The average annual income of an approved borrowers from PA is 70,046.69 Lab 2-5 2-5MA 2-5 MB
OQ1: 1304 schools report average SAT scores
OQ2: The average completion rate (C150 4) off all the schools is 0,4779
OQ3: The schools report data to the U.S Department of Education
Document Outline

• Lab 2-2 Part 1 2-2MA
• Lab 2-2 Part 2 2-2MB
• Lab 2-3 2-3MA
• Lab 2-4 2-4MA
• Lab 2-5 2-5MA