Create a map

You'll create a map using an Excel spreadsheet, so that you can quickly visualize the salon data. You'll start by plotting salon locations on the map and styling these points according to revenue so you can easily see how each salon is doing. Next, you'll add a layer to the map to show the locations of potential new customers whose contact information you collected at the Women's Show. Finally, you'll configure pop-ups to display detailed information about each feature on the map.

Map business locations

To begin, you'll create a map from a spreadsheet of salon data. Then you'll modify the salon symbols to style them according to revenue.

  1. Download the Excel spreadsheet salonCustomersOttawaArea.xlsx.
  2. Open the spreadsheet in Microsoft Excel.

    The spreadsheet contains two tabs—one for each worksheet. The salons tab has information about the salons, and the new customers tab has all the contact information that you collected at the Women's Show.

  3. If necessary, click the salons tab to make it the active worksheet.

    Each salon location has its own row that contains fields for the salon name, manager's name, salon address, city, province, and phone number, as well as the salon's revenue and profits for the current year. To add data to a map, it must contain at least one location-based attribute, such as address data or longitude and latitude values. You'll use the address fields to plot the salon locations on the map.

  4. On the Excel ribbon, click the ArcGIS Maps tab to display the ArcGIS Maps tools.
    Note:

    If you don't see the ArcGIS Maps tab, download ArcGIS Maps for Office. If you've already installed ArcGIS Maps for Office, see About ArcGIS Maps for Office or Frequently asked questions for a possible solution.

    Before you can use the tools, you must first sign in to an ArcGIS organizational account (or a Portal for ArcGIS instance).

  5. Click Sign In and sign in to your ArcGIS organizational account.
    Note:

    If you don't have an organizational account, you can sign up for a free trial.

    Now that you're signed in, the Add Map tool is available.

    The other tools in the Map group are unavailable until you create at least one map. With these tools, you can find, arrange, and synchronize maps in your worksheet.

  6. In Excel, in the salons tab, select any of the cells that contain salon data.
  7. On the Excel ribbon, on the ArcGIS Maps tab, click Add Map.

    Add Map button

    The Map 1 window appears. It contains the Add data from Excel wizard, which shows the default customers dataset.

    ArcGIS Maps for Office looks for Excel tables in the workbook and suggests map contents and styling options according to the current dataset. Because the salon data isn't formatted as an Excel table, you'll have to specify the data to use to create the map layer.

  8. Click Advanced data format.

    Add data from Excel

    ArcGIS Maps for Office provides three ways of adding data from Excel: from a table, a cell range, or a named range. The salon information is provided as a range of cells in the spreadsheet. The first row in the salons spreadsheet contains headers for the columns. You want to preserve these as attribute field names, which will help you style the map later.

    Note:

    ArcGIS Maps for Office restricts the number of features you can add to a map at one time. You can add a maximum of 15,000 polygons, 15,000 lines, or 50,000 points to a layer. For more information, see Data import and format considerations in the online help.

  9. Click Cell range.

    Data format cell range

  10. Click Select range.

    The Select the range to plot on the map window appears.

    Note:

    If you don't see this window, it may have opened behind your Excel window. Click the application in the task bar to bring this window to the front.

  11. In the salons worksheet, select the range of cells from cell A1 to H6.
    Tip:

    Click the first cell in the range and press the Shift key while you click the last cell in the range.

    Selected range of cells

    The selected cells are surrounded by a dashed box and the cell range appears under Select Range.

  12. Click OK.

    Cell range specified in data format pane

    The selected cell range appears in the Data format pane.

  13. Confirm that the First row contains headers box is checked. Close the Data format pane.

    Next, you'll specify the mapping options and confirm the location information for the salons.

  14. If necessary, for Location Type, choose Address.

    This field indicates the type of location-based data that you're providing, such as street addresses or latitude/longitude coordinates. In this case, the selected cells contain address data. When you create a layer from addresses, corresponding locations are determined using the default locator set by your organization's administrator.

    Note:

    Geocoding addresses uses ArcGIS credits. To learn more, see Understand credits.

    Several of the mapping options are automatically selected depending on the default settings of your ArcGIS organization and the data in your spreadsheet. However, you must still confirm that the location information is appropriate for your map. For example, the salons are located in Canada. If the default country for your account is United States, you must choose the correct country (Canada) to ensure that your map displays the features properly.

  15. Click Match columns with location type.

    Match columns with location type

  16. For Choose a country, choose Canada.
  17. If necessary, click Several columns and verify that the location fields were mapped correctly to the corresponding columns in your spreadsheet.

    Country and Several columns options

    Note:

    The salons spreadsheet doesn't have a column with values for Postal or Country Code. The None value for these columns is okay because the software has enough location information to properly map the salons without these values.

  18. Close the Match columns with location pane.

    Next, you'll choose a style for visualizing this data in the map. ArcGIS Maps for Office provides many options for styling the data that you use to create a layer. The values in the Map style by column menu correspond to the column headers in your data. You choose a column to determine which attribute the symbols should represent. In this case, you want to visually compare the revenue of salons in Ottawa.

  19. For Map style by column, choose Revenue.

    When you choose the column, the style that is typically most suitable for the data is selected by default and indicated by a check mark. You'll apply a style that symbolizes features with graduated circles, which are useful for comparing records on the map. (For more information about the other styles, see Choose a layer theme.)

  20. In the list of suggested styles, confirm that the Counts and amounts (size) style is selected and click Add data.

    Style by Revenue column using Counts and amounts (size)

    A confirmation window appears that summarizes your options. You're creating a map layer using address values from data range $A$1:$H$6. The layer will be styled using graduated circles for which the symbol size will vary respective to values in the Revenue column. Click the Show credits button to view the estimated number of service credits you'll use to create this layer.

    Add data summary

  21. In the Add data summary window, click Add data to create the map.

    Map with styled salon locations

    The Map 1 window updates, showing a map of the Ottawa, Canada area. The map displays the salon locations styled according to revenue. The graduated circles give you a sense of how salon revenue is distributed in the region.

    The layer card appears over the left side of the map.

    The map layer that contains the salons is named according to the cell range that you chose in the worksheet. You'll provide a more meaningful layer name here.

  22. Point to the right side of the layer card to display the layer tools and click the Layer settings button.

    Layer settings pane

  23. Click the Rename button so you can modify the layer name text. Type salons and press Enter.
  24. Close the layer settings pane.
  25. If you don't see five green symbols on the map, resize the Map window and drag the map to pan across until you see all the features on the layer. (The rightmost symbol is small, so it may be difficult to see at first.)
    Tip:

    You can also zoom the map using the navigation tools in the corner.

    Map window with Orleans salon circled in black and navigation tools highlighted in green

    It's immediately apparent that the salon in Orleans (to the northeast) is generating the lowest revenue of the five locations. This is the newest salon—the one for which you want to send promotional packages to potential new customers.

    The Map window contains a ribbon of tools for working with the map and data; you'll use some of these throughout this lesson. The map also includes a set of tools that you can use to search for places of interest, select features on the map, and change the basemap.

    The salons layer displays over a basemap, which provides context for your locations. In an ArcGIS organization, the administrator chooses the default basemap, but you can change it for your map. You want to draw attention to the data that you're adding to the map, so you'll choose a simple basemap.

  26. In the map toolbar, click the Change basemap button.

    Change basemap button

    The basemap gallery opens.

  27. Click Dark Gray Canvas.
    Note:

    Your organization may use different basemaps, depending on how your administrator has configured it. If you don't see Dark Gray Canvas, choose another simple basemap that provides enough contrast with the salons layer. If your map already uses this basemap, close the Basemap pane.

    Dark Grey Canvas basemap

    The dark gray canvas basemap is used to minimize background distraction.

    Map of salons with dark gray basemap

  28. Close the basemap gallery.

    Now that you've located your salons on a map and chosen a neutral basemap, you're ready to add the potential new customers to the map.

Map customer addresses

Next, you'll add a layer to the map that shows the locations of the potential new customers who provided their contact information at the Women's Show. Eventually, you'll add demographic information from ArcGIS to enrich the customer data, so your data should be in the format of a Microsoft Excel table.

  1. Click the new customers tab to make it the active worksheet.

    The customer information is contained in an Excel table. This format simplifies data enrichment, which will add a column to the table, automatically updating the map. (You'll see this behavior in the next lesson when you enrich the data.) When you add a layer to the map from a table, new rows or columns that get added later are automatically included in the map. When you add a layer to the map from a range of cells, as you did in the previous section, adding rows or columns will not update the map.

  2. In the Map window, on the ribbon, click Excel data.

    Excel data

    Note:

    If you minimized the Map window earlier, click the ArcGIS Maps tab, click Go to Map, and choose the map to open it.

  3. In the Add data from Excel window, for Location Type, verify that Address is selected.

    As before, you'll confirm that the location information is appropriate for your map.

  4. Click Match columns with location type.

    Confirm location columns

  5. For Choose a country, choose Canada.
  6. If necessary, click Several columns and verify that the location fields were mapped correctly to the corresponding columns in your spreadsheet.
  7. Close the Match columns with location pane.

    You only want to show the customer's proximity to a salon, so you'll style the layer by location only.

  8. If necessary, for Map style by column, choose <None>. In the list of suggested styles, verify that Location (single symbol) is selected.

    Style using Location (single symbol)

    In this style, all features in the layer are drawn with the same symbol.

  9. Click Add data. Confirm the map options and that you have enough credits for the operation. (Adding this data requires approximately 15 service credits.) Click Add data to add the layer to the map.

    The map updates, showing all the locations of the new customers from your spreadsheet.

    Now you'll change the default symbol style, as it is similar to the style used for salons.

  10. On the customers layer card, point to the right side of the card to display the layer tools. Click Layer settings and choose Layer style.

    Layer settings pane with Layer style selected

  11. If necessary, in the Layer style pane, expand the Symbol style section.

    The pane shows basic options to change the shape, color, and size of the symbol.

  12. Click Advanced.

    Basic symbol styles

    The pane shows options to change the shape and size of the symbol, as well as its fill and outline colors.

  13. Confirm that the symbol category is set to Shapes and choose the blue circle. Set the symbol size to 15 pixels (px).

    Shape symbol settings

    The symbol on the map changes automatically. To go back to the original symbol style, click the Revert button.

  14. Click Close to close the layer settings pane.

    You can also click Back to layer options to close the layer style pane and continue working with the other layer options. In this case, you don't need to keep the layer settings pane open.

    Layers are drawn on the map in the order in which they were generated. The symbols for the customers layer obscure the symbols for the salons layer, so you'll move the salons layer above the customers layer.

  15. On the salons layer card, point to the right side of the card to display the layer tools and click the Move layer up button.

    Move layer up button on the layer card

    The salons layer moves above the customers layer. On the map, the green salon symbols appear on top of the blue customer symbols.

  16. Point to the customers layer card and click the Zoom to layer button.

    The map zooms to the full extent of the selected layer, so you can see all its features.

  17. On the map toolbar, click the Show layers button to hide the layer cards.

    Map of potential customers and salon locations

    Now you can see the distribution of potential customers that surround each salon location. For now, your analysis will focus on identifying customers closest to the Orleans salon—the smallest green circle on the map.

Configure pop-ups

Next, you'll configure pop-ups for the customers layer. Pop-ups appear when you click a feature on the map; they contain descriptive information about the features in each layer on the map. The attribute information that displays in a pop-up comes from the columns and rows in your data.

  1. Click a customer location on the map to open its pop-up.

    Pop-up for customer location

    The basic configuration of a pop-up is just what you see: a list of fields and values associated with a layer. The information should be familiar to you because it comes from the table.

    Tip:

    In this example, the pop-up title bar shows "1 of 2." When you open a pop-up, you also access pop-ups for other features at or near the same location. (These may be in the same layer or different layers.) Click the white arrow in the title bar to see the other pop-ups.

    You can change the way this information is presented in pop-ups on this layer. You'll add a header and specify which attributes to display.

  2. On the pop-up window, click the Pop-up settings button to display the pop-up configuration options for this layer.

    Pop-up settings button

    Tip:

    You can also access the pop-up settings from the layer options pane.

  3. In the Pop-up settings pane, ensure that pop-ups are enabled. Move the toggle button to the right if pop-ups are not already enabled.
  4. For Header, choose Name.

    Now you'll specify which attributes to include in the pop-up. Because you're using the Name field as the header, you don't need this information to be repeated in the pop-up. Also, it's unnecessary to show the city and province names, which are the same for each location. The basemap labels tell anyone using the map that this is Ottawa, Ontario.

  5. Uncheck the boxes next to Name, City, and Province.

    A field has both a name and an alias. An alias is a display name that replaces the field name in the pop-up. By default, the alias and field names match, but you can change the alias to something more informative or familiar.

  6. Point to the Address row and click the Edit button. Type Home Address and press Enter.

    Pop-up settings pane

  7. Click OK.
  8. On the map, click a customer feature near the Orleans salon to view the updated pop-up.

    The pop-up also contains several tools that allow you to work with the selected feature.

  9. In the pop-up, click the Zoom to button.

    Updated pop-up with Zoom to highlighted in green

    The map zooms to the selected feature.

  10. Drag the pop-up window to a different location so that you can see the map behind it.

    To learn more about the other tools, see Display pop-ups.

  11. Close the pop-up.
  12. On the map toolbar, click the Hide layers button to display the layer cards.
  13. On the salons layer card, point to the right side of the card to display the layer tools and click the Zoom to layer button.

    The map zooms to the full extent of the selected layer so all its features display in the map window.

  14. In Excel, click Save.

You've created a map that compares salon revenue and shows potential new customers and their proximity to the various salon locations. You also configured pop-ups so you can view detailed information about each customer. Next, you'll analyze the data to identify potential customers for the new salon.


Enrich and analyze the data

Previously, you created a map of salons and potential new customers.

Next, you'll enrich the customer data by adding household income data to help determine who can afford the salon's services. You'll also analyze the map to identify which of these potential customers are within a reasonable distance from the new salon—say, a 15-minute driving distance. Finally, you'll use your analysis results to select customers who meet these requirements, so you can create a customized mailing list for your promotional package.

Enrich customer data

You can enhance your data by adding demographic data from ArcGIS as new columns to the spreadsheet. Then you can use standard Excel features to further refine your data and your map. Because your high-end salons are aimed at more affluent customers, you'll add income data and filter the table to find customers whose annual income exceeds $90,000.

Note:

Because data enrichment adds new columns to your spreadsheet, the data that you used to create the map layer must be in an Excel table. Otherwise, to enrich a layer that was added from a cell range, you'd need to overwrite an existing column. To learn more, see Enrich your data.

  1. If necessary, open the lesson spreadsheet (salonCustomersOttawaArea.xlsx) in Excel and sign in to ArcGIS.
  2. On the customers layer card, point the right side of the card to display the layer tools and click the Layer settings button.
  3. On the layer settings pane, in the Data group, click Enrich data.

    Enrich data

    This tool enriches your data by getting facts about the people, places, and businesses that surround your data locations. You can choose from a list of countries to access the available demographic categories. You can also search for specific variables.

  4. In the Enrich layer window, make sure Canada is listed.
  5. Click Income.

    Enrich layer window

    There are several available income variables for Canada; the window displays the most popular variables.

  6. Check the box next to the 2014 Median Household Income (Constant Year 2005$) variable.
    Note:

    Demographic data is updated periodically, so the available variables and values may differ from those specified in the lesson. If necessary, use the most recent data.

    2014 median household income variable

  7. Click Next.
  8. In the Sample distance for features field, type 1. Ensure that the Sample area for features value is Radius and the distance is in miles.

    Sample distance set to a 1-mile ring around features

  9. Confirm that <Create new column> is chosen and click Add data to worksheet.

    The demographic data will be added to a new column in the sheet. This may take a few minutes. A message will indicate that the data has been added successfully.

  10. Click OK. Move the Map window so you can see the new column in Excel.

    ArcGIS Maps for Office created a new column in the table and populated it with the income variable that you chose. Your customer data now includes median household income within a 1-mile radius of each customer location.

Filter the spreadsheet

Next, you'll use standard Excel features to filter only those records that fit within your target income range. To identify customers with a household income above $90,000, you'll filter the new column to display only rows with a value greater than 89999.

  1. In the Excel table, click the arrow in the 2014 Med Hh Inc column to display the context menu. Point to Number Filters and click Greater Than.

    Filter column by numbers greater than a value

  2. In the Custom AutoFilter window, next to the is greater than value field, type 89999.

    Custom AutoFilter window

  3. Click OK.

    The map automatically updates to show only the customers in areas where the household income is $90,000 or higher.

    Note:

    If you minimized the Map window, to open it, click the ArcGIS Maps tab, click Go To Map, and choose your map.

    Map showing filtered customers layer

  4. Click one of the features on the map to view its pop-up.

    The pop-up now includes the 2014 median household income for the area surrounding that feature.

  5. Close the pop-up.

Find nearby customers

You want to specifically promote the new salon in the East end of the city. To identify potential customers within a 15-minute drive time of this location, you'll perform analysis using the Find Nearby tool.

  1. On the salons layer, display the layer tools and click the Layer settings button.
  2. On the layer tools pane, in the Analyze group, click Find nearby.

    The Find nearby pane opens. You can use this analysis tool to find locations in a layer that are within a specified distance or drive time of the features that you select on the map.

  3. Click the rectangle selection tool on the right side of the map and click the smallest salon symbol on the map.
    Tip:

    If you click the wrong feature on the map, click anywhere on the map to deselect it. Zoom in the map (if necessary), and click the correct salon.

    Smallest salon symbol selected on the map

    The symbol is highlighted on the map.

  4. Click Next.
  5. For Choose a search area and distance, choose Drive Time. For Distance, type 15 and confirm that Minutes is chosen..

    Specify a 15-minute drive time

  6. Click Next.
  7. For Choose target layer, make sure customers is selected.
  8. Click Next.

    The summary page describes the parameters you set the Find Nearby operation. This will find features in the customer layer that are located within a 15-minute drive of the selected salon feature.

  9. Click Run analysis.

    Map with results of Find Nearby selected

    The map updates, highlighting all the potential customers who could drive to the new salon in 15 minutes or less. A message also appears in the Find nearby pane indicating that 43 potential customers were found within the 15-minute drive time area.

    Next, you'll create a new table for these selected customer records so you can add them to the map as a new layer.

Export selected features

Because you enriched the data and filtered it to show only customers in high-income areas, you know that the selected customers fit within the target demographic for your promotion. Now that you've identified potential customers near the new salon, you can export the selected features to a new worksheet to isolate only the customers that you want to contact directly.

  1. In the Find nearby pane, click Export selected rows.

    Export selected rows

    A window opens that prompts you to choose whether to save the selection to a separate file or to a new worksheet in the current workbook. For this lesson, you'll create a new worksheet in the current workbook. You can also specify a spatial reference for the coordinates that define the location of the features on the map. You'll just accept the current spatial reference (4326 World Geodetic Survey (WGS) 1984), which is the spatial reference for the current basemap, Dark Grey Canvas.

  2. In Export selection to, choose Worksheet and click OK.

    A new worksheet is created; this new worksheet contains an Excel table that lists the 43 potential customers within a 15-minute drive to the new salon. The default table name is Sheet1 8_customers. Because the customer locations were already geocoded, the new table also includes longitude and latitude coordinates.

    Now you'll rename the Excel table.

  3. On the Formulas tab, in the Defined Names group, click Name Manager.

    Name Manager button

  4. Click the customers_Sheet1_8_customers entry and click Edit.
    Note:

    The default name for your new table may have a different number in it.

  5. In the Edit Name window, change the name to salonPromo and click OK.

    Table names in Excel cannot contain spaces, and the first character of the name must be a letter.

    Name Manager window

  6. In the Name Manager window, click Close. (You may need to click the Excel application in the task bar to bring this window to the front.)
  7. In the Map window, close the Find nearby pane.

    You now have a list of all the potential customers within a 15-minute driving distance of the new salon. You can use this list to send those customers a personalized promotional kit to entice them to try the salon.

View analysis results on the map

Now you'll use your new Excel table to add a layer to the map that shows only the customers that you identified for the promotion. Because the new table includes longitude and latitude coordinates, you can use these columns to define the location type to avoid using ArcGIS service credits for geocoding.

  1. On the Map ribbon, click Excel data.
  2. In the Add data from Excel window, for Dataset, choose salonPromo.
  3. Specify the location information for the salonPromo customers:
    • For Location Type, choose Coordinates. The Match columns with location types pane opens.
    • From the Longitude (X) and Latitude (Y) drop-down menus, choose corresponding columns in your data.
    • Accept the default World Geodetic Survey (WGS) 1984 spatial reference.
    • You only want to show the customers' proximity to a salon, so you'll style the layer by location only. For Map style by column, choose <None>. Accept the default theme, Location (single symbol).

    Location type set to Coordinates

  4. Click Add data. Confirm the map options and click Add data to add the layer to the map.

    A new layer appears on the map, showing the locations of the filtered customer list from your spreadsheet. The name of the layer is based on the Excel table name, salonPromo.

    Next, you'll change the symbol to differentiate it from the other customer features.

  5. On the salonPromo layer card, display the layer tools and click Layer settings, then click Layer style.
    Note:

    If you receive a message that states that continuing will cause you to lose the current selection on the map, click OK.

  6. In the Symbol style section, click Advanced to display the advanced symbol settings.
  7. In the advanced symbol pane, confirm that the category is set to Shapes and choose the yellow circle. Set the symbol size to 15 pixels (px).

    Advanced symbol styles

    The map updates to show the new symbols.

  8. Close the Layer style pane.
  9. On your own, configure pop-ups for the new salonPromo layer (click a feature on the layer to display a pop-up and click the pop-up settings button, or configure pop-ups from the Layer settings):
    • Set the Name column as the Header.
    • Exclude the Name, City, Province, Longitude (X), and Latitude (Y) columns.
    • Change the Alias for Address to Home Address.
    • Change the Alias for 2014 Median Household Income (constant $) to Median household income.
  10. In Excel, click Save.

You've identified potential customers for the new salon, and you're confident that household incomes for these customers are well within the acceptable range. Now you're ready to show these findings to your boss and get final approval for your promotion. Next, you'll add a dynamic map slide to PowerPoint to present your results.


Share the results

Previously, you enriched customer data in your map to include household income information for the areas that surround the new customers. Then you filtered the data to create a map layer that shows only those customers who you want to contact for your promotion. Next, you'll share your map on ArcGIS and add a dynamic map-enabled slide to a PowerPoint presentation to present your analysis results.

Share a map on ArcGIS

Before you create your marketing presentation, you’ll share your map as a web map on ArcGIS. Sharing a map on ArcGIS is a quick way to share information with others in or outside of your organization. When you share a map, a web map is created in ArcGIS. Once you publish the map, you can add a dynamic map to a PowerPoint slide. (If you don't need to interact with the map in a presentation, you can add a static image of the map to a slide without sharing the map as a web map.)

  1. If necessary, open the lesson spreadsheet (salonCustomersOttawaArea.xlsx) in Excel and sign in to ArcGIS.
  2. On the Map ribbon, click Share map.
    Note:

    If you don't see all the buttons in the Share group, click Share to show all the options.

    Share map button

  3. In the Share Map pane, specify a title, tags, and summary for the map using the following information:
    • Title: Orleans Salon Promo
    • Tags: salon, Orleans, promotion
    • Summary: Promo for potential customers for Orleans salon

    These fields are used to display information about the map on ArcGIS and are also used for searching.

  4. Choose whether to share it with everyone (publicly), your organization, or any groups to which you belong.

    Share map pane

  5. Click Share.

    Once the map has successfully published, a message indicates that the map has been shared.

  6. Click OK.
  7. In Excel, click Save. Close Excel.

Add a dynamic map to a PowerPoint slide

With ArcGIS Maps for Office, you can add dynamic maps to PowerPoint slides to create interactive presentations of geographic information.

  1. Open a blank PowerPoint presentation.
  2. On the PowerPoint ribbon, click the ArcGIS Maps tab to display the tools.
  3. If necessary, click Sign In and sign in to the same ArcGIS account that you used to create the map in Excel.
  4. On the ArcGIS Maps tab, click Add Map.

    Add Map button

    The Insert Map wizard opens, displaying the first tab of the workflow: Browse maps.

  5. In the Search field, type the name of the web map that you shared from Excel: Orleans Salon Promo. Press Enter or click the magnifying glass icon.

    Search results in PowerPoint

    The list pane on the left shows the results of your search.

  6. Click the Add button on the Orleans Salon Promo entry with your username and click Next.
    Note:

    If there are several maps in the results, you can refine the search by adding owner:username to the search phrase (replace username with your actual username).

    The Choose layers and legend keys tab lists all the layers that are available in the web map.

  7. Click the eye icon to hide the customers layer. If necessary, pan and zoom the map so you can see the salonPromo points.

    Choose layers tab

    You only want to include the salons and salonPromo layers in the initial display of your map slide. The customers layer will be available in the map but will be hidden.

    You can optionally configure a legend for your map. In this case, you don't need a legend.

  8. At the bottom of the map, click Next.
  9. On the Choose layout tab, click Fill slide.

    Fill slide layout

  10. Click Next.

    A preview of the slide opens with options to zoom and pan the map.

  11. Review the size, extent, and zoom level of the map and make any necessary changes. Click Insert map to add the map to your slide.
  12. Save your presentation.

Present your findings

Next, you'll show your boss the salon locations styled by revenue and where new potential customers live. You'll also show the results of your analysis: the locations of potential customers to whom you'll send the special promotion package for the new salon. Because the map is interactive, you'll also demonstrate how to view pop-ups with the corresponding contact information that you collected at the trade show.

  1. If necessary, open your PowerPoint and sign in to your ArcGIS account (on the ArcGIS Maps tab, click Sign in).
  2. View your presentation in Slide Show mode, and navigate to the map-enabled slide.

    Before you can interact with the map in your presentation, you need to unlock the map.

  3. At the top of the map, click the Unlock button.

    Unlock button

    The map becomes fully dynamic—you can zoom in and out, pan across the map, and click features to display pop-ups with detailed information about locations.

  4. On the layer cards, hide all the layers except salons; zoom and pan to show all the salon locations on the map.
  5. Show the customers layer to display the locations of all the new contacts you gathered at the Women's Show.
  6. Hide the customers layer and show the salonPromo layer. Click several of the features to show the customer information in pop-ups.
  7. Click Exit live mode to exit the interactive map and return to slide show mode. Press Esc to return to your presentation slides.

In just a short amount of time, you created a map that shows the location of hundreds of potential customers and their proximity to your salons. You analyzed the data that you collected at the Women's Show to illustrate the customers who are closest to the newest salon. You also enriched that data with information about household incomes. Finally, you created a visually compelling, dynamic map to present your analysis, all using ArcGIS Maps for Office and your ArcGIS organization.

You can find more lessons in the Learn ArcGIS Lesson Gallery.