• Online, Self-Paced
Course 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.

Learning Objectives

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 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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.