Become QlikView Developer from Scratch
4.0 (1,283 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.
5,973 students enrolled

Become QlikView Developer from Scratch

Learn how to become an awesome QlikView developer without any prior experience.
4.0 (1,283 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.
5,973 students enrolled
Created by Shilpan Patel
Last updated 8/2017
English
English [Auto]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 6 articles
  • 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
  • You will be able to start building QlikView data models after completing this course.
Requirements
  • Download Free QlikView desktop from Qlik.com
  • Understand basics of SQL
Description

Course updated on March 18, 2017.

Hi there! Since you've stumbled upon this course, you are likely looking for QlikView training to become an awesome QlikView developer. That's fabulous. But, if you are still wondering if this course is right for you or not, let not your heart be troubled.

Let me breakdown reasons for you to become a QlikView developer.

  1. Have you been asked to create a QlikView application at your work since your company just invested in QlikView as a business discovery tool?
  2. Are you looking to quickly learn QlikView scripting to transform data from various sources?
  3. Did you create a QlikView application without formal training but feel that you have not unleashed power of QlikView's unique ETL capability?
  4. Do you enjoy building data models that can help companies gain insight and help executives make fact based decisions?
  5. Are you a Business Intelligence professional with experience with Cognos or OBIEE and want to change career as most QlikView developers make six-figure income?

If you answered 'yes' to any of these questions, then this course is for you!

QlikView is growing rapidly. With over 30,000 customers, demand for skilled QlikView developers l is higher than ever before!

QlikView is the only in-memory tool with ETL(Extract, transform, load) engine to transform data from various data sources.

This course will make you an awesome QlikView developer. You will be able to extract data from various sources and transform data based on the business rules to create a data model that business analysts can use to create Presentation layer.

Course starts with basics and builds on gradually. Each session starts with a conceptual overview followed by hands-on examples to reinforce concepts. Each session also contains a quiz to test level of your knowledge.

I also am committed to keep improving and enhancing course content in the future and you will have lifetime access to this course.

Enroll in this course now and start making six-figure income by becoming a QlikView developer. Welcome aboard!

Who this course is for:
  • Are you interested in learning how to connect to various data sources, transform data and create a QlikView data model for data visualization and business discovery? Are you interested in making six-figure income by learning QliKView developer? If you answered YES then this is the right course for you! Welcome to the Course!
  • This course will teach you all the concepts with hands-on tutorials to make you an awesome QliKView developer. No prior programming exprience is needed other than basic understanding of SQL.
  • You will learn concept first before the hands-on session to make it easier for your to master each QliKView scripting concept. In addition, eachh section has a quiz to gauge your level of knowledge
Course content
Expand all 52 lectures 07:47:31
+ Introduction to QlikView
6 lectures 33:28

Introduction to QlikView as a Business Discovery Platform

Overview of QlikView Personal Edition, QlikView Desktop, QlikVew Server and QlikView Publisher

Preview 02:44
QlikView Overview
08:27
Introduction to Relational Database
06:50
Data Files
00:22

This Quiz will gauge your knowledge about basics of QlikView architecture, relational databases and dimension data model.

Introduction to QlikView
4 questions
+ Introduction to Scripting
5 lectures 36:18
Introduction to Scripting
04:48
Connect to the Database
07:34

Conceptual overview of script syntax

Script Syntax and Data Load
10:51
Load Fact Tables
10:52
Introduction to Scripting
3 questions
+ Data Modeling Basics
7 lectures 01:03:45
Synthetic Keys
04:06
Remove Synthetic Key from the Data Model
07:47
Data load from an Excel file
07:42
Load a table from an Excel file
10:41
Load data from XML file
08:03
How to resolve circular loops and synthetic keys
16:22
Data Modeling Basics
3 questions
+ Generating Data in the Script
7 lectures 01:15:41
How to generate data in the script
05:15
Generating data in the script using Resident load
18:28
Master Calendar
09:34
Master Calendar Script
16:09
Improved Master Calendar Script
06:12
Mapping tables
04:54
Add Mapping tables and Preceding load to the script
15:09
Generating data in the script
5 questions
+ Data Model Optimization
4 lectures 36:30
Joins vs Concatenate
07:03
Join or Concatenate tables
07:45
Optimize data model
02:32
Create star schema
19:10
Data Model Optimization
2 questions
+ Data Model Challenges
4 lectures 39:01
Cross tables
06:23
Load data from Cross table
11:02
Link tables
05:41
Create a Link table
15:55
Data Model Challenges
2 questions
+ Scripting Considerations
12 lectures 02:24:20
Slowly Changing Dimensions
05:41
IntervalMatch function
17:26
Introduction to Set Analysis
18:03

This is a hands-on side example to go over basics of Set Analysis from my blog(learnQlikview.com)

Set Analysis Basics
14:34
Set Analysis Basics - QVW
00:02
Power of Set Analysis Part I
12:45
Power of Set Analysis Part II
10:21
AGGR function
12:52
QlikView Data Files(QVD)
13:34
Load data from QVD
12:40
Metadata
06:30
Add metadata
19:52
Scripting Considerations
4 questions
+ Security
3 lectures 33:49
Introduction to document security
16:32
Add Section Access
16:32
Security
4 questions
Summary
00:45
+ QlikView Scripting: Tips and Tricks
4 lectures 04:37
QlikView Script Syntax: 3 Pitfalls to Avoid
03:03
QlikView Substring Functions
01:16
QlikView Set analysis Cheat Sheet
00:05
Optimize Your QlikView Application Using Document Analyzer
00:12