BI with QlikView: Data Modeling


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
QlikView offers various functionalities to help you perfect your data model. In this course, you will learn about these functions and different types of data models. It also covers best practices, as well as the challenges that you can face along the way. This course contains an in-depth look at dimensional modeling and the processes involved.

Target Audience
Business users and professionals looking to learn how to use QlikView to create BI visualizations in QlikView

Prerequisites
None

Expected Duration (hours)
2.7

Lesson Objectives

BI with QlikView: Data Modeling

  • start the course
  • identify the different data modeling types and their characteristics
  • work with and understand the QlikView script editor
  • work with QlikView table viewer
  • use joining and linking tables
  • recognize when to use concatenation
  • identify synthetic keys and synthetic tables
  • identify circular references
  • optimize QVD Loads
  • use mapping statements
  • use entity relationship diagrams (ERD)
  • use transactional tables
  • work with dimensional models
  • use dimension tables
  • use fact tables
  • recognize null values
  • understand how |w null values are displayed in QlikView documents
  • Work with null values in QlikView
  • identify normalizing and denormalizing dimensions
  • work with conformed dimensions
  • create surrogate keys
  • use the 4-step dimensional design process
  • demonstrate the best practices used when creating a QlikView data model

    • Course Number:
    df_biwq_a02_it_enus

    Expertise Level
    Beginner