Chat with us, powered by LiveChat 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 - Writeden

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/