You just learned three different approaches to identifying potentially problematic/invalid data: (a) filtering, (b) data validation, and (c) PivotTable. Now you are ready to apply these approaches to the following fields in the table: Facility, Hire Date, Start Date, and Onboarding Completed. Be sure to revisit the definitions of the data fields that appear at the beginning of this tutorial in the Background section.

1.Using the PivotTable approach and one other approach of your choosing (filtering or data validation), identify any data integrity issues for the Facility, Hire Date, Start Date, and Onboarding Completion fields.

2.Describe any data integrity issues you identified in each field, and make recommendations regarding what information you might use (within the data table itself or potentially in the organization at large) to correct data integrity issues, which ultimately cleans the data.

Employee ID - EA4411 : EA4412 Onboarding Completed Yes EA4413 EA4414 EA4415 Y EA4416 EA4417 Ray Last Name First Name Job Level Facility Hire Date Start Date Linkous Kenan 1 Omaha, NE 1/28/2017 2/1/2017 Robertson James 3 Omaha, NE 9/1/2013 9/11/2013 Zuckerman Mandie 5 Charlotte, NC 2/9/2013 2/10/2013 Swartout Shayna 4 Charlotte 7/10/2015 7/18/2015 Jimenez Derek 4 Indianapolis, IN July 16 2015 July 18 2015 Tyler Chun 3 Charlotte, NC 2/21/2018 3/2/2018 Tyson 3 Omaha 9/15/2013 9/29/2013 Jensen John 5 Charlote, NC May 10th 5/12/2016 Keagle Fatima 5 Indianapolis, IN 11/9/2018 11/12/2018 Mckay Horace 11 Indianapolis, IN 3/25/2014 4/1/2014 Lafountain Floyd 4 Omaha, NE 6/1/2017 June 6th Ward Kris 5 Indianapolis, IN 5/20/2013 5/22/2013 Connor Johan Charlotte, NC 4/29/2118 5/2/2018 Hernandez Rolf 3 Indianapolis, IN 8/15/2015 8/16/2015 Bailey Courtney 3 Omaha, NE 10/10/2013 10/16/2013 No 5 Yes N EA4418 0 EA4419 1 EA4420 2 EA4421 3 EA4422 4 EA4423 5 EA4424 6 EA4425 7 5 Yes N 3 3