get app

    The Advanced QlikView Developer Bootcamp

    BY
    Udemy

    Challenge yourself to become an expert in advanced QlikView developer and designer concepts.

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 2999

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course overview

    The QlikView developer will play a crucial technical role in supporting and maintaining our client's QlikView platform. Individuals will be responsible for helping our user community in the management of the platform end-to-end, as well as giving assistance to Business users and the BI team. This individual must be extremely data-driven and possess solid technical abilities. QlikView can extract, transform, and load data from numerous sources. Conduct data and system analysis in order to convert business requirements into technical code, as well as maintain and support code. Diagnose problems with the existing data model and dashboards. Alter existing dashboards to create the next major release, incorporating new user-requested features. Build brand-new dashboards from scratch based on Business Analyst and end-user requirements. The Advanced QlikView Developer Bootcamp certification is made available by Udemy to candidates who want to learn complex concepts for the QlikView developer, along with difficulties.

    The Advanced QlikView Developer Bootcamp online training contains 12 hours of video, five articles, and five downloaded resources, as well as a digital certificate once the course has been completed.

    The Advanced QlikView Developer Bootcamp online syllabus consists of Github, data modeling, mapping load, resident load, preceding load, synthetic keys, link table, incremental reload, joins, master calendar, folder structure, script configuration, inter record functions, advanced script operators, and troubleshooting missing app on QlikView access point site. 

    The highlights

    • Full Lifetime Access
    • 12 Hours of Video
    • Five Articles
    • Five Downloadable Resources
    • Access on Mobile and TV
    • Certificate of Completion

    Program offerings

    • Online course
    • Learning resources
    • 30-day money-back guarantee
    • Unlimited access

    Course and certificate fees

    Fees information
    ₹ 2,999
    certificate availability

    Yes

    certificate providing authority

    Udemy

    What you will learn

    The Advanced QlikView Developer Bootcamp certification course, the aspirant will be able to develop and learn advanced concepts for QlikView developers with the help of challenges. The participant will gain an understanding of GitHub, data modeling, varieties of data models, snowflake schema, mapping load, and comprehension of ApplyMap ( ). The candidate will gain knowledge of script execution, resident load, preceding load, source files, synthetic keys, and link table, creating link table, synthetic table to link table, incremental reload inserts, joins, master calendar fundamentals, application folder structure, QlikView, and source control. The candidate will learn about the variable naming convention, the fundamentals of Inter record functions, optimised QVD load, a cross table, advanced script operators and functions, and drop variables set analysis with alternate states, as well as QlikView server and publisher installation and configuration.

    The syllabus

    Introduction

    • Course Intro
    • Course Curriculum Overview
    • For HELP: Join Private Slack Channel

    Github: Data Set, Challenges, Solution QVWs

    • 2.1: Course Approach and Github
    • 2.2: Approach - Challenges and Solutions

    QlikView Data Modelling

    • 3.0 Chapter Goals
    • 3.1: Understanding Data Modelling (Part 1)
    • 3.1: Understanding Data Modelling (Part 2)
    • 3.1: Understanding Data Modelling (Part 3)
    • 3.2: Conceptual Aside - Data Modelling
    • 3.3: Types of Data Models
    • 3.4: Conceptual Aside - Star Schema
    • Data Modelling
    • 3.5: Demo - Star Schema
    • 3.6: Conceptual Aside - Snowflake Schema
    • 3.7: Demo - Snowflake Schema
    • 3.8: Concatenated Fact Tables
    • 3:9: Demo - Concatenated Fact Table
    • 3.10: Our Advice
    • 3.11: Challenge - Simplify the Data Model
    • 3.12: Solution - Simplify the Data Model

    Mapping Load, ApplyMap and Map using

    • 4.0: Chapter Goals
    • 4.1: Understanding Mapping Load
    • 4.2: Understanding ApplyMap( )
    • 4.3: MapSubString( )
    • 4.4: Map Using
    • 4.5a: Challenge
    • 4.5a: Solution
    • 4.5b: Challenge
    • 4.5b: Solution
    • Mapping Load, ApplyMap and Map Using

    Resident Load vs. Preceding Load

    • 5:0: Chapter Goals
    • 5:1: Understanding Script Execution
    • 5.2: Understanding Resident Load
    • 5.3: Understanding Preceding Load
    • Script Execution, Resident load, Preceding Load
    • 5.4: Further Reading (Cost of Preceding Load)
    • 5.5: Difference between WHERE and HAVING clause
    • 5.6: How to implement HAVING clause in QlikView
    • 5.7: Challenge - Resident vs Preceding Load
    • 5.8: Challenge - Source Files (QVW, QVS and QVD)
    • 5.8: Solution - Resident vs Preceding Load
    • Where and Having Clause

    Synthetic Keys and Link Table

    • 6.0: Chapter Goals
    • 6.1: Introduction to Synthetic Keys and Link Table
    • 6.2: Link Table Deep Dive
    • 6.3: Creating Link Table - I
    • 6.4: Creating Link Table - II
    • 6.5: Challenge - Synthetic Table to Link Table
    • 6.6: Solution - Synthetic Table to Link Table
    • 6.7 Chapter Summary
    • Quiz: Link Tables and Synthetic Keys

    Incremental Reload

    • 7.0: Chapter Goals
    • 7.1: Understanding Incremental Reload
    • 7.2: Incremental Reload Architecture
    • 7.3 Incremental Reload: Inserts - Part I
    • 7.3 Incremental Reload: Inserts - Part II
    • 7.3 Incremental Reload: Inserts - Part III
    • 7.3 Incremental Reload: Inserts - Part IV
    • 7.4: Incremental Reload - Insert and Update - Part I
    • 7.4: Incremental Reload - Insert and Update - Part II
    • 7.5: Challenge Incremental load – Insert and Update
    • 7.6: Solution - Incremental load – Insert and Update
    • 7.7: Incremental Reload - Insert, Update and Delete - Part I
    • 7.7: Incremental Reload - Insert, Update and Delete - Part II
    • 7.8: Challenge - Incremental load – Insert, Update and Delete
    • 7.9: Solution - Incremental load – Insert, Update and Delete
    • 7.10: Chapter Summary
    • Quiz: Incremental Reload

    QlikView Joins Deep Dive

    • 8.0: Chapter Goals
    • 8.1: Associative Join and Explicit ANSI Style Joins
    • 8.2: Outer Join
    • 8.3: Inner Join
    • 8.4: Left Join
    • 8.5: Right Join
    • 8.6: Cartesian Product
    • QlikView Joins

    Introduction to Master Calendar

    • 9.0: Chapter Goals
    • 9.1: Master Calendar Fundamentals
    • 9.2: Steps to Create Master Calendar
    • 9.3 Challenge - Master Calendar
    • 9.4: Solution - Master Calendar
    • 9.5 Chapter Summary
    • Quiz: Master Calendar

    Folder Structure, Script Configuration & Variable Naming Convention

    • 10.0 Chapter Goals
    • 10.1: Application Folder Structure
    • 10.2 QlikView and Source Control
    • 10.3: Script Tab Layout
    • 10.4: Script Global Config File
    • 10.5: Variable Naming Convention
    • Chapter 10

    Inter Record Functions

    • 11.0 Chapter Goals
    • 11.1: Fundamentals of Inter Record Functions
    • 11.2: Above ( ) , Below ( ), RowNo(), NoOfRows()
    • 11.3: Challenge: Pareto Analysis - Part I
    • 11.3: Challenge: Pareto Analysis - Part II
    • 11.4: Solution: Pareto Analysis - Part II
    • 11.5: Peek() and Previous()
    • 11.6: Challenge - Inventory Analysis
    • 11.7: Solution – Inventory Analysis - Part I
    • 11.7: Solution – Inventory Analysis - Part II
    • 11.8: FieldValue ( ) and FieldValueCount()
    • 11.9: Challenge - Optimized QVD Load
    • 11.10: Solution – Optimized QVD Load
    • 11.11: Chapter Summary
    • Quiz: Inter Record Functions

    Advanced Script Operators and Functions

    • 12.0 Chapter Goals
    • 12.1: Crosstable
    • 12.2: Challenge - Crosstable
    • 12.3: Solution - Crosstable
    • 12.4: Generic Load
    • 12.5 Challenge - Generic Load
    • 12.6 Solution - Generic Load
    • 12.7 : Understanding Aggr()
    • 12.8 Challenge 1 - Aggr()
    • 12.9 Solution 1 - Aggr()
    • 12.10: Challenge 2 - Aggr()
    • 12.11: Solution 2 - Aggr()
    • 12.12: FirstSortedValue()
    • 12.13 Challenge - FirstSortedValue()
    • 12.14 Solution - FirstSortedValue()
    • 12.15 Hierarchy Prefix
    • 12.16 Challenge - Hierarchy Prefix
    • 12.17 Solution - Hierarchy Prefix
    • 12.18: Chapter Summary
    • Quiz: Advanced Script Operators and Functions

    Bonus: Advanced Tips & Tricks

    • 13.1: Animated Text: Loading... Message
    • 13.2: Draw Shapes Using Textbox Object
    • 13.3: Trick: Using Clear Button
    • 13.4: How to Drop Variables

    Bonus: Advanced Set Analysis

    • Chapter Goals
    • Dollar-Sign Expansion
    • Double Dollar Sign Expansion
    • Parameterized Dollar Sign Expansion
    • Set Exclusion
    • Alternate States
    • Dealing with NULL values
    • How to compare two fields
    • Interesting Operators
    • Set Modifier with an Expression
    • Challenge: Set Analysis with Alternate States
    • Solution: Set Analysis with Alternate States
    • Challenge: Exclusion Operators
    • Solution: Exclusion Operator
    • Challenge: Compare two fields
    • Solution: Compare two fields

    Bonus: QlikView Server Single Node Installation & Configuration

    • QlikView Server and Publisher Installation & Configuration - November 2017
    • Troubleshooting Missing App on QlikView Access Point Site

    Instructors

    Mr Shilpan Patel
    Instructor
    Freelancer

    Mr Deepak Vadithala
    Architect
    Freelancer

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses NPTEL Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books