Order from us for quality, customized work in due time of your choice.
Assignment Overview
This assignment is composed of three parts. Be sure to compl
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/
Order from us for quality, customized work in due time of your choice.