+48 22 270 14 02 office@datawizards.pl

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

f

Use tricks to meet user needs

Troubleshoot common data handling issues

Improve data processing speed

Connect to various data sources

Contact us and find out the details!

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