ACTIVITY #6

MIS 3210Unit 2 – Creating Pivot Tables
Activity #6
Learning Objectives
• Explore and apply the concept of cross-tabulation as a
means of analyzing 2-dimensional datasets
• How to create PivotTables using Excel
• How to add filter to a PivotTable results using slicers
• Using Pivot Charts
Learning Pivot Tables
• In this activity, you will develop knowledge and skills to
cross-tabulate using Excel Pivot Tables.
• Pivot Tables allow you a powerful way to quickly and
efficiently conduct aggregate analysis of 2-dimensional data.
• Many organizations place a high value on strong Pivot Table
skills.
What is cross-tabulation?
Cross tabulation is an analytical method that allows you
compare the relationship between two variables; usually in
large data sets by aggregating numbers appropriately.
Examples:
• Frequency of product purchases by gender
• Average age of students by degree of study
• Total sales by territory
Cross-Tabulation: Additional Information
• Video – Cross-Tabulation (1:06)
• Information Page on Cross-Tabulation
A PivotTable report is especially designed for…
➢Querying large amounts of data in many user-friendly ways.
➢Subtotaling and aggregating numeric data, summarizing data by
categories and subcategories, and creating custom calculations
and formulas.
➢Expanding and collapsing levels of data to focus your results and
drilling down to details from the summary data for areas of
interest to you.
➢Moving rows to columns or columns to rows (or “pivoting”) to see
different summaries of the source data.
➢Filtering, sorting, grouping, and conditionally formatting the most
useful and interesting subset of data to enable you to focus on
the information that you want.
➢Presenting concise, attractive, and annotated online or printed
reports.
Example: Survey of a
population regarding visits
to fitness facilities.
Cross tabulations enable you
to examine relationships
within the data that might
not be readily apparent
when analyzing total survey
responses.
Using spreadsheets to create pivot tables for
cross-tabulation analysis
• A Pivot Table is used to summarize a dataset by numerous
dimensions.
• PivotTables are often used to summarize sales transaction
data by salesperson, by store location, by month or week,
by product, by brand, etc.
Activity #6 – Pivot Tables
Background Information
• You have been hired as a data analytics consultant and your
current client is Alex. He is the store manager for an athletic
shoe store and has extended his product line to include a new
category: wearable technologies
• His product line now includes activity trackers, smart watches,
and sports watches.
• Alex carries three manufacturer’s brands:
FitBit, Garmin, and Polar.
Scenario for Activity #6 (continued)
• Alex needs to see how sales activity has gone with this new
product line and asked you to conduct this analysis.
• He has given you a dataset that includes all the sales
transactions for the first six months of business from the
POS transaction system used by their store chain across the
region.
Questions to answer for Alex
Q1: How many items were sold by Product Brand?
Q2: How many items were sold by brand and gender?
Q3: How many items were sold by color?
Q4: Unit Sales by Age Group and Gender?
Q5: What are total sales by Age Group and By Gender?
Q6: What is the average price paid by Age Group and By Gender?
Q7: How many items did we sell by Day-of-Week?
Q8: Can we visually show Product Sales by Gender?
Activity #6 – Basic Guidelines
• Download from Canvas the starter file of sales data:
Act#6-Pivot-WearableTechData-Starter.xlsx
• Immediately rename and save as:
Act#6-Pivot-WearableTechData-Your.Name
(substitute your name for “Starter”)
• Use the following instructions to complete a series of Pivot Table
activities that will allow you to answer the questions that Alex has
asked you to address.
• When you are done, submit a completed workbook that includes the
various pivot tables needed to provide the answers to Alex’s questions.
(Each completed pivot table will be on a separate workbook tab.)
Resulting Dataset in spreadsheet format
Act#6-PivotTables-InClass-Your.Name
Mechanics of building Pivot Tables
Step 1: Select the range of data for the analysis. Use the menu bar
to “insert” a pivot table into your workbook. The easiest method is
to put each pivot table on a separate workbook tab.
The popup also automatically
selects the range of cells with
the data to analyze. Notice
the absolute addressing
format.
Pop-up
generated
Click “OK” to create the new
tab with a working pivot table
The new
worksheet tab
will have the
skeletal pivot
table on the left
and the
development
tools on the
right.
Drag fields
(columns) to
summarize into
the “values”
area and the
fields to group
by into Rows
and/or Columns
Columns in
your dataset
(“fields”)
Let’s do the first one to calculate number
of individual sales grouped by Product
Brand.
Note that we can use the TranID column
to “count” number of transactions.
To get started, watch this Youtube step-by-step
of how to build pivot tables in Excel. It runs
about 6-minutes and will prepare you for the
following step-by-step instructions on the
following slides.
How to build Pivot Tables in Excel (6:21)
Doing the First Pivot Table
To build a pivot table, click on “Insert” and then
“Pivot Table” using the top menu bar. Click OK.
First steps…
Add Prod_Brand to Rows
and TranID to Values
When you add a field to be
summarized, it defaults to
“Sum”, but in this case we
need to change that to
“Count”. You do this by
clicking the down arrow next
to “Sum of TranID”, select
“Value Field Settings in
popup and then “Count” in
the list.
Click “OK” to refresh the pivot
table and change the calculation to
“count” the # of individual sales.
Results
Resulting version after changing the
calculation to “Count”.
Now that we understand the process of
creating and modifying the Pivot Tables,
let’s begin to answer the questions.
Q1: How many items were sold by Product Brand?
DRAG field
names into
pivot table
areas
Change “Sum” to “Count”
Rename the Worksheet
A small Excel quirk in Pivot tables
• Occasionally an odd Excel quirk shows up in Pivot tables so here is a
workaround to fix it!
• When you create a new pivot table, are you seeing an extra blank line in the
results? Or an extra line in the grouping that shouldn’t occur?
• You have checked the data and there is NO blank row/column or any apparent
reason why this extra line is occurring!!!!
SOLUTION:
Explicitly select the data range in your
original data using CTRL+SHIFT+RIGHT,
CTRL+SHIFT+DOWN ARROW
before inserting and creating the pivot
table result.
This seems to fix the problem!!
Q2: How many items were sold by brand and gender?
Change “Sum” to “Count”
Rename sheet to “ByGender”
Q3: How many items were sold by color?
Sort from
High-to-Low on
Column B
To sort a column of a
Pivot table, make sure
your cursor is inside the
pivot table column and
right-click for Sort option
Rename sheet to “ByColor”
Q4: Unit Sales by Age Group and Gender?
To create Age Groups : Right-click
on Age column in pivot table to
display a popup menu. On popup
menu, select Group.
Start at 10 and end at 69.
Create standard groups in 10’s
Rename sheet to “ByGenderAgeCnt”
Q5: What are total sales by Age Group and By Gender?
SUM of all Prices in all Transactions
Rename sheet to “ByGenderAgeSales”
Q6: What is the average price paid
by Age Group and By Gender?
AVERAGE of all Prices in all Transactions
Rename sheet to “ByGenderAgeAvgPrice”
Prep for Q7: Creating a New Field
1.
2.
3.
4.
Go back to your transaction data worksheet.
Insert a new column to the right of TranDate.
Rename new column to DayofWeek.
In new column first cell, insert the formula that you see
here, =TEXT(B2,”DDD”), to extract the day out of the date
for the first row.
5. Copy that formula to the remaining rows.
Refresh the Data Sources
Initiate a new PivotTable and then, under the
PivotTable Analyze tab, click Refresh to refresh
the data courses and make DayofWeek
appear in your PivotTable Fields list.
Q7: How many items did we sell by Day-of-Week?
Sort the Count
of TranID
column to
determine
busiest day
Rename sheet to “DayofWeek”
Prep for Q8: Creating a New Field
and Refreshing Data Sources, Again
Using the same method that was used in the Prep
for Q7 slide, create a new field called Month.
To retrieve the month as text from the parent cell,
use MMM instead of DDD.
Once created, initiate a new PivotTable and
Refresh the Data Sources.
Q8: Can we visually show Product Sales by Gender?
(via Slicer) Part 1
Q8: Can we visually show Product Sales by Gender?
(via Slicer) Part 2
Insert Slicers into the PivotTable for
CUST_gender and Prod_Brand.
Q8: Can we visually show Product Sales by Gender?
(via Slicer) Part 3
Use the slicers to experiment with different
combinations of gender and brand.
Select one combination and move on.
Rename sheet to “ByGenderSalesSlicer”
Q8: Can we visually show Product Sales by Gender?
(via PivotChart) Part 1
Initiate a PivotChart by selecting PivotChart
under the Insert tab. Select OK.
Q8: Can we visually show Product Sales by Gender?
(via PivotChart) Part 1
Rename sheet to “ByGenderSalesChart”
Save and Upload
• You have now completed all of the required Pivot Tables to
answer Alex’s questions.
• Make sure each question is recorded on a separate
worksheet (slicer may be an additional one).
• Save your workbook and upload it to the assignment folder
for Activity #6.
TranID
TranDate
TranTime
ProdID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
1/2/2016
1/2/2016
1/3/2016
1/5/2016
1/7/2016
1/8/2016
1/8/2016
1/9/2016
1/9/2016
1/10/2016
1/10/2016
1/12/2016
1/12/2016
1/12/2016
1/13/2016
1/15/2016
1/15/2016
1/15/2016
1/15/2016
1/16/2016
1/20/2016
1/20/2016
1/22/2016
1/22/2016
1/22/2016
1/23/2016
1/24/2016
1/24/2016
1/25/2016
1/25/2016
1/26/2016
1/27/2016
1/28/2016
1/29/2016
1/30/2016
2/3/2016
2/3/2016
2/3/2016
2/3/2016
2/3/2016
2/3/2016
2/4/2016
2/4/2016
2/6/2016
2/8/2016
10:00:49
15:55:21
19:02:23
10:10:03
15:13:39
11:11:32
11:47:23
13:47:46
17:15:06
14:16:02
19:38:36
13:18:39
14:11:22
14:19:59
17:47:24
11:18:26
13:02:07
15:01:36
15:23:01
16:37:51
12:28:56
18:58:04
14:08:20
15:39:06
17:43:40
14:41:21
15:36:47
17:23:30
18:25:12
18:41:11
10:24:28
12:59:27
16:44:56
19:38:53
11:25:16
10:11:43
10:57:18
15:15:27
16:29:16
17:22:01
19:43:55
10:30:11
11:29:15
15:00:11
16:06:01
FB-Charge 2-Aqua
FB-Flex 2-Aqua
FB-Charge 2-Blac
PO-M400-Blue
FB-Surge-Blac
GM-VivoActive HR-Blac
PO-Loop 2-Red
FB-Charge 2-Blue
FB-Blaze-Grey
FB-Flex 2-Blue
PO-M450-Blac
FB-Flex 2-Blac
FB-Surge-Silv
FB-Charge 2-Blac
FB-Flex 2-Blac
PO-M450-Whit
FB-Flex-Aqua
FB-Charge 2-Aqua
FB-Blaze-Silv
GM-VivoSmart HR+-Blac
PO-M400-Pink
PO-M400-Blac
GM-Fenix 3 Saphire-Silv
FB-Flex-Blac
FB-Charge 2-Blac
PO-A360-Blac
PO-M400-Red
FB-Charge -Blac
FB-Flex 2-Blac
PO-A360-Blue
GM-Fenix 3 Saphire-Blac
FB-Charge -Plum
FB-Blaze-Blue
FB-Blaze-Blac
FB-Flex-Blac
GM-ForeRunner 25-Silv
FB-Flex-Aqua
FB-Altra-Aqua
FB-Flex 2-Blue
FB-Charge -Blac
FB-Blaze-Blue
FB-Flex-Blac
FB-Flex 2-Blac
PO-V800-Blac
GM-Fenix 3 HR-Blac
CustID CUST_Lname
54
59
64
38
13
26
36
65
48
10
41
57
15
5
70
98
82
81
49
28
97
95
21
8
52
100
40
4
9
30
20
77
50
60
56
23
68
16
71
63
3
69
84
45
19
Wright
Nelson
Evans
Green
Campbell
Cook
Morgan
Bell
Cooper
James
Ward
Perry
Jenkins
Coleman
Graham
Johnson
Mcdonald
Gibson
Smith
Taylor
Mason
Grant
Davis
Brown
Miller
Wilson
Martinez
Lee
Walker
Hall
Scott
Nichols
Campbell
Williams
Mccoy
Clark
Lewis
Hanna
Deramus
Rodriguez
Robinson
Bartleson
Sublett
Thompson
Graham
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
2/8/2016
2/10/2016
2/10/2016
2/13/2016
2/13/2016
2/14/2016
2/17/2016
2/17/2016
2/20/2016
2/23/2016
2/25/2016
2/25/2016
2/26/2016
2/26/2016
2/27/2016
2/28/2016
2/28/2016
2/28/2016
2/28/2016
3/3/2016
3/3/2016
3/3/2016
3/3/2016
3/4/2016
3/5/2016
3/5/2016
3/5/2016
3/5/2016
3/6/2016
3/9/2016
3/9/2016
3/11/2016
3/15/2016
3/15/2016
3/15/2016
3/17/2016
3/18/2016
3/25/2016
3/27/2016
4/2/2016
4/3/2016
4/4/2016
4/5/2016
4/5/2016
4/13/2016
4/13/2016
4/15/2016
18:19:57
11:33:01
13:23:03
11:07:53
18:02:15
13:23:02
11:30:35
19:31:19
17:18:15
18:08:28
10:05:14
19:48:51
18:27:31
19:01:58
10:14:10
11:24:12
11:40:12
12:27:37
14:16:22
18:33:11
18:39:01
19:33:30
19:53:18
12:02:49
14:16:09
16:55:40
17:45:05
18:32:03
17:02:44
11:06:37
17:39:28
13:19:48
10:31:06
14:37:44
18:02:05
11:48:53
18:15:29
16:59:08
11:24:17
16:58:27
15:14:15
11:45:49
10:52:08
10:58:17
11:41:42
13:56:54
12:07:03
PO-M600-Whit
PO-Loop-Pink
FB-Altra-Plum
FB-Flex 2-Plum
FB-Flex 2-Blue
PO-M400-Pink
PO-Balance-Blac
PO-M400-Blac
PO-A360-Blac
FB-Charge 2-Plum
FB-Flex-Plum
FB-Flex-Plum
PO-M400-Red
FB-Blaze-Blac
GM-VivoSmart HR+-Whit
PO-M450-Blac
PO-V650-Blac
GM-ForeRunner 630-Whit
PO-Loop-Whit
GM-ForeRunner 25-Blac
FB-Charge 2-Blue
FB-Flex-Aqua
PO-A360-Pink
PO-M450-Whit
FB-Flex-Plum
FB-Charge -Blac
FB-Charge -Plum
PO-A360-Pink
GM-Fenix 3 HR-Whit
FB-Charge -Plum
FB-Blaze-Grey
PO-V650-Whit
FB-Charge 2-Blue
FB-Flex-Blac
FB-Blaze-Blac
PO-Loop-Whit
FB-Flex 2-Blue
FB-Charge 2-Plum
FB-Charge 2-Blac
PO-V800-Whit
FB-Charge -Plum
FB-Blaze-Silv
PO-M600-Blac
GM-VivoActive HR-Whit
FB-Charge 2-Plum
PO-A360-Whit
PO-V800-Red
43
93
18
11
85
39
33
37
87
6
69
84
98
49
28
99
44
25
34
21
52
8
100
40
9
78
4
30
20
50
60
44
6
83
1
92
58
66
79
46
62
2
42
27
53
91
47
Sullivan
Reynolds
Owens
Porter
Hunter
Warren
Grant
Knight
Reid
Elliott
Bartleson
Sublett
Johnson
Smith
Taylor
Robinson
Martinez
Thompson
Garcia
Davis
Miller
Brown
Wilson
Martinez
Walker
Rice
Lee
Hall
Scott
Campbell
Williams
Martinez
Elliott
Ramos
Harper
Robinson
Brown
Richards
Johnson
Wright
Lopez
Carter
Rogers
Morris
Hamilton
Sullivan
Watson
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
4/15/2016
4/15/2016
4/16/2016
4/16/2016
4/18/2016
4/18/2016
4/19/2016
4/23/2016
4/23/2016
4/29/2016
4/29/2016
4/29/2016
4/29/2016
4/29/2016
4/30/2016
5/2/2016
5/3/2016
5/3/2016
5/4/2016
5/5/2016
5/7/2016
5/7/2016
5/7/2016
5/9/2016
5/11/2016
5/11/2016
5/18/2016
5/21/2016
5/22/2016
5/22/2016
5/24/2016
5/24/2016
5/25/2016
5/28/2016
5/29/2016
5/31/2016
6/4/2016
6/5/2016
6/12/2016
15:06:19
19:18:18
12:23:17
19:06:25
17:21:12
17:32:46
19:31:14
14:42:12
17:16:50
11:25:08
13:07:18
19:16:52
19:35:33
19:36:47
17:33:48
12:50:01
17:05:01
18:14:15
12:28:40
11:13:06
15:03:06
18:22:55
19:01:17
19:17:02
12:03:58
12:05:03
13:01:50
16:30:12
12:45:09
17:38:31
12:19:03
15:09:07
17:55:48
11:58:58
14:07:09
11:27:01
16:05:19
13:47:56
16:09:21
FB-Altra-Blac
PO-Loop 2-Whit
FB-Flex-Aqua
PO-A360-Gree
FB-Charge 2-Plum
PO-M400-Blue
FB-Charge 2-Aqua
FB-Charge -Blac
FB-Blaze-Grey
FB-Flex 2-Aqua
GM-VivoActive -Blac
PO-A360-Whit
PO-Loop-Pink
PO-M600-Blac
FB-Blaze-Blac
FB-Surge-Aqua
FB-Flex 2-Aqua
FB-Blaze-Silv
FB-Blaze-Silv
PO-Loop 2-Whit
PO-A360-Pink
GM-ForeRunner 25-Whit
FB-Flex 2-Plum
PO-A360-Blue
PO-A360-Blac
FB-Blaze-Grey
PO-A360-Gree
FB-Flex-Plum
FB-Surge-Plum
FB-Blaze-Blue
FB-Blaze-Blue
PO-Loop 2-Red
GM-ForeRunner 630-Blac
FB-Charge 2-Aqua
FB-Flex 2-Aqua
FB-Flex 2-Plum
PO-Balance-Blac
FB-Flex 2-Plum
FB-Charge 2-Blue
17
35
55
31
80
96
67
51
1
73
25
32
34
99
75
14
87
76
61
94
88
22
72
89
29
74
90
56
14
76
61
94
24
7
12
86
92
58
79
Smith
Scott
Wallace
Holmes
Boyd
Reyes
Mills
Watkins
Harper
Castillo
Thompson
Montgomery
Garcia
Robinson
Williamson
Little
Reid
Jacobs
Mendoza
Moreno
Vargas
Fleming
Jensen
Barnett
Gregory
Mckinney
Lyons
Mccoy
Little
Jacobs
Mendoza
Moreno
Tate
Reese
Smith
Garcia
Robinson
Brown
Johnson
CUST_Fname
CUST_address
CUST_city
Mark
Andrew
Seth
Allen
Alfred
Don
Eddie
Ricky
Alexander
Miguel
Francisco
Derek
Leon
Tommy
Rita
John
Edith
Victoria
James
Thomas
Juanita
Michele
Raymond
Andrew
Gregory
Joshua
Ryan
Albert
Jonathan
Justin
Nicholas
Suzanne
Jeremy
Russell
Vera
Antonio
Bryan
Sheldon
Gary
Danny
Jimmy
Jake
Richard
Paul
Brian
342 Cherry Cir W
342 Cherry Cir W
6987 Gwynne Rd
2395 Capri St
600 Cherry Road
2889 Bear Dr
4474 Massey Pointe Ln
310 Fields Drive
6431 Van Der Veer Dr
230 Fair Meadows Lane
9523 Massey Pointe Ln
3906 Brierhaven Ave
9906 Winding River Cir Apt 303
8322 Shadowland Cv
6995 Belsfield Rd
2380 Princeton Ave
3392 Liggon Green Ln
1993 Calkins Rd
1068 Phyllis Ln
1432 Sycamore Grove Ln
2431 Lennox Drive
9623 Marcia Rd
6889 Summer Crk N
9846 Sycamore Grove Ln
7962 Brierhaven Ave
5486 Fleda Rd
7139 Shadow Oaks Cv
3994 Steve Road Apt 6
8649 Eagle Crest Dr Apt 1
1008 Island Park Drive
5621 Patrick Henry Dr
1674 Ansnow Ln
4937 Quail Pointe Cir N
4333 N Quail Hollow Rd Apt 146
9061 Hawthorn Hill Cv
6528 Sycamore Grove Ln
2799 Longshadow Cove
7561 Summit Arbors Cir Apt 101
4245 N Oak Grove Rd
2806 Cobb Road
2049 Pecan Grove Ln
9915 Fairwood Ln
9950 Montrose Dr
6450 S Goodlett St
2379 Edgeware Rd S
Memphis
Memphis
Memphis
Memphis
Eads
Memphis
Memphis
Arlington
Memphis
Eads
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Germantown
Germantown
Memphis
Memphis
Germantown
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Germantown
Memphis
Cordova
Memphis
Memphis
Lakeland
Memphis
Memphis
Memphis
Memphis
Memphis
CUST_st CUST_zip CUST_gender
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
38117
38117
38117
38118
38028
38118
38120
38002
38133
38028
38120
38120
38120
38125
38119
38112
38139
38139
38118
38120
38138
38117
38141
38120
38120
38120
38125
38104
38117
38103
38134
38118
38120
38120
38139
38120
38016
38128
38120
38002
38120
38120
38117
38118
38118
M
M
M
M
M
M
M
M
M
M
M
M
M
M
F
M
F
F
M
M
F
F
M
M
M
M
M
M
M
M
M
F
M
M
F
M
M
M
M
M
M
M
M
M
M
Ronald
Jose
Timothy
Douglas
Henry
Albert
Harry
Fred
Constance
Dale
Jake
Richard
John
James
Thomas
Brian
Edward
Kenneth
Steven
Raymond
Gregory
Andrew
Joshua
Ryan
Jonathan
Ralph
Albert
Justin
Nicholas
Jeremy
Russell
Edward
Dale
Eva
Danny
Emily
Rochelle
Wilma
Patricia
Brenda
Amy
Amanda
Teresa
Heather
Gladys
Dawn
Oscar
8926 Bridlewood St
4698 Shady Grove Rd
3400 Glade View Dr
7352 Nash Dr Apt 102
9259 Windy Meadow Lane
5773 Colony Ln
5709 Brierbrook Rd
4349 Spottswood Ave
9131 King Rd
5546 Rippling Creek Ln
9915 Fairwood Ln
9950 Montrose Dr
2380 Princeton Ave
1068 Phyllis Ln
1432 Sycamore Grove Ln
9751 Haymarket Cv
7478 Colony Ln
4925 Kenosha Rd
4532 Texel Cv
6889 Summer Crk N
7962 Brierhaven Ave
9846 Sycamore Grove Ln
5486 Fleda Rd
7139 Shadow Oaks Cv
8649 Eagle Crest Dr Apt 1
7683 Bubbling Brook Dr
3994 Steve Road Apt 6
1008 Island Park Drive
5621 Patrick Henry Dr
4937 Quail Pointe Cir N
4333 N Quail Hollow Rd Apt 146
7478 Colony Ln
5546 Rippling Creek Ln
3155 Burt Cv
5878 Cherry Rd Apt 1163
8865 S Goodlett St
3436 Estate Dr
2148 Groveway Dr
9388 Forest Downs Rd
3373 Springmead Dr
3908 Rockwood Ave
6963 Park Ave
9198 Tealstone Dr
9803 Grey Cliff Dr
8808 Pavilion Grn S
9772 S Goodlett St
11679 Wynestone Oaks Cove
Memphis
Memphis
Memphis
Memphis
Cordova
Memphis
Germantown
Memphis
Memphis
Bartlett
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Germantown
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Bartlett
Memphis
Memphis
Memphis
Memphis
Germantown
Germantown
Germantown
Memphis
Memphis
Germantown
Germantown
Memphis
Memphis
Eads
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
38016
38120
38120
38125
38016
38119
38138
38114
38112
38135
38120
38117
38112
38118
38120
38120
38119
38118
38133
38141
38120
38120
38120
38125
38117
38138
38104
38103
38134
38120
38120
38119
38135
38119
38118
38118
38119
38139
38138
38139
38120
38119
38139
38139
38119
38117
38028
M
M
M
M
M
M
M
M
F
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
M
F
M
F
F
F
F
F
F
F
F
F
F
F
M
Wendy
Norman
Anthony
Willie
Emma
Debbie
Alicia
Yvonne
Danny
Gertrude
Kenneth
Stacey
Steven
Brian
Gina
Maureen
Constance
Georgia
Marian
Stella
Christy
Myrtle
Lena
Carole
Sonia
Miriam
Eunice
Vera
Maureen
Georgia
Marian
Stella
Yvette
Latoya
Patty
Angelica
Emily
Rochelle
Patricia
1900 Wakefield Dr
1734 Winding River Cir Apt 204
6730 Quail Pointe Cir N
2047 Winter Cv
2877 Rue Jordan Cove
2876 W Crestwood Dr
3071 Steeplegate Cove
4184 Johnson Rd
5878 Cherry Rd Apt 1163
8975 Forest Grove Dr
4925 Kenosha Rd
4764 Oaklawn Ln
4532 Texel Cv
9751 Haymarket Cv
4153 Meier Dr
8469 Wood Briar Drive
9131 King Rd
3769 Mayo Ave
4961 Groveway Cv
1878 Millers Pond Cir
6741 Timmons Ave Apt 1
7322 Garrison Ave
7095 Flamingo Rd
4130 Columbine Ct Apt 32
4541 Juanita Cir N
8632 Deerfield Lane
3891 S Galloway Drive
9061 Hawthorn Hill Cv
8469 Wood Briar Drive
3769 Mayo Ave
4961 Groveway Cv
1878 Millers Pond Cir
2201 S Main St Apt 606
2390 Laurelwood Dr
4728 Wakefield Dr
7907 Flamingo Rd
8865 S Goodlett St
3436 Estate Dr
9388 Forest Downs Rd
Memphis
Memphis
Memphis
Memphis
Germantown
Memphis
Germantown
Germantown
Memphis
Memphis
Memphis
Germantown
Memphis
Memphis
Memphis
Germantown
Memphis
Memphis
Germantown
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Germantown
Memphis
Germantown
Germantown
Memphis
Germantown
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Memphis
Germantown
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
TN
38117
38120
38120
38128
38138
38119
38138
38139
38118
38119
38118
38139
38133
38120
38118
38138
38112
38128
38139
38119
38119
38128
38117
38118
38133
38138
38111
38139
38138
38128
38139
38119
38103
38117
38117
38117
38118
38119
38138
F
M
M
M
F
F
F
F
M
F
M
F
M
M
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
F
CUST_age Prod_Brand
12
14
16
31
32
34
34
34
35
37
36
38
38
38
29
19
30
30
19
20
31
33
22
22
22
22
23
24
24
24
25
33
26
27
40
29
29
17
17
29
29
18
18
40
41
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Garmin
Polar
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Fitbit
Fitbit
Garmin
Polar
Polar
Garmin
Fitbit
Fitbit
Polar
Polar
Fitbit
Fitbit
Polar
Garmin
Fitbit
Fitbit
Fitbit
Fitbit
Garmin
Fitbit
Fitbit
Fitbit
Fitbit
Fitbit
Fitbit
Fitbit
Polar
Garmin
Prod_Model
Prod_Description
Charge 2
Flex 2
Charge 2
M400
Surge
VivoActive HR
Loop 2
Charge 2
Blaze
Flex 2
M450
Flex 2
Surge
Charge 2
Flex 2
M450
Flex
Charge 2
Blaze
VivoSmart HR+
M400
M400
Fenix 3 Saphire
Flex
Charge 2
A360
M400
Charge
Flex 2
A360
Fenix 3 Saphire
Charge
Blaze
Blaze
Flex
ForeRunner 25
Flex
Altra
Flex 2
Charge
Blaze
Flex
Flex 2
V800
Fenix 3 HR
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker
Wristband Fitness Tracker w/Heartrate
GPS Running Watch
Fitness Super Watch
Smart Activity Tracker w/ HR + GPS
Stylish Activity Tracker
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Wristband Fitness Tracker
GPS Bike Computer
Wristband Fitness Tracker
Fitness Super Watch
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker
GPS Bike Computer
Wristband Fitness & Sleep Tracker
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Smart Activity Tracker w/ HR + GPS
GPS Running Watch
GPS Running Watch
fēnix 3 HR multisport training GPS watch
Wristband Fitness & Sleep Tracker
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker w/Heart Rate
GPS Running Watch
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker
Wristband Fitness Tracker w/Heart Rate
fēnix 3 HR multisport training GPS watch
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Smart Fitness Watch
Wristband Fitness & Sleep Tracker
GPS Running Watch with Smart Notifications
Wristband Fitness & Sleep Tracker
Fitness Wristband
Wristband Fitness Tracker
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Wristband Fitness & Sleep Tracker
Wristband Fitness Tracker
GPS Sports Watch
fēnix 3 HR multisport training GPS watch
41
42
42
44
44
46
50
50
42
64
18
18
19
19
20
21
21
21
21
22
22
22
22
23
24
47
24
24
25
26
27
21
64
32
58
12
14
39
20
22
22
23
24
24
29
29
37
Polar
Polar
FitBit
Fitbit
Fitbit
Polar
Polar
Polar
Polar
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Garmin
Polar
Polar
Garmin
Polar
Garmin
Fitbit
Fitbit
Polar
Polar
Fitbit
Fitbit
Fitbit
Polar
Garmin
Fitbit
Fitbit
Polar
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Fitbit
Polar
Garmin
Fitbit
Polar
Polar
M600
Loop
Altra
Flex 2
Flex 2
M400
Balance
M400
A360
Charge 2
Flex
Flex
M400
Blaze
VivoSmart HR+
M450
V650
ForeRunner 630
Loop
ForeRunner 25
Charge 2
Flex
A360
M450
Flex
Charge
Charge
A360
Fenix 3 HR
Charge
Blaze
V650
Charge 2
Flex
Blaze
Loop
Flex 2
Charge 2
Charge 2
V800
Charge
Blaze
M600
VivoActive HR
Charge 2
A360
V800
Sport Smartwatch
Stylish Wristband Fitness Tracker
Fitness Wristband
Wristband Fitness Tracker
Wristband Fitness Tracker
GPS Running Watch
Weight Mgmt Service
GPS Running Watch
Wristband Fitness Tracker w/Heart Rate
Wristband Fitness Tracker w/Heartrate
Wristband Fitness & Sleep Tracker
Wristband Fitness & Sleep Tracker
GPS Running Watch
Smart Fitness Watch
Smart Activity Tracker w/ HR + GPS
GPS Bike Computer
Smart GPS Bike Computer
GPS Smartwatch with Advanced Running Metrics
Stylish Wristband Fitness Tracker
GPS Running Watch with Smart Notifications
Wristband Fitness Tracker w/Heartrate
Wristband Fitness & Sleep Tracker
Wristband Fitness Tracker w/Heart Rate
GPS Bike Computer
Wristband Fitness & Sleep Tracker
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker w/Heart Rate
fēnix 3 HR multisport training GPS watch
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Smart GPS Bike Computer
Wristband Fitness Tracker w/Heartrate
Wristband Fitness & Sleep Tracker
Smart Fitness Watch
Stylish Wristband Fitness Tracker
Wristband Fitness Tracker
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker w/Heartrate
GPS Sports Watch
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Sport Smartwatch
Smart Activity Tracker w/ HR + GPS
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker w/Heart Rate
GPS Sports Watch: JAVIER Gomez Noya SE
30
31
41
47
31
32
33
35
58
38
21
39
21
21
39
41
42
42
44
44
45
45
45
47
48
48
54
40
41
42
44
44
58
62
62
65
12
14
20
FitBit
Polar
Fitbit
Polar
Fitbit
Polar
Fitbit
Fitbit
Fitbit
Fitbit
Garmin
Polar
Polar
Polar
Fitbit
Fitbit
Fitbit
Fitbit
Fitbit
Polar
Polar
Garmin
Fitbit
Polar
Polar
Fitbit
Polar
Fitbit
Fitbit
Fitbit
Fitbit
Polar
Garmin
Fitbit
Fitbit
Fitbit
Polar
Fitbit
Fitbit
Altra
Loop 2
Flex
A360
Charge 2
M400
Charge 2
Charge
Blaze
Flex 2
VivoActive
A360
Loop
M600
Blaze
Surge
Flex 2
Blaze
Blaze
Loop 2
A360
ForeRunner 25
Flex 2
A360
A360
Blaze
A360
Flex
Surge
Blaze
Blaze
Loop 2
ForeRunner 630
Charge 2
Flex 2
Flex 2
Balance
Flex 2
Charge 2
Fitness Wristband
Stylish Activity Tracker
Wristband Fitness & Sleep Tracker
Wristband Fitness Tracker w/Heart Rate
Wristband Fitness Tracker w/Heartrate
GPS Running Watch
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker w/Heartrate
Smart Fitness Watch
Wristband Fitness Tracker
Smart Activity Tracker + GPS
Wristband Fitness Tracker w/Heart Rate
Stylish Wristband Fitness Tracker
Sport Smartwatch
Smart Fitness Watch
Fitness Super Watch
Wristband Fitness Tracker
Smart Fitness Watch
Smart Fitness Watch
Stylish Activity Tracker
Wristband Fitness Tracker w/Heart Rate
GPS Running Watch with Smart Notifications
Wristband Fitness Tracker
Wristband Fitness Tracker w/Heart Rate
Wristband Fitness Tracker w/Heart Rate
Smart Fitness Watch
Wristband Fitness Tracker w/Heart Rate
Wristband Fitness & Sleep Tracker
Fitness Super Watch
Smart Fitness Watch
Smart Fitness Watch
Stylish Activity Tracker
GPS Smartwatch with Advanced Running Metrics
Wristband Fitness Tracker w/Heartrate
Wristband Fitness Tracker
Wristband Fitness Tracker
Weight Mgmt Service
Wristband Fitness Tracker
Wristband Fitness Tracker w/Heartrate
Prod_Color Prod_Price
Aqua
Aqua
Black
Blue
Black
Black
Red
Blue
Grey
Blue
Black
Black
Silver
Black
Black
White
Aqua
Aqua
Silver
Black
Pink
Black
Silver
Black
Black
Black
Red
Black
Black
Blue
Black
Plum
Blue
Black
Black
Silver
Aqua
Aqua
Blue
Black
Blue
Black
Black
Black
Black
149.95
99.95
149.95
179.95
249.99
249.99
119.95
149.95
199.99
99.95
169.95
99.95
249.99
149.95
99.95
169.95
79.99
149.95
199.99
219.99
179.95
179.95
599.99
79.99
149.95
199.95
179.95
129.99
99.95
199.95
599.99
129.99
199.99
199.99
79.99
125
79.99
129.99
99.95
129.99
199.99
79.99
99.95
499.95
599.99
White
Pink
Plum
Plum
Blue
Pink
Black
Black
Black
Plum
Plum
Plum
Red
Black
White
Black
Black
White
White
Black
Blue
Aqua
Pink
White
Plum
Black
Plum
Pink
White
Plum
Grey
White
Blue
Black
Black
White
Blue
Plum
Black
White
Plum
Silver
Black
White
Plum
White
Red
329.95
159.95
129.99
99.95
99.95
179.95
99.95
179.95
199.95
149.95
79.99
79.99
179.95
199.99
219.99
169.95
299.95
399.99
159.95
125
149.95
79.99
199.95
169.95
79.99
129.99
129.99
199.95
599.99
129.99
199.99
299.95
149.95
79.99
199.99
159.95
99.95
149.95
149.95
499.95
129.99
199.99
329.95
249.99
149.95
199.95
549.95
Black
White
Aqua
Green
Plum
Blue
Aqua
Black
Grey
Aqua
Black
White
Pink
Black
Black
Aqua
Aqua
Silver
Silver
White
Pink
White
Plum
Blue
Black
Grey
Green
Plum
Plum
Blue
Blue
Red
Black
Aqua
Aqua
Plum
Black
Plum
Blue
129.99
119.95
79.99
199.95
149.95
179.95
149.95
129.99
199.99
99.95
219.99
199.95
159.95
329.95
199.99
249.99
99.95
199.99
199.99
119.95
199.95
125
99.95
199.95
199.95
199.99
199.95
79.99
249.99
199.99
199.99
119.95
399.99
149.95
99.95
99.95
99.95
99.95
149.95