Using Monkey Tools - Analyze Your Data Model Memory Usage in Seconds!
Monkey Tools Model Sleuth reports provide you with an instant analysis of how much memory it takes to run your Power Pivot or Power BI model. Where this monkey really shines, however is that it displays the values in an easy-to-read Pivot Table which makes it VERY easy to see which columns take up the most space. Even better - in Excel - our monkeys also report which of the columns are actually in use vs not, so that you can remove unused columns, as well as the data types in use, which impact the memory compression.
Remember, less memory = faster recalc = better stability. And this Monkey helps you get instant insight as to where improvements to your Power Pivot or Power BI models can be made.