QSDA2018: Qlik Sense Data Architect Certification Exam

Curriculum For This Course

Introduction

1Lectures

Time 00:02:00

Qlik Sense Introduction

2Lectures

Time 00:05:00

Environment Setup

2Lectures

Time 00:03:00

Introduction to Qlik Sense Scripting

9Lectures

Time 00:27:00

Synthetic Keys

5Lectures

Time 00:15:00

Adding Flat Files

11Lectures

Time 00:28:00

Dealing with Data Model Challenges - Part I

8Lectures

Time 00:29:00

Master Calendar

3Lectures

Time 00:16:00

Mapping Tables

6Lectures

Time 00:20:00

Data Model Optimization

8Lectures

Time 00:29:00

Dealing with Data Model Challenges - Part II

8Lectures

Time 00:38:00

All about QVD Files

3Lectures

Time 00:18:00

Set Analysis

10Lectures

Time 00:41:00

Access

10Lectures

Time 01:03:00

On Demand App Generation (ODAG)

2Lectures

Time 00:16:00

Tips & Tricks

2Lectures

Time 00:07:00

Introduction
	1. Introduction	02:24

Qlik Sense Introduction
	1. Qlik Sense Architecture	01:45
	2. Qlik Sense Tour	02:59

Environment Setup
	1. Qlik Sense Desktop Installation	01:56
	2. Course Folder Structure	01:18

Introduction to Qlik Sense Scripting
	1. Data Load Editor	03:26
	2. Connect, Extract, Load	05:02
	3. Load Fact Tables	05:46
	4. Challenge - Load Fact Table	01:07
	5. Solution - Load Fact Table	01:50
	6. Basic Transformations	03:17
	7. Challenge - Basic Transformations	00:43
	8. Solution - Basic Transformations	02:01
	9. Script Debugging	03:57

Synthetic Keys
	1. Synthetic Keys Basics	03:22
	2. Loading Dimension Tables	03:04
	3. Challenge - Synthetic Key	02:30
	4. Solution - Synthetic Key	02:17
	5. Data Model Viewer	04:51

Adding Flat Files
	1. Load Excel Files	03:38
	2. Challenge - Load Suppliers Table	01:12
	3. Solution - Load Suppliers Table	01:24
	4. Challenge - Qualify Statement	03:20
	5. Solution - Qualify Statement	01:51
	6. Variables	06:51
	7. Challenge - Variables	01:21
	8. Solution - Variables	01:43
	9. Include Files	04:35
	10. Challenge - Include Files	00:45
	11. Solution - Include Files	01:10

Dealing with Data Model Challenges - Part I
	1. Using Record Counters	03:21
	2. Challenge - Record Counters	01:15
	3. Solution - Record Counters	04:10
	4. WHERE Clause	03:39
	5. Resident Load	06:44
	6. WHERE EXISTS Clause	05:22
	7. Challenge - WHERE EXISTS	01:38
	8. Solution - WHERE EXISTS	02:43

Master Calendar
	1. Master Calendar Fundamentals	03:22
	2. FieldValue Function and Flags	04:28
	3. Create a Master Calendar	09:20

Mapping Tables
	1. Mapping Load Fundamentals	03:47
	2. Add Mapping Tables	05:34
	3. Challenge - Mapping Table	00:37
	4. Solution - Mapping Table	03:42
	5. Challenge - Preceding Load	03:21
	6. Solution - Preceding Load	02:01

Data Model Optimization
	1. Joins Deep Dive	06:03
	2. Challenge - Join tables	04:30
	3. Solution - Join tables	01:55
	4. Concatenation	04:23
	5. Implicit and Forced Concatenation	05:51
	6. Challenge - Concatenate	00:50
	7. Solution - Concatenate	02:40
	8. Consolidate Fact Tables	02:03

Dealing with Data Model Challenges - Part II
	1. Circular Reference	01:39
	2. Cross table	03:41
	3. Add Cross table	02:56
	4. Link table	04:30
	5. Create a Link Table	09:56
	6. Class function	03:08
	7. Solution - Class Function	02:23
	8. Interval Match	08:45

All about QVD Files
	1. QVD Fundamentals	06:29
	2. Creating QVD Files	06:17
	3. Optimized QVD Load	05:49

Set Analysis
	1. Set Analysis Fundamentals	12:00
	2. Create a Chart with Set Expression	05:45
	3. Challenge - Set Modifier	01:02
	4. Solution - Set Modifier	03:22
	5. Aggr()	07:04
	6. Challenge - Set Analysis with Aggr()	00:51
	7. Solution - Set Analysis with Aggr()	03:48
	8. FirstSortedValue Function	03:50
	9. Challenge – FirstSortedValue	11:25
	10. Solution – FirstSortedValue	02:15

Access
	1. Introduction	01:54
	2. Chapter Goals	10:36
	3. Layers of Security	07:13
	4. ABAC vs RBAC	03:02
	5. Authentication vs Authorization	03:43
	6. Why Section Access?	05:01
	7. Section Access Basics	10:09
	8. Section Access - App Authorization	08:32
	9. Troubleshooting App Lockdown	11:25
	10. Section Access - Data Authorization	11:00

On Demand App Generation (ODAG)
	1. Introduction to On Demand App Generation	06:48
	2. On Demand App Generation Example	09:07

Tips & Tricks
	1. Optimized QVD Load	02:37
	2. How to Load Data from a SharePoint List	04:22

Free QSDA2018 Exam Questions & QlikView QSDA2018 Dumps
Qlikview.passcertification.qsda2018.v2025-02-06.by.tareq.30q.ete	Downloads: 129	Size: 2.91 MB
Qlikview.selftesttraining.qsda2018.v2021-03-23.by.eliska.30q.ete	Downloads: 1534	Size: 2.65 MB
Qlikview.pass4sures.qsda2018.v2019-11-16.by.nicholas.28q.ete	Downloads: 2042	Size: 2.71 MB

Student Feedback

4.4

Good

42%

58 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Pass IT Certication Exams Guaranteed!

Curriculum For This Course

Free QSDA2018 Exam Questions & QlikView QSDA2018 Dumps

Student Feedback

Add Comments

Get Premium Membership

Pass IT Certication
Exams Guaranteed!