Data modeling in Qlik Sense
This training is designed to help you master the art of data processing in Qlik Sense and learn about the strengths and uses of the unique Qlik Data Model. The training covers key data processing techniques – reading, merging, cleaning, repairing, and filtering data, and includes a series of exercises based on real-life examples. You will also get acquainted with best practices and techniques used by data leaders in other companies worldwide.
Duration
16 hours
Level
intermediate
Training type
open | online
Price
900 EUR
Duration
16 hours
Level
intermediate
Training type
open | online
Price
900 EUR
Learn how to:
Read data using Qlik script
Ensure the accuracy of data and user conclusions
Clean, enrich, generate, and group data
Combine multiple data sets, e.g. sales and budget
Use tricks to meet user needs
Troubleshoot common data handling issues
Improve data processing speed
Connect to various data sources
Submit for the upcoming trainings!
Data modeling in Qlik Sense
Level: intermediate | Duration: 16 hours
Content
- Working with Qlik script
- Connecting to data sources
- Design and advantages of the associative data model
- Types of data models, fact tables, and masterdata tables
- Solving common data issues
- Combining data from multiple sources (Excel, CSV, XML, databases)
- Merging data (Join, Concatenate)
- Various ways of limiting imported data (Where, Exists, Keep)
- Generating data (Mapping, Resident, Preceding, Group By, Inline, IntervalMatch)
- Data modeling example: Linking budget to sales
- Data modeling example: Dynamic exchange rates
- Combining data with different granularity and value range
- Restricting access (row-based Section Access)
- Creative use of Section Access, data island
- Storing processed data, working with QVDs
- Incremental data reading and storage
- Additional commands and script control statements
- Exporting the created app after the training for reference