QSDA2018: Qlik Sense Data Architect Certification Exam

What’s included

$14.99 / $24.99

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.

4.59

Pay once, own it forever

Video Courses

Introduction

Lectures	Duration
1. Introduction	2m 24s

1. Introduction

2m 24s

Qlik Sense Introduction

Lectures	Duration
1. Qlik Sense Architecture	1m 45s
2. Qlik Sense Tour	2m 59s

1. Qlik Sense Architecture

1m 45s

2. Qlik Sense Tour

2m 59s

Environment Setup

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

1. Qlik Sense Desktop Installation

1m 56s

2. Course Folder Structure

1m 18s

Introduction to Qlik Sense Scripting

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

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

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

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

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

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

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

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

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

1. Master Calendar Fundamentals

3m 22s

2. FieldValue Function and Flags

4m 28s

3. Create a Master Calendar

9m 20s

Mapping Tables

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

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

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

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

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

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

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

1. QVD Fundamentals

6m 29s

2. Creating QVD Files

6m 17s

3. Optimized QVD Load

5m 49s

Set Analysis

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

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

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

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)

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

1. Introduction to On Demand App Generation

6m 48s

2. On Demand App Generation Example

9m 7s

Tips & Tricks

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

1. Optimized QVD Load

2m 37s

2. How to Load Data from a SharePoint List

4m 22s

QSDA2018: Qlik Sense Data Architect Certification Exam

What’s included

Pay once, own it forever

Introduction

Qlik Sense Introduction

Environment Setup

Introduction to Qlik Sense Scripting

Synthetic Keys

Adding Flat Files

Dealing with Data Model Challenges - Part I

Master Calendar

Mapping Tables

Data Model Optimization

Dealing with Data Model Challenges - Part II

All about QVD Files

Set Analysis

Access

On Demand App Generation (ODAG)

Tips &amp; Tricks

Tips & Tricks