ArcGIS Maps - Weighted Heatmap by Column
It would be great if heatmaps could be weighted by a column. For example, if I have latitude longitude co-ordinates of customers, I can make a heatmap showing where the customers are located. But if I have a sales dollar amount attached to each customer, there's no way for me to make a heatmap showing where customers with the highest sales volume live.
In ArcGIS I can aggregate data by state/province, and within the USA by county, zipcode, census block or track, and so on. I can even overlay the data with a so-called fishnet (a simple grid of regularly sized rectangles. I can then color according to any value I want, such as a count of points, or a sum (a dollar amount). Most importantly, I can normalize (in the case of things like census blocks) to obtain results per household. By "normalize" I simply mean that ArcGIS will let me specify a divisor, such as total population, that I can use in a calculation, with my own data.
Suppose, for example, I have sales figures. And say I'm looking at Chicago. Chicago is big. We might to a lot of selling there. But suppose what I'm really wanting to know is how efficient my marketing is. In that case I would want to divide sales by the population of an area. That way I can tell the difference between areas where I sold a lot, simply because there were lots of people, and areas where I actually marketed really effectively, and I sold a lot per household, person, etc.
This is all pretty easy in ArcGIS, and it should be easy in Power BI. I'm not an ArcGIS expert by any means, but I know enough to be able to say that drawing circles on a map is not GIS. We need some more basic functionality in order for Power BI to be useful.