Personal Business Intelligence (PerBI), What No Cubes?

No Meta Cubes?

Simple PerBi view
If you have not been involved with other business intelligence products then this page is probably best ignored.

PerBI dropped the notion of a "Cube" and uses the power of the modern processor and the forever growing amounts of memory to process data is a similar manner to a spreadsheet. That is to say just read the data file and process it a line at a time.

The problem we found was that the idea of a "cube" frightened many users away from a product that could have benefited them.

This approach makes using PerBI simple, but it does impose a limit on the size of a the data file, this limit is variable depending upon the amount of RAM and the size of each line of data and the number of graphs that you want open at the same time.

No Cubes Mean Some Limits As Well

PerBui And Underlying Screen Shot The rule is that you have to have enough spare RAM to load the model along with space for working storage.

To stress the point we mean physical RAM not swap space.


As guidance 20 million rows is about the point where switching to a "Cube" based product starts to become a realistic requirement as for a model this size you are probably talking about needing 8GB+ of RAM.  20 Million rows is within the bounds of a new desktops and laptops.

Having said that we have run 30 million row models and the performance is acceptable, but not great, and you start having to trim down the number of columns in the model to fit it into memory. Our 40 million row model is at the limit of usability, if you have nothing else, for example a graph takes about 4 seconds to appear. 

You can tell when you have not got enough memory, because processing changes from under a few seconds to a lot longer.



Does PerBI Work Well With Older PCs?

Multiple charts Although PerBI benefits slightly from newer, faster processors, in practice it is normally restricted by the amount of spare RAM available.

We can't really give a definitive answer as it depends on the size of your model and the amount of free RAM.

The best suggestion is download the evaluation and try it.

PerBI is a single threaded application so it does not benefit from multi-core processors.


PerBI is a 32bit application so only cheaper modern PCs and Laptops contain less RAM than PerBI can use.


Prev   Next