{"id":17844,"date":"2021-02-06T12:51:57","date_gmt":"2021-02-06T12:51:57","guid":{"rendered":"https:\/\/maplytics.com\/blog\/?p=17844"},"modified":"2021-02-06T13:01:02","modified_gmt":"2021-02-06T13:01:02","slug":"use-data-from-excel-to-visualize-geographical-areas-and-related-information-directly-on-the-map-using-maps-integration","status":"publish","type":"post","link":"https:\/\/www.maplytics.com\/blog\/use-data-from-excel-to-visualize-geographical-areas-and-related-information-directly-on-the-map-using-maps-integration\/","title":{"rendered":"Use Data from Excel to Visualize Geographical Areas and Related Information Directly on the Map Using Maps Integration within Dynamics 365 CRM \/ Power Apps"},"content":{"rendered":"
[vc_row][vc_column][vc_column_text]\n

To grow and expand any business there is a need to deeply understand its market and target audience. Once identified, the smart move is to streamline the necessary resources and efforts towards them. This process gives rise to a need for deep and meaningful analysis of your customer data.<\/p>\n

Dynamics 365 CRM does a fantastic job at consolidating and managing your information in this respect and gets you closer to having more control. However, there are still many companies that still miss out on a very important piece of geographic information and analysis. This is where Maplytics steps in and offers exclusive locational intelligence.<\/p>\n

Let us walk through a scenario to understand this better. Consider if you had a company called EduNow that sells a product used by school students in the USA. You need to maximize returns from your marketing efforts, so you need to target the right geographic location to run your lead generation campaigns.<\/p>\n

EduNow targets the city of New York. Within the city, there are multiple postal code areas. EduNow needs to focus on the areas where below 15-year population is higher. This single targeting, if executed right, will increase the quality of your prospects and your leads will be almost sure to convert!<\/p>\n

Let’s see how Maplytics would help you do this.<\/p>\n

First, you need to get the excel data with all appropriate information. Once you have an excel file, follow the below steps to upload and configure the excel file:<\/p>\n

Go to Settings -> Territory -> click on New -> give name and click on Save -> select Maplytics Territory Preview -> select Excel File option.<\/p>\n

\"Use<\/p>\n

Note: The region column should be in Excel.<\/p>\n

Once you browse the file, select the region column and color for the geography and click on the Plot Region. Once all-regions are plotted, click on Save.<\/p>\n

\"Use<\/a><\/p>\n

Once the required geographical area is created and plotted on the map then you can configure other attributes that you need to show. For example, you can set hover attributes, summary attributes, data grid information, etc. As you can see here, I have set some Excel columns which need to be shown on the map when a sales rep is on the field.<\/p>\n

\"Use<\/a><\/p>\n

Now let’s see how it will show on the map. First, go to the Detail map\u2019s \u2018Select Overlay\u2019 section and select the record which we have created. Once you select the overlay record, the column which we selected in the configuration tab will automatically get selected. Now click on search.<\/p>\n

\"Use<\/a><\/p>\n

After plotting the overlay on the map, you can hover on the geographical areas to see more information or you can click on any shape, it will give you further summary attribute information in the Tooltip card. Also, you can see all the required data in the View Data grid as shown.<\/p>\n

\"Use<\/a><\/p>\n

This was a simple glimpse into how your sales rep will get abundant information about their region boundaries like total population or density of the geographical area. Maplytics ensures that your sales reps can analyze, drill down, and gain insights for which area they should focus on to get more sales.<\/p>\n

Got a couple of minutes? You can get a crash course into the power-packed features of Maplytics through this video:<\/p>\n