Deliverable: a single Excel Workbook for:
· Cust ID – Unique ID for each customer
· Region – Sales Region of the country where the sale was made
· Payment Method – Method of payment
· Transaction Code – Unique transaction code for each transaction
· Purchase Source – How purchase was made
· Purchase Amount – Amount of purchase in USD $
· Product Type – Type of Product purchased
Submit a single Excel Workbook with worksheet tabs named as outlined above containing the 4 Required Pivot Tables listed in the Assignment document. Name and submit your Excel file in Canvas using the following naming convention: lastname-firstname-MBA6350- Case1.xlsx
Submit a single Word Document containing your “Executive Summary”. Ensure it follows the requirements listed in the Assignment Document. Name and submit your Word file in Canvas using the following naming convention: lastname-firstname-MBA6350-Case1.doc
