Data Modeling

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

Prerequisite
None

Expected Duration
159 minutes

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.

Objective

QlikView Data Model

  • 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

Dimensional Modeling

  • 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

Practice: QlikView Data Modeling Best Practices

  • demonstrate the best practices used when creating a QlikView data model

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.