Forum Discussion
Power query fuzzy clustering with large data sets
Hi Anonymous ,
Before applying the fuzzy cluster, we can refer the following link to optimize the data model to improve the performance.
As any fuzzy operation on the dataset will bring a huge performance impact to the data processing. The reason is that every text value has to be compared with every other text value in the table, the similarity threshold of the two has to be calculated (based on the algorithm above). This process is a very time-consuming process. Especially with more rows in the data table, you will feel it much more... Please find more details about Fuzzy Clustering...
Fuzzy Clustering in Power BI using Power Query: Finding similar values
Best Regards
Hi Anonymous ,
Before applying the fuzzy cluster, we can refer the following link to optimize the data model to improve the performance.
As any fuzzy operation on the dataset will bring a huge performance impact to the data processing. The reason is that every text value has to be compared with every other text value in the table, the similarity threshold of the two has to be calculated (based on the algorithm above). This process is a very time-consuming process. Especially with more rows in the data table, you will feel it much more... Please find more details about Fuzzy Clustering...
Fuzzy Clustering in Power BI using Power Query: Finding similar values
Best Regards