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.
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.
Car Insurance Premiums Explained
Generic car picture Car Insurance Premiums Explained This site aims to explain how car insurance premiums are usually calculated in response to repeated questions on various internet fora such as;

I added my mum as a driver and the premium went down.Why is someone quoting £300 and someone else £1200? Why is my renewal premium higher than my first year's premium?
Buy A Ghost
Picture of a cat with yellow star Buy A Ghost is a light hearted source of one page ghost stories aimed at pubs and restaurants as talking points.

Print them off and put them on the tables or walls and you have an instant talking point.

Aimed at regulars who have run out of things to say or new groups or couples as an ice-breaker.
Please note that these links do not use any tracking cookies or similar technology.