Clustering

Find similarity groups in your data, using k-means algorithm

Everyone is trying to make sense of, and extract value from, their data. In the real world, data is often not easy to separate, and patterns are not usually obvious. Clustering helps you find similarity groups in your data and it is one of the most common tasks in the Data Science; it provides analysts the ability to achieve better results for initiatives and understand customers and processes at a much deeper level than a human can achieve alone.

This visual uses a well known k-means clustering algorithm. You can control the algorithm parameters and the visual attributes to suit your needs.

NEW: support for tooltips on hover and selection

Here is how it works:

  • Define the fields to be used in clustering (two or more numerical variables)
  • Optionally, provide the labels to be shown on top of each observation
  • If the dimensionality of data is higher than two, consider data preprocessing
  • One of the most challenging tasks in clustering is defining the number of output clusters. To facilitate this task we provide both automatic and manual options for the control.
  • When you are sattisfied with clustering output, use numerous formatting controls to refine the visual apperance of the plot
  • If you are the advanced user, control the inner parameters of k-means clustering algorithm

R package dependencies(auto-installed): nloptr, seriation, pbkrtest,NbClust, cluster, car, scales, fpc, mclust, apcluster, vegan

Supports R versions: R 3.3.1, R 3.3.0, MRO 3.3.1, MRO 3.3.0, MRO 3.2.2

This is an open source visual. Get the code from GitHub: https://github.com/microsoft/PowerBI-visuals-clustering-kmeans

Add-in capabilities

When this add-in is used, it

  • Can read and make changes to your document
  • Can send data over the Internet
Membership

***** Related Blog Posts *****
Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique
Custom Dynamic Segmentation Using DAX In Power BI

***** Related Video Tutorials *****
Create Dynamic Visuals Based On Ranking in Power BI w/DAX

Outlier Detection & Visualization in Power BI – Advanced DAX
How To Use Virtual Tables With COUNTROWS in Power BI – DAX Formula Technique
RANKX Considerations – Power BI & DAX Formula Concepts
Manufacturing Operations – Power BI Showcase

Center of Excellence

**** Related Course Modules *****
Ultimate Beginners Guide to Power BI
Power BI Super Users Workshop
Solving Analytical Scenarios w/ Power BI & DAX
Advanced Analytics in Power BI
Financial Reporting w/ Power BI
Power BI Showcases

***** Related Support Forum Posts*****
Custom Visual AppStore
Custom Visuals vs Standard Visuals
Power BI – Creativity