Lab 2-2 -I could really use some help with this lab, I'm not understanding what to do.

Slinte has brought you in to help determine potential areas for sales growth in the next year. Additionally, management has noticed that the companys margins arent as high as they had budgeted and would like you to help identify some areas where they could improve their pricing, marketing, or strategy.

Specifically, they would like to know how many of each product were sold, the products actual name (not just the product code), and the months in which different products were sold.

1. Q1.Given Slintes request, identify the data attributes and tables needed to answer the question. You can rely on Lab Exhibit 2-2A to help answer this question. If you are simply trying to calculate statistics or make comparisons using attributes within a single table, there is no need to transform the tables. Simply load the table, make sure the data are clean, and proceed to analysis. For example, to find the total number of each item sold, you would need only the [Sales_Subset] table and its attributes [Product_Code] and [Sales_Order_Quantity_Sold].

2. Q2.List two other questions that could be answered using only a single table from the Slainte dataset. Given the sales data, management has asked you to prepare a report showing the total number of each item sold each month between January and April 2020. This means that we should create a PivotTable with a column for each month, a row for each product, and the sum of the quantity sold where the two intersect.

3. Open any of the files you created in Part 2 in Excel, and click the Insert tab on the ribbon.;Click PivotTable in the Tables section.; In the Create PivotTable window click Add this data to the Data Model. Note: If you have only one table, choose Select a table or range and choose your sheet.; Click OK to create the PivotTable. A PivotTable Fields pane appears on the right.

   • Note: If at any point while working with your PivotTable, your PivotTable Fields list disappears, you can make it reappear by ensuring that your active cell is within the PivotTable itself. If the Field List still doesnt reappear, navigate to the Analyze tab in the Ribbon, and select Field List.

4. Click the arrow toggle next to each table to show the available fields. If you dont see your three tables, click the All option directly below the PivotTable Fields pane title. ;Take a screenshot of your PivotTable field list (label it 2-2D) ; Because you defined relationships or merged the tables in Part 2, you can drag any of the attributes from your list of fields to their respective Filters, Columns, Rows, or Values. Do that now:

   1. Columns: [Sales_Order_Date] (Month) from [Sales_Subset]. Note: When you add a date, Excel will automatically try to group the data by Year, Quarter, etc. For now, remove the other options.

   2. Rows: [Product_Description] from [FGI_Products].

      • Note: If you imported the data from the Access database query, it will be named Product.Product_Description

5. 1. Values: [Sales_Order_Quantity_Sold] from [Sales_Subset]. Filters: None.; Finally, to show only the four months from January to April, click the drop-down arrow next to Column Labels in the PivotTable (not in the Field list) and uncheck Nov and Dec.; Take a screenshot of your PivotTable (label it 2-2E). Save a copy of your workbook as Slainte_Pivot.xlsx.

6. 

LAB EXHIBIT 2-2A Sales Subset Customer 1 * 1 FGI Product PK: Product Code Product_Description Product_sale_Price PK: Sales_Order_ID Sales_Order_Date FK: Sales_Employee_ID FK: Customer_ID FK: Product_Code Sales_Order_Quantity_Sold Product_sale_Price PK: Customer_ID Business_Name Customer_Address Customer_city Customer_st Customer_zip LAB EXHIBIT 2-2A Sales Subset Customer 1 * 1 FGI Product PK: Product Code Product_Description Product_sale_Price PK: Sales_Order_ID Sales_Order_Date FK: Sales_Employee_ID FK: Customer_ID FK: Product_Code Sales_Order_Quantity_Sold Product_sale_Price PK: Customer_ID Business_Name Customer_Address Customer_city Customer_st Customer_zip