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/
Important - Read this before proceeding
These instructions are based on a task we've worked on previously. If you're looking for an answer to the same assignment, you'll need to submit an order on our writers' platform to receive a unique paper that you can confidently present as your own work. Read our "How It Works" page for more information.