You are the marketing manager for a chain of high-end beauty salons in the Ottawa, Canada area. The owners recently opened a new location and revenue isn't yet matching expectations—you need to create a new, loyal customer base! At a recent Women's Show convention, you held a drawing at your booth and collected a large amount of new contact information. You want to streamline this list to identify people who might realistically become new clients at the new salon, and send them a special promotional package to entice them to book an appointment.
To do this, you'll use ArcGIS Maps for Office to visualize salon locations on a map in Microsoft Excel. You'll also add the locations of the new, potential customers and enrich the customer data with demographic information to ensure that you're pursuing more affluent customers. You'll analyze the data to determine which potential customers are within a reasonable driving distance from the new salon. Then, you'll filter the analysis results to select only those particular customers, so you can create a customized mailing list for your promotional package. Finally, you'll add a dynamic map slide to a PowerPoint presentation to show your findings to your boss.
|Create a map||Create a map and configure pop-ups to visualize data.||20 minutes|
|Enrich and analyze the data||Add demographic data for areas that surround locations on the map, and find customers who meet specific criteria.||20 minutes|
|Share the results||Share your map on ArcGIS and create a dynamic PowerPoint presentation to show your analysis results.||20 minutes|