Personal Business Intelligence (PerBI)

Personal Business Intelligence, What Is It?

Stylised PerBI screen shot
PerBI (Personal Business Intelligence) is a data analysis or business intelligence tool designed for use by "normal people" not IT Departments and is intended for use alongside existing administration systems.

Although developed after experiences with insurance brokers, PerBI is relevant to any business that has up to 20,000,000 transactions that it wants to analyse.

If you do have 20 million transactions then you are getting near the product's limits and you will need a newish PC.

Depending upon how much data you want per "line" the practical limits are between 2 million and 20 million.

Personal Business Intelligence In A Nut Shell

It's quite difficult to introduce a new product if it is not part of MS Office.
PerBI Screen shot This screen shows, in the top left, the number of insurance policies by cover type (Comprehensive, TPFT or TPO) and then for each cover type who is allowed to drive (Policy Holder Only, Any Driver etc,).

No pre-preparation of the data was needed to be able do this, if you have never used a BI product before then this may not seem important. However is it one of the main differentiators between PerBI and other BI products.

PerBI Screen shot Again this screen shows the number of insurance polices by cover type (Comprehensive, TPFT or TPO) this time at the bottom and who can drive. But this time the other two screens are both for comprenhsive cover but for vehicles which are garaged and which are not.

This example may seem a bit obscure after all who would want to know this? But I have picked it to demonstrate the point that if you want to get the answer you can.

In this case you might want to pick the policy holders with comp cover who park on the road to do a mailshot offering a security device for which you would earn a commission.

This is the point of a business intelligence product, to find areas of your business that are of interest not to find things that you already instinctively know.

Where It Fits In The Market

Icons representing the section
PerBI was designed to fill a perceived gap between Excel Pivot Tables and full blown Business Intelligence products like SQL Server Analysis Services or Cognos PowerPlay.

The objective of PerBI is to be as easy to use as a spreadsheet, just load a file and get results, but be able to handle much more data.

Even now Excel has a limit of 1 million rows and it doesn't seem very comfortable with that much data.

The specialised business intelligence products can handle more data than PerBI but generally require a lot of setting up. This can be outside the capabilities of many organisations that don't have an IT department.

It is often the case that existing administration systems are great for administration but are weak when it comes to examining your data when you are not sure what you want to know.
PerBI lets you "play" around with your data in an easy to use way, whether you are looking for sales opportunities or analysing that part of the business that you do not intuitively know about.

How does it work with my data?

10 peoples heads
On a regular basis the "techie" that looks after your computer system unloads the relevant information from your administration system as a text file (CSV) to your PC. PerBI works with this copied data, it does not directly interact with your live system.
Where there are no specific export facilities within the admin system, data can often be extracted using the admin system's report writer or letter writer to create "letters" with the relevant information.

Download And Purchasing

Item Size Link Description
PerBI Version 1.22.2 4MB PerBI This is a full and unrestricted version of the program
Visual C++ redistributables 15MB Visual C Redistributables Microsoft's files that are needed to run programmes created with Visual C++, most recent pcs will already have these. If PerBI complains about them missing then you will need to download these files from Microsoft, VC_redist.x86.exe.

These are seperated out to reduce the download size for most people.
For more information please see

Business Friendly Licencing, On A Concurrent Usage Basis.

10 peeples heads The PerBI software is copyrighted and is offered on an As Is basis with no warranty as to suitability, reliability or fitness for purpose and on the basis that the author will not be liable for any losses or damages. These terms are the only ones that grant permission to use the software.

The software is copyrighted but may be downloaded and used without the payment of any fee and if it is felt to be useful a donation is requested but not required.

The suggested donation is based on the number of concurrent users and this is based on trust with no enforcement measures in the software.

Suggested Donation

Other Interesting Pages On Some Of My Sites.
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.
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.
Please note that these links do not use any tracking cookies or similar technology.