this is business analytics

You have recently been hired as a Junior Business Analyst for a small analytics firm called Analytics R'Us. The VP of Sales and Marketing for one of their clients, the Michael Scott Paper Company, as asked the firm to analyze their company dataset to understand which customers are the most and least profitable and which employees have the highest average sales price. They would like to have this information organized into some tables and have Analytics R'US provide a quick rundown of the results. You will need to download the following files: 1. MichaelScottPaper Company.accdb This is the Microsoft Access Database we will be analyzing. 2. MSPC Customer Profitability Report.docx This is a template for your report to the Michael Scott Paper Company that you will fill out and make professional. You must complete the following tasks: 1. Create a table containing all of the Michael Scott Paper Company's customers including their first and last name, the company they work for the position they hold (job title) and how profitable that customer has been (i.e, how much did they spend at MSPC vs. how much they cost MSPC in terms of salesperson labor). 2. Create a table containing all of the Michael Scott Paper Company's sales people including each sales person's first and last name, the date they started at the company, and the average price of that sales person's sales. 3. After creating the table queries, you must export them and properly include them in the Report template. 2. MSPC Customer Profitability Report.docx This is a template for your report to the Michael Scott Paper Company that you will fill out and make professional. You must complete the following tasks: 1. Create a table containing all of the Michael Scott Paper Company's customers including their first and last name, the company they work for the position they hold (job title) and how profitable that customer has been (i.e, how much did they spend at MSPC vs. how much they cost MSPC in terms of salesperson labor). 2. Create a table containing all of the Michael Scott Paper Company's sales people including each sales person's first and last name, the date they started at the company, and the average price of that sales person's sales. 3. After creating the table queries, you must export them and properly include them in the Report template. 4. You must also make sure to include your name on the cover letter (Analytics R' Us will look stupid if you forget to do this and leave the template value) 5. You must write a professional looking (good grammar, spelling, spacing, etc.) executive summary making sure to answer the prompts provided in the document. Once you have satisfactorily completed these tasks, please upload and submit your finished Microsoft Word document as your assignment through Canvas. EXECUTIVE SUMMARY > > > You have recently been hired as a Junior Business Analyst for a small analytics firm called Analytics R'Us. The VP of Sales and Marketing for one of their clients, the Michael Scott Paper Company, as asked the firm to analyze their company dataset to understand which customers are the most and least profitable and which employees have the highest average sales price. They would like to have this information organized into some tables and have Analytics R'US provide a quick rundown of the results. You will need to download the following files: 1. MichaelScottPaper Company.accdb This is the Microsoft Access Database we will be analyzing. 2. MSPC Customer Profitability Report.docx This is a template for your report to the Michael Scott Paper Company that you will fill out and make professional. You must complete the following tasks: 1. Create a table containing all of the Michael Scott Paper Company's customers including their first and last name, the company they work for the position they hold (job title) and how profitable that customer has been (i.e, how much did they spend at MSPC vs. how much they cost MSPC in terms of salesperson labor). 2. Create a table containing all of the Michael Scott Paper Company's sales people including each sales person's first and last name, the date they started at the company, and the average price of that sales person's sales. 3. After creating the table queries, you must export them and properly include them in the Report template. 2. MSPC Customer Profitability Report.docx This is a template for your report to the Michael Scott Paper Company that you will fill out and make professional. You must complete the following tasks: 1. Create a table containing all of the Michael Scott Paper Company's customers including their first and last name, the company they work for the position they hold (job title) and how profitable that customer has been (i.e, how much did they spend at MSPC vs. how much they cost MSPC in terms of salesperson labor). 2. Create a table containing all of the Michael Scott Paper Company's sales people including each sales person's first and last name, the date they started at the company, and the average price of that sales person's sales. 3. After creating the table queries, you must export them and properly include them in the Report template. 4. You must also make sure to include your name on the cover letter (Analytics R' Us will look stupid if you forget to do this and leave the template value) 5. You must write a professional looking (good grammar, spelling, spacing, etc.) executive summary making sure to answer the prompts provided in the document. Once you have satisfactorily completed these tasks, please upload and submit your finished Microsoft Word document as your assignment through Canvas. EXECUTIVE SUMMARY > > >