Hello everyone,I require help in visualizing the content attached in the excel file and get meaningful insights.I am working on a problem to recommend nearest Service Center based on distance from customer pincode to service center pincode.In the attached file, I have Customer Pincode, Customer Latitude, Customer Longitude, ServiceCenter Pincode, ServiceCenter Latitude, ServiceCenter Longitude. Based on these details I have calculated Distance_Travelled_By_Customer. Typically most of the customers visit the nearest ServiceCenter that is available. However, I have noticed that they travel far to another ServiceCenter to get the service completed.Premium / Non-premiumStation TypeCustomer_RegionCustomer_StateCustomer_CityCustomer_Post_CodeCust_LatCust_LongServiceCenter_RegionServiceCenter_StateServiceCenter_CityServiceCenter_Post_CodeServiceCenter_LatServiceCenter_LongDistance_Travelled_By_CustomerDistance_CategoryRecommended_ServiceCenter_Post_CodeRecommended_ServiceCenter_LatRecommended_ServiceCenter_LongDistance_to_Recommended_ServiceCenterCustomer VisitsNon-PremiumCarry-in CenterNorthDelhiParliament House11000128.6377.22NorthNew DelhiDelhi11009228.6477.297.100-15 KM11002428.5777.240.072Non-PremiumCarry-in CenterNorthDelhiDarya Ganj11000228.6477.25NorthNew DelhiDelhi11002428.5777.247.450-15 KM11009228.6477.290.051Non-PremiumCarry-in CenterNorthDelhiC G O Complex11000328.5977.23NorthNew DelhiDelhi11002428.5777.242.760-15 KM11002428.5777.240.032Non-PremiumCarry-in CenterNorthDelhiNew Delhi11000528.6677.19NorthNew DelhiDelhi11008528.7277.1110.140-15 KM11008528.7277.110.104Non-PremiumCarry-in CenterNorthDelhiNew Delhi11000528.6677.19NorthNew DelhiDelhi11009228.6477.2910.450-15 KM11008528.7277.110.101Non-PremiumCarry-in CenterNorthDelhiNew Delhi11000628.6677.23NorthNew DelhiDelhi11009228.6477.296.270-15 KM11009228.6477.290.063Non-PremiumCarry-in CenterNorthDelhiNew Delhi11000728.6877.19NorthNew DelhiDelhi11002428.5777.2413.190-15 KM11008528.7277.110.092Non-PremiumCarry-in CenterNorthDelhiNew Delhi11000728.6877.19NorthNew DelhiDelhi11008528.7277.119.050-15 KM11008528.7277.110.091Non-PremiumCarry-in CenterNorthDelhiNew Delhi11000728.6877.19NorthNew DelhiDelhi11009228.6477.2910.890-15 KM11008528.7277.110.092

I would do something like this: A user selects its location which is point A and the distance is calculated from point A to several Point B's. The user selects the maximum radius. The shortest is what you'll likelly recommend to the user but you can show other locations as an option. https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Philippine-Barangays-on-the-Map/m-p/3384116 Here's the tutorial https://www.youtube.com/watch?v=5nkPRsD-olM

prasadhebbar315

Advocate I

1 year ago

Solved

PBI Maps based on Geo Coordinates

Hello everyone,

I require help in visualizing the content attached in the excel file and get meaningful insights.

I am working on a problem to recommend nearest Service Center based on distance from customer pincode to service center pincode.

In the attached file, I have Customer Pincode, Customer Latitude, Customer Longitude, ServiceCenter Pincode, ServiceCenter Latitude, ServiceCenter Longitude. Based on these details I have calculated Distance_Travelled_By_Customer. Typically most of the customers visit the nearest ServiceCenter that is available. However, I have noticed that they travel far to another ServiceCenter to get the service completed.

Premium / Non-premium	Station Type	Customer_Region	Customer_State	Customer_City	Customer_Post_Code	Cust_Lat	Cust_Long	ServiceCenter_Region	ServiceCenter_State	ServiceCenter_City	ServiceCenter_Post_Code	ServiceCenter_Lat	ServiceCenter_Long	Distance_Travelled_By_Customer	Distance_Category	Recommended_ServiceCenter_Post_Code	Recommended_ServiceCenter_Lat	Recommended_ServiceCenter_Long	Distance_to_Recommended_ServiceCenter	Customer Visits
Non-Premium	Carry-in Center	North	Delhi	Parliament House	110001	28.63	77.22	North	New Delhi	Delhi	110092	28.64	77.29	7.10	0-15 KM	110024	28.57	77.24	0.07	2
Non-Premium	Carry-in Center	North	Delhi	Darya Ganj	110002	28.64	77.25	North	New Delhi	Delhi	110024	28.57	77.24	7.45	0-15 KM	110092	28.64	77.29	0.05	1
Non-Premium	Carry-in Center	North	Delhi	C G O Complex	110003	28.59	77.23	North	New Delhi	Delhi	110024	28.57	77.24	2.76	0-15 KM	110024	28.57	77.24	0.03	2
Non-Premium	Carry-in Center	North	Delhi	New Delhi	110005	28.66	77.19	North	New Delhi	Delhi	110085	28.72	77.11	10.14	0-15 KM	110085	28.72	77.11	0.10	4
Non-Premium	Carry-in Center	North	Delhi	New Delhi	110005	28.66	77.19	North	New Delhi	Delhi	110092	28.64	77.29	10.45	0-15 KM	110085	28.72	77.11	0.10	1
Non-Premium	Carry-in Center	North	Delhi	New Delhi	110006	28.66	77.23	North	New Delhi	Delhi	110092	28.64	77.29	6.27	0-15 KM	110092	28.64	77.29	0.06	3
Non-Premium	Carry-in Center	North	Delhi	New Delhi	110007	28.68	77.19	North	New Delhi	Delhi	110024	28.57	77.24	13.19	0-15 KM	110085	28.72	77.11	0.09	2
Non-Premium	Carry-in Center	North	Delhi	New Delhi	110007	28.68	77.19	North	New Delhi	Delhi	110085	28.72	77.11	9.05	0-15 KM	110085	28.72	77.11	0.09	1
Non-Premium	Carry-in Center	North	Delhi	New Delhi	110007	28.68	77.19	North	New Delhi	Delhi	110092	28.64	77.29	10.89	0-15 KM	110085	28.72	77.11	0.09	2

Need Help

danextian
1 year ago
I would do something like this:

A user selects its location which is point A and the distance is calculated from point A to several Point B's. The user selects the maximum radius. The shortest is what you'll likelly recommend to the user but you can show other locations as an option.
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Philippine-Barangays-on-the-Map/m-p/3384116

Here's the tutorial https://www.youtube.com/watch?v=5nkPRsD-olM

Forum Discussion

PBI Maps based on Geo Coordinates

3 Replies

Related content

Coordinates

using map visual with lamber 93 coordinates

Name-based column mappings

Using coordinates for a shape map

Convert between different coordinate map system