QlikSense Data Architect Masterclass
4.4 (887 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,197 students enrolled

QlikSense Data Architect Masterclass

The Qlik Sense Developer Bootcamp
4.4 (887 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,197 students enrolled
Last updated 4/2020
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 1 article
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create a data model in QlikSense
  • Create and maintain data connections
  • Develop and debug QlikSense script
  • Cleanse and transform source data
  • Resolve data model issues
  • Optimization for performance
  • Create and use Qlik Data Files (QVD) files
  • Manage security with Section Access
Requirements
  • Qlik Sense Desktop tool
  • Basics of SQL
Description

Welcome to QlikSese Data Architect Masterclass. In this course, you will master skill to develop associative data models in Qlik Sense from scratch.

In this brand new QlikSense masterclass, you will learn step-by-step to cleanse, transform, and unify data from multiple disparate sources using June 2018 release version and its features.

You will build optimized associative data model using powerful ETL scripting and learn how to deal with complex data integration challenges.

Throughout the course, with hands-on examples and challenges, you will master QlikSense developer skill to build a data model which business analysts can use to build insight driven, self service applications for your enterprise.

QlikSense data architect masterclass topics include: data connections, cleansing and transforming source data, resolving data model issues, optimization for performance, using QlikView Data Files (QVD) files and data model security.

This course is designed so that anyone can learn how to develop data models in Qlik Sense!

Who this course is for:
  • Beginner QlikSense developers interested in mastering scripting to build a data model
  • QlikView developers who are interested in mastering scripting in QlikSense
Course content
Expand all 94 lectures 06:19:15
+ Qlik Sense Introduction
2 lectures 04:44
Qlik Sense Architecture
01:45
Qlik Sense Tour
02:59
+ Environment Setup
2 lectures 03:14
Qlik Sense Desktop Installation
01:56
Course Folder Structure
01:18
+ Introduction to Qlik Sense Scripting
9 lectures 27:09
Data Load Editor
03:26
Connect, Extract, Load
05:02
Load Fact Tables
05:46
Challenge - Load Fact Table
01:07
Solution - Load Fact Table
01:50
Basic Transformations
03:17
Challenge - Basic Transformations
00:43
Solution - Basic Transformations
02:01
Script Debugging
03:57
Introduction to Qlik Sense Scripting
5 questions
+ Synthetic Keys
5 lectures 16:02
Synthetic Keys Basics
03:22
Loading Dimension Tables
03:03
Challenge - Synthetic Key
02:29
Solution - Synthetic Key
02:17
Data Model Viewer
04:51
Synthetic Keys
5 questions
+ Adding Flat Files
11 lectures 27:48
Load Excel Files
03:38
Challenge - Load Suppliers Table
01:12
Solution - Load Suppliers Table
01:24
Challenge - Qualify Statement
03:20
Solution - Qualify Statement
01:50
Variables
06:51
Challenge - Variables
01:21
Solution - Variables
01:43
Include Files
04:35
Challenge - Include Files
00:45
Solution - Include Files
01:09
Adding Flat Files
6 questions
+ Dealing with Data Model Challenges - Part I
8 lectures 28:51
Using Record Counters
03:21
Challenge - Record Counters
01:15
Solution - Record Counters
04:10
WHERE Clause
03:39
Resident Load
06:44
WHERE EXISTS Clause
05:22
Challenge - WHERE EXISTS
01:37
Solution - WHERE EXISTS
02:43
Dealing with Data Model Challenges - Part I
5 questions
+ Master Calendar
3 lectures 17:09
Master Calendar Fundamentals
03:22
FieldValue Function and Flags
04:28
Create a Master Calendar
09:19
Master Calendar
5 questions
+ Mapping Tables
6 lectures 19:01
Mapping Load Fundamentals
03:47
Add Mapping Tables
05:34
Challenge - Mapping Table
00:36
Solution - Mapping Table
03:42
Challenge - Preceding Load
03:21
Solution - Preceding Load
02:01
Mapping Tables
5 questions
+ Data Model Optimization
8 lectures 28:14
Joins Deep Dive
06:03
Challenge - Join tables
04:30
Solution - Join tables
01:55
Concatenation
04:23
Implicit and Forced Concatenation
05:51
Challenge - Concatenate
00:49
Solution - Concatenate
02:40
Consolidate Fact Tables
02:03
Data Model Optimization
5 questions