Choose test markets for a start-up

Create a project

First, you'll create a project in ArcGIS Business Analyst Web App. Projects contain layers, reports, and other map items and help you manage and organize your data more efficiently. Projects also allow you to share your work.

Your project will map neighborhoods in Berlin, Germany. However, you can perform this workflow for any area in Germany or other countries.

  1. Go to Business Analyst Web App.
  2. If you are not already signed in, click Sign In. Sign in with your ArcGIS organizational account.

    If you don't have an organizational account, see options for software access.

    Your account must be licensed to use Business Analyst. If you are the administrator of your organization, you can assign yourself a license. Otherwise, you must contact your administrator for permission.

    If this is your first time using Business Analyst, a Welcome window appears. If you've created a project in Business Analyst previously, you will not see the Welcome window, although you might see a What's new window.

  3. If necessary, close the Welcome or What's new window.
  4. If this is your first time using Business Analyst, click Create project. If you've used Business Analyst before, click New project.

    The Create project window appears.

  5. For Project name, type Berlin Bike-Friendly Neighborhoods and add your name or initials. Click Create.

    A message explains that a project is being created. The process may take a few moments. When it finishes, a message confirms that the project has been created.

  6. Click OK.
  7. If necessary, in the list of the projects, point to your Berlin Bike-Friendly Neighborhoods project and click Open project.

    The project appears.

    Default project


    Depending on your organization's settings, the default extent and appearance of your project may differ from the example image.

    You'll ensure the data you're using is for Germany.

  8. On the ribbon, click the menu showing your country or region.

    Menu showing country or region

  9. In the list of countries and regions, find Germany and click the Click for data source selections button.

    Click for data source selections button

    The two data sources available for Germany appear.

  10. Next to the Standard data source, click Apply.

    Standard data source for Germany

    The map navigates to Germany and the demographic data source is set to Germany (Standard).

Add demographic variables

Now that you've set your data source to Germany, you're ready to help Max and Renate find neighborhoods that meet the criteria for their bike kiosk start-up. Their target market has the following characteristics: a high percentage of households with children, low-middle income, and above-average levels of spending on recreational activities. You'll create a list of demographic data variables that represent these characteristics. Then, you'll narrow the analysis area to Berlin neighborhoods.

  1. On the ribbon, click Create maps and choose Smart map search.

    Smart map search option

    The Smart map search pane appears. It displays featured lists of preassembled variable sets that are popular with Business Analyst users. You'll create your own list of variables of particular interest to you.

  2. At the bottom of the workflow pane, click Browse all variables.

    Browse all variables button

    You'll use the Data browser window to select variables matching Max and Renate's criteria.

  3. Under Browse by category, click Households.

    Households category

    In the Households category, you'll find variables describing types of households in Germany, including the variable you're interested in: households with children.

  4. At the bottom of the screen, click Show all 'Households' variables.

    Show all 'Households' variables option

  5. Expand 2023 Households by Type (MBR) and check the box for 2023 Households by Type: Multi-Person Households with Children.

    2023 Households by Type: Multi-Person Households with Children variable

    The variable is added to your Selected variables list at the top of the Data browser window. Next, you'll add variables that reflect low- and middle-income households.

  6. Click the Categories button to return to the main data browser screen.

    Categories button

  7. Under Browse by category, click Income. Click Show all 'Income' variables.
  8. Expand 2023 Households by Income (MBR) and check the boxes for 2023 Total Households in 2nd Income Quintile (€20,999 to €31,828) and 2023 Total Households in 3rd Income Quintile (€31,829 to €47,354).

    2nd and 3rd Income Quintile variables

    Next, you'll add a variable that reflects households with above-average levels of spending on recreational activities.

  9. Click the Categories button.
  10. Under Browse by category, click Spending. Click Show all 'Spending' variables.
  11. Expand 2023 Recreational & Cultural Service Expenditures (MBR) and check the box for 2023 Recreational & Cultural Service Expenditures: Index.

    2023 Recreational & Cultural Service Expenditures: Index variable

    An index compares the value in the areas on the map to another value, such as the nationwide average. This index will indicate which areas have above-average spending on recreation compared to the German national average.

    You've selected four variables in total. You'll save this list of variables and apply them to the map.

  12. At the bottom of the Data browser window, click Save list.

    Save list button

  13. For List name, type Bike-Friendly Indicators.
  14. For List icon, choose Shapes and icons. Under Transportation, click a bicycle icon.

    Bicycle icon


    You can use the search bar to find a bicycle icon more quickly.

  15. In the Save variable list window, click Save.

    Save button in the Save variable list window

  16. At the bottom of the Data browser window, click Apply.

    The smart map search workflow runs, applying the variables you selected to the entire map of Germany. Next, you'll refine your analysis extent to examine Berlin in particular.

  17. In the Smart map search pane, scroll down to the Geography section. Click the Analysis extent menu, search for Berlin, and choose the Municipality of Berlin.

    Municipality of Berlin in the list of search results

    The map navigates to Berlin and limits the analysis extent. Next, you'll adjust the level of detail of the map so you can see individual neighborhoods.

  18. In the Geography section, for Level of detail, choose Postcodes5.

    Postcodes5 level of detail

    The map now shows the individual postcode boundaries within Berlin. These boundaries will enable you to examine your criteria at the neighborhood level.

    Map showing Berlin with postcodes

    You've created a list of relevant demographic variables and narrowed the analysis area to Berlin neighborhoods. Next, you'll analyze and compare the neighborhoods based on the variables you chose.

Find bike-friendly neighborhoods

To help Max and Renate secure funding for their start-up, you need to identify at least 10 areas in Berlin that are highly likely to make use of bike kiosks. You've selected indicators that measure bike-friendly attitudes (children, income, and spending on recreation). Next, you'll set ranges for these variables to determine which neighborhoods are the most bike-friendly areas.

First, you'll change the Multi-Person with Children variable to use a percentage, instead of a raw count. Using a percentage allows you to compare the variable more easily across neighborhoods. The count of households does not consider how many people live in the neighborhood.

  1. In the Smart map search pane, scroll up to the Variable list section. For 2023 HHs: Multi-Person with Children, click Calculation: Count and choose Percentage.

    Percentage option

    Next, you'll set a range threshold to the variable so only neighborhoods with a certain minimum value will appear on the map. This way, your map will only show neighborhoods with a suitable percentage of households with children.

  2. Adjust the range for the 2023 HHs: Multi-Person with Children variable so that the lower threshold is 20 percent.

    Lower threshold set to 20 percent

    The map automatically filters out neighborhoods where fewer than 20 percent of households have children. You'll adjust the lower thresholds of the other variables to filter out neighborhoods that aren't demographically suitable for bike kiosks.

  3. Adjust the following variables:
    • For 2023 HHs: 2nd Quintile (€20,999 to €31,828, change the lower threshold to 2,000 households.
    • For 2023 HHs: 3rd Quintile (€31,829 to €47,354), change the lower threshold to 2,000 households.
    • For 2023 Recreational Services: Index, change the lower threshold to 100.

    The map updates to show all the areas that match your modified criteria.

    Map showing neighborhoods that meet all four variable thresholds

    The Results pane shows that 21 postcodes match the criteria you entered.

    Results pane

    Now that you've set your basic criteria, you'll explore the data, refine the criteria, and narrow the results to the 10 most suitable neighborhoods.

  4. In the Results pane, click the Histogram button.

    Histogram button

    The histogram shows the distribution of data in a format similar to a bar chart.

  5. Under Chart settings, for Variable, choose 2023 Recreational Services: Index.

    Chart settings section

    The histogram now shows the distribution of all the locations where spending on recreation is above the national index value (100).

    Histogram for the 2023 Recreational Services: Index variable

  6. Point to the bars to view the index value and how many areas have that value.

    There are 10 sites with spending on recreation that have an index value higher than 104. You'll adjust the recreational spending variable so that the lower threshold is 104.1.

  7. In the Smart map search pane, for 2023 Recreational Services: Index, change the lower threshold to 104.1.

    The map now shows 10 postcodes meeting the bike-friendly criteria, with a particular focus on high spending on recreation.

    Map with the 10 most suitable neighborhoods

    Next, you'll save your work.

  8. In the Smart map search pane, click Save layer.
  9. In the Save layer window, for Layer name, type Top 10 Bike-Friendly Berlin Neighborhoods and add your name or initials. Click OK.

    After a few moments, your layer is saved.

  10. On the ribbon, click Berlin Bike-Friendly Neighborhoods.

    Project tab

    The layer is listed under Smart map search layers.

    Location of the saved layer

In this tutorial, you identified neighborhoods in Berlin suitable for Max and Renate's proposed bike kiosk start-up. You created a project in Business Analyst Web App, compiled a list of relevant demographic variables, and set thresholds to map neighborhoods meeting the desired criteria. Your result indicates the 10 neighborhoods most suitable for bike kiosks based on your criteria.

Though this workflow was focused on bike kiosks in Berlin, using the demographic data available in Business Analyst, you can replicate the workflow for almost any type of business throughout the world. All you need is to think of the demographic variables appropriate for your business and map them in your area of interest.

You can find more tutorials in the tutorial gallery.