EMARK Academy
Emark Academy provides education in the areas of Qlik Sense functions, usage, and administration together with analytics skills development.New Emark Academy will be introduced in Autumn 2024.
Since our formation in 2000, we have grown into a recognized innovation hub for data analytics and business intelligence (BI).
We focus on Qlik technologies, but we also develope our own BI solutions. We have already completed projects for more than 200 companies of various sizes and focuses coming from 11 countries in Europe and around the world.
EMARK consists of a team of 50 experts who can advise and help with every aspect in Qlik technology. This is one of the reasons why we hold the status of Qlik Master Reseller, the highest level of partnership with Qlik.
Customized training is availabe upon agreement. Please use the form below.
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