Internal Data

by | Aug 8, 2025 | Homework Answsers / Business & Finance / Accounting

I'm unsure of the correct way to do this as it is strong suit. I need the landing page fixed, the other sheets are simply information that lays out the assignment. Data audit report is the sheet to refer to. 

Instructions

Complete the following steps for cleaning the internal data provided.

Steps

  • 1Download and Review the Data File
    The file below contains conversion data from Buhi's website. Identify any extreme outliers, incorrect value formats, impossible values, null values, and data outside of Q3. These values are errors in the data.
  • 2Clean Landing Page – Conversions Data
    Remove the erroneous values you identified by clearing the individual cells containing them, not entire rows. After clearing a cell, simply leave it empty. Then, upload your cleaned file and check the correctness of your cleaned data by clicking Validate.

    Note: If there are any errors remaining when you validate your file, you'll receive feedback pointing out the rows and columns where the errors are. When referring to column numbers, the numbering starts at zero. Therefore, column 0 in the feedback refers to the ID column, column 1 is Landing Page, and so on.

(If you're using a spreadsheet application, deleting erroneous values in one column may cause a long value from an adjacent column to appear to bleed into the now-empty cell. This only affects the way the spreadsheet is displayed, not the actual value of the cell in question, which is still empty.)

 

Upload Cleaned Internal Data

Accepted File Requirements

  1. File must be uploaded as a csv
  2. File must contain 7 columns with the names: "ID", "Landing Page", "Date Range", "Country", "Ad Campaign Clicks", "Converted Sales", "Instructions"
  3. File must contain 391 rows (+-10)
ID Landing Page Date Range Country Ad Campaign Clicks Converted Sales Instructions
1001 /tote/canvas/pink 10/01/2022 – 10/07/2022 USA 1111 135
1002 /backpack/medium/orange 10/01/2022 – 10/07/2022 USA 755 157
1003 /pouch/medium/red 10/01/2022 – 10/07/2022 USA 1548 136
1004 /messenger/medium/brown 10/01/2022 – 10/07/2022 USA 1041 36
1005 /bag/gym/blue 10/01/2022 – 10/07/2022 USA 533 95
1006 /tote/large/red 10/01/2022 – 10/07/2022 USA 1753 85
1007 /backpack/leather/brown 10/01/2022 – 10/07/2022 USA 892 104
1008 /wallet/leather/black 10/01/2022 – 10/07/2022 USA 1019 54
1009 /tote/canvas/white 10/01/2022 – 10/07/2022 USA 1267 145
1010 /wallet/medium/brown 10/01/2022 – 10/07/2022 USA 1256 133
1011 /pouch/leather/red 10/01/2022 – 10/07/2022 USA 538 27
1012 /duffle/leather/red 10/01/2022 – 10/07/2022 USA 836 57
1013 /duffle/medium/pink 10/01/2022 – 10/07/2022 USA 1195 176
1014 /backpack/leather/orange 10/01/2022 – 10/07/2022 USA 1059 31
1015 /duffle/canvas/orange 10/01/2022 – 10/07/2022 USA 1174 104
1016 /wallet/gym/blue 10/01/2022 – 10/07/2022 USA 1145 54
1017 /travel/leather/black 10/01/2022 – 10/07/2022 USA 811 33
1018 /backpack/gym/pink 10/01/2022 – 10/07/2022 USA 517 170
1019 /pouch/canvas/black 10/01/2022 – 10/07/2022 USA 1633 44
1020 /duffle/leather/blue 10/01/2022 – 10/07/2022 null 1576 148 Delete null and leave blank.
1021 /backpack/medium/gray 10/01/2022 – 10/07/2022 USA 1231 98
1022 /bag/gym/black 10/01/2022 – 10/07/2022 USA 1509 36
1023 /tote/large/gray 10/01/2022 – 10/07/2022 USA 967 180
1024 /backpack/striped/blue 10/01/2022 – 10/07/2022 USA 655 67
1025 /backpack/canvas/white 10/01/2022 – 10/07/2022 USA 696 151
1026 /messenger/striped/red 10/01/2022 – 10/07/2022 USA 771 116
1027 /bag/striped/brown 10/01/2022 – 10/07/2022 USA 689 30
1028 /backpack/striped/gray 10/01/2022 – 10/07/2022 USA 838 23
1029 /backpack/striped/pink 10/01/2022 – 10/07/2022 USA 1527 -120 Remove the impossible negative value.
1030 /backpack/canvas/black 10/01/2022 – 10/07/2022 USA -650 87 Remove the impossible negative value.
1031 /tote/canvas/pink 10/08/2022 – 10/14/2022 USA 1510 77
1032 /backpack/medium/orange 10/08/2022 – 10/14/2022 USA 1087 71
1033 /pouch/medium/red 10/08/2022 – 10/14/2022 USA 1001 142
1034 /messenger/medium/brown 10/08/2022 – 10/14/2022 USA 1374 49
1035 /bag/gym/blue 10/08/2022 – 10/14/2022 USA 720 112
1036 /tote/large/red 10/08/2022 – 10/14/2022 USA 1261 52
1037 /backpack/leather/brown 10/08/2022 – 10/14/2022 USA 1181 125
1038 /wallet/leather/black 10/08/2022 – 10/14/2022 USA 895 109
1039 /tote/canvas/white 10/08/2022 – 10/14/2022 USA 673 91
1040 /wallet/medium/brown 10/08/2022 – 10/14/2022 USA 587 32
1041 /pouch/leather/red 10/08/2022 – 10/14/2022 USA 1593 67
1042 /duffle/leather/red 10/08/2022 – 10/14/2022 USA null 95620 Delete null in Ad Campaign Clicks and leave blank; remove extreme outlier in Converted Sales.
1043 /duffle/medium/pink 10/08/2022 – 10/14/2022 USA 773 53
1044 /backpack/leather/orange 10/08/2022 – 10/14/2022 USA 566 172
1045 /duffle/canvas/orange 10/08/2022 – 10/14/2022 USA 1037 106
1046 /wallet/gym/blue 10/08/2022 – 10/14/2022 USA 1694 75
1047 /travel/leather/black 10/08/2022 – 10/14/2022 USA 717 28
1048 /backpack/gym/pink 10/08/2022 – 10/14/2022 USA 1769 114
1049 /pouch/canvas/black 10/08/2022 – 10/14/2022 USA 917 129
1050 /duffle/leather/blue 10/08/2022 – 10/14/2022 USA 1390 162
1051 /backpack/medium/gray 10/08/2022 – 10/14/2022 USA 560 173
1052 /bag/gym/black 10/08/2022 – 10/14/2022 USA 1012 158
1053 /tote/large/gray 10/08/2022 – 10/14/2022 USA 1254 39
1054 /backpack/striped/blue 10/08/2022 – 10/14/2022 USA 1188 46
1055 /backpack/canvas/white 10/08/2022 – 10/14/2022 USA 1065 44
1056 /messenger/striped/red 10/08/2022 – 10/14/2022 USA 1295 -2 Remove the impossible negative value.
1057 /bag/striped/brown 10/08/2022 – 10/14/2022 USA 1077 138
1058 /backpack/striped/gray 10/08/2022 – 10/14/2022 USA 1789 67
1059 /backpack/striped/pink 10/08/2022 – 10/14/2022 USA 996 43
1060 /backpack/canvas/black 10/08/2022 – 10/14/2022 USA 881 168
1061 /tote/canvas/pink 10/15/2022 – 10/21/2022 USA 1066 24
1062 /backpack/medium/orange 10/15/2022 – 10/21/2022 USA 1290 136
1063 /pouch/medium/red 10/15/2022 – 10/21/2022 USA 721 171
1064 /messenger/medium/brown 10/15/2022 – 10/21/2022 USA 983 72
1065 /bag/gym/blue 10/15/2022 – 10/21/2022 USA 1142 64
1066 /tote/large/red 10/15/2022 – 10/21/2022 USA 1151 123
1067 /backpack/leather/brown 10/15/2022 – 10/21/2022 USA 1036 110
1068 /wallet/leather/black 10/15/2022 – 10/21/2022 USA 1400 93
1069 /tote/canvas/white 10/15/2022 – 10/21/2022 USA 1643 150
1070 /wallet/medium/brown 10/15/2022 – 10/21/2022 USA 914 61
1071 /pouch/leather/red 10/15/2022 – 10/21/2022 USA 1548 170
1072 /duffle/leather/red 10/15/2022 – 10/21/2022 USA 1025 52
1073 /duffle/medium/pink 10/15/2022 – 10/21/2022 USA 990 111
1074 /backpack/leather/orange 10/15/2022 – 10/21/2022 USA 1315 64
1075 /duffle/canvas/orange 10/15/2022 – 10/21/2022 USA 1459 125
1076 /wallet/gym/blue 10/15/2022 – 10/21/2022 USA 1709 75
1077 /travel/leather/black 10/15/2022 – 10/21/2022 USA null -1 Delete null in Ad Campaign Clicks and leave blank; remove the impossible negative value in Converted Sales.
1078 /backpack/gym/pink 10/15/2022 – 10/21/2022 USA 1145 184000 Remove extreme outlier in Converted Sales.
1079 /pouch/canvas/black 10/15/2022 – 10/21/2022 USA 1185 68
1080 /duffle/leather/blue 10/15/2022 – 10/21/2022 USA 1522 43
1081 /backpack/medium/gray 10/15/2022 – 10/21/2022 USA 870 49
1082 /bag/gym/black 10/15/2022 – 10/21/2022 USA 1138 39
1083 /tote/large/gray 10/15/2022 – 10/21/2022 USA 940 35
1084 /backpack/striped/blue 10/15/2022 – 10/21/2022 USA 1368 41
1085 /backpack/canvas/white 10/15/2022 – 10/21/2022 USA 629 141
1086 /messenger/striped/red 10/15/2022 – 10/21/2022 USA 1165 71
1087 /bag/striped/brown 10/15/2022 – 10/21/2022 USA 685 58
1088 /backpack/striped/gray 10/15/2022 – 10/21/2022 USA 1536 47
1089 /backpack/striped/pink 10/15/2022 – 10/21/2022 USA 1570 54
1090 /backpack/canvas/black 10/15/2022 – 10/21/2022 USA 1199 170
1091 /tote/canvas/pink 10/22/2022 – 10/28/2022 USA 1368 55
1092 /backpack/medium/orange 10/22/2022 – 10/28/2022 USA 1028 74
1093 /pouch/medium/red 10/22/2022 – 10/28/2022 USA 510 84
1094 /messenger/medium/brown 10/22/2022 – 10/28/2022 USA 1429 111
1095 /bag/gym/blue 10/22/2022 – 10/28/2022 USA 1081 174
1096 /tote/large/red 10/22/2022 – 10/28/2022 USA 1332 33
1097 /backpack/leather/brown 10/22/2022 – 10/28/2022 USA 1785 22
1098 /wallet/leather/black 10/22/2022 – 10/28/2022 USA 1520 77
1099 /tote/canvas/white 10/22/2022 – 10/28/2022 USA 1A2 27 Remove the invalid number.
1100 /wallet/medium/brown 10/22/2022 – 10/28/2022 USA 865 96
1101 /pouch/leather/red 10/22/2022 – 10/28/2022 USA 1429 165
1102 /duffle/leather/red 10/22/2022 – 10/28/2022 USA 1614 31
1103 /duffle/medium/pink 10/22/2022 – 10/28/2022 USA 1003 66
1104 /backpack/leather/orange 10/22/2022 – 10/28/2022 USA 1146 126
1105 /duffle/canvas/orange 10/22/2022 – 10/28/2022 USA 1628 41
1106 /wallet/gym/blue 10/22/2022 – 10/28/2022 USA 1508 98
1107 /travel/leather/black 10/22/2022 – 10/28/2022 USA 1247 146
1108 /backpack/gym/pink 10/22/2022 – 10/28/2022 USA 1787 102
1109 /pouch/canvas/black 10/22/2022 – 10/28/2022 USA 635 141
1110 /duffle/leather/blue 10/22/2022 – 10/28/2022 USA 1593 69
1111 /backpack/medium/gray 10/22/2022 – 10/28/2022 SAA 570 60 Delete invalid country name.
1112 /bag/gym/black 10/22/2022 – 10/28/2022 USA 865 50
1113 /tote/large/gray 10/22/2022 – 10/28/2022 USA 1461 74
1114 /backpack/striped/blue 10/22/2022 – 10/28/2022 USA 675 56
1115 /backpack/canvas/white 10/22/2022 – 10/28/2022 USA 641 41
1116 /messenger/striped/red 10/22/2022 – 10/28/2022 USA 583 105
1117 /bag/striped/brown 10/22/2022 – 10/28/2022 USA 516 79
1118 /backpack/striped/gray 10/22/2022 – 10/28/2022 USA 1017 110
1119 /backpack/striped/pink 10/22/2022 – 10/28/2022 USA 1576 176
1120 /backpack/canvas/black 10/22/2022 – 10/28/2022 USA 675 121
1121 /tote/canvas/pink 10/29/2022 – 11/04/2022 USA 641 133
1122 /backpack/medium/orange 10/29/2022 – 11/04/2022 USA 1060 60
1123 /pouch/medium/red 10/29/2022 – 11/04/2022 USA 1202 null Delete null and leave blank.
1124 /messenger/medium/brown 10/29/2022 – 11/04/2022 USA 1366 78
1125 /bag/gym/blue 10/29/2022 – 11/04/2022 USA 861 46
1126 /tote/large/red 10/29/2022 – 11/04/2022 USA 1520 170
1127 /backpack/leather/brown 10/29/2022 – 11/04/2022 USA 854 155
1128 /wallet/leather/black 10/29/2022 – 11/04/2022 USA 780 30
1129 /tote/canvas/white 10/29/2022 – 11/04/2022 USA 725 91
1130 /wallet/medium/brown 10/29/2022 – 11/04/2022 USA 1117 43
1131 /pouch/leather/red 10/29/2022 – 11/04/2022 USA 996 31
1132 /duffle/leather/red 10/29/2022 – 11/04/2022 USA 1226 172
1133 /duffle/medium/pink 10/29/2022 – 11/04/2022 USA 588 108
1134 /backpack/leather/orange 10/29/2022 – 11/04/2022 USA 1275 65
1135 /duffle/canvas/orange 10/29/2022 – 11/04/2022 USA 1094 157
1136 /wallet/gym/blue 10/29/2022 – 11/04/2022 USA 571 135
1137 /travel/leather/black 10/29/2022 – 11/04/2022 *** 1087 80 Remove invalid country value.
1138 /backpack/gym/pink 10/29/2022 – 11/04/2022 USA 1592 159
1139 /pouch/canvas/black 10/29/2022 – 11/04/2022 USA 674 137
1140 /duffle/leather/blue 10/29/2022 – 11/04/2022 USA 1533 172
1141 /backpack/medium/gray 10/29/2022 – 11/04/2022 USA 952 163
1142 /bag/gym/black 10/29/2022 – 11/04/2022 USA 1072 83
1143 /tote/large/gray 10/29/2022 – 11/04/2022 USA 1406 179
1144 /backpack/striped/blue 10/29/2022 – 11/04/2022 USA 1075 49
1145 /backpack/canvas/white 10/29/2022 – 11/04/2022 USA 630 108
1146 /messenger/striped/red 10/29/2022 – 11/04/2022 USA 1285 112
1147 /bag/striped/brown 10/29/2022 – 11/04/2022 USA 1090 103
1148 /backpack/striped/gray 10/29/2022 – 11/04/2022 USA 1436 82
1149 /backpack/striped/pink 10/29/2022 – 11/04/2022 USA 590 119
1150 /backpack/canvas/black 10/29/2022 – 11/04/2022 USA 1186 29
1151 /tote/canvas/pink 11/05/2022 – 11/11/2022 USA 721 64
1152 /backpack/medium/orange 11/05/2022 – 11/11/2022 USA 1295 26
1153 /pouch/medium/red 11/05/2022 – 11/11/2022 USA 1212 99
1154 /messenger/medium/brown 11/05/2022 – 11/11/2022 USA 664 166
1155 /bag/gym/blue 11/05/2022 – 11/11/2022 USA 1415 112
1156 /tote/large/red 11/05/2022 – 11/11/2022 USA 561 173
1157 /backpack/leather/brown 11/05/2022 – 11/11/2022 USA 876 53
1158 /wallet/leather/black 11/05/2022 – 11/11/2022 USA 1097 120
1159 /tote/canvas/white 11/05/2022 – 11/11/2022 USA 1078 112
1160 /wallet/medium/brown 11/05/2022 – 11/11/2022 USA 1517 115
1161 /pouch/leather/red 11/05/2022 – 11/11/2022 USA 1085 78
1162 /duffle/leather/red 11/05/2022 – 11/11/2022 USA 867 39
1163 /duffle/medium/pink 11/05/2022 – 11/11/2022 USA 897 92
1164 /backpack/leather/orange 11/05/2022 – 11/11/2022 USA 794 29
1165 /duffle/canvas/orange 11/05/2022 – 11/11/2022 USA 1313 140
1166 /wallet/gym/blue 11/05/2022 – 11/11/2022 USA 1571 42
1167 /travel/leather/black 11/05/2022 – 11/11/2022 USA 1035 64
1168 /backpack/gym/pink 11/05/2022 – 11/11/2022 USA 1332 115
1169 /pouch/canvas/black 11/05/2022 – 11/11/2022 UUU 1664 116 Delete invalid country name.
1170 /duffle/leather/blue 11/05/2022 – 11/11/2022 USA 1726 29
1171 /backpack/medium/gray 11/05/2022 – 11/11/2022 USA 1297 95
1172 /bag/gym/black 11/05/2022 – 11/11/2022 USA 1757 126
1173 /tote/large/gray 11/05/2022 – 11/11/2022 USA 776 122
1174 /backpack/striped/blue 11/05/2022 – 11/11/2022 USA 1558 152
1175 /backpack/canvas/white 11/05/2022 – 11/11/2022 USA 1228 151
1176 /messenger/striped/red 11/05/2022 – 11/11/2022 USA 1418 40
1177 /bag/striped/brown 11/05/2022 – 11/11/2022 USA 1454 155
1178 /backpack/striped/gray 11/05/2022 – 11/11/2022 USA 631 52
1179 /backpack/striped/pink 11/05/2022 – 11/11/2022 USA 1319 63
1180 /backpack/canvas/black 11/05/2022 – 11/11/2022 USA 1670 168
1181 /tote/canvas/pink 11/12/2022 – 11/18/2022 USA 890 20
1182 /backpack/medium/orange 11/12/2022 – 11/18/2022 USA 596 152
1183 /pouch/medium/red 11/12/2022 – 11/18/2022 USA 1420 132
1184 /messenger/medium/brown 11/12/2022 – 11/18/2022 USA 1667 66
1185 /bag/gym/blue 11/12/2022 – 11/18/2022 USA 1724 142
1186 /tote/large/red 11/12/2022 – 11/18/2022 USA 935 129
1187 /backpack/leather/brown 11/12/2022 – 11/18/2022 USA 604 151
1188 /wallet/leather/black 11/12/2022 – 11/18/2022 USA 1026 167
1189 /tote/canvas/white 11/12/2022 – 11/18/2022 USA 609 107
1190 /wallet/medium/brown 11/12/2022 – 11/18/2022 USA 820 47
1191 /pouch/leather/red 11/12/2022 – 11/18/2022 USA null null Delete null values and leave them blank.
1192 /duffle/leather/red 11/12/2022 – 11/18/2022 USA 953 133
1193 /duffle/medium/pink 11/12/2022 – 11/18/2022 USA 809 173
1194 /backpack/leather/orange 11/12/2022 – 11/18/2022 USA 1187 176
1195 /duffle/canvas/orange 11/12/2022 – 11/18/2022 USA 1220 28
1196 /wallet/gym/blue 11/12/2022 – 11/18/2022 USA 840 89
1197 /travel/leather/black 11/12/2022 – 11/18/2022 USA 1600 64
1198 /backpack/gym/pink 11/12/2022 – 11/18/2022 USA 912 111
1199 /pouch/canvas/black 11/12/2022 – 11/18/2022 USA ### 115 Delete invalid value in Ad Campaign Clicks.
1200 /duffle/leather/blue 11/12/2022 – 11/18/2022 USA 1221 42
1201 /backpack/medium/gray 11/12/2022 – 11/18/2022 USA 1681 60
1202 /bag/gym/black 11/12/2022 – 11/18/2022 USA 824 174
1203 /tote/large/gray 11/12/2022 – 11/18/2022 USA 588 175
1204 /backpack/striped/blue 11/12/2022 – 11/18/2022 USA 1358 105
1205 /backpack/canvas/white 11/12/2022 – 11/18/2022 USA 796 150
1206 /messenger/striped/red 11/12/2022 – 11/18/2022 USA 1725 99
1207 /bag/striped/brown 11/12/2022 – 11/18/2022 USA 1052 20
1208 /backpack/striped/gray 11/12/2022 – 11/18/2022 USA 981 167
1209 /backpack/striped/pink 11/12/2022 – 11/18/2022 USA 728 48
1210 /backpack/canvas/black 11/12/2022 – 11/18/2022 USA 1364 85
1211 /tote/canvas/pink 11/19/2022 – 11/25/2022 USA 1357 115
1212 /backpack/medium/orange 11/19/2022 – 11/25/2022 USA 1142 176
1213 /pouch/medium/red 11/19/2022 – 11/25/2022 USA 1127 30
1214 /messenger/medium/brown 11/19/2022 – 11/25/2022 USA 693 115
1215 /bag/gym/blue 11/19/2022 – 11/25/2022 USA 1544 166
1216 /tote/large/red 11/19/2022 – 11/25/2022 USA 1777 81
1217 /backpack/leather/brown 11/19/2022 – 11/25/2022 USA 1531 108
1218 /wallet/leather/black 11/19/2022 – 11/25/2022 USA 840 116
1219 /tote/canvas/white 11/19/2022 – 11/25/2022 USA 1123 88
1220 /wallet/medium/brown 11/19/2022 – 11/25/2022 3M 181322 -987 Remove invalid name in Country; extreme outlier in Ad Campaign Clicks value; and impossible negative value in Converted Sales.
1221 /pouch/leather/red 11/19/2022 – 11/25/2022 USA 778 92
1222 /duffle/leather/red 11/19/2022 – 11/25/2022 USA 1681 149
1223 /duffle/medium/pink 11/19/2022 – 11/25/2022 USA 1540 165
1224 /backpack/leather/orange 11/19/2022 – 11/25/2022 USA 797 179
1225 /duffle/canvas/orange 11/19/2022 – 11/25/2022 USA 1336 162
1226 /wallet/gym/blue 11/19/2022 – 11/25/2022 USA 1619 88
1227 /travel/leather/black 11/19/2022 – 11/25/2022 USA 1133 136
1228 /backpack/gym/pink 11/19/2022 – 11/25/2022 USA 1012 74
1229 /pouch/canvas/black 11/19/2022 – 11/25/2022 USA 977 39
1230 /duffle/leather/blue 11/19/2022 – 11/25/2022 USA 1412 176
1231 /backpack/medium/gray 11/19/2022 – 11/25/2022 USA 707 104
1232 /bag/gym/black 11/19/2022 – 11/25/2022 USA 654 97
1233 /tote/large/gray 11/19/2022 – 11/25/2022 USA 952 87
1234 /backpack/striped/blue 11/19/2022 – 11/25/2022 USA 1168 83
1235 /backpack/canvas/white 11/19/2022 – 11/25/2022 USA 1135 42
1236 /messenger/striped/red 11/19/2022 – 11/25/2022 USA 776 55
1237 /bag/striped/brown 11/19/2022 – 11/25/2022 USA 758 159
1238 /backpack/striped/gray 11/19/2022 – 11/25/2022 USA 794 59
1239 /backpack/striped/pink 11/19/2022 – 11/25/2022 N3S 1580 84 Remove invalid country name.
1240 /backpack/canvas/black 11/19/2022 – 11/25/2022 USA 1585 121
1241 /tote/canvas/pink 11/26/2022 – 12/04/2022 USA 667 147
1242 /backpack/medium/orange 11/26/2022 – 12/04/2022 USA 1477 125
1243 /pouch/medium/red 11/26/2022 – 12/04/2022 USA 1733 134
1244 /messenger/medium/brown 11/26/2022 – 12/04/2022 USA 790 172
1245 /bag/gym/blue ##/##/#### – ##/##/#### USA 1696 99 Remove invalid dates.
1246 /tote/large/red 11/26/2022 – 12/04/2022 USA 1124 66
1247 /backpack/leather/brown 11/26/2022 – 12/04/2022 USA 1327 60
1248 /wallet/leather/black 11/26/2022 – 12/04/2022 USA 1568 98
1249 /tote/canvas/white 11/26/2022 – 12/04/2022 USA 1568 168
1250 /wallet/medium/brown 11/26/2022 – 12/04/2022 USA null 170 Delete null and leave blank.
1251 /pouch/leather/red 11/26/2022 – 12/04/2022 USA 833 141
1252 /duffle/leather/red 11/26/2022 – 12/04/2022 USA 1138 148
1253 /duffle/medium/pink 11/26/2022 – 12/04/2022 USA 1414 23
1254 /backpack/leather/orange 11/26/2022 – 12/04/2022 USA 778 40
1255 /duffle/canvas/orange 11/26/2022 – 12/04/2022 USA 1731 126
1256 /wallet/gym/blue 11/26/2022 – 12/04/2022 USA 1569 128
1257 /travel/leather/black 11/26/2022 – 12/04/2022 USA 1348 161
1258 /backpack/gym/pink 11/26/2022 – 12/04/2022 USA 577 39
1259 /pouch/canvas/black 11/26/2022 – 12/04/2022 USA 1041 134
1260 /duffle/leather/blue 11/26/2022 – 12/04/2022 USA 1066 59
1261 /backpack/medium/gray 11/26/2022 – 12/04/2022 USA 1324 152
1262 /bag/gym/black 11/26/2022 – 12/04/2022 USA 1768 20
1263 /tote/large/gray 11/26/2022 – 12/04/2022 USA 1202 22
1264 /backpack/striped/blue 11/26/2022 – 12/04/2022 USA 1449 123
1265 /backpack/canvas/white 11/26/2022 – 12/04/2022 USA 621 105
1266 /messenger/striped/red 11/26/2022 – 12/04/2022 USA 727 55
1267 /bag/striped/brown 11/26/2022 – 12/04/2022 USA 883 169
1268 /backpack/striped/gray 11/26/2022 – 12/04/2022 USA 528 93
1269 /backpack/striped/pink 11/26/2022 – 12/04/2022 USA 1040 29
1270 /backpack/canvas/black 11/26/2022 – 12/04/2022 USA 1642 116
1271 /tote/canvas/pink 12/05/2022 – 12/11/2022 USA 688 28
1272 /backpack/medium/orange 12/05/2022 – 12/11/2022 USA 830 79
1273 /pouch/medium/red 12/05/2022 – 12/11/2022 USA 1151 63
1274 /messenger/medium/brown 12/05/2022 – 12/11/2022 USA 1046 27
1275 /bag/gym/blue 12/05/2022 – 12/11/2022 USA 972 172
1276 /tote/large/red 12/05/2022 – 12/11/2022 USA 1493 49
1277 /backpack/leather/brown 12/05/2022 – 12/11/2022 USA 1236 119
1278 /wallet/leather/black 12/05/2022 – 12/11/2022 USA 1444 96
1279 /tote/canvas/white 12/05/2022 – 12/11/2022 USA 882 98
1280 /wallet/medium/brown 12/05/2022 – 12/11/2022 USA 1094 123
1281 /pouch/leather/red 12/05/2022 – 12/11/2022 USA 1629 151
1282 /duffle/leather/red 12/05/2022 – 12/11/2022 USA 971 91
1283 /duffle/medium/pink 12/05/2022 – 12/11/2022 USA 543 37
1284 /backpack/leather/orange 12/05/2022 – 12/11/2022 USA 1109 49
1285 /duffle/canvas/orange 12/05/2022 – 12/11/2022 USA 837 153
1286 /wallet/gym/blue 12/05/2022 – 12/11/2022 USA 1150 123
1287 /travel/leather/black 12/05/2022 – 12/11/2022 USA 1399 23
1288 /backpack/gym/pink 12/05/2022 – 12/11/2022 USA 1286 58
1289 /pouch/canvas/black 12/05/2022 – 12/11/2022 USA 1214 161
1290 /duffle/leather/blue 12/05/2022 – 12/11/2022 USA 978 64
1291 /backpack/medium/gray 12/05/2022 – 12/11/2022 USA 1632 105
1292 /bag/gym/black 12/05/2022 – 12/11/2022 USA 1125 80
1293 /tote/large/gray 12/05/2022 – 12/11/2022 USA 1076 43
1294 /backpack/striped/blue 12/05/2022 – 12/11/2022 USA 1400 159
1295 /backpack/canvas/white 12/05/2022 – 12/11/2022 USA 1357 124
1296 /messenger/striped/red 12/05/2022 – 12/11/2022 ASU 1246 71 Delete invalid country name.
1297 /bag/striped/brown 12/05/2022 – 12/11/2022 USA 576 29
1298 /backpack/striped/gray 12/05/2022 – 12/11/2022 USA 787 146
1299 /backpack/striped/pink 12/05/2022 – 12/11/2022 USA 1797 71
1300 /backpack/canvas/black 12/05/2022 – 12/11/2022 USA 1259 73
1301 /tote/canvas/pink 12/12/2022 – 12/18/2022 USA 648 120
1302 /backpack/medium/orange 12/12/2022 – 12/18/2022 USA 587 65
1303 /pouch/medium/red 12/12/2022 – 12/18/2022 USA 521 144
1304 /messenger/medium/brown 12/12/2022 – 12/18/2022 USA 1264 179
1305 /bag/gym/blue 12/12/2022 – 12/18/2022 USA 879 166
1306 /tote/large/red 12/12/2022 – 12/18/2022 USA 1672 40
1307 /backpack/leather/brown 12/12/2022 – 12/18/2022 USA 567 124
1308 /wallet/leather/black 12/12/2022 – 12/18/2022 USA 645 75
1309 /tote/canvas/white 12/12/2022 – 12/18/2022 USA 833 67
1310 /wallet/medium/brown 12/12/2022 – 12/18/2022 USA 1249 166
1311 /pouch/leather/red 12/12/2022 – 12/18/2022 USA 1191 153
1312 /duffle/leather/red 12/12/2022 – 12/18/2022 USA 1037 103
1313 /duffle/medium/pink 12/12/2022 – 12/18/2022 USA 622 77
1314 /backpack/leather/orange 12/12/2022 – 12/18/2022 USA 795 162
1315 /duffle/canvas/orange 12/12/2022 – 12/18/2022 USA 1344 165
1316 /wallet/gym/blue 12/12/2022 – 12/18/2022 USA 783 63
1317 /travel/leather/black 12/12/2022 – 12/18/2022 USA 565 47
1318 /backpack/gym/pink 12/12/2022 – 12/18/2022 USA 1277 32
1319 /pouch/canvas/black 12/12/2022 – 12/18/2022 USA 614 140
1320 /duffle/leather/blue 12/12/2022 – 12/18/2022 USA 1446 80
1321 /backpack/medium/gray 12/12/2022 – 12/18/2022 USA 1223 80
1322 /bag/gym/black 12/12/2022 – 12/18/2022 USA 939 84
1323 /tote/large/gray 12/12/2022 – 12/18/2022 USA 500 53
1324 /backpack/striped/blue 12/12/2022 – 12/18/2022 USA 776 38
1325 /backpack/canvas/white 12/12/2022 – 12/18/2022 USA 1179 90
1326 /messenger/striped/red 12/12/2022 – 12/18/2022 USA 701 40
1327 /bag/striped/brown 12/12/2022 – 12/18/2022 USA 1029 20
1328 /backpack/striped/gray 12/12/2022 – 12/18/2022 USA 821 28
1329 /backpack/striped/pink 12/12/2022 – 12/18/2022 USA 600 160
1330 /backpack/canvas/black 12/12/2022 – 12/18/2022 USA 1318 26
1331 /tote/canvas/pink 12/19/2022 – 12/25/2022 USA 710 124
1332 /backpack/medium/orange 12/19/2022 – 12/25/2022 USA 6BF 115 Remove invalid number.
1333 /pouch/medium/red 12/19/2022 – 12/25/2022 USA 1262 110
1334 /messenger/medium/brown 12/19/2022 – 12/25/2022 USA 991 22
1335 /bag/gym/blue 12/19/2022 – 12/25/2022 USA 1751 61
1336 /tote/large/red 12/19/2022 – 12/25/2022 USA 1280 164
1337 /backpack/leather/brown 12/19/2022 – 12/25/2022 USA 733 116
1338 /wallet/leather/black 12/19/2022 – 12/25/2022 USA 1054 65
1339 /tote/canvas/white 12/19/2022 – 12/25/2022 USA 1481 47
1340 /wallet/medium/brown 12/19/2022 – 12/25/2022 USA 1240 111
1341 /pouch/leather/red 12/19/2022 – 12/25/2022 USA 1036 38
1342 /duffle/leather/red 12/19/2022 – 12/25/2022 USA 1194 64
1343 /duffle/medium/pink 12/19/2022 – 12/25/2022 USA 1290 47
1344 /backpack/leather/orange 12/19/2022 – 12/25/2022 USA 1515 85
1345 /duffle/canvas/orange 12/19/2022 – 12/25/2022 USA 1208 47
1346 /wallet/gym/blue 12/19/2022 – 12/25/2022 USA 1044 59
1347 /travel/leather/black 12/19/2022 – 12/25/2022 USA 540 142
1348 /backpack/gym/pink 12/09/2022 – 12/45/2022 USA 1446 97 Remove date range that includes an invalid date.
1349 /pouch/canvas/black 12/19/2022 – 12/25/2022 USA 1031 70
1350 /duffle/leather/blue 12/19/2022 – 12/25/2022 USA 1114 144
1351 /backpack/medium/gray 12/19/2022 – 12/25/2022 USA 1266 151
1352 /bag/gym/black 12/19/2022 – 12/25/2022 USA 1484 129
1353 /tote/large/gray 12/19/2022 – 12/25/2022 USA 1784 142
1354 /backpack/striped/blue 12/19/2022 – 12/25/2022 USA 663 61
1355 /backpack/canvas/white 12/19/2022 – 12/25/2022 USA 1233 64
1356 /messenger/striped/red 12/19/2022 – 12/25/2022 USA 1237 71
1357 /bag/striped/brown 12/19/2022 – 12/25/2022 USA 1779 157
1358 /backpack/striped/gray 12/19/2022 – 12/25/2022 USA 1357 52
1359 /backpack/striped/pink 12/19/2022 – 12/25/2022 USA 1423 125
1360 /backpack/canvas/black 12/19/2022 – 12/25/2022 USA 1071 76
1361 /tote/canvas/pink 12/26/2022 – 12/31/2022 USA 916 28
1362 /backpack/medium/orange 12/26/2022 – 12/31/2022 USA 1442 180
1363 /pouch/medium/red 12/26/2022 – 12/31/2022 USA 555 62
1364 /messenger/medium/brown 12/26/2022 – 12/31/2022 USA 1258 105
1365 /bag/gym/blue 12/26/2022 – 12/31/2022 USA 854 39
1366 /tote/large/red 12/26/2022 – 12/31/2022 USA 1450 143
1367 /backpack/leather/brown 12/26/2022 – 12/31/2022 USA 573 129
1368 /wallet/leather/black 12/26/2022 – 12/31/2022 3UXTA 619 85 Delete invalid country name.
1369 /tote/canvas/white 12/26/2022 – 12/31/2022 USA 1551 151
1370 /wallet/medium/brown 12/26/2022 – 12/31/2022 USA 900 101
1371 /pouch/leather/red 12/26/2022 – 12/31/2022 null 1548 null Remove null values and leave them blank.
1372 /duffle/leather/red 12/26/2022 – 12/31/2022 USA 1714 99
1373 /duffle/medium/pink 12/26/2022 – 12/31/2022 USA 1585 62
1374 /backpack/leather/orange 12/26/2022 – 12/31/2022 USA 619 152
1375 /duffle/canvas/orange 12/26/2022 – 12/31/2022 USA 1328 83
1376 /wallet/gym/blue 12/26/2022 – 12/31/2022 USA 836 39
1377 /travel/leather/black 12/26/2022 – 12/31/2022 USA 1747 114
1378 /backpack/gym/pink 12/26/2022 – 12/31/2022 USA 1601 24
1379 /pouch/canvas/black 12/26/2022 – 12/31/2022 USA 1022 40
1380 /duffle/leather/blue 12/26/2022 – 12/31/2022 USA 804 106
1381 /backpack/medium/gray 12/26/2022 – 12/31/2022 USA 772 146
1382 /bag/gym/black 12/26/2022 – 12/31/2022 USA 931 119
1383 /tote/large/gray 12/26/2022 – 12/31/2022 USA 693 103
1384 /backpack/striped/blue 12/26/2022 – 12/31/2022 USA 1331 124
1385 /backpack/canvas/white 12/37/2922 – 12/47/2922 USA 1715 61 Remove date range that includes invalid dates.
1386 /messenger/striped/red 12/26/2022 – 12/31/2022 USA 190330 129 Delete extreme outlier in Ad Campaign Clicks.
1387 /bag/striped/brown 12/45/2044 – 12/52/2044 USA 1483 77 Remove date range that includes invalid dates.
1388 /backpack/striped/gray 12/26/2022 – 12/31/2022 USA 1522 67
1389 /backpack/striped/pink 12/26/2022 – 12/31/2022 USA 1413 64
1390 /backpack/canvas/black 12/26/2022 – 12/31/2022 USA 1510 171

,

Sheet1

Group Table Field Data Type Example
Customers customers customer_id U123456
Customers customers user_id character
Customers customers create_date 2022-10-24
Customers customers segment_id character SG123456
: What's this? Is there a list of types or categories? -Joseph Borjon
Employees human_resources employee_id integer 450339
Employees human_resources user_id 273245
Employees human_resources start_date date 2020-07-09
Employees human_resources end_date 2021-07-09
Employees human_resources role character Software engineer
Employees human_resources hourly_wage numeric 36.5
Employees human_resources salary_wage numeric 85000.25
Employees human_resources bonus_cap numeric 150.6
Employees human_resources turnover_reason character Discharged
Products products product_id character PR123456
Products products product_name Journey Messenger
Products products product_category character Duffel
Products products product_subcategory character Women's tote
Products products list_price 34.99
Accounting expenses expense_id character E123456
Accounting expenses name Backpack order
Accounting expenses expense_type inventory
Accounting expenses expense_date 2021-09-19
Accounting expenses expense_amount numeric 56.48
Accounting expenses user_id character U123456
Sales orders order_id character OR123456
Sales orders customer_id character C123456
Sales orders delivery_id character DL123456
Sales orders order_total_revenue 500.06
Sales orders shipping_cost numeric 32.23
Sales orders order_discount_rate numeric 10.15
Sales orders order_date 2023-03-20
Marketing engagements engagement_id EG123456
Marketing engagements customer_id character C123456
Marketing engagements order_id character OR123456
Marketing engagements campaign_id character CP123456
Marketing engagements subscription_id character SB123456
Marketing engagements customer_segment_id character SG123456
Marketing engagements send_date date 2021-01-23
Marketing engagements country character Canada
Marketing engagements opens integer 23406
Marketing engagements clicks 512
Marketing engagements conversions integer 42
Marketing engagements likes integer 1258
Marketing engagements shares integer 647
Marketing engagements comments integer 323
Marketing engagements revenue 1280.55

,

MARKETING

CUSTOMERS

ORDERS/SALES

PRODUCTS

ACCOUNTING

HR/EMPLOYEES

campaigns

PK campaign_id

FK channel_id

name

landing_page

type

message_type

image_type

impressions

ad_spend

revenue

start_date

end_date

cust_segmentation_survey

PK survey_id

suvey_date

FK customer_id

gender

age

relationship_status

dependents

occupation

geographic_area

income

education

bag_use_type

bag_use_frequency

bag_use_purpose

bag_travel_type

work_travel_frequency

fun_travel_frequency

fun_trip_type

bag_count

planning

spending

local_buying

trend

hobby

shopping_location

product_pref

brand_pref

bag_pref_1

bag_pref_2

bag_pref_3

bag_pref_4

annual_bags

annual_spend

product_feature_survey

PK survey_id

FK customer_id

survey_date

persona

feature

feature_score

orders

PK order_id

FK customer_id

FK delivery_id

order_total_revenue

shipping_cost

order_discount_rate

order_date

warranty_claims

PK claim_id

FK order_Id

create_date

type

resolved_date

description

FK product_id

FK unit_id

refund_amount

accounts_payable

PK payable_id

FK supplier_id

name

type

payable_date

payable_amount

days_outstanding

FK expense_id

human_resources

PK employee_id

FK user_id

start_date

end_date

role

hourly_wage

salary_wage

bonus_cap

turnover_reason

suppliers

PK supplier_id

FK user_id

create_date

types

retailer_reports

PK retailer_report_id

FK retailer_id

report_month_year

monthly_revenue_target

monthly_buhi_sales

monthly_transaction_ct

avg_inventory

user

PK user_id

user_type

first_name

last_name

email

phone_number

street_address

city

state

postal_code

retailers

PK retailer_id

FK user_id

FK customer_id

create_date

type

employee_surveys

PK survey_id

FK employee_id

name

survey_date

job_satisfaction

mgr_relationship

coworker_relationship

workload

position_history

PK position_id

FK employee_id

create_date

open_date

filled_date

accounts_receivable

PK receivable_id

FK retailer_id

name

type

receivable_date

receivable_amount

FK order_id

days_outstanding

paid_in_full

expenses

PK expense_id

name

expense_type

expense_date

expense_amount

FK user_id

smart_product_app_data

PK record_id

FK user_id

FK product_id

unit_id

record_date

record_time

location

location_time

avg_daily_distance

max_distance

avg_daily_elevation

max_elevation

min_temp

max_temp

avg_daily_temp

max_bag_load

max_elevation

min_elevation

avg_daily_weight

max_weight

days_no_weight

days_with_weight

products

PK product_id

product_name

product_category

product_subcategory

list_price

smart_product_sensor_data

PK record_id

FK product_id

unit_id

record_date

record_time

location

air_pressure

strap_1_weight

strap_2_weight

temperature

units

PK unit_id

FK product_id

FK user_id

FK supplier_id

delivery

PK delivery_id

type

status

scheduled_date

delivered_date

order_line_item

PK line_item_id

FK order_id

FK product_id

unit_price

quantity

line_total_price

customers

PK customer_id

FK user_id

create_date

type

FK segment_id

customer_segments

PK segment_id

name

min_age

max_age

gender

interests

occupation

geographic_area

relationship_status

dependents

average_income

education_level

FK target_product_id

target_product_name

engagements

PK engagement_id

FK customer_id

FK order_id

FK campaign_id

FK subscription_id

customer_segment_id

send_date

reception_status

subscription_target

country

opens

clicks

conversions

likes

shares

comments

revenue

marketing_channels

PK channel_id

name

type

customer_subscriptions

PK subscription_id

FK customer_id

subscription_type

subscription_status

start_date

end_date

subscription_list

FK engagement_id

FK subscription_id

OTHER

  • [campaigns] campaign_id
  • [engagements] campaign_id
  • [engagements] order_id
  • [orders] order_id
  • [campaigns] channel_id
  • [marketing_channels] channel_id
  • [subcription list] engagement_id
  • [engagements] engagement_id
  • [subscription_list] subscription_id
  • [customer_subscriptions] subscription_id
  • [engagements] customer_id
  • [customers] customer_id
  • [customer_subscriptions] customer_id
  • [cust_segmentation_survey] customer_id
  • [product_feature_survey] customer_id
  • [customer_segments] segment_id
  • [customer_segments] target_product_id
  • [customers] segment_id
  • [order_line_itme] product_id
  • [pdoucts] product_id
  • [customers] user_id
  • [user]user_id
  • [suppliers] supplier_id
  • [suppliers] user_id
  • [retailers] retailer_id
  • [retailers] user_id
  • [retailers] customer_id
  • [retailer_reports] retailer_id
  • [user] user_id
  • [smart_product_app_data] user_id
  • [warranty_claims] order_Id
  • [accounts_receivable] retailer_id
  • [accounts_receivable] retailer_id
  • line_item_id
  • [order_line_item]order_id
  • [customers] customer_id
  • [delivery] delivery_id
  • [orders] delivery_id
  • [accounts_payable] expense_id
  • []expenses] expense_id
  • [human_resources] user_id
  • [human_resources] employee_id
  • [smart_product_app_data] unit_id
  • [units] unit_id
  1. channel_id:
  2. campaign_id:
  3. engagement_id:
  4. subscription_id:
  5. segment_id:
  6. user_id:
  7. target_product_id 3:
  8. customer_id [css]:
  9. customer_id [cs]:
  10. retailer_id:
  11. supplier_id:
  12. supplier_id [2]:
  13. delivery_id:
  14. expense_id:
  15. user_id [e]:
  16. user_id [hr]:
  17. employee_id [es]:
  18. customer_id:
  19. user_id [s]:
  20. user_id [s] 1:
  21. user_id [r]:
  22. customer_id [r]:
  23. customer_id [o]:
  24. order_id [e]:
  25. order_id [oli]:
  26. order_id [wc]:
  27. target_product_id 1:
  28. user_id [spad]:
  29. user_id [u] [1]:
  30. employee_id [ph]:
  31. retailer_id [ar]:
  32. customer_id [pfs]:
  33. user_id [u] [2]:
  34. user_id [hr] 2:
  35. user_id [r] 2:
  36. user_id [s] 2:
  37. user_id [spad] 2:
  38. user_id [spad] 3:
  39. customer_id [o] 2:
  40. channel_id 3:
  41. channel_id 2:
  42. engagement_id 2:
  43. engagement_id 3:
  44. campaign_id 2:
  45. order_id [e] 2:
  46. order_id [e] 3:
  47. customer_id 2:
  48. customer_id 3:
  49. customer_id [cs] 2:
  50. customer_id [css]2:
  51. customer_id [css] 3:
  52. customer_id [css] 4:
  53. segment_id 2:
  54. segment_id 3:
  55. user_id 2:
  56. user_id 3:
  57. supplier_id 2:
  58. supplier_id 3:
  59. supplier_id 4:
  60. supplier_id 5:
  61. retailer_id [ar] 2:
  62. retailer_id [ar] 3:
  63. retailer_id [ar] 4:
  64. retailer_id [ar] 5:
  65. order_id [ar]:
  66. order_id [ar] 2:
  67. order_id [ar] 3:
  68. order_id [ar] 4:
  69. order_id [ar] 5:
  70. customer_id [r] 2:
  71. customer_id [r] 3:
  72. target_product_id 2:
  73. user_id [spad] 4:
  74. user_id [spad] 5:
  75. order_id [oli] 2:
  76. order_id [oli] 3:
  77. expense_id 2:
  78. expense_id 3:
  79. user_id [e] 3:
  80. user_id [e] 2:
  81. employee_id [ph] 2:
  82. employee_id [ph] 3:
  83. order_id [wc] 2:
  84. order_id [wc] 3:
  85. customer_id [css] 5:
  86. unit_id [units] 2:
  87. product_id 3:
  88. unit_id [units] 3:
  89. unit_id [units] 4:
  90. unit_id [units] 5:
  91. unit_id [units – warranty_claims]:
  92. product-id [ units – products]:
  93. product_id #:
  94. unit_id [smart] 1:
  95. unit_id [smart] 2:
  96. unit_id [smart] 3:
  97. campaign_id [HIDE]:
  98. channel_id [HIDE]:
  99. channel_id [HIDE] 1:
  100. engagement_id [HIDE]:
  101. subscription_id [HIDE]:
  102. subscription_id [HIDE] 1:
  103. subscription_id [HIDE] 2:
  104. customer_id [cfs] [HIDE]:
  105. target_product_id [HIDE]:
  106. customer_id [cfs] [HIDE] 2:
  107. customer_id [cfs] [HIDE] 1:
  108. engagement_id [HIDE] 1:
  109. engagement_id [HIDE] 2:
  110. campaign_id [SHOW]:
  111. channel_id [SHOW]:
  112. channel_id [SHOW] 1:
  113. engagement_id [SHOW]:
  114. subscription_id [SHOW]:
  115. subscription_id [SHOW] 1:
  116. subscription_id [SHOW] 2:
  117. subscription_id [SHOW] 3:
  118. target_product_id [SHOW]:
  119. subscription_id [SHOW] 5:
  120. subscription_id [SHOW] 4:
  121. engagement_id [SHOW] 1:
  122. engagement_id [SHOW] 2:
  123. campaign_id [ANCHOR]:
  124. channel_id [ANCHOR]:
  125. channel_id [ANCHOR] 2:
  126. engagement_id [ANCHOR:
  127. subscription_id [ANCHOR] 1:
  128. subscription_id [ANCHOR]:
  129. customer_id [cs] [ANCHOR]:
  130. target_product_id [ANCHOR]:
  131. segment_id [cs] [ANCHOR]:
  132. customer_id [ANCHOR] 1:
  133. engagement_id [ANCHOR] 2:
  134. customer_id [ANCHOR]:
  135. campaign_id [ANCHOR] 1:
  136. order_id [ANCHOR]:
  137. campaign_id [HIDE] 2:
  138. order_id [HIDE]:
  139. campaign_id [SHOW] 2:
  140. order_id [SHOW]:
  141. customer_id [cfs] [HIDE] 3:
  142. customer_id [cfs] [HIDE] 4:
  143. customer_id [cfs] [HIDE] 5:
  144. subscription_id [SHOW] 6:
  145. subscription_id [SHOW] 7:
  146. subscription_id [SHOW] 8:
  147. segment_id [c] [ANCHOR] :
  148. user_id [c] [ANCHOR]:
  149. supplier_id [HIDE]:
  150. supplier_id [show]:
  151. customer_id [cfs] [HIDE] 7:
  152. customer_id [cfs] [HIDE] 8:
  153. customer_id [cfs] [HIDE] 12:
  154. customer_id [cfs] [HIDE] 11:
  155. customer_id [cfs] [HIDE] 13:
  156. customer_id [cfs] [HIDE] 14:
  157. customer_id [cfs] [HIDE] 10:
  158. subscription_id [SHOW] 10:
  159. subscription_id [SHOW] 11:
  160. subscription_id [SHOW] 15:
  161. subscription_id [SHOW] 14:
  162. subscription_id [SHOW] 16:
  163. subscription_id [SHOW] 17:
  164. subscription_id [SHOW] 13:
  165. segment_id [c] [ANCHOR] 2:
  166. segment_id [c] [ANCHOR] 6:
  167. segment_id [c] [ANCHOR] 28:
  168. segment_id [c] [ANCHOR] 26:
  169. segment_id [c] [ANCHOR] 29:
  170. segment_id [c] [ANCHOR] 30:
  171. customer_id [cfs] [HIDE] 9:
  172. subscription_id [SHOW] 12:
  173. segment_id [c] [ANCHOR] 4:
  174. retailer_id [rr] [HIDE}:
  175. retailer_id [rr] [HIDE} 4:
  176. retailer_id [rr] [HIDE} 1:
  177. retailer_id [rr] [HIDE} 3:
  178. retailer_id [rr] [HIDE} 6:
  179. retailer_id [rr] [HIDE} 7:
  180. retailer_id [rr] [HIDE} 12:
  181. retailer_id [rr] [HIDE} 14:
  182. retailer_id [rr] [HIDE} 24:
  183. retailer_id [rr] [HIDE} 25:
  184. retailer_id [rr] [HIDE} 13:
  185. retailer_id [rr] [HIDE} 8:
  186. retailer_id [rr] [HIDE} 9:
  187. retailer_id [rr] [HIDE} 10:
  188. retailer_id [rr] [HIDE} 11:
  189. retailer_id [rr] [HIDE} 5:
  190. retailer_id [HIDE]:
  191. retailer_id [rr] [SHOW]:
  192. retailer_id [rr] [SHOW] 4:
  193. retailer_id [rr] [SHOW] 1:
  194. retailer_id [rr] [SHOW] 3:
  195. retailer_id [rr] [SHOW] 6:
  196. retailer_id [rr] [SHOW] 7:
  197. retailer_id [rr] [SHOW] 12:
  198. retailer_id [rr] [SHOW] 14:
  199. retailer_id [rr] [SHOW] 24:
  200. retailer_id [rr] [SHOW] 25:
  201. retailer_id [rr] [SHOW] 13:
  202. retailer_id [rr] [SHOW] 8:
  203. retailer_id [rr] [SHOW] 9:
  204. retailer_id [rr] [SHOW] 10:
  205. retailer_id [rr] [SHOW] 11:
  206. retailer_id [rr] [SHOW] 5:
  207. retailer_id [SHOW]:
  208. segment_id [c] [ANCHOR] 3:
  209. segment_id [c] [ANCHOR] 5:
  210. segment_id [c] [ANCHOR] 7:
  211. segment_id [c] [ANCHOR] 9:
  212. segment_id [c] [ANCHOR] 8:
  213. segment_id [c] [ANCHOR] 14:
  214. segment_id [c] [ANCHOR] 16:
  215. segment_id [c] [ANCHOR] 25:
  216. segment_id [c] [ANCHOR] 27:
  217. segment_id [c] [ANCHOR] 10:
  218. segment_id [c] [ANCHOR] 11:
  219. segment_id [c] [ANCHOR] 12:
  220. segment_id [c] [ANCHOR] 13:
  221. retailer_id [rr] [HIDE} 15:
  222. retailer_id [rr] [HIDE} 19:
  223. retailer_id [rr] [HIDE} 16:
  224. retailer_id [rr] [HIDE} 20:
  225. retailer_id [rr] [HIDE} 22:
  226. retailer_id [rr] [HIDE} 23:
  227. retailer_id [rr] [HIDE} 21:
  228. retailer_id [rr] [HIDE} 17:
  229. retailer_id [rr] [HIDE} 18:
  230. retailer_id [rr] [SHOW] 15:
  231. retailer_id [rr] [SHOW] 19:
  232. retailer_id [rr] [SHOW] 16:
  233. retailer_id [rr] [SHOW] 20:
  234. retailer_id [rr] [SHOW] 22:
  235. retailer_id [rr] [SHOW] 23:
  236. retailer_id [rr] [SHOW] 21:
  237. retailer_id [rr] [SHOW] 17:
  238. retailer_id [rr] [SHOW] 18:
  239. segment_id [c] [ANCHOR] 17:
  240. segment_id [c] [ANCHOR] 21:
  241. segment_id [c] [ANCHOR] 18:
  242. segment_id [c] [ANCHOR] 22:
  243. segment_id [c] [ANCHOR] 23:
  244. segment_id [c] [ANCHOR] 24:
  245. segment_id [c] [ANCHOR] 19:
  246. segment_id [c] [ANCHOR] 20:

,

Data-Audit Report: Buhi Supply Co. B Y D U R C H D E N W A L D G LO B A L

This report outlines the findings by Durchdenwald Global (DG) from a database audit for Buhi Supply Co. In this audit, DG assessed the integrity and usability of Buhi’s data without making any changes or corrections to it.

Trustworthy data is a critical element in making data-driven business decisions with confidence. Therefore, we recommend that Buhi address errors and issues in its data to the fullest extent possible.

ERRORS AND POTENTIAL ISSUES FOUND

DG’s audit uncovered the following issues and potential problems in the data.

MISSING VALUES

Missing values are blank or null values in cells where an actual value is expected.

We found 126,061 instances of missing values in the database.

Examples

These examples represent the most common patterns of missing values seen in Buhi’s data:

• The image_type field in the campaigns table has 80 instances of missing values.

• The employee_surveys table has 32 total missing values in the job_satisfaction, mgr_relationship, and coworker_relationship fields. If those values correspond to optional responses in the survey, their absence may not be detrimental, since having some blank optional responses would be expected.

PAGE 1

Recommendation

We advise Buhi to review each missing value in its database and determine if its absence could impair decision-making. If a missing value is likely problematic, it should be addressed either by deleting the entire record or interpolating the value using known data.

OUTLIERS

Outliers are data points that differ noticeably from the other equivalent values in the data. They represent truthful, valid data. However, their inclusion in an analysis can greatly skew the results, producing inaccurate outcomes.

We found 3,754 instances of outliers in the database.

Examples

These examples represent the most common patterns of outliers seen in Buhi’s data:

• Most order_total_revenue values in the orders table ranged from $35 to $4,500. However, in 1,820 instances, they were $150,000 or more.

• Most impressions values in the campaigns table ranged from zero to 1,600. However, in 86 instances, they were 2,000,000 or more.

Recommendation

We advise Buhi to consider the impact of outliers on its data analysis. If it’s significant, rows containing outliers should either be removed from the database or filtered out in queries.

IMPOSSIBLE VALUES

Impossible values don’t belong in the range of acceptable values. Unlike outliers, impossible values cannot possibly be truthful values of the data they represent.

We found 1,548 instances of impossible values in the database.

PAGE 2

Examples

These examples represent the most common patterns of impossible values seen in Buhi’s data:

• Values in the feature_score field in the product_feature_survey table ranged between 1 and 5. However, in 63 instances, the value is not in the 1-5 range. It’s unclear how this could have happened with software that allows a maximum response value of 5.

• In 312 instances, the age value in the cust_segmentation_survey table is a negative number; in one instance, it’s 128.

Recommendation

We advise Buhi to remove impossible values from its database and then treat them as missing values.

INCONSISTENT VALUES

Inconsistent values are those that may be incorrect based on the data around them. They aren’t necessarily impossible, but their validity is questionable.

We found 41,222 instances of inconsistent values in the database.

Examples

These examples represent the most common patterns of inconsistent values seen in Buhi’s data:

• In 1,177 instances, the bag_count value in the cust_segmentation_survey table is greater than 100. Not an inconceivable number of bags for a customer to own, but it does warrant confirmation.

• The role of one employee in the human_resources table is listed as “software engineer.” However, the salary_wage value for that record is 21,000 — which seems low for the position.

PAGE 3

Recommendation

We advise Buhi to investigate all database values flagged as inconsistent. If a value can be corroborated by data in other tables or data sources, the flag can be removed. Otherwise, it may be necessary to delete the value from the database and then treat it as a missing value.

ERRONEOUS FORMATTING

Erroneously formatted values arise when data is entered with an incorrect format; the value may be accurate, but it may not be usable in its present form in the database.

We found 4,261 instances of erroneous formatting.

Examples

These examples represent the most common patterns of erroneous formatting seen in Buhi’s data:

• In the order_line_item table, 400 quantity values are spelled out instead of being numeric values; for example, “six,” “eight,” “twenty,” and “twenty-seven.”

• In the expenses table, 628 expense_amount values are spelled out, either with the word “dollar” (“eighty-seven dollars”) or without (“two hundred and twenty”).

Recommendation

We advise Buhi to convert all instances of erroneously formatted values to their proper format. If a value is too ambiguous to determine, we advise removing it from the database and then treating it as a missing value.

DUPLICATE RECORDS

Duplicate records can occur when information from the same row is repeated more than once by mistake. A form may be submitted twice due to a technical mishap; that would be a duplicate record.

PAGE 4

However, it’s entirely possible a customer may purchase the same item for the same price at two different times; that wouldn’t be a duplicate record, but two genuine records of two separate transactions.

We found 27,049 possible instances of duplicate records in the database.

Examples

These examples represent the most common patterns of duplicate records seen in Buhi’s data:

• In the delivery table, there are five records containing the same delivery_id value. Since the ID is uniquely generated, it’s almost certain these are accidental duplicates.

• There are three records in the cust_segment_survey table containing exactly the same information in all fields except survey_id. It’s unlikely that three different 26-year-olds named Caoimhe Banasiewicz in Wyoming, United States, completed the survey on the same date and with all the same responses.

Recommendation

We advise Buhi to identify and investigate any records that appear to be duplicated. If a record is determined to be a duplicate, it should be removed, leaving a single instance of the record in the database.

PAGE 5

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order Solution Now