Arizona State University - WPC 300 (Hybrid Course) Assignment-4 Maximum points: 25

Document Content and Description Below

WPC 300 (Hybrid Course) Assignment-4 Maximum points: 25 Student Name: ____________________ Class Day &Time:__ Instructions This assignment builds on the ETL In-Cl... ass Assignment using the Excel workbook “ETL Exercise.xlsx.” If you haven’t finished that yet, you’ll need to do that before starting this. • Save the “ETL Exercise.xlsx” as FullName_ETLExercise.xlsx. Save this document as YourFullName_AssignmentETL.docx. • Finish all tasks below • Submit o the answers to the questions on a new blank word document o the final version of your YourFullName_ETLExercise.xlsx worksheet. The In-Class Exercise involved a scenario where you brought together two different data sets from two sources. Each data set contained a group of orders by a group of customers, and those customers did not overlap (no customer was in both data sets). For this assignment, you’ll be building on that data set by adding new fields to the “Full Set” worksheet. Instead of adding new rows, this time you’ll be adding new columns. The data will come from the “Source 3” worksheet (also in the workbook). Evaluation Your submission will be graded based on two factors: • The correctness of the answers to the questions. • The accuracy of the “Full Set” worksheet in the “ETL Exercise.xlsx” workbook. Data preparation for answering assignment questions. Part 0: Complete the lab for week-5 [5 points] Part 1: Add the “Credit Line” information from “Source 3” to “Full Set” Question: Which customer(s) lacks usable data when you apply the VLOOKUP() function? Explain what is causing this problem? [5 points] Part 2: Add the “Missed Payments” information from “Source 3” to “Full Set” Question: Write the data transformation rule for the missed payment field (list the syntax of the IF() function and explain the criteria you used to transform the data). [5 points] Part 3: Add the “Country” information from “Source 3” to “Full Set” Question: Write the data transformation rule for the country field (list the syntax of the IF() function and explain the criteria you used to transform the data). [5 points] Part 4: Applying ETL Question: Using this assignment, briefly illustrate how ETL plays a critical role in analytics. [5 points] [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages