QSDA2018: Qlik Sense Data Architect Certification Exam

QSDA2018: Qlik Sense Data Architect Certification Exam

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

$13.74 / $24.99

Introduction

  • 1. Introduction
    2m 24s

Qlik Sense Introduction

  • 1. Qlik Sense Architecture
    1m 45s
  • 2. Qlik Sense Tour
    2m 59s

Environment Setup

  • 1. Qlik Sense Desktop Installation
    1m 56s
  • 2. Course Folder Structure
    1m 18s

Introduction to Qlik Sense Scripting

  • 1. Data Load Editor
    3m 26s
  • 2. Connect, Extract, Load
    5m 2s
  • 3. Load Fact Tables
    5m 46s
  • 4. Challenge - Load Fact Table
    1m 7s
  • 5. Solution - Load Fact Table
    1m 50s
  • 6. Basic Transformations
    3m 17s
  • 7. Challenge - Basic Transformations
    43s
  • 8. Solution - Basic Transformations
    2m 1s
  • 9. Script Debugging
    3m 57s

Synthetic Keys

  • 1. Synthetic Keys Basics
    3m 22s
  • 2. Loading Dimension Tables
    3m 4s
  • 3. Challenge - Synthetic Key
    2m 30s
  • 4. Solution - Synthetic Key
    2m 17s
  • 5. Data Model Viewer
    4m 51s

Adding Flat Files

  • 1. Load Excel Files
    3m 38s
  • 2. Challenge - Load Suppliers Table
    1m 12s
  • 3. Solution - Load Suppliers Table
    1m 24s
  • 4. Challenge - Qualify Statement
    3m 20s
  • 5. Solution - Qualify Statement
    1m 51s
  • 6. Variables
    6m 51s
  • 7. Challenge - Variables
    1m 21s
  • 8. Solution - Variables
    1m 43s
  • 9. Include Files
    4m 35s
  • 10. Challenge - Include Files
    45s
  • 11. Solution - Include Files
    1m 10s

Dealing with Data Model Challenges - Part I

  • 1. Using Record Counters
    3m 21s
  • 2. Challenge - Record Counters
    1m 15s
  • 3. Solution - Record Counters
    4m 10s
  • 4. WHERE Clause
    3m 39s
  • 5. Resident Load
    6m 44s
  • 6. WHERE EXISTS Clause
    5m 22s
  • 7. Challenge - WHERE EXISTS
    1m 38s
  • 8. Solution - WHERE EXISTS
    2m 43s

Master Calendar

  • 1. Master Calendar Fundamentals
    3m 22s
  • 2. FieldValue Function and Flags
    4m 28s
  • 3. Create a Master Calendar
    9m 20s

Mapping Tables

  • 1. Mapping Load Fundamentals
    3m 47s
  • 2. Add Mapping Tables
    5m 34s
  • 3. Challenge - Mapping Table
    37s
  • 4. Solution - Mapping Table
    3m 42s
  • 5. Challenge - Preceding Load
    3m 21s
  • 6. Solution - Preceding Load
    2m 1s

Data Model Optimization

  • 1. Joins Deep Dive
    6m 3s
  • 2. Challenge - Join tables
    4m 30s
  • 3. Solution - Join tables
    1m 55s
  • 4. Concatenation
    4m 23s
  • 5. Implicit and Forced Concatenation
    5m 51s
  • 6. Challenge - Concatenate
    50s
  • 7. Solution - Concatenate
    2m 40s
  • 8. Consolidate Fact Tables
    2m 3s

Dealing with Data Model Challenges - Part II

  • 1. Circular Reference
    1m 39s
  • 2. Cross table
    3m 41s
  • 3. Add Cross table
    2m 56s
  • 4. Link table
    4m 30s
  • 5. Create a Link Table
    9m 56s
  • 6. Class function
    3m 8s
  • 7. Solution - Class Function
    2m 23s
  • 8. Interval Match
    8m 45s

All about QVD Files

  • 1. QVD Fundamentals
    6m 29s
  • 2. Creating QVD Files
    6m 17s
  • 3. Optimized QVD Load
    5m 49s

Set Analysis

  • 1. Set Analysis Fundamentals
    12m
  • 2. Create a Chart with Set Expression
    5m 45s
  • 3. Challenge - Set Modifier
    1m 2s
  • 4. Solution - Set Modifier
    3m 22s
  • 5. Aggr()
    7m 4s
  • 6. Challenge - Set Analysis with Aggr()
    51s
  • 7. Solution - Set Analysis with Aggr()
    3m 48s
  • 8. FirstSortedValue Function
    3m 50s
  • 9. Challenge – FirstSortedValue
    11m 25s
  • 10. Solution – FirstSortedValue
    2m 15s

Access

  • 1. Introduction
    1m 54s
  • 2. Chapter Goals
    10m 36s
  • 3. Layers of Security
    7m 13s
  • 4. ABAC vs RBAC
    3m 2s
  • 5. Authentication vs Authorization
    3m 43s
  • 6. Why Section Access?
    5m 1s
  • 7. Section Access Basics
    10m 9s
  • 8. Section Access - App Authorization
    8m 32s
  • 9. Troubleshooting App Lockdown
    11m 25s
  • 10. Section Access - Data Authorization
    11m

On Demand App Generation (ODAG)

  • 1. Introduction to On Demand App Generation
    6m 48s
  • 2. On Demand App Generation Example
    9m 7s

Tips & Tricks

  • 1. Optimized QVD Load
    2m 37s
  • 2. How to Load Data from a SharePoint List
    4m 22s