Using Microsoft MapPoint for Various Real Estate Activities

You can use MapPoint for various real estate activities, including:
  • Locating listings on maps.
  • Calculating and mapping routes to show properties.
  • Finding places of interest near properties.
  • Performing demographic analysis.
The exercises below provide a guided experience of some of the ways to work with the MapPoint mapping tools. The real estate agent in this scenario is located in the Seattle area. Her client is looking for a property within a specific price range that is also within a 10-minute drive of her office. The agent needs to target properties that fit these criteria and map an efficient route between them.

You may download the free 14-day trial or use the MapPoint Test Drive to see for yourself how key features of MapPoint can make light work of common real estate tasks. Every map point you display will help you become more effective. It’s easy to translate the skills acquired in this Test Drive to other industries where spatial data and mapping can help improve decision making.

To start MapPoint:
On the Start menu, click All Programs, and then click Microsoft MapPoint 2013.

Exercise 1: Import listings
You are the listing agent for several properties whose details are stored in a Microsoft Office Excel worksheet. You need to use the Excel data to plot the property locations on the map and assign different symbols and colors to represent the price ranges of the properties.
  1. On the Data menu, click Import Data Wizard.
    The Import Data Wizard starts.

  2. On the first page of the wizard, in My Documents folder, click the Real Estate Data workbook, and then click Open.

  3. On the next page of the Import Data Wizard, select Seattle Listings, click Next, and then click Finish to map the listing to the map.
    Note: When you import your own database, MapPoint might flag some records as unmatched, meaning it cannot find an exact match for an existing street address. It is possible the record has more than one match on the map. In this case, you can skip the record, or you can map it to one of the addresses suggested by MapPoint.
    The Data Mapping Wizard starts, prompting you to select the type of map you want to use.

  4. On the Map Type page, click Multiple Symbol, and then click Next.

  5. On the Data Fields page, in the data fields list, select Price, and then click Next.
    You can also specify criteria by which to sort your data, and you can apply various calculations to the data, such as totaling the values, averaging the values, and counting the number of items.

  6. On the Legend page, accept the default title for the legend. Accept the default colored circle symbols, or select another type of symbol from the Symbol lists.
    Many symbols are available, including pushpins, flags, and shapes.

  7. Click Finish to display the imported data on the map.
    You can click the Zoom In or Zoom Out button or adjust the magnifying slider on the Advanced toolbar to broaden or narrow the focus of your view. To pan the map, move the mouse pointer near any edge of the map window, and click when the large white arrow appears.

Note: For information about other ways to move around the map, see the MapPoint Help file.

Leave the map open to continue with the next exercise.