Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out Qlik.com. I write this blog to showcase some technical bits that I hope will be useful to others.
adamcooke@webofwork.com

Tags

Qlik Sense for beginners

Webofwork > Qlik Sense for beginners

Hello! This is a file I created by scraping data from a freely available Geographical API. It has proven really useful for Qlik Sense Mapping visualizations. It contains the latitude and longitude of every uk postcode. It also includes the Easting, Northing, Grid Reference, District, Ward, District Code, Ward Code and Country.   You can use this file in a tool like Qlik Sense to make fancy maps like...

Read More

Personally, I don't have anything against a pie chart in the right context. Some people hate pie charts/donut charts, I do not hold such strong views. Really when considering using a pie chart with a dynamic tool like Qlik Sense or Tableau, it's more about understanding the context. Pie Charts are one of the best visualizations when they are comparing two values in a snapshot. They are also one...

Read More

One of the easiest charts to create in Qlik Sense or Excel or any BI tool is a line chart. Very good for showing trends over time but also very easy to make look like spaghetti or a pile of string if not thought about correctly.   See what I mean?   Here are a couple of alternatives while still using the line chart to make the data more readable. Use space to...

Read More
m

Are you looking for a quick way to turn your excel/csv/text file into an interactive visualization you can embed on your website for free? This post will show you exactly that and it takes about 5 minutes. Maybe you thought about just taking an image from excel or maybe doing something very time consuming with photoshop. Those wont be interactive though...

Read More

Streams are kind of like user groups. Here are the key points about Qlik Sense Streams: A stream enables users to read and/or publish apps, sheets, and stories. Users who have publish access to a stream, create the content for that specific stream. The stream access pattern in a Qlik Sense site is determined by the security rules for each stream. By default, Qlik Sense includes two streams: Everyone...

Read More

Most organisations and people in business intelligence are aware of the term Data Warehouse and its percieved benefits: A Data Warehouse Delivers Enhanced Business Intelligence A Data Warehouse Saves Time A Data Warehouse Enhances Data Quality and Consistency A Data Warehouse Provides Historical Intelligence by storing snapshots from a live system We can actually do these things with Qlik Sense. This is thanks to the powerful Qlik Engine, the great compression speed...

Read More

Datamarket is an attempt to give you access to reliable external data such as Weather, Demographics to provide insight with your own data set. Practically it means that once you go through the datamarket wizard, it will generate a Load statement that will pull the data you specified into your data model. By default the script will be locked - so it is controlled by the wizard,...

Read More

Extensions are cool and wizzy. They are great for early buy in on a Qlik Sense project, but in production there are some important questions to ask before utilizing them: Who built the extension? How often is the extension updated? Does the extension work with my dataset? Where can I get support if the extension breaks? Does the extension use external css or js files? Are there any license restrictions on...

Read More