Data modeling with Qlik Sense

Develop applications in Qlik Sense using scripts

Learn how to build an optimized data model structure by loading and transforming multiple data sources. This course includes topics on: connections to different sources, data cleansing and transformation, troubleshooting data models, using QVD files, and developing applications on the Qlik Sense server.

Duration
20 hours (4 hrs daily)

    Request Information

      Request Information

      Objectives

      • Creating a data model in Qlik Sense
      • Using the load editor and data manager
      • Create and maintain data connections
      • Resolving data structure problems and script errors
      • Transforming data for better performance
      • Discussing synthetic keys and circular references
      • Add dimensions and measures to the master catalog

      Agenda

      • Basic concepts of data modeling
      • Data load editor environment
      • Data connections
      • Script structure
      • Data loading and transformations
      • Data troubleshooting
      • Generate data with script
      • Debugging a data load
      • Data model and scripting challenges
      • Synthetic keys, table record counts, and references.
      • Advanced calculations
      • Performance considerations
      • Security management with SectionAccess

      Addressed to

      • Data architect

      Requirements

      • Basic knowledge of database management systems (Oracle, SQL, etc).
      • Basic knowledge of QlikSense
      See more courses
      Qlik Cloud Assistant