This project is a demonstration of my skills using the newly released Tableau Prep software program. The original data set encompassed two tables.

• The first step was to utilize the union function to join the tables using employee code as the primary key.
• Step two (clean 1), I removed redundant and duplicate columns, I created a calculated field to split the department prefix from the employee code, I grouped and replaced the State column, and I changed the "Y" under the 401k enrollment column to read "Yes".
• Step three I pivoted the quarters 1-4 and the quarterly bonuses. 
• Step four I aggregated the bonus column, and grouped the emp code column.
• Step five I created a join clause between aggregate 1 Emp Code and Pivot 1 Emp Code. 
• Step six I input a third table, titled Emp FIN. 
• Step seven, I applied a second join cause, between my previous join column of Emp Code and the Emp Code column in the EMP FIN table introduced in step six.
• Step eight I removed a redundant column (Emp Code), renamed Bonus column to Yearly Bonus, I changed yearly bonus to a string data type, renamed bonus-1 column to Bonus, and removed the redundant column for department.
• Step Nine I saved my output as a .hyper file.