Airtable and Qlik Sense

Data entry with Airtable in Qlik Sense

It has been a while since I last posted. Between coaching, playing cricket and work, I haven’t found much free time this summer to blog. But now that sunny summer days are behind us, I thought I would pick up the pen (well, keyboard in this case) and share some of my ideas.

This year has been a busy year for Qlik. Qlik Sense SaaS is adding new features quicker than I can keep up with. It’s great news for all the fellow Qlikies out there. It’s no surprise that past 12 months I have been busy with SaaS and hybrid deployments to help our clients with their SaaS journey.

For all the new features in Qlik Sense SaaS, there are times when businesses demand more of the platform. And today, I would like to look at one of those use cases, which involves integration with Airtable using a simple Qlik Sense extension from yours truly!

Read More »
qlik sense process step container v2

Process step container (stepper) v2

This year has been another great year for the Qlik enthusiasts, with every new release of Qlik Sense, we saw a number of new exciting features added to the product. It is now a good time to look back at some of my old extensions and give them the attention they deserve. First up, the process step container which I originally developed for the data literacy project (which has now evolved into Kids in Data). This is also a story of collaboration in the Qlik community and helping others.

Read More »
qlik-sense-mashup-dev-hub

Qlik Sense Mashup – Dev Hub

Lego is the building blocks that bring our imagination to life. Like Lego, Qlik provides many of the building blocks that bring our BI needs to reality.

I look at Qlik Sense as a collection of building blocks. These building blocks make Qlik Sense a modern BI platform. Qlik Sense dev hub is a member of these blocks. Today, in my third blog of the mashup series, we will look at some of the features of the dev hub and how these features help build a better BI solution.

Read More »
qlik-sense-alert-2 via Teams and Power Automate

Qlik Sense Alert 2 – MS Teams + Power Automate

Nearly a year ago, I wrote about sending alerts to Microsoft Teams channel using Qlik load script and REST connector. With the coronavirus sweeping through the world, forcing people in lock-downs, we are seeing surge in the use of collaboration tools such as Microsoft Teams. So, I wanted to expand on this further and send a HTML table as notification to MS Teams channel and send emails using Microsoft Power Automate (Previously known as Flow) to help people get the notifications quicker.

Read More »
Python Web scraper - Coronavirus feed

Coronavirus Outbreak Data Feed

2020-03-06 UPDATE: Added daily UK feed including total tested figures, GitHub and Azure Notebooks both have been updated.

With the spread of coronavirus and the general panic around it, it’s hard not to ask or hear questions like –

  • How many people have been infected so far?
  • How many people recovered?
  • Wonder how many people have lost their loved ones?
  • Which countries’ been affected so far and in what rate?

TLDR: A python script to scrape Wiki table to get up-to-date summarised information on coronavirus outbreak. The link to my Azure notebooks (Jupyter hub) or GitHub.

Read More »