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
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.
- Determine the variables you are going to use.
- 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.
- Compare the revenue generated in each state to the state’s median household income using the Map Layers option.
- 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.
- Elaborate on the opportunities for sales and marketing.
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/
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. All Rights Reserved Terms and Conditions |