TRANSPORT + GEOLOCATION

[Anonymous]

Hi Can anyone help. I run a logistics operation and I am trying to create a view which allows me to use mapping to view transport transactions. I have an excel sheet with all my post and geolocations sorted. Likewise I have my transport data in a separate file. I want to see for example how many of the companies I look after are moving freight along similar transport corridors on similar days. Would appreciate some help with this.

Thank you

[Rfranca · Accepted solution]

hi, @Anonymous

Can you send a sample of the data?
See this example from Microsoft Partner

Pragmaticworks.com

power-bi-custom-visuals-route-map

 and 

Flow map - Weiwei Cui

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca

[Anonymous]

Hi Rfranca,

Thank you fo the links in parcticular I found pragmaticworks.com very helpful and I learned alot.

Where I am struggling is organizing my data and creating the measures or columns so that they can be used in conjunction with each other.

Due to commercially sensitive data, I can't share the files, which are themselves in excess of 70mb each.

If you have any references that can help me with data cleansing, data relationships etc, this would be another huge help

Thank you