Personal Business Intelligence (PerBI) Viewing Data

Selecting Data To View

Simple PerBi view
The main PerBI views are Bar and Line graphs.

The contents of these graphs are selected from a drop down list of model columns that were in the data source and for advanced users values derived from those columns programmatically using a BASIC type language.

This BASIC type language we call ASL initially sounds quite daunting but is in fact very easy to use and once learnt gives the application its real power.

Many Business Intelligence solutions require that a Model has to be designed and then you can cut and dice this model in all sorts of wonderful ways.

If you decide that you want to see the data in a way that the Model didn't envisage then things can become difficult.

Can I See Numbers Instead Of Charts?

When you are interested in details not overviews.
PerBui And Underlying Screen Shot Most of the time a graphical view is the most appropriate.

You can also see the data that underlies the graph or the rows in the data source that are currently in use, this is particularly useful if you are using PerBI to plan a marketing campaign.


Viewing Multiple Graphs

Multiple charts We can see here 4 graphs being displayed at one time and its already quite cluttered.

In this example we also see the overlaying of standard deviation and counts onto an average premium graph.

What is important to know is that the data that makes up the 4 graphs can use either all of the data or different subsets.


Information Not Presentation

Chart using a custom bitmap PerBI is intended for examining data not for presenting the results in a manner where style outweighs substance.

Despite this the charts can be customised for colour and image files can be used to replace the solid bar charts.

Prev   Next


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