I always felt that the report usage extracted from Power BI is just not enough. Data from “usage report” is nice, but is aggregated to daily level, while Activity logs need to be retained, because they will disappear. It is also not possible to extract e.g. slicer usage. We can do better!
Have you ever wondered what it is ’10’? You have 10 fingers, right? Well, the answer actually depends on the numeral system that you use. In duodecimal (or dozenal), for example, you in fact have ↊ fingers, in binary 1010, in octal 12 and in Quinary 20. The decimal system is so prevalent and everywhere that it is sometimes hard to escape its perspective. But what if it wasn’t the case?
This is a case that I have come across with one of my customers very recentely. I wanted to calculate sum of sales generated by first N products pareto style i.e. if first product’s sales is 200 and second’s 100, my calculation would show 200 for the first product and 300 for second. This allowed me to see that e.g. 90% of our total sales are generated by 7 products.