• Online, Self-Paced

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 NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • All-Source Analysis

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.

Feedback

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