QlikSense, QlikView services
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.
-- This query wil...
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 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...
Paul 'Scotchy' Scotchford
I have released my new course for those that want to understand and use SQL for data analytics in their day to day data discovery tasks, yep cheap to enroll but the value is worth $1000's !
I built the course to cover those gnarly topics that seem to go unanswered such as how to use the APPLY statement, so many blogs ask what is the use of...
New QlikSense Master Class - Published!
September 4, 2019
Qlik Posted as Market Leader by BARC
October 18, 2017
QlikView training $10 - October only
October 12, 2017
The Complete QlikView Boot Camp - Now Available
September 26, 2017
QlikView Boot Camp Releasing Soon
September 17, 2017
The Complete QlikView Boot Camp
July 18, 2017
QlikSense Set Analysis - How To (Part 2)
July 2, 2017
QlikSense Set Analysis - How To (Part 1)
Over 20K students enrolled across all of my course...
April 21, 2017
Happy 2017 to everyone
February 19, 2017
Anatomy of a SQL query