Taking your Qlik exams and becoming certified is a great way of proving your knowledge, not just of Qlik but of understanding customer requirements, the Windows environment, business intelligence best practice and lot, lot more. The content is broad and therefore revision is required but where are the best learning resources, how much do they cost (though some are free) and which exams are they aimed at? Continue reading “Qlik Exam Preparation”
I’ve been itching to do this one ever since I upgraded my Spotify account to premium and started using it on an almost daily basis! What better data set could you hope for than all your favourite music?
When writing blog posts on Qlik and BI in general it’s often handy to have a data set to hand; to connect to, transform and visualise. This is why sites with APIs are so useful and the rich variety of sites and companies now offering them makes for a playground of possibilities. The Spotify API is free and available for anyone with a Spotify account (free, premium or family). I’ll talk you through how I created my app…
I wanted to build an app for demo purposes that shows how you can conduct What If analysis in Qlik Sense, I just needed a theme…
It isn’t really that long ago since Jimmy Hill introduced the the 3 points for a win system to English football in 1981 in an effort to encourage attacking play and tackle the issue dwindling crowds. Big hitters like Germany, Spain, Brazil and Argentina didn’t introduce the system until as recently as 1995. Nowadays it’s hard to think that teams only got 2 points following victory. Some pundits have argued that it actually stifled attacking play; causing teams that went 1-0 ahead to “park the bus” and protect their precious points.
Having written a list of potential new blog articles my thoughts should have been on “which one to write up first,” but after after listening to some Billy Bragg in the evening I decided to indulge my inner socialist and write up something that wasn’t on the list. Using Qlik Sense and some VizLib charts I examined the Tories’ track record using what you might call “the Ghandi measurement.” Continue reading “The Ghandi Measurement”
2017 has been a disastrous year, politically and environmentally, but something I will always cherish about the year will be my trip to Qlik in Lund, where the company was founded back in 1993.
We love our recipes in Qlik land, none more so than master chef Rob Wunderlich (qlikviewcookbook), and they’re great but they do make me hungry. We use recipes as a way to describe processes but this time I thought it might be fun to use one as a way to describe an overall approach to building a dashboard in Qlik. These best practice tips are the kind of things I wish I’d known about when I first started out with Qlik and that even now are all too easily taken for granted. The link to open/download is below.
Link: A Recipe for a Dashboard
This post is a just a bit of fun using Qlik and contains two videos of apps/movies made I developed in Qlikview and used in my presentation at Edinburgh Qlik Dev Group earlier this week. The videos are of “moving” data.
I had the honour of meeting up with Brian Booden from Neolytics recently and talk all things Qlik. We didn’t have time to fit everything into one catch up so Brian kindly agreed to an interview about his 2nd year as a Qlik Luminary, his new blog and the excellent Qlik Dev group (see you at the next meet up in Edinburgh soon!). Brian is a pioneer, having contributed sleek Qlik Sense extensions, and an enthusiastic promoter of the benefits of business intelligence.
This blog post started as one thing and ended up another, but I’m actually glad it did. I set out with the intention of using a range of Premier League data to examine Qlik Sense Chart chart types and best practices. However, after coming up with a list of around 20 different measures off the back of just the first 4 columns I decided it would be interesting to see what Qlik Sense can do with even the smallest of data sets. With just 4 columns; Club Name, Season, Position and Points, there’s enough to take you wherever your mind dares and Qlik Sense provides the tools to put your thoughts onto screen. The tools are not just the visualisations but the ability to rearrange and aggregate data within your front end calculations; in the forms of set analysis, aggr() and firstsortedvalue() functions.