Please use the case materials of Pixysystems. Please come u…
Please use the case materials of Pixysystems. Please come up with three ways use the case data related to accounts payable, inventory, and sales to provide insights to relevant parties, such as CFO, business process manager, internal audit department, and external audit. Dataset-Pixysystems-2.xlsx You are NOT required to perform the actual analyses. Specific requirements: Please identify two research questions related to accounts payable, inventory, and sales. (It is not necessary to focus on one account at a time. For each question, you may choose a combination of multiple accounts.) (20 pts) Please describe the audience of the analysis; and how they would benefit from the results. (10 pts) Indicate the data fields that is necessary for your analysis using the following format: “table name_field name”. Please include all fields that are necessary for your analysis. Make sure to use data from multiple tables in at least one of your analyses as it is necessary for requirement d. (20 pts) Describe how you will join tables when applicable. For each join, specify which is the left and right table; which data field serves as the matching keys; what is the type of the join; and why you need to use this specific type. It may not be necessary to perform joins for both research questions. Please put NA if a join is not necessary. (10 pts for all)