Quick Insights

In similar way to the newer versions of Excel PowerBI offers a mechanism that, based on a given dataset, can provide you with visuals, usually the charts that best represent your data. These can be: columns, bars, pie charts … At the same time, along with each one a brief description is provided on the basis of which you can conclude why this visual is proposed. Get ready to know Quick Insights!

Data clustering

When we make PowerBI reports with Scatter chart there is a technique where, by using machine learning mechanisms, data groups are grouped into clusters. Clusters are represented by different colors and in this way it is easier to see the connection between groups of data. Once created clusters can also be used to create other PowerBI visuals.

DAX variables

When you write DAX expressions it is a general recommendation not to overestimate their complexity. It is always better to create several measures and further consolidate them within the new formula. The code is more transparent, and there is a lot less chance to make an error. Since recently DAX also allows making variables. They are used to create measures that will be used to create an expression that returns final result.

Manual data entry

PowerBI Desktop allows you to obtain data from different sources. They are being acquired into tables between which we later create relationships to create the Data Model. Sometimes it is necessary to have temporary table that needs to be used to create a specific report. To create such a table and manually fill it, you can use the Enter Data option.

Data transformation

After importing data there is often a need to rearrange or update them so that we get adequate inputs on the basis of which we can make reports. Previously, to perform that, we used traditional Excel functions, and a few years ago an Excel add-in called PowerQuery was released. It offers the possibility of obtaining data from a variety of sources and the possibility of transforming them. Good News: PowerQuery is integrated in PowerBI!