Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to? - Map speed optimization with Lat/Long

Hi,

 

My end users are complaining that the map used in a report updates to slowly, but can't figure out how to increase the lat/long plotting the best way, so I'm looking for advice.

 

Model contains an address tabel with 3 millon rows, including these details:

Unique Latitude: 252.315

Unique Longitude: 398.188

Unique sets of Lat / Long: 1.840.361

 

The model is currently a simple setup, with a dimension tabel containing 15.280 rows (think zipcode / municipality) that filters my main tabel with 3 million rows.

 

I've thought of creating a seperate table for Lat/Long, but that would likely need a "both" relationship, and due to still having a high cardinality of 1.8 million rows, it doesn't seem worth it compared to keeping in my existing table.

 

Is there any general advice how to setup a model that can process Lat / Longs faster than the existing?

 

Current ideas is to split Lat / Long into seperate tabels and possibly add additional dimension tabels to my zipcode/municipality table.

 

Thanks.

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks, but besides from this part 

       

      "In Power BI, if the dataset you are using has fields for longitude and latitude -- use them! Power BI has special buckets to help make the map data unambiguous. Just drag the field that contains your latitude data into the Visualizations > Latitude area. And do the same for your longitude data. When you do this, you also need to fill the Location field when creating your visualizations. Otherwise, the data is aggregated by default, so for example, the latitude and longitude would be paired at the state level, not the city level." I don't see how it helps me, as I'm already using Lat / Long.

       

      Additionally I've already decrease the accuracy of my Lat / Long to 5 decimals to reduce cardinality.

       

      To me it seems that performance increase should come from the data model?