QlikView, known as one of the most innovative developments, is an extremely effective business intelligence (BI) program. The platform enables business managers and developers to visualise data and turn data into knowledge.
You are here
One of the most common practices we all use is concatenation of tables (usually our facts) inside our load script. One of the givens are that these fact tables don't always have exactly the same columns, but rather only a few overlapping core columns.
Here is a small sample of a 3 facts with concatenate loads:
During your script development process, the GROUP BY clause is often (probably for every single solution you build) needed to summarise data.
You are also, more often than not, required to rename fields from your source to more appropriate field names.
We then end up with syntax that looks something like this:
If used correctly, colour is a very effective tool that you can use to visually display data.
Colour can be used to encode extra meaning into your charts; however, it can become an issue if colour is used for no real purpose. Instead of splashing colour onto your charts for appeal, rather use colour so that various audiences are able to obtain relevant information.
Remember that no matter how well data is presented, if the data is not correct, it is useless. Using guided analytics, such as QlikView business intelligence software, will ensure that your data is organised and effective.