IoT Data And The Power Of Qlik

The Internet of Things (IoT) has grown rapidly in recent years and shows no signs of slowing any time soon.

In fact, it’s estimated each of us will own 28 IoT devices by 2020 compared to the average six devices per person we see today – that’s a massive increase. It’s no wonder that, as a result, the IoT market is expected to be worth more than 11 trillion USD within the next 10 years.

All this newly acquired data raises a new set of questions and most importantly the main query for us is what are we going to be doing with all this data. The amounts of information available are going to be huge.

The reason behind this increase in IoT devices is the obvious advancement of technology, which also shows no signs of slowing any time soon. Cost-effective and energy efficient sensors have enabled the sentient enterprise, while Edge/Fog computing has provided real-time intelligence close to the source of data creation.

The rise of connectivity through the likes of IPV6, LTE (5G) and low-energy BT allows the constant transfer of this data, which is then stored in the cloud meaning all this data is then easily accessed. This is all great but it’s still huge amounts of data, which, despite easy access, is seemingly insurmountable when it comes to any type of analysis.

That’s where Qlik comes in.

Firstly, to truly understand the value of IoT data, it must be associated with other data. Secondly, any innovation from IoT data must be discovered within the data itself, and, thirdly, for the true value of IoT data to be realised, insights need to be easily shared and acted upon.

Qlik’s influence on these three key areas cannot be underestimated nor overstated. It’s simple, without a platform like Qlik, there’s no way of breaking down, digesting and disseminating this data without the requirements of hours and hours of human processing, analysis and, ultimately, sharing. With Qlik, this process becomes almost instantaneous in comparison.

We could spend time here running through numerous examples of how the Qlik platform has enabled swift processing of IoT data and the subsequent results but I’m going to focus on one that I’m sure we can all relate to, one that is understandably a forward-thinking leader in the IoT phenomenon.

BMW have been using Qlik’s platform to help them understand all areas of their products, processes and procedures. They use Qlik to analyse machine-generated data including in-car data, paint-shop robotics and diagnostic readouts in service.

You can imagine the reams of data produced from one vehicle alone, which is why Qlik is so important to the company. It’s used to analyse data from advanced analytics for creation and tuning of algorithms as well as delivering insight into business processes.

If you’re looking to capitalise on your IoT data, or utilise your business data to ensure advantageous decision making over your competitors, we’re here to help.

Get in touch with the expert Ometis team now to request a free demo of the Qlik platform. After that, as the UK’s largest dedicated Qlik consultancy, we’ll look after everything. So, call us now on 0330 363 9900 and start using your data to your competitive advantage or visit http://www.ometis.co.uk.

By Ross Greig

Visualize YOUR World Was A Sabering Success

We had a fantastic time at this month’s Visualize YOUR World event in London with Qlik.

We also arguably had the best stand at the event thanks to the fantastic Gary Palmer and ForbiddenPlanet.com, who provided an excellent array of displays and giveaways that would excite any sci-fi fan.

From real-life lightsabers to huge Wonder Woman graphics, the collateral from ForbiddenPlanet.com definitely put our stand on the map!

We also had a lightsaber to give away, but not just any lightsaber (as if there is such a thing) but Luke Skywalker’s very own lightsaber… does it get any better than that?

Gary helped attendees understand the power of Qlik and the bespoke service Ometis provides, with compelling examples of how ForbiddenPlanet.com have utilised the platform to revolutionise the way they do business – and as their IT Director, he should know.

There were plenty of questions during Gary’s lunchtime session, although this may have been down to the fact that visitors had to be holding a lightsaber to ask a question… We had everything from serious queries to ‘What’s your favourite colour?’ as people vied for the chance to swing a saber, and who can blame them?

All-in-all, it was an entertaining day packed with data-driven opportunities and was a fantastic opportunity to showcase the work we do, as well as how good we are at doing it (even if I do say so myself!).

Now we’re looking forward to Visualize YOUR World in 2018, we’ve already been thinking hard about how we’re going to top this year’s display but if ForbiddenPlanet.com are involved once again, I’m sure it won’t be too difficult.
By Andy Patrick

We’re Heading To IP Expo – Europe’s No.1 Enterprise Event

It’s official, Ometis are heading to this year’s IP Expo, Europe’s leading enterprise event, at Excel London from 4 – 5 October.

We’ll be joining more than 300 exhibitors as the must-attend IT event of the year for CIOs, heads of IT and insight leaders. IP Expo is a platform for exclusive content and senior-level discussion topics, and we’re happy to announce we’ll be joined by Qlik to host a seminar session.

The annual event is an important part of the Ometis calendar and incorporates expert opinion and knowledge around analytics and IoT, key factors in the understanding and capturing of business data. We’ll see you inside the Analytics area on stand KK17, make sure you pop by.

We’ve also organised a special appearance by Qlik Director of Retail & Services Market Development, Paul Winsor, who’ll be hosting a seminar session on discovering the value in IoT Data.

It is estimated there will be over 20x connected devices per person on the planet by 2020, and anything from 50-200 billion IoT devices. That’s a lot of data being generated from IoT ecosystems. The challenge will be making all that data accessible and understandable to start extracting value from it all. Paul will explain how Qlik are making this happen at 2.40pm on Thursday 4th October inside the Analytics Theatre.

While we’re there, we’ll be taking the opportunity to discuss Qlik’s various products and complementary platforms that ensure you get the most from your software. These include Narratives for Qlik and NodeGraph and we’ll have a number of pre-set demos that showcase the power of Qlik, with true data visualisation at the touch of a button.

If you’re heading to this year’s IP Expo in London, come and say hello – we’ll have a few goodies to give away and plenty of charm and wit to make your visit worth it.

Don’t despair if you’re not attending this year’s event either, we’ll keep you up-to-date over the official Ometis social channels, so get following! We’ll also have a complete IP Expo review to follow so you won’t feel too left out.

 

By Ross Greig

QS 3.0 New Features Blog

The new release of Qlik Sense, version 3.0, was released at the end of June and makes it even easier to explore your data and provide insight to your organisation.

Read below for our summary of the new features included in the latest version of Qlik Sense.

Visual Data Preparation

With Qlik Sense 3.0, self-service data exploration goes to the next level with visual data preparation. Previously, to link tables of data together took a bit of know-how. Now the tables are shown in their own “bubble”, meaning that you can drag tables that you know should be linked together and Qlik Sense will associate them based on the data.

1

Figure 1Table “bubbles” linked together in the new Visual Data Preparation window

Now you can leave the complicated job of modelling your data to Qlik Sense and concentrate on what is important, analysing your data.

Branding

Add some pizazz to your Qlik Sense apps by branding them. Add your company logo and colours to your Qlik Sense apps making your corporate applications look more professional.

2

Figure 2Apply branding to your Qlik Sense Apps

Visual Search

Search has become visual in Qlik Sense 3.0. With the addition of charts to the standard search tool, you can now save time searching through sheets and sheets to find the one you want. You can even search for chart types and Qlik Sense will return the most relevant results!

3

Time Aware Charts

Charts in Qlik Sense have always helped the user build something powerful in just a few clicks, but Time-aware charts in Qlik Sense 3.0 take this a step further.  You no longer need to build your own calendar tables and pre-select the most appropriate granularity of date to use in your chart.

With Time-aware charts you simply add the original Date field to the chart and Qlik Sense will automatically work out the best way to display it.  It could be days, weeks, months or years – Qlik Sense will automatically scale the chart for you.

In addition to this, it will also understand if you have missing data points where you may want to show a continuous scale and auto-fill the gaps. Line charts are available in this release, but you can expect to see other chart types with this functionality in future versions.

No selections:

4

2015 & 2016 selected

 5

Widgets

This new feature gives us, the developers, the freedom to create what the customer wants but doesn’t yet exist in Qlik Sense. Widgets can adapt to the shape and size and the customisation possibilities are endless. In this example we’ve made a KPI where the icon can relocate itself or disappear if necessary depending on the size and shape of the widget. The icon and the colours can be changed and the second measure is optional, and this is only the beginning!

6

The widget editor allows us to use HTML, CSS and Angular.js to create and edit widgets.  It’s a comfortable place for a developer and gives us all the tools we need to preview our widgets as well as to connect them to a published app to test it with real values.

This is just tip of the Widget iceberg – the possibilities are endless!

 7

 

DataMarket

Qlik DataMarket is a revolutionary new Data-As-A-Service offering from Qlik.  It allows direct access to a range of standardised information that can help supplement your analytics.  With Qlik Sense 3.0, Qlik have included access to four new premium data packages:

  • Historical stock prices from major stock exchanges
  • Financial data from companies worldwide
  • Population indicators for India’s states and districts
  • Population of Canada by provinces or territories

While we expect Qlik to continue to add in population and demographic data of new countries fairly regularly, it’s great to see some additional company and financial markets data being released.

We can see some great use-cases for this.  Imagine supplementing your ERP or CRM data with the latest stats about your Customers or Vendors.  For some of our Financial Services customers, having the ability to get single-source access to financial markets data will make a big difference in how responsive they can be when making data-driven decisions based on Qlik dashboards.

We’re looking forward to seeing what other new packages are made available in the coming months.

9

 

Choosing the right chart

Choosing the right chart to best analyse your data and showcase your results can be tricky. Whilst data visualisation is incredibly useful, faced with the vast array of options it can be an intimidating task.

The best place to start is selecting the right type of visualisation. For this, you can choose from the four main types: comparison, composition, distribution and relationship. Then you can decide on the chart that best displays your results. At Ometis, we can even help you customise your dashboard to reflect your company’s branding.

 

The Four Main Types of Visualisations:

Comparison
Comparison charts are used to compare the magnitude of values to each other and can be used easily to find the lowest and highest values in the data. It can also be used to compare current versus old values to see if the values are increasing or decreasing. Common questions are “what products sell best” and “how are our sales compared to last year”.

Charts include:

  • Variable width chart
  • Bar chart – horizontal or vertical
  • Table or tables with embedded charts
  • Line chart
  • Circular area chart

 

 Composition
Composition charts are used to see how a part compares to the whole and how a total value can be divided into shares. Composition charts shows the relative value but some charts can also be used to show the absolute difference. The difference is between looking at percentage of total and value of total. Common questions are “how big of a market share do we have in a region” or “what areas are our budget divided into”.

Charts include:

  • Stacked bar chart
  • Stacked area chart
  • Pie chart
  • Waterfall chart
  • Tree map

 

Distribution
Distribution charts are used to see how quantitative values are distributed along an axis from lowest to highest. Looking at the shape of the data a user can identify characteristics such as the range of values, central tendency, shape and outliers. It can be used to answer questions such as “number of customers per age group” or “how many days late are our payments”

Charts include:

  • Bar histogram
  • Line histogram
  • Scatter plot

 

Relationship
Relationship charts are used to see the relationship between the data and can be used to find correlations, outliers and clusters of data. Common questions are “is there a correlation between advertising spend and sales of our products” or “how do expenses and income vary per region, and what’s the deviation”.

Charts include:

  • Scatter plot
  • Scatter plot bubble size