00:01Esri Maps for Office brings mapping inside of Microsoft Excel.
00:04It makes mapping your spreadsheet data as easy as creating a chart in Excel.
00:08You can visualize your data on a map and explore clusters and density.
00:16Let’s say you work in the GIS group of an insurance company.
00:19Your sales team has customer data in Excel and needs your help in mapping it.
00:24The spreadsheet contains customers’ contact information, addresses...
00:30...and details about their insurance policy.
00:32The Sales team has added another worksheet with sales summary...
00:35...by zip code using a pivot table in Excel.
00:41Using Esri Maps for Office, you can quickly map this data inside Excel.
00:45Simply follow the Add Data wizard to use customer address information...
00:48...to add these locations to the map.
00:55Similarly, add the sales summary data by using the zip code column.
01:06Now you’ve got your spreadsheet data on the map.
01:09If you have a lot of records in a spreadsheet, you will see many points on top of each other.
01:14To get a clear view of each point, click the clustering button.
01:18You can also generate a heat map to visualize the density of customer locations.
01:24You can style your data in different ways according to your business needs.
01:30You can further group the data in classes to make sense of its distribution.
01:34For example: you can group zip codes by insurance premium...
01:37...where blue represents low values and green represents high values.
01:47These zip codes here with low premium values...
01:49...are right next to zip codes with really high premium values.
01:53You can also see that there are a lot more customers in green-colored zip codes...
01:56...than there are in blue-colored ones.
01:58This was not noticeable just by looking at the tabular data.
02:01Your sales team can now use this insight to apply sales efforts...
02:04...similar to that in green-colored zip codes to the under-performing blue-colored zip codes.
02:10Learn more about how you can use Esri Maps for Office to gain deeper insights about your data.
02:14Sign up for the free 30-day trial.
Map Your Excel Data
Learn how to map your Excel data using Esri Maps for Office. You can easily create interactive color-coded, point, clustered-point, and heat maps directly in Excel to gain visual insights about your data.
- Recorded: Apr 30th, 2013
- Runtime: 02:19
- Views: 1256
- Published: Sep 23rd, 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.