Great introduction to the new version. I am just getting started with Qlik Sense and this update seems to make the data modelling process much more 'new' user friendly. Having no coding/SQL/data modelling background and only 5 days training on the software, I was finding it difficult to get my head around the back end creating my data model.
I have been tasked with getting this software up and running in my current company with some complex reporting requirements using a variety of data sources 'live' linking into the system. I had suggested getting some help from someone with relevant experience however I was wondering how far someone could get with the system using the new visual data modelling and at what stage would coding experience become a necessity when creating apps?
Look forward to the next session.
Hi Nicholas, thanks for the note.
Being Qlik products take the data from the source (usually in the form of the complete table or selected columns), and loads it into its indexed engine, you will rarely if ever - need to script any sort of data access. We do allow the ability to combine sources manually using JOIN syntax, but these are usually used when creating a file (known as a QVD) - which is used to speed up and facilitate the reload process of an app.
However, data augmentation and transformation etc can occur at the data model level using the Data Manager, in the Chart Objects (Using Chart Expressions), in the Master Items section of the chart (data dictionary) and also at the script level. Below are some examples when script would become necessary just to give you an idea. Please note, in regards to "live linking" - I assume you mean real-time - passing queries to the live data? - If so then we do use some script for what is known as Direct Discovery - this enables a Hybrid approach.
- A Beginners' Introduction to Set Analysis (video)
- Power of Qlik Script - Reshaping Data with Crosstable (video)
- Qlik Sense in 60 - The Class() Function - YouTube
- Qlik Sense in 60 - The Aggr() function - YouTube
- Qlik Sense in 60 - Circular Reference - YouTube
- Qlik Sense in 60 - Synthetic Keys - YouTube
- https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/DirectDiscovery/access-large-data-sets-with-direct-discover… (Direct Discovery topic)
Hi Nicholas - yes - as the event team coordinates them they will be scheduled. I do a Standard live webinar every Thursday at 2PM EST - the content is somewhat repeated but I mix it up a bit and it provides a great opportunity to ask questions. You can sign up here: Getting started with Qlik Sense Desktop - I'll be presenting today as well.
Another Webinar you might be interested in is this one:
Reach out anytime.