You are here

Blog

Cleaning up Temp Tables and Fields in QlikView and Qlik Sense.

QlikView south africa

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.

QlikView south africa

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.

Is there a difference between Business Intelligence and Business Activity Monitoring?

business intelligence

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).

Signs That It's Time To Introduce BI To Your Business

QlikView
  1. Your data is not really useful information.

Companies, organisations and individuals are masters when it comes to collecting data – in fact we collect data daily, often without even knowing. However, data is not the same as information – data is not helpful, nor meaningful, unless used in context to gain insight or information. BI tools help with this – business intelligence helps to analyse data and transform it into useable information that can help fine tune business operations and meet goals.

How Incremental Analysis Can Be Used To Improve A Business's Effectiveness

QlikView

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 analysisincremental analysis disregards any sunk cost.

Do You Need Data Warehouse Business Services?

QlikView south africa
Every business is always on the lookout for a way to enhance its operations. One way to do this is to use the services provided by a data warehouse business in South Africa. When your operations are done in the best way, you have the ability to sustain the competition that you face on daily basis. One of the things that have set the foundation for businesses to advance is Information Technology. There are various benefits that technology brings to your business today, one of them being data handling. This is where data warehousing comes in.
 
Simply put, this is a process where you can access tools for designing, building, maintaining and retrieving your data. This service allows you to make informed decisions faster and with more confidence.