The Sales Transactions worksheet has 40,000 rows and the col…
The Sales Transactions worksheet has 40,000 rows and the columns are: Sales Order ID Sales Order Date Customer ID Product Code ID Sales Order Quantity Sold Product Sales Price The Customers worksheet has 150 rows and the columns are: Customer ID Customer Name Customer State The Products worksheet has 25 rows and the columns are: Product Code Product Description Required: 1. Describe how you would combine the data into a single dataset in Excel. Be specific about the tool(s) you would use 2. Describe two descriptive analyses you could perform after combining the data. Be specific about analysis type and Excel tool 3. Management notices that some products have declining sales. Describe one diagnostic analysis to determine the cause. Be specific about the tool What specific insight do you expect this to provide?