You are here
Most of the time we use temporary fields and tables in our load scripts in Qlik.
Usually we have some sort of a naming convention like temp_TableName or TableName_temp.
I quite like the way a temp table is identified in SQL with a #-prefix, so I adopted this naming convention for my temp fields and tables in Qlik.
This brought with it a nice advantage in that all the #-fields and #-tables are listed at the top.
Now you can easily see if you have any temp fields and tables left in the app.
This got me thinking: if all my temp tables and fields follow a strict naming convention, I can identify and drop those at the end of my script easily, and not have to worry about them being left behind.
The least intelligent business decisions would be to dismiss change. We can’t force today’s competitive environment not to be hot on our heels all the time, so we must accept change as a constant.
Business Intelligence (BI) has been adapting since day one. BI’s evolution grew from being a simple support system for a single manager, to becoming the master of data mining, analytical processing, querying and reporting. It’s evolution also introduced interactive online platforms with high security that large groups of decision-makers can access at any time.
In between this evolution, around the early 2000’s, Gartner Inc. helped accelerate BI’s growth to fast forward by introducing Business Activity Monitoring (BAM).
Do you know how many e-mails are sent, videos are uploaded onto YouTube and tweets are sent out per day? All types of data is generated and sent around every millisecond and it is very important that we try our best to understand this data.
Many organisations strive to leave a very big digital footprint, but if they do not make sense of the fast paced data that is constantly generating and evolving, they will not benefit from the crucial insights that could be crucial to their success.
What is incremental analysis? If you've studied either macroeconomics or managerial accounting after high school, you are probably very familiar with the term. According to Investopedia,
An incremental analysis is a decision-making technique used in business to determine the true cost difference between alternatives. Also called the relevant cost approach, marginal analysis or differential analysis, incremental analysis disregards any sunk cost.