For one dataset you describe in your email, I want you to write up a description of one dataset you describe in your email-essay. (One dataset might be Salesforce'shistory of salaries and bonuses for

Example Data Description Exercise ALY 6100 Based on Example Week 2 Email - essay Last Modified: 9 Feb 2020 1. Purpose of Dataset – Hierarchy of management and employees at Google, to use as a part of gathering performance data to determine the value of managers to Google 2. Source of dataset – Google’s internal recordings including performance reviews 3. Time window (that the dataset re presents) – 2007 - 2009 4. Cost of data (to the company) – Data exists internally in HR databases, but has never been gathered across departments before. Cost on the order of a week of engineering time expected. 5. Collection techniques and tools – Data will be p ulled and joined from internal databased. All Google IDs will be anonymized (for privacy reasons) before being output. The anonymization function and seed will be the same for this whole project. 6. Quality – Unknown if each department has been logging chang es to management roles at the same level of detail across the company. Will need to do an audit once data is pulled together. 7. Completeness – Similar to completeness, unsure how completely changes to managerial roles have been recorded across the company. W ill need to audit for completeness once data is initially pulled together. 8. Data definitions and classifications Variable name Definition Variable classification Pull date Dat e and t ime in formation was pulled (and presumed accurat e) Date EmployeeAnonID For a particular Google Employee, an anonymized version of their Google ID Integer Position Job Role at Google Categorical Position Level Num erical level associated with job role Ca tegoric al: Relative Magnitudes (Or dinal ) Department Department to which employee belongs Categorical Team name Team to which employee belongs Categorical ManagerAnonID Manager to whom Google Employee reports, an anonymized vers ion of their Google ID Integer 9. Example data Pulldate Employee AnonID Position Position Level Department Team name Manager AnonID 1/1/08 12:00 AM 541002 Staff Software Engineer 6 Software Engineering Google Home 900900 1/1/08 12:00 AM 491498 Senior Software Engineer 5 Software Engineering Google Home 541002 1/2/08 12:00 AM 411316 Software Engineer III 4 Software Engineering Google Home 541002 1/3/08 12:00 AM 542570 Software Engineer III 4 Software Engineering Google Home 541002 1/4/08 12:00 AM 606204 Staff Software Engineer 6 Software Engineering Google Home 900900 1/5/08 12:00 AM 396483 Senior Software Engineer 5 Software Engineering Google Home 606204 1/6/08 12:00 AM 852923 Software Engineer III 4 Software Engineering Google Home 606204 1/7/08 12:00 AM 826229 Software Engineer III 4 Software Engineering Google Home 606204 1/8/08 12:00 AM 121416 Software Engineer III 4 Software Engineering Google Home 606204 1/9/08 12:00 AM 827787 Software Engineer III 4 Software Engineering Google Home 606204