Report: Maps And Data Layers

Full Answer Section

    The analysis also shows that there is a correlation between revenue generated and median household income. However, there are some exceptions to this rule. For example, Nevada has a relatively high median household income, but it is not one of the top states for revenue generation. This suggests that other factors, such as population density and competition from other pizza restaurants, also play a role in determining success. Based on the analysis, the company has the following opportunities for business expansion:

• Expand into new regions, such as the Southeast and Southwest United States.
• Target high-income zip codes that are not well-represented by the company's current customer base.
• Market to restaurants in states that have a high median household income and a relatively low level of competition from other pizza restaurants.

Maps The following maps were created using Tableau to analyze the data set: Map 1: Count of Customers by U.S. State This map shows the count of customers by U.S. state. The states with the most customers are shaded in darker colors. [Screenshot of Map 1] Map 2: Sum of Order_Total Variable by U.S. State This map shows the sum of the order_total variable by U.S. state. The states that have generated the most revenue for the restaurants are shaded in darker colors. [Screenshot of Map 2] Map 3: Revenue Generated by State Compared to Median Household Income This map compares the revenue generated in each state to the state's median household income. The states that are shaded in darker colors have a higher ratio of revenue to median household income. This suggests that these states may be more lucrative for business expansion. [Screenshot of Map 3] Map 4: Revenue Generated by Zip Code This map shows the revenue generated by zip code. The zip codes with the highest revenue are shaded in darker colors. [Screenshot of Map 4] Analysis The analysis of the maps shows that the company's customer base is concentrated in the Northeast and Midwest regions of the United States. The states with the most customers and the most revenue generation are New York, California, Texas, Florida, and Illinois. The analysis also shows that there is a correlation between revenue generated and median household income. However, there are some exceptions to this rule. For example, Nevada has a relatively high median household income, but it is not one of the top states for revenue generation. This suggests that other factors, such as population density and competition from other pizza restaurants, also play a role in determining success. Recommendations Based on the analysis, the company has the following opportunities for business expansion:

• Expand into new regions, such as the Southeast and Southwest United States. These regions have a growing population and a relatively low level of competition from other pizza restaurants.
• Target high-income zip codes that are not well-represented by the company's current customer base. For example, the map of revenue generated by zip code shows that there are several high-income zip codes in California and Florida that have a relatively low level of revenue generation. This suggests that there is an opportunity to expand into these zip codes.
• Market to restaurants in states that have a high median household income and a relatively low level of competition from other pizza restaurants. For example, the map of revenue generated by state compared to median household income shows that the states of Utah, Colorado, and Washington have a relatively high ratio of revenue to median household income. This suggests that these states may be more lucrative for business expansion.

Impact of Having Data with the Names and Zip Codes of the Restaurants' Suppliers Having data with the names and zip codes of the restaurants' suppliers could provide the company with valuable insights into its supply chain and potential opportunities for business expansion. For example, the company could use this data to:

• Identify suppliers that are located in high-traffic areas or near major population centers. This could help the company to reduce its transportation costs and improve its customer service.
• Identify suppliers that are willing to offer discounts or other incentives to the company in exchange for increased business. This could help the company to reduce its costs and improve its profitability.
• Identify

 

Sample Solution

   

Pizza Ingredient Distribution Company Report

Executive Summary

This report presents recommendations for business expansion for a pizza ingredient distribution company, based on analysis of a clean customer sales data set for 2015 and 2016. The data set includes household income data for the restaurant zip codes.

The analysis shows that the company's customer base is concentrated in the Northeast and Midwest regions of the United States. The states with the most customers are New York, New Jersey, Pennsylvania, Illinois, and California. The states that have generated the most revenue for the restaurants are New York, California, Texas, Florida, and Illinois.