© 2017 by awari.com.au

  • Black Twitter Icon
  • Black LinkedIn Icon

April 29, 2016

OK, so you have some source data that is pivoted and you want to unpivot it to work for charts within QlikView (and applies to QlikSense).


The source data contains columns across month rows that I want to aggregate, but the columns have to be a single dimension to represent the source of the traffic.


What I will end up with in the QlikView model is a tabl...

April 26, 2016

Hey all, how many times have you been data profiling and had the question, what data has been duplicated data in a table ?

It's pretty easy to find out quickly using the HAVING clause with the GROUP BY statement.

Below is an example query that you can use to do this, just replace the table and columns to suit your data requirements.

Code ...

-- This query wil...

April 24, 2016

Hey All,


I now have over 1200 students enrolled across my courses, and what's interesting is how students plan to actually engage with the course, especially FREE courses, as sometimes value can be hard to determine from the plethora of FREE courses available.


When I undertook a profile of what courses students are enrolled on, the results reveal some int...

April 20, 2016


Just released today 21 Apr 16 , a FREE course for getting started with writing SQL queries.


The course will get the ab-initio student up to speed with writing SQL queries.


The course is delivered using SQL Server 2014 express , so the student does not need to spend any $ and the SQL is all standard ANSI SQL with is transferrable knowledge to other SQL ba...

April 20, 2016

Dictionary loader workflow (Contact me for load source code)


The flow for the Business Dictionary load module is straightforward and can be summarised into the following steps …


1: Connection


The loader requires a connection to the repository, during development a ‘SQLServer 2014 Express’ connection was used, in production the connector should be to the d...

April 15, 2016


QlikSense Implementation




Charts and Tables within QlikSense will surface metrics (measures) and KPI’s providing actionable insight to the user.


Typically these metrics and KPI’s are constructed using the inbuilt scripting language and Set Analysis for more complex calculations across the associative model.


There is always a propensity for the re...

April 7, 2016

Thought I would post a sample video from my new course "SQL for punk analytics" , enjoy ...





Understanding the SQL query structure is pivotal to succeeding with constructing any query, but in order to code up a complex join, then this basic understanding is pivotal.


April 7, 2016

My apologies for taking so long to add this next post , but my SQL course development work took up all of my time and I just did not even think about my blog, so remiss of me!


Anyway, time to rectify this ....


In this post , I will outline the repository architecture , note that this architecture is designed for single or multi tenancy applications, hence...

April 7, 2016


What is the point of a Business Dictionary for QlikSense apps ?


Actually there are many, but lets list the most salient ...


1: Single source of truth for the implementation of agreed business rules.


2: A 99% reduction in post implementation maintenance where dashboard calculations (expressions) require change. Change once in the dictionary and all dashbo...

April 7, 2016

Since my last post of Feb '16 , my Certificate of QlikSense analytics development course has acquired another 40 enrollments, taking the cohort count to 176.


Overall it has achieved a star rating of 4.67 out of 5.00 , so clearly it hits the correct balance of content and technique, and of course more will be added in time, hanging out for QS V3.0 this yea...

Please reload

The Blog

February 19, 2017

Please reload