Home

All courses

The Advanced QlikView Developer Bootcamp

Qlikview

Business Analytics & Intelligence

Business

The Advanced QlikView Developer Bootcamp

Master Advanced QlikView developer and designer concepts with challenges

4.6

(441)

2916 enrolled on this course

Last updated 11/2021

Vertechs .IO

₹ 2999.0

₹ 4499.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

Hi there!

As a QlikView developer you must have realized that it is easy to learn basics but very difficult to master this awesome, industry leading analytic tool.

Likely, you enrolled in one of our beginner QlikView courses and mastered the skill that enabled you to become a QlikView developer. But now your manager and peers expect you to be an expert. That’s a tall order, right?

Worry not! This advanced QlikView course will be your sole source to help you become an expert QlikView developer. You will learn nuances of QlikView that you won’t find anywhere online.

Even if you are a novice QlikView developer, we have your back! Every section starts with basics and quickly leads you to learn advanced concepts with ease.

We firmly believe that you learn by doing. Just watching video won’t make you an expert.

That said we have countless challenges throughout the course with aim to make your practice what we teach. Not to mention quizzes and summary lectures to reinforce difficult to comprehend topics.

We believe that touchstone of success of our course is if you can apply knowledge into practice so we have tried our best to show you tricks of the trade that we have learned by working in the trenches.

Like all of our other best-selling Udemy courses, this course also offers 30 day money back guarantee.

And best of all, we intend to keep adding and improving content in the future.

So what are you waiting for? Enroll now and join the ranks of expert QlikView developers!!

Who this course is for:
QlikView Developers

What you'll learn

Master advanced QlikView developer concepts with challenges

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-Course Intro

1.2-Course Curriculum Overview

1.3-For HELP: Join Private Slack Channel

2-Github: Data Set, Challenges, Solution QVWs

2.1-2.1: Course Approach and Github

2.2-2.2: Approach - Challenges and Solutions

3-QlikView Data Modelling

3.1-3.0 Chapter Goals

3.2-3.1: Understanding Data Modelling (Part 1)

3.3-3.1: Understanding Data Modelling (Part 2)

3.4-3.1: Understanding Data Modelling (Part 3)

3.5-3.2: Conceptual Aside - Data Modelling

3.6-3.3: Types of Data Models

3.7-3.4: Conceptual Aside - Star Schema

3.8-Data Modelling

3.9-3.5: Demo - Star Schema

3.10-3.6: Conceptual Aside - Snowflake Schema

3.11-3.7: Demo - Snowflake Schema

3.12-3.8: Concatenated Fact Tables

3.13-3:9: Demo - Concatenated Fact Table

3.14-3.10: Our Advice

3.15-3.11: Challenge - Simplify the Data Model

3.16-3.12: Solution - Simplify the Data Model

4-Mapping Load, ApplyMap and Map using

4.1-4.0: Chapter Goals

4.2-4.1: Understanding Mapping Load

4.3-4.2: Understanding ApplyMap( )

4.4-4.3: MapSubString( )

4.5-4.4: Map Using

4.6-4.5a: Challenge

4.7-4.5a: Solution

4.8-4.5b: Challenge

4.9-4.5b: Solution

4.10-Mapping Load, ApplyMap and Map Using

5-Resident Load vs. Preceding Load

5.1-5:0: Chapter Goals

5.2-5:1: Understanding Script Execution

5.3-5.2: Understanding Resident Load

5.4-5.3: Understanding Preceding Load

5.5-Script Execution, Resident load, Preceding Load

5.6-5.4: Further Reading (Cost of Preceding Load)

5.7-5.5: Difference between WHERE and HAVING clause

5.8-5.6: How to implement HAVING clause in QlikView

5.9-5.7: Challenge - Resident vs Preceding Load

5.10-5.8: Challenge - Source Files (QVW, QVS and QVD)

5.11-5.8: Solution - Resident vs Preceding Load

5.12-Where and Having Clause

6-Synthetic Keys and Link Table

6.1-6.0: Chapter Goals

6.2-6.1: Introduction to Synthetic Keys and Link Table

6.3-6.2: Link Table Deep Dive

6.4-6.3: Creating Link Table - I

6.5-6.4: Creating Link Table - II

6.6-6.5: Challenge - Synthetic Table to Link Table

6.7-6.6: Solution - Synthetic Table to Link Table

6.8-6.7 Chapter Summary

6.9-Quiz: Link Tables and Synthetic Keys

7-Incremental Reload

7.1-7.0: Chapter Goals

7.2-7.1: Understanding Incremental Reload

7.3-7.2: Incremental Reload Architecture

7.4-7.3 Incremental Reload: Inserts - Part I

7.5-7.3 Incremental Reload: Inserts - Part II

7.6-7.3 Incremental Reload: Inserts - Part III

7.7-7.3 Incremental Reload: Inserts - Part IV

7.8-7.4: Incremental Reload - Insert and Update - Part I

7.9-7.4: Incremental Reload - Insert and Update - Part II

7.10-7.5: Challenge Incremental load – Insert and Update

7.11-7.6: Solution - Incremental load – Insert and Update

7.12-7.7: Incremental Reload - Insert, Update and Delete - Part I

7.13-7.7: Incremental Reload - Insert, Update and Delete - Part II

7.14-7.8: Challenge - Incremental load – Insert, Update and Delete

7.15-7.9: Solution - Incremental load – Insert, Update and Delete

7.16-7.10: Chapter Summary

7.17-Quiz: Incremental Reload

8-QlikView Joins Deep Dive

8.1-8.0: Chapter Goals

8.2-8.1: Associative Join and Explicit ANSI Style Joins

8.3-8.2: Outer Join

8.4-8.3: Inner Join

8.5-8.4: Left Join

8.6-8.5: Right Join

8.7-8.6: Cartesian Product

8.8-QlikView Joins

9-Introduction to Master Calendar

9.1-9.0: Chapter Goals

9.2-9.1: Master Calendar Fundamentals

9.3-9.2: Steps to Create Master Calendar

9.4-9.3 Challenge - Master Calendar

9.5-9.4: Solution - Master Calendar

9.6-9.5 Chapter Summary

9.7-Quiz: Master Calendar

10-Folder Structure, Script Configuration & Variable Naming Convention

10.1-10.0 Chapter Goals

10.2-10.1: Application Folder Structure

10.3-10.2 QlikView and Source Control

10.4-10.3: Script Tab Layout

10.5-10.4: Script Global Config File

10.6-10.5: Variable Naming Convention

10.7-Chapter 10

11-Inter Record Functions

11.1-11.0 Chapter Goals

11.2-11.1: Fundamentals of Inter Record Functions

11.3-11.2: Above ( ) , Below ( ), RowNo(), NoOfRows()

11.4-11.3: Challenge: Pareto Analysis - Part I

11.5-11.3: Challenge: Pareto Analysis - Part II

11.6-11.4: Solution: Pareto Analysis - Part II

11.7-11.5: Peek() and Previous()

11.8-11.6: Challenge - Inventory Analysis

11.9-11.7: Solution – Inventory Analysis - Part I

11.10-11.7: Solution – Inventory Analysis - Part II

11.11-11.8: FieldValue ( ) and FieldValueCount()

11.12-11.9: Challenge - Optimized QVD Load

11.13-11.10: Solution – Optimized QVD Load

11.14-11.11: Chapter Summary

11.15-Quiz: Inter Record Functions

12-Advanced Script Operators and Functions

12.1-12.0 Chapter Goals

12.2-12.1: Crosstable

12.3-12.2: Challenge - Crosstable

12.4-12.3: Solution - Crosstable

12.5-12.4: Generic Load

12.6-12.5 Challenge - Generic Load

12.7-12.6 Solution - Generic Load

12.8-12.7 : Understanding Aggr()

12.9-12.8 Challenge 1 - Aggr()

12.10-12.9 Solution 1 - Aggr()

12.11-12.10: Challenge 2 - Aggr()

12.12-12.11: Solution 2 - Aggr()

12.13-12.12: FirstSortedValue()

12.14-12.13 Challenge - FirstSortedValue()

12.15-12.14 Solution - FirstSortedValue()

12.16-12.15 Hierarchy Prefix

12.17-12.16 Challenge - Hierarchy Prefix

12.18-12.17 Solution - Hierarchy Prefix

12.19-12.18: Chapter Summary

12.20-Quiz: Advanced Script Operators and Functions

13-BONUS: Advanced Tips & Tricks

13.1-13.1: Animated Text: Loading... Message

13.2-13.2: Draw Shapes Using Textbox Object

13.3-13.3: Trick: Using Clear Button

13.4-13.4: How to Drop Variables

14-Bonus: Advanced Set Analysis

14.1-Chapter Goals

14.2-Dollar-Sign Expansion

14.3-Double Dollar Sign Expansion

14.4-Parameterized Dollar Sign Expansion

14.5-Set Exclusion

14.6-Alternate States

14.7-Dealing with NULL values

14.8-How to compare two fields

14.9-Interesting Operators

14.10-Set Modifier with an Expression

14.11-Challenge: Set Analysis with Alternate States

14.12-Solution: Set Analysis with Alternate States

14.13-Challenge: Exclusion Operators

14.14-Solution: Exclusion Operator

14.15-Challenge: Compare two fields

14.16-Solution: Compare two fields

15-Bonus: QlikView Server Single Node Installation & Configuration

15.1-QlikView Server and Publisher Installation & Configuration - November 2017

15.2-Troubleshooting Missing App on QlikView Access Point Site

Course Categories

Popular Courses

The Advanced QlikView Developer Bootcamp

Description

What you'll learn

Requirements

Course Content

You May Like