Personal Business Intelligence (PerBI) Scripting

What Is Scripting?

Simple PerBi view
In the context of PerBI scripting is a way of manipulating the data using something that looks a bit like programming but isn't.

If you talk about doing a mail-merge in a word processor, people often say "that sounds complicated", then they do it and find that it wasn't that painful after all.

For many people scripting is something new, but it is not difficult!

What Soft Of Thing 1?

Scripting often sounds intimidating but is just a way of saying what you want to do.
PerBi And Underlying Screen Shot Imagine that you are looking at an item such as a car which for which you know the age. Your data may have ages ranging from 0 to 50 years, but you want to look at the data in bands of 5 years.

If we then decide that we don't find that the be useful, it would be better to band them is 4 year bands it is a trivial change. If we want to band them 0-2, 2-3, 3-5,5 plus is clear that this should also be fairly easy but clearly this is so arbitrary that no generic dialog box could cope with this.

Normally models are created with a number of "spare" columns, these columns are used to store calculated data.

The script shows how we achieve this, apart from the comment and the line that says Let !UserInt = !VehicleAge/5 all of the code was created automatically when you asked to create an ASL script.

What Soft Of Thing 2?

Multiple charts In this case we want to split our policy holders into the groups Good and Bad, based on the number of years they have been driving without a claim.

The second script shows that this is almost as simple as the first task.

No, that does look complicated!

Multiple charts Look again, most of the two scripts are the same and this same bit is used time and time again, so you will become familiar with it very quickly.

All it is doing is;
  • Create some memories, like on a calculator.

  • Ensure that no Data Manipulation Commands have dropped any of the data.

  • Go to the first row in the model.

  • Looking at the number of years NCD and storing good or bad based on that number.

  • The While/EndWhile/GetNextRow stuff just means keep on doing this for all the rows in the model.


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.