CPS Correlogram+ for Power BI is a custom Power BI Visual thought to facilitate Data Exploration by condensing key preliminary information about correlations and distributions in the same intuitive and interactive graphic contex.

(Nov. 2024)

LET’S SEE HOW IT WORKS

Correlation tiles – we started by emulating the most popular tool for plotting Correlograms that’s undoubtedly Cran R’s “corrplot” so, by simply dragging numeric columns in the only field, named “Column”, in the Power Visualizations panel (filtering out null/blank values) you’ll see a tile matrix in which tiles different colors and size depend on the Pearson’s correlation coefficient between the values of the two columns whose names are on the row and column of the matrix that cross with in correspondence with each tile.

CPS Corrplot+ supports up to 40’000 rows and 250’000 values. Such amounts might be increased in case of customers’ special needs.

When the correlogram appears a text that will fade-out in few seconds notifies the user about how many rows and values are involved in the calculation of correlation coefficients as this is also useful to know the exact size of the sample especially in case of further direct or indirect filterings.

Once the user click on a tile a kind of custom tooltip will show the scatterplot of the distribution of points whose coordinates are: the values of column the row of the tile for the X axis and those on the column of the tile for the Y axis.

Scatterplot’s header shows the equation of the regression line that will be also displayed on the scatter plot.

In order to ensure scatterplot readability the X and the Y axis have independent scales avoiding that, for example, in the case a percentage (ranging from 1 to 100) on the X axis and an average incomes (or sales amounts) on the Y axis (or vice versa), percentages get plotted extremely close to the other axis. Please note that a relevant difference between the X and the Y scale will affect the correspondence between the slope of the regression line on the scatterplot and it’s angular coefficient reported on the equation on the header of the scatterplot but will not affect the relation with points.

You can check CPS Correlogram in action at on this link DATITALIA – CPS on the report pages concerning correlation analysis or refer to the demo video.

Do not hesitate to mail to: analytics@cpsweb.it for requests or further info.