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.
Purpose of PowerBI Desktop application is to create reports on a local machine and publish them in the cloud for users who can see them anytime, at any moment, by Internet browser on a PC or a mobile device. Managers need to get clear, simple and visually nice reports. It seems that PowerBI meets all given criteria. In a text that follows I will describe various ways to create reports in PowerBI Desktop.
When making Marketing Plan one of the activities being carried out is the analysis of competition. How strong is our competition? There are several ways to find this out, and this is perhaps most easily accomplished by tracking revenue and profit of competitors over several years. The following text will show you several Excel charts which should show where is our company and where are competitors on the market.
There is a time of Christmas holidays, the time when everybody, more or less, decorates the Christmas tree, and this served as an inspiration for the text on the application of one more type of Excel chart. It is a subtype of the Scatter called Bubble and by which we can get a “XY” chart whereby a multicolored “balls” are found on the section. To create this diagram all we need are: a table of data, a picture of the Christmas tree and a little work in Excel!
When I was in school, and learning about Cartesian (Descartes’s) coordinate system I must admit I liked it a lot! I was in love with the idea that in the intersection of x and y axes, dots can be drawn, and then they connect to the line and show some trend. It’s been a long time since than, and in the honor of legendary Rene Descartes I’ll be creating a recipe about scatter charts.