Data modeling in Qlik Sense
The training provides an opportunity to learn how to develop and optimize effective data models to facilitate data analysis and visualization development, examining various data source integration, data transformation, and model optimization methods in the Qlik Sense environment, as well as demonstrating best practices in creating complex data structures.
Course target
Audience
At Course Completion you will be able to:
Prerequisites
Training materials
Electronic training materials available on Learning.qlik.com (access to the training environment is 180 days after the start of the course).
Certification exam
If you require formal proof of knowledge, you have the option to take the Qlik Qualification Exam (for an additional fee).
Course Outline
- Introduction to Data Modeling with Qlik Sense
- Data model principles and structure;
- Qlik Sense data model architecture.
- Data Source Integration
- Importing data from various sources;
- Creating and transforming data connections.
- Data Transformation and Cleaning
- Data filtering, renaming and merging;
- Application of functions and expressions in data preparation.
- Relationship and Key Management
- Key types and their meaning;
- Proper creation of table relationships.
- Model Performance Optimization
- Reducing the amount of data required;
- Caching and indexing methods.
- Qlik Sense Special Data Modeling Methods
- Link tables and intermediate table usage;
- Intermediate tables and data modeling techniques.
- QVD Files and Data Storage
- Benefits of using QVD;
- Efficient data storage and retrieval.
- Developing and Troubleshooting Complex Data Models
- Troubleshooting loops and syntax issues;
- Model testing and validation.
If you want to get more information about this course, please contact us by phone +371 67505091 or send an e-mail at mrn@bda.lv.
