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

It's quite possible that this is meaningless to you, especially if you are new to BI.
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


Other Interesting Pages On Some Of My Sites.
Weight Loss Calculator
Screen shot of weight loss calculator Weight Loss Calculator Tries to simulate the body and report the effects of food and exercise in periods as short as 15 minutes.

This level of detail highlights the effects of a run, bike ride or chocolate bar.

For those who are new to exercise, weight fluctuation due to glycogen usage is made much clearer.
Initial Programming Language
IPL Screen shot Initial Programming Language possibly the easiest way to learn programming on a Windows computer.

Designed to mimic the simplicity of the 1980s home computers where you could get started in minutes...

...but still powerful enough to do pretty complex things.
Learn To Budget
Money Manager Screen shot Learn To Budget MoneyManger.ipl is a free, MS Windows based, computer program that can be used with children and young adults to practice budgeting

Put simply you get paid once a week, you then spend this money on food, rent etc. If you do just this, then you will be able to save some money and then buy cars, holidays etc.
Please note that these links do not use any tracking cookies or similar technology.