Clustering using k-mean in power query, elbow chart

leilaetaati — Thu, 18 May 2017 04:01:26 GMT

In this demo files I cluster my fitibit data, I have shown how to:
1.write R codes inside the power query to cluster data using k-mean algorithm

2. show the result using powerBI features (tab 1 and 2)

3.identify the best number of cluster via "elbow"chart (tab 3)

for more explanaton visit below blog

http://radacad.com/clustering-concepts-writing-r-codes-inside-power-bi-part-5

http://radacad.com/k-mean-clustering-in-r-writing-r-codes-inside-power-bi-part-6

for download the file if you downloadthe zip file simply extract it

for pbxi file, you should download it, you will see the download as zip file , then change the file type to pbxi, I am following the problem with portal manager to see how to download easily

eyJrIjoiZjYyOWFmM2EtM2IxOS00OTA3LWIyOGQtM2YzMTk3MWI1YWNkIiwidCI6ImNjODBmOGQ2LTNjMzUtNGRhNC1iMGY4LWNiZWFkYjAwNDY3ZSIsImMiOjEwfQ

topic Clustering using k-mean in power query, elbow chart in R Script Showcase

Clustering using k-mean in power query, elbow chart