data engineering project

The owner of a chain store ask the data engineer to prepare a report presenting the following information: 1. The list of stores that sell each product. 2. The average sales of each product. 3. The maximum and minimum monthly sales of each product. 4. The store id and city name in which the maximum sales are recorded of each product. 5. The product name that recoded the maximum average sales. 6. The list of stores that no longer offer each product. The data engineer is given a dataset that stores the monthly sales of four products in the chain store. This data contains the following information: URL = "https://bit.ly/2KXbRzV" Store ID represents the identifier of each store. City represents the location of the store. Item 1, Item 2, Item 3, and Item 4 are the four products that the chain store offer. The entry value of these columns can be: O when the store does not offer this product. 1 when the store offers the product. 2 when the store no longer offers the product. Monthly Sales represents the monthly sales of the store in which this value is resulted from summing the monthly sales of the available products in the store. For example, if the monthly sales of the store are equal to 1500 and there are two products available in this store then the sales of each product are 1500/2 = 750. Currency represents the currency of monthly sales. You are asked as a data engineer to prepare an accurate report for the project manager. In addition, you are supposed to report all problems in the dataset as in the following example: Problem Col name/Whole dataset Number of defective rows Ratio of defective rows Problem 1 Store ID 1500 row 37.5% Where the number of defective rows refers to the count of rows that show the problem and the ratio of defective rows is the percentage of defective rows to the total number of rows in the dataset. The list of projects that each employee worked on. The average award received by each employee. The maximum and minimum monthly awards are received by each employee. The project id and language in which each employee received the maximum award for working on that project The employee name that received the maximum awards within 10 years. The number of projects that each employee did not work on it