USE THE DATA BELOW AND PDF to help FORM THE EXCEL Customer Data
Rewards Card Purchases: This organization offers a rewards credit card to their customers that can be used for any kind of purchase. This data set is a sample of purchases customers made with their rewards card in 2017 and 2018. The data include the amount of purchase, the date of purchase, the a brief description of the purchase, whether the purchase counted for bonus rewards points, and how many rewards points the customer received for the purchase. Download Rewards Card Purchases-1.xlsx E-Commerce Transactions: This organization has online sales that ship to locations all over the United States. This data set contains items sold online from 2018 to 2021, a small description of each item, the quantity of that item purchased, the price of each item, the state of the shipping address, and the customer ID of the customer who made the purchase. These customer IDs may overlap with those in the Rewards Card Purchases data set. Download E-Commerce Transactions-1.xlsx Human Resource Data
Full HR Data Set: This data set includes all of the people who are currently employed at this organization, and those who have separated (historically back to 2010). It includes demographic information about each employee, information about their position, about their supervisors, the method they were recruited/hired, their performance score, their retirement eligibility date, and a recent survey score about their satisfaction with their job. Download Full HR Data Set-2.xlsx Production Staff: This data set includes some performance data for the employees who are on the production team (and those who have recently separated. The data set describes some demographic information for the employees, their position title, their hourly pay, their supervisor, performance score, and some production statistics (how many units they produce per hour for 2 weeks, and their daily error rate). Download Production Staff.xlsx