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

Qlik Sense Subscription Model Announced

The long-awaited subscription model for Qlik Sense was announced in July and offers a more flexible way for businesses to utilise the ground-breaking platform.

As an elite Qlik partner, we’re delighted Qlik have introduced this subscription model. It’s only for Qlik Sense at the moment but will provide a greater reach for the invaluable services the Qlik platform provides.

I know some of our existing Qlik customers and members of the Qlik community have been eagerly awaiting this subscription pricing. The new model works in the same way as a perpetual license and can be deployed either in the cloud or on-premise.

Pricing is staggered based on the number of users and there are some subtle differences to the perpetual licenses, which we’d be happy to discuss. Please get in touch with the team at Ometis to find out more about subscription pricing.

It’s an important scheme as the subscription model will help companies by reducing barriers to entry, enabling more businesses to utilise the innovative and efficient Qlik Sense platform.  The model’s flexibility to easily and cost-effectively increase or decrease subscribers will be a huge draw to new businesses eager to unlock the information their business data holds.

Not only does the new subscription price include maintenance, which entitles users to the latest versions of the Qlik Sense software, it will also free up budgets in Year One to deploy more services and ensure a successful implementation.

The subscription model may only be available for Qlik Sense at the moment but we hope to see services such as NPrinting and GeoAnalytics have some type of subscription service later in 2017 or early 2018. Qlik Sense users still have the option to buy perpetual licenses as well and we do not expect to see this taken away.

If you would like to know about the Qlik Sense services under the new subscription model, please get in touch with us by calling +44 (0)330 363 9900, or emailing me direct at andy.patrick@ometis.co.uk . Alternatively you can click here and filling out the contact form.

By Andy Patrick

Planning Your ETL in Qlik

Qlik has a powerful script engine which allows you to bring information in from a variety of sources. It’s included within Qlik and because you load all the data into memory, once saved it is effectively a portable business intelligence (BI) solution. Of course in the real world the file would remain on a server where all the decision makers can access the information held within.

Naturally, one would assume each dashboard would bring in the data needed from its sources and this can be the case. However, when you’re planning a larger scale strategic implementation this becomes less efficient.

Qlik has a simple yet effective option to allow you to develop these large suites of BI dashboards. As mentioned, Qlik stores the information into memory and also has the ability to export data tables in a special format which is already optimised in the standard Qlik file format (QVD). This optimisation reduces the data size without the need for compression. A Qlik dashboard file can now be seen as something different; it becomes a script which moves a set of data from one location to another and perhaps transforming it as well.

For large deployments we would recommend creating three layers (three Qlik dashboard files):

  1. Extract
  2. Transform
  3. Dashboard Load

The Extract layer would take information from the source systems and place it straight into a QVD file. Here, the latest information from the source system can be added to the data retrieved previously – also known as incremental loading. This method is far more efficient than taking the whole history each time you re-load. It’s important at the extract stage that no data is changed, combined or additional fields added. This way you can easily test that your saved data matches the source file.

The next step is Transformation.  Here we read the previously saved data and get it ready for consumption for a dashboard. As before we would do this incrementally for large tables that are added to over time. Transformation would include; joining tables together, adding flags and calculations.

Finally the Dashboard Loads the transformed data it requires. As the data is fully prepared in the transformation stage, it can be loaded as ‘optimised’ which means it happens very quickly.

When storing QVDs in the Extract and Transform layers it’s good practice to split large tables into manageable chunks. These tables typically contain your transactional data which grows over time (commonly referred to as FACT tables). These bite sized chucks depend on the data volume although we would typically recommend monthly files – this makes archiving data in the future easier. Also, if your dashboard only requires information from the last twelve months, you don’t need to load a QVD file which potentially could contain many years of data, which of course would slow down your process.

The benefits of this type of data load structure include:

  • Your source systems are only accessed once, reducing the demand on their resources
  • You can validate the accuracy of each stage of the process
  • QVD files are built up over time and are optimised
  • Several dashboards can re-use the same data which is both efficient and consistent

If you have any questions or you’d like more information on how Qlik business intelligence can help your organisation, please don’t hesitate to contact us on +44 (0)330 363 9900 today.

Thanks for reading!

Richard Pearce, Senior Consultant.

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