There are four business quarters in a year. In between these quarters, your organisation has the opportunity to review all past data and use it to improve strategies, set new goals and formulate reports. Reviewing data can be time-consuming and stressful, however, it is absolutely crucial for organisations to look at their past data to improve future business.
You are here
Data has always been the most important puzzle piece of a small business but now business has become even more data-centric. Now data is the board that your puzzle is built out of.
With that being said it is shocking how few business owners make use of that data that is already available to them.
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.
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: