Answer the required questions a-f using R. Also answer the Bonus question.

BUA 301 – Homework 3 This assignment involves planning data transformations you can apply to structured data to answer business analytics questions. Complete the following problems by sketching out the transformations necessary for answering the business analytics question(s) specified in the problem. Required Problem You can find Problem 2 from Homework 2 below. Your assignment is to write an R script that uses the CSV files on D2L to answer each business analytics question. You are a national sales manager and want to produce a report analyzing sales. You have the following tables: INVOICES(invoice_number, customer_id, employee_id, invoice_date, payment_terms) INVOICE_LI(invoice_number, line_item_number, product_id, quantity_sold, unit_price) CUSTOMERS(customer_id, customer_name, region_id, customer_address) REGIONS(region_id, region_name, region_desciption, employee_id) EMPLOYEES(employee_id, employee_name) PRODUCTS(product_id, product_description, category_id, standard_unit_cost) PRODUCT_CATEGORIES(category_id, category_description) In the invoices table, the employee_id corresponds with the salesman responsible for the sale. In the regions table, the employee_id corresponds with the manager in charge of the region. Use the data transformations discuss in class along with “TOP” to answer the business analytics questions that appear below. Be sure to use names (and not IDs) to identify regions, customers, salesman, etc. a) What regions had the highest sales (in dollars) for the most recent quarter? b) What salesman generated the most revenue for the company during the most recent quarter? c) What was the top selling product category (by quantity and revenue) in the most recent quarter? d) What was the top selling product in each region in the most recent quarter? e) What customer purchased the most from the company (in dollars) over the last year? f) Assuming standard costs, what customer generated the most profit for the company over the last year? Bonus Problem You can earn bonus points by writing Python or SQL code that answers the business analytics questions from Homework 2 Problem 2 (i.e., repeat the required assignments using Python or SQL). I recommend using the sqldf data frame in R to write SQL and using the pandas package in Python to work with data frames. I will also award innovative uses of ChatGPT – share your chat/prompts to potential earn additional credit.