Personal Business Intelligence (PerBI) Data Sources

What Does A Data Source Look Like?

Text file with csv data
A data source is simply a comma separated file with one line in the file for each "transaction" that is going to be analysed.

How Do I Get A CSV File?

Comma Separated Files are the normal way of getting data into PBi
SQL Server And App Screen Shot Depending upon who you are and what sort of system you have, you either create one yourself from your admin system or you get your "IT bod" to do it for you from your database.

As a generalisation the more modern the computer system that holds your data is, the easier it is to get the data out in a format suitable for PerBI or any other product.

In the past we have done things like a "mail shot" to get the necessary data, as well as more modern things like SQL queries.

It is possible that the only way to get data out of your system is to go back to your supplier and ask for a program to do it, this is more likely to be the case if you have had a bespoke application created.


What Is A DIS File?

The DIS Editor with an open DIS file When you use PerBI, the first thing that it asks for is a DIS file. A DIS file is simply a Data Import Specification and it describes what's in the data file.

Making a DIS file can be as easy as Selecting the menu options DIS->Autobuild.

A DIS file is not a "metacube" or anything like it, it's much more like a permanent record of what Excel asks you when you open a text file rather than a spreadsheet file.

You have to specify a DIS file as the application can make best guesses, hence the autbuild, but this is not always how you want to interpret the data.

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.