Clustering using k-mean in power query, elbow chart

Frequent Visitor
2239 Views
Highlighted
Frequent Visitor
Posts: 5
Registered: ‎04-09-2017

Clustering using k-mean in power query, elbow chart

[ Edited ]

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

 

 

 

 

Attachment
Attachment