Customer lifetime value

The customer’s lifetime is the period in which we perform sales transactions, and the calculation of its value is a profit forecast based on the relationships that are mutually achievable. There are several ways to calculate it, and all of them show us profit flow that we can expect by retaining a customer. In other words, how much money comes if they pay regularly, if they are financed, and if a certain percentage of customers goes from year to year.

Error Checking Options

Excel has built-in functionality that allows automatic error checking when entering values ​​in cells. Where he recognizes or finds error, a small green triangle in the upper left corner of the cell and a warning icon (a yellow diamond with an exclamation point) will appear. If you click on the icon then a menu will open that explains why the error occurred and offers a way to overcome it.

Shape maps

Shape Maps are predefined maps that are recently deployed  as business intelligence visuals for Power BI Desktop, and contain predefined maps of organizational units (republics, regions, ares) within the state. This is a new functionality that is supported only for some countries, but it’s not bad idea to mention it as I believe that one day it will be available for more countries including Serbia.

ArcGIS maps

Vector maps were always better than raster for better quality and more precise location display. Power BI since recently  supports ArcGIS maps, based on Esri’s geographic information system, which in addition to common functionality of maps offers the ability to use some profound options and display statistics. The text that follows will be about the basic features of this visual.

Report page tooltip

When creating report visuals, their look is modified by dragging the dimensions and measures into different fields within the Visuals panel. One of the visuals fields is called Tooltip, and by adding values to this field we could see them as an additional clarification of report series after we position the mouse over them. Power BI Desktop now has the ability to add entire charts that behaves as a tooltip.