Transcript

00:01Esri Maps for Office enables you to understand

00:06It gives you the tools you need to analyze and

00:08...to get insights that you are missing when you

00:13Let’s say you work in the GIS group for a

00:18Your marketing group is getting ready for a new

00:21...and wants to reach early adopter customers to

00:25They have decided to put up a billboard ad to

00:29They have shared with you an Excel spreadsheet that contains a list of customers...

00:32...who bought the last generation gadget; and a

00:37You can help the marketing group find the right billboard location...

00:39...based on proximity to existing customer locations.

00:45With Esri Maps for Office, you can map customer locations and create a heat map...

00:48...that clearly shows the density of customer locations.

00:52You can add the billboard locations to the same map.

00:55Some of the billboards are not available for new ads so you can remove those locations...

00:59...from the map using Excel’s filter tool.

01:06Notice that there are a lot of customers and available billboards...

01:08...in the areas northwest and southwest of downtown Los Angeles.

01:13To take a closer look, zoom into one of the areas.

01:18Using the select tool in Esri Maps for Office, you can pick a particular billboard...

01:22...and find all the customers that are located within a 2 miles radius.

01:31You can see that there are 35 customers in this billboard’s proximity.

01:34You can also choose to find customers by drive times.

01:38Now zoom into the other area and perform the same analysis.

01:52You will find that there are 44 customers within a 2 miles range...

01:55...of the selected billboard in this area.

01:58This would be a better choice for the billboard ad...

02:00...as it can be seen by more customers as compared to the other location.

02:04Based on your analysis, you can now make an informed recommendation...

02:07...to your marketing team.

02:09Learn more about how you can use Esri Maps for Office to gain deeper insights about your data.

02:13Sign up for the free 30-day trial.

Copyright 2014 Esri
Auto Scroll (on)Enable or disable the automatic scrolling of the transcript text when the video is playing. You can save this option if you login

Analyze Your Excel Data on a Map

Explore your Excel data in a location-based context using Esri Maps for Office. Select features in one layer and find nearby features in another layer to gain insights you may not get from just columns and rows.

  • Recorded: May 30th, 2013
  • Runtime: 02:19
  • Views: 246
  • Published: Jun 20th, 2013
  • Night Mode (Off)Automatically dim the web site while the video is playing. A few seconds after you start watching the video and stop moving your mouse, your screen will dim. You can auto save this option if you login.
  • HTML5 Video (Off) Play videos using HTML5 Video instead of flash. A modern web browser is required to view videos using HTML5.
Download VideoDownload this video to your computer.
<Embed>Customize the colors and use the HTML code to include this video on your own website
480x270
720x405
960x540
Custom
Width:
Height:
Start From:
Player Color:

Right-click on these links to download and save this video.

Comments 

Be the first to post a comment
To post a comment, you'll need to login.
If you don't have an Esri Global Login ID, please register here.