EMARK Tutorials
Take your Qlik expertise to the next level.
EMARK Tutorials
Gain practical knowledge on how to fully leverage the power of Qlik Sense. In this section, you’ll find short video tutorials guiding you through specific features, workflows, and useful tips for working with data efficiently.
We specialize in Qlik technologies and also develop our own BI solutions. We have delivered projects for more than 200 companies of various sizes and industries across 11 countries in Europe and around the world. The core of EMARK is a team of experts ready to support you with all aspects of Qlik solutions. Thanks to this, we are proud holders of the Qlik Master Reseller status – the highest level of partnership with Qlik.
Our Qlik-based solutions deliver measurable results, help optimize operations and processes, and eliminate inefficiencies.
Custom training is also available upon request – just reach out via the form below.
Overview of tutorials
Course overview
Data literacy
Spring 2024
4 hours
Enterprise
Qlik Sense Basics - Analyzer License
Spring 2024
4 hours
Enterprise
Data Analysis in Qlik Sense - Self-Service
Spring 2024
2 x 4 hours
Enterprise
Data Analysis in Qlik Sense - Advanced
Spring 2024
2 x 4 hours
Enterprise
Qlik Sense Data Manager - Self-Service
Spring 2024
2 x 4 hours
Enterprise
Qlik Sense Data Modelling - Advanced
Spring 2024
3 x 4 hours
Enterprise
What will you learn in the courses?
Data Literacy
The training is suitable for both newcomers to Qlik and participants with minimal experience with data analytics tools. This is the analytical minimum, and the training is suitable for a non-technical position or a new employee getting familiar with the discipline and Qlik Sense.
The training assumes familiarity with contingency tables in Excel (Office 365).
Agenda
- Tables, data preparation, data quality
- Contingency tables, dimensions and metrics, data aggregation, aggregation functions
- Data sessions, VLOOKUP
- Analytical workflow (MS Excel + MS PowerPoint -> analytical tools)
Qlik Sense Basics - Analyzer License
Suitable for new employees, newbies to Qlik, employees in new positions requiring interaction with Qlik Sense or for employees who have not worked with Qlik Sense for a long time and need to refresh basic knowledge and skills – familiarization with the Qlik Sense environment.
Agenda
- Introduction to Qlik Platform
- Qlik Introduction
- Query-based approach vs Qlik
- In-memory and associative data model
- Qlik Sense Enterprise (SAAS)
- Navigation in the Qlik Sense app environment
- Colour codes in Qlik Sense (Power of grey)
- Filter options (Selection tool, History of filters)
- Search
- Bookmarks
- Team cooperation
- Easy object editing (outside "Edit mode")
- Sharing analysis results in Qlik Sense (Story telling)
Data Analysis in Qlik Sense - Self-Service
Suitable for employees who have already taken the QS Basics course and want to move up in data analytics in Qlik Sense or need to refresh their skills and knowledge to be able to manage their own analytics requirements in Qlik Sense.
Agenda
- QS Hub - application copying, publications
- Navigating in the QS application environment
- Colour codes in Qlik Sense (Power of grey)
- Qlik Sense Insights and their usage
- Qlik Sense objects and their attributes
- Master items: dimensions, metrics and visualizations creation; Maps in Qlik Sense
- Qlik Sense application design - DAR methodology
- Object creation with predefined metrics, modification of existing objects
Data Analysis in Qlik Sense - Advanced Authoring
Suitable for employees who have already taken the Data Analysis – self-service course and want to take their data analytics skills to a more advanced level or need to refresh their skills and knowledge to be able to manage their own needs for more advanced data analytics in Qlik Sense.
Agenda
- Set analysis
- Time series, month-on-month and year-on-year comparison
- Use of specific aggregation functions
- Advanced data processing functions (Aggr, Class, Pick...)
- Comparative analyses (Alternate States, SET analysis 1-$)
- Qlik Sense Extensions
Qlik Sense Data Manager - Self-Service
Suitable for employees who want to learn the basics of the Qlik Sense data model and want to gain the basic skills and abilities to be able to use Data Manager to create a data model, understand the operating principle of Qlik Sense, or gain an understanding of how this BI tool works.
Agenda
- Data addition - new data sources
- Data association - model creation
- Data model Viewer
- Merging tables (Concatenate)
- Joining tables (Join)
- Unpivot
- Table editing - expressions, bucketing, etc.
Qlik Sense Data Modelling - Advanced Authoring
Suitable for employees who have already taken the basic Qlik Sense Data Manager – Self-Service course and want to take their data modelling skills to the next level. Suitable for future developers or existing developers who need to refresh their basic skills and competence in Qlik Sense and application script preparation after a long period of time.
Agenda
- Schemas and data model creation
- Qlik Sense data architecture
- Script creation basics
- Table loading from different files (Access, Excel, txt, xml, direct load...)
- Conflicts in model building and their solutions
- Data model Viewer
- Resident load
- Load with the WHERE condition
- Mapping Load
- Load on a Load
- Data model optimization
- Variables
- Master Calendar – work with dates
- Data Modelling best practices: flags, drop, store, loading currency exchange rates from web page, loading contingency table
- Categorization of values
- Link Table a Concatenate
- Data transformation: incremental load (incremental loading), missing data
- Metadata
- Minimizing memory requirements
- Loops
- Reload monitoring (Debug, Trace)
- Security
- Subroutines