The color scale can then show customer density in particular areas, or even how often sales reps engage or visit these customers. Sales territory mapping: In the context of an enterprise sales team, heat maps can be a powerful tool for territory mapping, where the geographic area of the map covers your sales teams' assigned territories.Here are some of the ways sales teams apply this basic idea to their own data: Darker shades of color represent areas of higher population density, and cooler or lighter colors are used for less-populated parts. You will have seen a map like this for a particular country, region or the entire globe. More than just a colored map, a geographical heat map can cover a small, specific area, or a large area, and helps visualize data points in each included region of the map based on color.Ī commonly cited example of a heat map is a simple population data visualization. What is a geographical heat map?īefore we look at different heat map generators, it's helpful to first understand what we mean by a "geographical heat map".Ī heat map, otherwise known as a choropleth map, displays data over a geographic area using different colors and shades to represent datasets. From conditional formatting to pivot tables these features make it easy to manage, manipulate and visualize data.īut Excel falls short in one area: geographical heat maps. Even if they have an enterprise CRM platform, internal team data and data on customers and prospects is often still found in spreadsheets.Įxcel offers a number of features sales reps and their managers know and like. And even if some Office users spend all of their time in Word or PowerPoint, conservative estimates still put the number of Excel users somewhere in the neighborhood of 800 million.Ī lot of sales teams rely heavily on Excel.
#Heat map vs click map software
According to the software giant, a resounding 1.2 billion people use Microsoft Office. Prefix an alias with “hide_” to not see a column even when used in the query.Microsoft's spreadsheet tool, Excel, has been a business staple for more than three decades. Select name, object_type, stereotype where object_type = ‘’Īdditionally, you can use the following aliases in Result query:Ī.Ědd alias “classguid” to the GUID - to see details of an item on click,įor example: select name,ea_guid as classguid from t_object where object_type = ‘’ī.Ědd aliases - Base Type and Stereotype to Type and Stereotype respectivelyto see appropriate EA icons,įor example: select name, object_type as basetype, stereotype as stereotype from t_object where object_type = ‘’ and stereotype= ‘’Ĭ.
#Heat map vs click map series
Select object_type as series from t_object
To enable users to see in-depth information on click of a section of the chart, Aliases in Chart query need to be used in Result Query. You can click on List View to see the table view similar to the ones shown in above samples.Īnd to link one level to the another, you need to use the following syntax: Optionally you can group them using groupname alias.Īs this is a multi-level chart, you can have many levels of Chart query and result query. This chart will be created based on the property you define using the Series alias. When you are building advanced charts using SQL queries, Chart query is used to build the charts and Result query is used to show in-depth information on click.
0 kommentar(er)
