Data in GeoAnalytics

[d_ankusha]

Hi All,

Can anyone guide me how to make data consistent for GeoAnalytics? I have multiple entries for City, State and Country for pickup and delivery , but the data have lots of missing fields and null values. Also some of the fields have wrongly associated values with different types of inputs.

So what can be the best practice for getting proper data for Geo-Analytics implementation?

[Patric_Nordstrom · Accepted solution]

Hi,

Yes, the process of handling bad location input data is topic for several blog posts. However, here's some advice:

• Add country code to the locations string (or use the drop down): 'New York, US'
• Add location type to locations string (or use the drop down): 'New York,US:P*' to get hits on the city not the state
• Use codes when possible (country, region etc) names are often spelled wrong
• Remove any trash in the location string
• Use NamedPointLookup and NamedAreaLookup to flush out mismatches when the data is loaded
• Check the QGA coverage to expect per country
• Buy Qlik Geocoding to get matching to street address number level

Read more how the Location Service works:

https://bi.idevio.com/products/idevio-maps-for-qlik-sense/documentation

Try the NamedPointLookup Example at

https://bi.idevio.com/geoanalytics/geoanalytics-connector-examples

Thanks,

Patric