Overview
You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants to expand its customer base but does not know what kind of restaurant or which U.S. region to target. You have been given a Clean Customer Sales Data Set that is a representative sample of the sales at your customers’ restaurants for 2015 and 2016. This also contains household income data for the restaurant zip codes.
You have been asked to compare demographic(s) data to determine consistencies or inconsistencies in the data. You must also determine the areas with the highest household income and the restaurants in those areas. You must then analyze these results to find out whether there are opportunities for business expansion and determine how these may impact your recommendations.
In this activity, you will work with the given data set and create maps in Tableau, and then recommend opportunities for business expansion.
Prompt
Create a report that presents the recommendations for business expansion by creating and analyzing maps using your data set. Include the relevant screenshots in the report.
Specifically, you must address the following rubric criteria:
Create Maps
Determine the variables you are going to use.
Determine whether they are in the correct format for creating a map.
Graph the count of customers by U.S. state and the sum of the order_total variable.
Identify the states with the most and least customers.
Identify the states that have generated the most and least revenue for the restaurants.
Add Data Layers to Maps
Compare the revenue generated in each state to the state’s median household income using the Map Layers option.
Determine whether this would provide an indication of how successful a product expansion would be in those areas.
Analyze the results when you use Household Income and State to create a map.
Analyze the results when you select Zip Code instead of State in the “By” option.
Identify the zip codes with the highest revenue for this group of restaurants and determine if they are in high-income or low-income zip codes.
Analyze the high-income zip codes and determine if the restaurants are well-represented or largely absent.
Recommendations
Elaborate on the opportunities for sales and marketing.
Determine if there are high-income zip codes that aren’t well-represented by the restaurants but would be lucrative to expand into.
Analyze the impact of having data with the names and zip codes of the restaurants’ suppliers on opportunities for sales and marketing.
Identify other data layers that you consider important to map out and investigate. Explain.
What to Submit
Submit a 3- to 4-page Word document containing relevant screenshots using double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.
Clean Customer Sales Data Set
customer_id
transaction_id
order_type
restaurant_address
restaurant_category
restaurant_city
order_date
order_time
order_time_of_day
order_total
restaurant_name
restaurant_zip_code
restaurant_state
Household_income
AVwc3UrlByjofQCxjByp
LdZhuo92o1
DI
4200 Boat St
Restaurant
Fairbanks
1/20/2016
08:08:35
AM
$14.77
Chena’s Alaskan Grill
99709
AK
87055
AVwdDWuaIN2L1WUfrt8G
HEW5AJMGpi
DE
120 N College St
Cafe
Auburn
6/10/2016
11:43:00
AM
$20.69
Big Blue Bagel
36830
AL
53972
AVwdqDJ1kufWRAb58C24
KtOCkDOMzV
CO
3295 Bel Air Mall
Pizza Place
Mobile
6/26/2016
20:08:09
PM
$14.79
Buck’s Pizza
36606
AL
40850
AVwdqDJ1kufWRAb58C24
GOuCgpzp9e
CO
3295 Bel Air Mall
Pizza Place
Mobile
1/21/2016
10:43:23
AM
$24.34
Buck’s Pizza
36606
AL
40850
AVwdqDJ1kufWRAb58C24
eAIczfEqUB
DE
3295 Bel Air Mall
Pizza Place
Mobile
5/12/2015
12:32:41
PM
$7.68
Buck’s Pizza
36606
AL
40850
AVwdqDJ1kufWRAb58C24
oznPTS4k8j
DE
3295 Bel Air Mall
Pizza Place
Mobile
4/28/2016
05:45:01
AM
$22.48
Buck’s Pizza
36606
AL
40850
AVwdqDJ1kufWRAb58C24
EELmQ8XJX0
DE
3295 Bel Air Mall
Pizza Place
Mobile
3/15/2015
08:18:05
AM
$18.02
Buck’s Pizza
36606
AL
40850
AVwdcHktByjofQCxpIxp
ULyFpzjsRF
CO
1031 E Fairview Ave
Bars
Montgomery
4/9/2016
06:07:03
AM
$10.53
El Rey Burrito Lounge
36106
AL
59985
AVwdYsNfIN2L1WUfvQ_v
2jdamTq9Xl
CO
2080 Valleydale Rd
American Restaurant
Birmingham
9/24/2015
02:36:40
AM
$16.35
Ragtime Cafe
35244
AL
91323
AVwdYsNfIN2L1WUfvQ_v
HhDADSdulN
DE
2080 Valleydale Rd
American Restaurant
Birmingham
2/3/2015
06:52:07
AM
$16.35
Ragtime Cafe
35244
AL
91323
AVwdYsNfIN2L1WUfvQ_v
b2Y78eZwKJ
DE
2080 Valleydale Rd
American Restaurant
Birmingham
6/24/2016
01:21:47
AM
$24.58
Ragtime Cafe
35244
AL
91323
AVwdEBoc_7pvs4fz135d
iNbJn9Wtru
CO
300 E 3rd St
American Restaurant
Sylacauga
5/13/2016
06:24:20
AM
$9.30
Buttermilk Hill Restaruant and Bars
35150
AL
31819
AVwc-YZE_7pvs4fz071n
0fEeZporvi
CO
700 S E Walton Blvd
Pizza Place
Bentonville
9/8/2015
18:14:58
PM
$23.63
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
rCbaHZmC8x
CO
700 S E Walton Blvd
Pizza Place
Bentonville
10/2/2015
09:29:57
AM
$16.43
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
0Ii4bLaAsa
DE
700 S E Walton Blvd
Pizza Place
Bentonville
6/18/2016
03:55:43
AM
$13.56
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
I59DlhbZ1x
DE
700 S E Walton Blvd
Pizza Place
Bentonville
4/28/2015
18:03:10
PM
$7.99
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
zmQkuoyFib
DE
700 S E Walton Blvd
Pizza Place
Bentonville
8/18/2015
10:33:10
AM
$19.52
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
uUcfsL6jb0
DE
700 S E Walton Blvd
Pizza Place
Bentonville
3/7/2015
16:34:53
PM
$4.79
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
7rPDPhBKg2
DE
700 S E Walton Blvd
Pizza Place
Bentonville
11/14/2015
05:40:50
AM
$17.61
Johnny Brusco Pizza
72712
AR
83601
AVwc-YZE_7pvs4fz071n
wMCCBIbdFy
DE
700 S E Walton Blvd
Pizza Place
Bentonville
12/3/2015
06:21:44
AM
$6.26
Johnny Brusco Pizza
72712
AR
83601
AVwdBKTXByjofQCxkpWQ
8NULrFVNmt
CO
2006 S Pine St
Italian Restaurant
Cabot
6/9/2015
08:06:17
AM
$23.52
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
jiDOO4GgzD
CO
2006 S Pine St
Italian Restaurant
Cabot
3/24/2016
23:25:43
PM
$8.41
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
8zjbaKx2Ew
CO
2006 S Pine St
Italian Restaurant
Cabot
6/16/2015
11:08:26
AM
$5.72
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
BVCfltAeF9
CO
2006 S Pine St
Italian Restaurant
Cabot
2/22/2015
01:35:11
AM
$7.73
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
5xH6nPwRRV
DI
2006 S Pine St
Italian Restaurant
Cabot
1/10/2016
19:33:44
PM
$24.19
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
pcwXOozAkt
DI
2006 S Pine St
Italian Restaurant
Cabot
1/9/2015
06:41:54
AM
$21.24
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
Job5kH702c
DI
2006 S Pine St
Italian Restaurant
Cabot
4/24/2016
13:47:08
PM
$23.91
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
1N8Lg50kAi
DI
2006 S Pine St
Italian Restaurant
Cabot
9/4/2016
23:25:00
PM
$6.62
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
rO0khSFPAL
DI
2006 S Pine St
Italian Restaurant
Cabot
4/17/2016
22:03:56
PM
$7.23
Morina’s Italian Restaurant
72023
AR
62730
AVwdBKTXByjofQCxkpWQ
tNTL5vS2Fk
DI
2006 S Pine St
Italian Restaurant
Cabot
7/16/2015
03:55:00
AM
$12.03
Morina’s Italian Restaurant
72023
AR
62730
AVweRq3nkufWRAb5BhC5
ppOpYxbUQM
DI
3400 S 74th St
Restaurant
Fort Smith
9/13/2016
14:34:56
PM
$14.76
Joe’s Grill & Cantina
72903
AR
46706
AVwctjExByjofQCxhWE4
RiHoFw9Y9s
CO
1730 E Highland Dr
Pizza Place
Jonesboro
7/25/2015
19:40:22
PM
$10.76
Fazoli’s
72401
AR
42218
AVwctjExByjofQCxhWE4
OMpzjvzMBF
DI
1730 E Highland Dr
Pizza Place
Jonesboro
3/8/2015
07:47:16
AM
$9.04
Fazoli’s
72401
AR
42218
AVwctjExByjofQCxhWE4
zObYUgeSE9
DI
1730 E Highland Dr
Pizza Place
Jonesboro
12/2/2015
07:11:51
AM
$10.43
Fazoli’s
72401
AR
42218
AVwctPUlIN2L1WUfn_t4
d51ETukfCD
DI
8605 Highway 107
Mexican Restaurant
Sherwood
5/14/2015
15:25:03
PM
$13.25
Senior Tequila
72120
AR
65516
AVwdHYVGIN2L1WUfsXQs
d5Ap9RXBc8
DE
6746 E Cave Creek Rd
Bars
Cave Creek
12/14/2015
04:12:25
AM
$22.60
The Hideaway Grill
85331
AZ
106401
AVwcgg1e_7pvs4fzv1Z-
QKCb4AO9hu
CO
1909 E Ray Rd
Family Style Restaurant
Chandler
10/25/2015
19:18:54
PM
$6.83
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
zp5hyKGiZO
CO
1909 E Ray Rd
Family Style Restaurant
Chandler
5/3/2016
05:31:37
AM
$6.40
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
kJL1lTPJvH
CO
1909 E Ray Rd
Family Style Restaurant
Chandler
5/23/2016
12:08:38
PM
$6.98
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
l4TRIaEGnU
CO
1909 E Ray Rd
Pizza Place
Chandler
6/22/2015
23:28:01
PM
$7.20
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
YOSmSMGhKs
DI
1909 E Ray Rd
Family Style Restaurant
Chandler
5/2/2016
09:41:28
AM
$20.70
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
ZRXke9cMP9
DI
1909 E Ray Rd
Family Style Restaurant
Chandler
11/19/2015
08:40:24
AM
$22.86
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
HmhhvtDJCQ
DI
1909 E Ray Rd
Family Style Restaurant
Chandler
3/14/2015
18:36:00
PM
$19.98
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
ABOWKzM6Cw
DI
1909 E Ray Rd
Family Style Restaurant
Chandler
11/3/2016
16:36:02
PM
$11.80
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
wfg31JiOgS
DI
1909 E Ray Rd
Family Style Restaurant
Chandler
2/28/2015
01:43:06
AM
$7.89
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
BddF0JyEfK
DI
1909 E Ray Rd
Family Style Restaurant
Chandler
10/4/2016
04:28:07
AM
$14.29
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
kbdhoW7qwP
DI
1909 E Ray Rd
Pizza Place
Chandler
2/3/2016
14:42:43
PM
$13.45
Hungry Howie’s Pizza
85225
AZ
62155
AVwcgg1e_7pvs4fzv1Z-
EmZKeLDpyv
DI
1909 E Ray Rd
Pizza Place
Chandler
12/
The post You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants first appeared on Nursingdemy.