Become QlikView Developer from Scratch

Learn how to become an awesome QlikView developer and earn over USD $100,000 a year without any prior experience.
4.2 (490 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
• 3,057 students enrolled Bestselling in QlikView
$19
$150
87% off
Take This Course
  • Lectures 48
  • Length 8 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

Course updated on May 30, 2016.

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!

What are the requirements?

  • Download Free QlikView desktop from Qlik.com
  • Understand basics of SQL

What am I going to get from this course?

  • You will be able to start building QlikView data models after completing this course.

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to QlikView
02:44

Introduction to QlikView as a Business Discovery Platform

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

Course Syllabus
Preview
04:30
QlikView Overview
08:27
Introduction to Relational Database
06:50
Data Files
Article
Dimensions and Measures
Preview
10:35
4 questions

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

Section 2: Introduction to Scripting
Install QlikView Desktop
Preview
02:13
Introduction to Scripting
04:48
Connect to the Database
07:34
10:51

Conceptual overview of script syntax

Load Fact Tables
10:52
Introduction to Scripting
3 questions
Section 3: Data Modeling Basics
Understanding data model
Preview
09:04
Synthetic Keys
04:06
Remove Synthetic Key from the Data Model
13:28
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
Section 4: Generating Data in the Script
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
Section 5: Data Model Optimization
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
Section 6: Data Model Challenges
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
Section 7: Scripting Considerations
Slowly Changing Dimensions
05:41
IntervalMatch function
17:26
Introduction to Set Analysis
18:03
14:34

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

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
Section 8: Security
Introduction to document security
16:32
Add Section Access
16:32
Security
4 questions
Section 9: QlikView Scripting: Tips and Tricks
QlikView Script Syntax: 3 Pitfalls to Avoid
03:03
QlikView Substring Functions
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shilpan Patel, Certified QlikView Developer and Designer

Greetings! I am a certified QlikView developer and designer /Qlik Sense Data Architect with over 15 years of experience in Business Intelligence, data warehousing and various relational database management systems.

With incredible data growth -- both structured and unstructured -- businesses struggle to make sense of data. Business discovery tools such as QlikView and Tableau offer new opportunities to those who want to help an enterprise make insight driven decisions. That's my passion and that's my life long purpose.

I enjoy sharing my knowledge in the field of Business Discovery and visual data analytics at my blog. I have developed and implemented numerous QlikView applications for banking, health care and manufacturing.

My goal is to make you an awesome QlikView developer!

Ready to start learning?
Take This Course