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/
Assignment Overview This assignment is composed of three parts. Be sure to compl
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
