Qlik Subscription Model Update

Qlik have now expanded their Qlik Sense subscription offerings.

This gives ultimate flexibility to suit the needs of all companies and provides opportunities for both opex and capex purchases.

The subscription model now covers line items such as:

  • Qlik Sense Enterprise
  • Qlik NPrinting (new)
  • Qlik GeoAnalytics (new)
  • Qlik Analytics Platform (new)
  • Qlik Web Connectors
  • Qlik SAP Connector (new)
  • Qlik DataMarket
  • Test and Development options for most products are also now available

Nearly all parts of your Qlik estate can now be covered on a subscription model, and there are ways to migrate to that model if you desire.

This is great news and fulfils the desires we set out in our previous blog post on this topic.  At Ometis, we hope there will always be flexible options to meet the needs of all customers going forward.

If upfront purchase doesn’t suit and you don’t want ongoing subscription then always talk to us about finance options for a purchase of software. It’s always worth giving us a call to discuss your requirements, as we pride ourselves on providing bespoke services that are tailored to suit your business’ needs.

That includes defining which products and services will be best utilised by your business in order to help you make informed decisions that ultimately provide a competitive advantage. The type of industries you’re working in will ascertain which services and products are best suited to ensure you gain that competitive advantage and with the subscription model, there are less barriers in accessing the innovative Qlik Sense platform.

That’s why we feel the subscription model is an exciting move made by Qlik, as it not only makes the platform much more accessible to business owners across the country, it does so in a much more malleable format. While other vendors have a subscription-first policy, Qlik has very clearly stated that the subscription model released is about giving consumers the choice. So, regardless of your preference in licencing strategy we have an option to suit.

That said, once you’ve experienced Qlik Sense and enjoyed accessing your business data on a granular level, we’re sure it will change the way you make decisions and therefore we’ll adapt to that situation for you as and when it arises.
By Andy Patrick

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

Did you see us at IP EXPO?

For the second year in a row, we attended IP EXPO as Europe’s largest enterprise event headed to the Excel centre in London this October.

There we were joined by members of the Qlik UK team, including Paul Winsor. Paul is Qlik’s Director of Retail & Services Market Development and he hosted a seminar session on day one that investigated the value of IoT data.

His talk went down a storm and there wasn’t a spare seat inside the Analytics Theatre as he explained the challenge of making IoT data accessible and understandable. That’s no small task considering there’s going to be anything from 50 to 200 billion IoT devices being utilised by 2020 (that’s around 20x more connected devices per person than today).

As it happens, Paul put people’s minds at rest by explaining the crucial role Qlik is likely to play in the digestion and dissemination of this data… thanks Paul!

Main-image

I do think Paul’s talk was one of the best seminar sessions at the event, but you may call me biased. It’s true there was plenty of expert opinion and knowledge around analytics, IoT and key factors in the understanding and capturing of business data. That said, we all know Qlik are the leading experts when it comes to understanding business data and Ometis are the UK’s largest dedicated Qlik provider. By default, I feel that makes us the leading BI experts in the country but if you want more proof, then please don’t hesitate to get in touch!

Overall, we joined more than 300 exhibitors at the event which was bursting with CIOs, heads of IT and heads of insight. That’s why it’s become such an important part of the Ometis calendar and one we do not want to disappoint at. And we certainly didn’t disappoint this year. Whether it was my excellent humour, Andy’s tight trousers or Chris’ youthful good looks, we were lucky enough to meet hundreds of people, all of whom were interested in learning more about Qlik’s innovative platform.

Then again, it could have been the free mints, pens and bottle openers!

By Neil Thorne

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 June 2017 Release – First Impressions

For those of you who follow Qlik closely, you’ll have noticed that the Qlik Sense June 2017 (or 17.06) Technical Preview has been released. This is the first in the new release naming convention and cadence – now five times per year.

Having seen it demonstrated at Qonnections, we were excited to get our hands on it. So as soon as it came out I installed the Desktop version to start familiarising ourselves with the new features. The data I decided to use was the electricity generated by the solar panels on my home roof which is logged at 15-minute increments.

The first thing you’ll see when loading data in is a range of new options in the Data Manager…

Measure Suggestions & Tools

Qlik Sense June 2017 Release 1

Here you can see that Qlik Sense has recommended the selected field should be a measure and shown a histogram of the frequency of values in that field – including the min, median, average and max statistics. Qlik Sense has also suggested that, since this has numerical values they could be put into buckets. All of this can be customised, but Qlik Sense makes some good guesses.

Dimension Suggestions & Tools

Qlik Sense June 2017 Release 2

In this screenshot, you can see what analysis – range and uniqueness – and options – the split tool – Qlik Sense presents when you select a dimension field. The split tool allows you to break a dimension field down, which is common for things like date/time fields, phone numbers or composite keys in source data.

(Yes, I know the split location looks wrong – that’s what I had to do to make the preview look right – I’ve logged a bug about that)

If you select a field that has fewer distinct values, you get a different set of tools:

Qlik Sense June 2017 Release 3
Here you can see that I have the choice to replace values in the DayofWeek field – perhaps I want to group my Sat & Sun into one value called “Weekend” – I can do that here.

Qlik Sense June 2017 Release 4
I can null values if I want to ignore those in a chart for some reason – here I’ve done that with some errors from the source data.

Qlik Sense June 2017 Release 5
And here’s how you set custom sort orders – drag & drop interface for setting the default sort order.

Please note that not every combination of these tools works with every other one – for instance you can do Order & Split together but not Nullify/Replace with Order.

What’s going on behind the scenes?

With all this in the data manager, what’s going on in the Data Load Editor? The script that Data Manager generates is all there and viewable – locked by default.

Qlik Sense June 2017 Release 6
New chart types

Once you’ve got your data imported using this new interface, you’ll see some three new charts you can use:

Qlik Sense June 2017 Release 7
Histogram – you just select a numerical field and it shows you the frequency distribution of values. You can customise the buckets (number or size of them), but that’s about it – so there will be scenarios where you want to use the buckets in the data load and a bar chart to achieve histogram-like charts with more flexibility.

Qlik Sense June 2017 Release 8
Box plot – this is something that has been much-requested – especially by the statisticians among us. While I’m not a statistician, I can see the value here. You select a couple of dimensions and a measure and it will do the box plot for you. You can choose from Standard (Tukey), Percentile-based or Standard deviation as presets or you can customise your own:

Qlik Sense June 2017 Release 9
In this case I chose to use the percentiles preset, setting the whisker lines at the 1st and 99th percentiles with the box ends at the 1st and 3rd quartiles and the line being the median. The dots are the “outliers” – there tends to be at least one each month as I only have 14 months of data in there so there are only up to 62 days for analysis, so they’re effectively the minimum and maximums within the months.

qlik-sense-june-2017-release-10-e1497954761945.png
Distribution Plot – a simpler, less statistical, chart that, similarly to the box plot takes a dimension or two and a measure. Here we can see each day’s generation plotted in its month, visualising the minimum, maximum and range of each month.

Consistent Colours for Dimensions

Qlik Sense June 2017 Release 11
Qlik Sense June 2017 Release 12
Enhancing the “Colour by dimension” functionality, here we can see that I’ve set custom colours for the months, inspired by someone with synaesthesia who sees the months as these colours. For example, this could be useful in your sales performance app – setting a consistent colour for each salesperson to be used across the app.

Not yet reviewed

There are a few things we’ve not covered here because we’ve not had enough time to test them just yet:

  • iOS app including offline support – we’ve got this installed and are starting to test it now.
  • Advanced Analytics, including R integration. Qlik have just published the details of setting this up – we’ve got it running but want to work with it a little more before sharing our thoughts.
  • Platform component updates – in this blog we’re been looking at the end-user experience, but the removal of the requirement for a single “central node” certainly looks interesting and a good step forward for resilience. The Enterprise Mobility compatibility (MobileIron, AirWatch & Blackberry) will certainly appeal to some of our more security-and-mobility focussed customers too.

Summary

This is a really exciting release of Qlik Sense – great new features across the board serving the end users, power users, enterprises, IT administrators and more. We can’t wait to get our hands on the other features we’ve not been able to test yet and the final release when it comes out.

Next steps

Most people should now wait until the final release to get these features and then look to upgrade at that point. However, if you’re a Qlik customer and keen to get hands on, you can also join the Technical Preview that will run until 26 June. To do this, just visit the community page and register. Health warning: this isn’t recommended for anything approaching a Production environment and it may stop working altogether after the 26 June deadline and/or you may have to uninstall it completely before being able to upgrade to the final release when that comes out.

Some useful pages in that community include:

  • What’s New – a good summary of the new features, although lacking in a little detail so some can be hard to find! Also note that it’s listing some items that aren’t actually new in this release of Qlik Sense – like new Web Connectors and Qlik Sense Cloud features.
  • Advanced Analytics video – first half of this shows some of the things the R integration will be able to do.

 

Alex Walker
Service Delivery Manager

NPrinting 17.2 Review – Three Steps Forward and One Step Back

For those who don’t already know, Qlik NPrinting is a content distribution tool for the Qlik Platform. It enables the distribution of static reports in various widely-used formats such as Word, PowerPoint and HTML.

A brief history

NPrinting 17 (NP17) is the result of the project code-named “Opera” – which was started before Qlik acquired Vizubi and finally came to fruition early in 2016. It’s fair to say the first two releases (17.0 and 17.1) weren’t quite ready for primetime, but 17.2 is a great step forward in reliability as well as functionality.

The NPrinting story so far…

  • 17.0 was the first release in the series – introducing web-based management of reports, schedules and related items. In version 16 and before this had all been done through a Windows application.
  • 17.1 introduced initial compatibility with Qlik Sense (QS). Previously it was a QlikView-only product and it became known as “Qlik NPrinting” not “QlikView NPrinting” at this point.
  • 17.2 was mostly a stability and performance release, but did also re-introduce the On-Demand functionality for QlikView (QV).

I’ve worked with NPrinting since 2012 (when it was Excel-only and being developed by Vizubi) and I have the honour of being the first ever certified NPrinting developer! I’ve been using 17.2 for the last couple of months and, combined with my experiences around earlier releases, here is my considered opinion.

nprinting-image-1
Alex being presented his NPrinting Developer Certificate by Vizubi’s Aran Nathanson,
now Qlik NPrinting Product Manager.

New architecture and delivery mechanisms

NPrinting 17 is a massive step forwards in terms of enterprise architecture – adding web-based management and report consumption, multi-user capabilities including permissions management. It keeps the familiar flexible structure of previous releases with Connections, Tasks, Reports, Filters and so on.

nprinting-1
The new NPrinting 17 web interface.

It adds two new distribution methods:

  1. NPrinting NewsStand – here users can see which reports they have access to and can subscribe to have them generated and/or sent to them on a schedule of their choosing.
  2. Qlik Sense Hub – you can push NPrinting reports into the Qlik Sense Hub so users have one place to go to consume all of their Qlik information. (Note: QlikView Publisher can do this now too – heading towards what Qlik are calling the “Unified Hub”.) The process for getting this up and running isn’t exactly slick, but once done, it’s a useful additional delivery mechanism.

nprinting-2
The Qlik Unified Hub – Qlik Sense, NPrinting & QlikView.

Additional compatibility

“Qlik Sense compatibility” is more true for this release than it was for 17.1 (where you’d often have reports fail if based on QS), but it still doesn’t come with all the functionality of the QlikView side of the tool.

The Select Objects dialog has improved with 17.2, now showing the IDs that you can (if no other way than via the dev hub single configurator) trace back to objects in the Qlik Sense app – which may be useful if you haven’t or can’t set a Name.

nprinting-3

One of the main limitations remains – that you don’t get to see previews of the Qlik Sense objects when you drop them into your template. Instead you just get a generic icon which can make designing your reports quite tricky.

nprinting-4

That said, when you do view a report, they look great. No issues with scaling here: since Qlik Sense has a fully responsive interface, the objects you embed flex as you resize them to fit your slide, document or web page…

nprinting-5
Example PowerPoint report with Qlik Sense objects embedded.

What’s missing?

As you can see from the three major releases this year, Qlik are actively developing NPrinting and I’m sure they have these ideas in mind, but here are some of the things I think should be on the roadmap:

  • Previewing of Qlik Sense objects in reports. As identified above, this is probably the most limiting factor right now.
  • Embedding reports into HTML emails. This was one of my favourite things in NPrinting 16 – embed the actual chart / KPI etc. in an email so the end user doesn’t even have to open an attachment! Unfortunately, whilst the help says this is possible, it’s not (yet).
  • Importing recipients from somewhere other than an Excel file. We have made extensive use of the ability to import from a QlikView object. There are workarounds to this but we’d love to see this re-introduced in NP17 for QV and QS.
  • Simplifying the process for adding reports to the Qlik Sense Hub and integration with the Qlik Sense QMC for user management and so on.

The conclusion

NPrinting has a special place in my heart and I have definitely skimmed over some of its amazing features that I’ve taken for granted over the last four years. So my advice is this:

  • If you’re a current NPrinting 16 user and you only have QlikView in your estate, then you might be better off sticking with NPrinting 16 for the time being. The main reason I can see to consider upgrading here would be if you need a multi-node environment to cope with the sheer volume of reports you distribute or to make use of the NewsStand feature.
  • If you’ve got a mixture of QlikView and Qlik Sense then I think that NP17 is worth a shot now it’s stabilised. Definitely check the features you need and trial it before making a decision on which version to use.
  • In a purely Qlik Sense environment, you’ve not got a choice – I’d just say be cautious about what you promise to deliver in tight timeframes as there is a learning curve as well as more improvements to come down the line. Again, trial it in your environment to see if it works for you.

For more information on NPrinting, please visit our product page where you can request a demo to find out how it can enhance your Qlik experience. We also have an NPrinting training session coming up on 23rd February 2017 – call us on 0330 363 9900.

Alex Walker
Service Delivery Manager

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