In this hands-on lab, students will be presented with a dataset and a set of transformations to be applied.
Successfully complete this lab by achieving the following learning objectives:
- Cleanse the Data
- Truncate the department column of the users table to 3 characters.
- Append the Expense Code
- Append the expense code value to the department column.
- Count the Expenses
- Sum expense amounts from expenses table for each department.