This assignment requires completing three parts, including reviewing SQL, MS Excel pivot tables, and conducting an urgent customer analysis for WWI using provided resources and uploading the work to Canvas.

Assignment Overview
This assignment is composed of three parts. Be sure to complete each part to get full credit. All of your work should be uploaded on this page.
NOTE: DO NOT USE GOOGLE SHEETS FOR THIS ASSIGNMENT. YOU MUST USE EXCEL!
Part A. SQL Review (15 points) Please upload your work using the file name: A2-SQL-uniqueID.doc (or .txt or docx) to Canvas.
Part B. MS Excel Pivot Table Reveiw (15 points) Please upload your work using the file name: A2-PT-uniqueID.doc (or .txt or docx) to Canvas.
Part C. WWI – Urgent Customer Analysis (30 points) Please upload your work using the file name: A2-WWI-1-uniqueID.doc (or .txt or docx or .xls) to Canvas. 
RESOURCES:
Review of SQL: SQL-WarmUp-Tutorial.pptx
Tutorial for Pivot Tables: 
Excel_pivot_tables_tutorial.pdf
Overview of PivotTable.pdf
https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576  

https://www.sqldatadictionary.com/WideWorldImporters/

The post This assignment requires completing three parts, including reviewing SQL, MS Excel pivot tables, and conducting an urgent customer analysis for WWI using provided resources and uploading the work to Canvas. appeared first on instant assignment support.