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.

$14.99 / $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