You are here

Blog

Data Balancing Tool

QlikView, QlikView South Africa, Qlik South Africa, B2IT

This tool has been designed to do balancing tests between two datasets efficiently and accurately, and with little hassle. In most cases a source data extract will be used to determine if the data structure and content of your QlikView data model is balancing back to the source system and that your analysis of the data is correct.

In this example we will be using 2 small files which will be easy to cross check manually by eye but will be very difficult to do on actual large datasets as indicated in below screenshots.

Data Set 1(This represents a data extract from the source):

NPrinting South Africa

Data Set 2(This represents the bi end result data needed to be balance checked). Note some differences has been highlighted which has been spotted manually by eye:

How Location Data Boosts Your Business

business intelligence, Location Data

Forbes Insights indicate that mapping various location data types, such as heat signatures, waterways and storm patterns, can highlight previously unseen spatial relationships and, consequently, improve decision making.

About 80% of all business data contains a location component, therefore, it is crucial for you to understand how location affects your business. If collected and sorted efficiently, location data can improve insights and benefit every area in your business, including marketing, sales, operations, logistics, and so on.

Location intelligence (LI) has become vitally important, yet often overlooked, when it comes to business intelligence (BI). LI is used to derive meaningful insights from geospatial data relationships to either create or improve processes and solutions within businesses.

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