The Countries table, sage 50 also has a Countries table that contains the full country name (the Customer table just stores the Country Code to identify the country) and a flag to identify if that country is in the European Union.
It is extremely common for there to be major inconsistencies over how each of these fields are used.Improvements for latitude and longitude queries: Bing will now show the associated address location and any nearby businesses for latitude and longitude searches.Just throw a single address string at Bing.To display the full country name for an address) but also because Sage 50 uses two-character country codes (e.g GB for the United Kingdom) and Bing Maps (the mapping engine behind Power BI) needs either the full country name or an ISO 3-letter country code.This is a great option if you are dealing with too many points to display using the ap visualisation.I dont need to specify that 4 Harbourmaster Place is Address 1, Dublin 1 is Address 3 (or is it?) for example.If you have structured and populated your Sage 50 address data well and as per the address data entry screen, what I would do is to rename the address fields and add categories to them as follows: Field New name Power BI Category Address.To use the filled map option effectively, you will need good quality, consistently-structured address data (for example you always use Address 4 for County.In Sage 50 an address has six fields: Address 1, Address 2, Address 3, Address 4, Address 5, Country Code.Which addresses to use?Although in the Sage 50 screen where you define a new address, you are encouraged to follow a certain structure, from what I have seen this is often not followed.Inconsistencies like this do limit what you can do with maps, but they are no longer show-stoppers.You cant for example display Sales and Margin on the same map.Once I have created the link between Country Code in my Countries table and my Customer Addresses table I create a new calculated column Country in Customer Addresses.Think about the human interaction with Google or Bing Maps.
Poorly structured addresses, this is probably the most obvious problem that I have come across when working with Sage 50 address data.
I have no idea what regions Bing does know about, but it clearly knows about English county boundaries (though it doesnt know about postcode boundaries You now have the option of seeing a Flat Map.
Here's a look at what's new: Address queries: - Now, when you search an address on m, a map with the location will appear in the results.I can just throw what I know about the address to Bing Maps or Google Maps and the rest is done for.Heat map A Heat Map is a nice alternative to the Filled Map where you dont have very well structured address data.Perfectly-structured address data is no longer so important.You can download it here: px?Clustering map A Clustering Map produces a nice uncluttered counts of data points by geographical area.The data feed that I use for my model does provide me with all of the addresses for every sales transaction and I can use these if I want.
A quick review of my Sage 50 dataset in Power BI reveals 11 different places in the following tables: Customers, Sales Invoices, Sales Orders, Suppliers and Purchase Orders.
Registered address, delivery address, billing address) to produce a best guess default address for each customer in a new Customer Addresses table.
This might be indication of new competitive activity in the southeast that is otherwise masked simply because you are not looking at your data from a geographical perspective.