Home

All courses

QlikSense Data Architect Masterclass

Qlik Sense

Business

Business Analytics & Intelligence

QlikSense Data Architect Masterclass

The Qlik Sense Developer Bootcamp

4.3

(2104)

7877 enrolled on this course

Last updated 11/2021

Vertechs .IO

₹ 7900.0

₹ 9400.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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

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

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction

1.2-Course Curriculum Overview

1.3-The Course Approach

2-Qlik Sense Introduction

2.1-Qlik Sense Tour

2.2-Qlik Sense Architecture

3-Environment Setup

3.1-The Qlik Sense Desktop Installation

3.2-Unlock Qlik Sense Desktop - Part I

3.3-Unlock Qlik Sense Desktop - Part II

3.4-Course Folder Structure

4-Introduction to Qlik Sense Scripting

4.1-Data Load Editor

4.2-Connect, Extract, Load

4.3-Load Fact Tables

4.4-Challenge - Load Fact Table

4.5-Solution - Load Fact Table

4.6-Basic Transformations

4.7-Challenge - Basic Transformations

4.8-Solution - Basic Transformations

4.9-Script Debugging

4.10-Introduction to Qlik Sense Scripting

5-Synthetic Keys

5.1-Synthetic Keys Basics

5.2-Loading Dimension Tables

5.3-Challenge - Synthetic Key

5.4-Solution - Synthetic Key

5.5-Data Model Viewer

5.6-Synthetic Keys

6-Adding Flat Files

6.1-Load Excel Files

6.2-Challenge - Load Suppliers Table

6.3-Solution - Load Suppliers Table

6.4-Challenge - Qualify Statement

6.5-Solution - Qualify Statement

6.6-Variables

6.7-Challenge - Variables

6.8-Solution - Variables

6.9-Include Files

6.10-Challenge - Include Files

6.11-Solution - Include Files

6.12-Adding Flat Files

7-Dealing with Data Model Challenges - Part I

7.1-Using Record Counters

7.2-Challenge - Record Counters

7.3-Solution - Record Counters

7.4-WHERE Clause

7.5-Resident Load

7.6-WHERE EXISTS Clause

7.7-Challenge - WHERE EXISTS

7.8-Solution - WHERE EXISTS

7.9-Dealing with Data Model Challenges - Part I

8-Master Calendar

8.1-Master Calendar Fundamentals

8.2-FieldValue Function and Flags

8.3-Create a Master Calendar

8.4-Master Calendar

9-Mapping Tables

9.1-Mapping Load Fundamentals

9.2-Add Mapping Tables

9.3-Challenge - Mapping Table

9.4-Solution - Mapping Table

9.5-Challenge - Preceding Load

9.6-Solution - Preceding Load

9.7-Mapping Tables

10-Data Model Optimization

10.1-Joins Deep Dive

10.2-Challenge - Join tables

10.3-Solution - Join tables

10.4-Concatenation

10.5-Implicit and Forced Concatenation

10.6-Challenge - Concatenate

10.7-Solution - Concatenate

10.8-Consolidate Fact Tables

10.9-Data Model Optimization

11-Dealing with Data Model Challenges - Part II

11.1-Circular Reference

11.2-Cross table

11.3-Add Cross table

11.4-Link table

11.5-Create a Link Table

11.6-Class function

11.7-Solution - Class Function

11.8-Interval Match

11.9-Dealing with Data Model Challenges - Part II

12-All about QVD Files

12.1-QVD Fundamentals

12.2-Creating QVD Files

12.3-Optimized QVD Load

12.4-All About QVD Files

13-Set Analysis

13.1-Set Analysis Fundamentals

13.2-Create a Chart with Set Expression

13.3-Challenge - Set Modifier

13.4-Solution - Set Modifier

13.5-Aggr()

13.6-Challenge - Set Analysis with Aggr()

13.7-Solution - Set Analysis with Aggr()

13.8-FirstSortedValue Function

13.9-Challenge – FirstSortedValue

13.10-Solution – FirstSortedValue

13.11-Set Analysis

14-Section Access

14.1-Introduction

14.2-Chapter Goals

14.3-Layers of Security

14.4-ABAC vs RBAC

14.5-Authentication vs Authorization

14.6-Why Section Access?

14.7-Section Access Basics

14.8-Section Access - App Authorization

14.9-Troubleshooting App Lockdown

14.10-Section Access - Data Authorization

14.11-Qlik Sense Section Access

15-On Demand App Generation (ODAG)

15.1-Introduction to On Demand App Generation

15.2-On Demand App Generation Example

15.3-On Demand App Generation (ODAG)

16-Tips & Tricks

16.1-Tips & Tricks Videos

16.2-Optimized QVD Load

16.3-How to Load Data from a SharePoint List

16.4-Peek() vs Previous()

16.5-Table Concatenation & Date Fields

Course Categories

Popular Courses

QlikSense Data Architect Masterclass

Description

What you'll learn

Requirements

Course Content

You May Like