[UDEMY]Become QlikView Developer from Scratch

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.

Instructed by Shilpan Patel Business / Data & Analytics

Course Description

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.

Have you been asked to create a QlikView application at your work since your company just invested in QlikView as a business discovery tool?
Are you looking to quickly learn QlikView scripting to transform data from various sources?
Did you create a QlikView application without formal training but feel that you have not unleashed power of QlikView's unique ETL capability?
Do you enjoy building data models that can help companies gain insight and help executives make fact based decisions?
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?

Over 44 lectures and 7.5 hours of content!
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
Curriculum

Section 1: Introduction to QlikView
Lecture 1
QlikVIew: Course Introduction
Preview
02:44
Lecture 2
Course Syllabus
Preview
04:30
Lecture 3
QlikView Overview
08:27
Lecture 4
Introduction to Relational Database
06:50
Lecture 5
Dimensions and Measures
Preview
10:35
Quiz 1
Introduction to QlikView
4 questions
Section 2: Introduction to Scripting
Lecture 6
Install QlikView Desktop
Preview
02:13
Lecture 7
Introduction to Scripting
04:48
Lecture 8
Connect to the Database
07:34
Lecture 9
Script Syntax and Data Load
10:51
Lecture 10
Load Fact Tables
10:52
Quiz 2
Introduction to Scripting
3 questions
Section 3: Data Modeling Basics
Lecture 11
Understanding data model
Preview
09:04
Lecture 12
Synthetic Keys
04:06
Lecture 13
Remove Synthetic Key from the Data Model
13:28
Lecture 14
Data load from an Excel file
07:42
Lecture 15
Load a table from an Excel file
10:41
Lecture 16
Load data from XML file
08:03
Lecture 17
How to resolve circular loops and synthetic keys
16:22
Quiz 3
Data Modeling Basics
3 questions
Section 4: Generating Data in the Script
Lecture 18
How to generate data in the script
05:37
Lecture 19
Generating data in the script using Resident load
18:28
Lecture 20
Master Calendar
09:34
Lecture 21
Add Master calendar to the script
16:09
Lecture 22
Mapping tables
04:54
Lecture 23
Add Mapping tables and Preceding load to the script
15:09
Quiz 4
Generating data in the script
5 questions
Section 5: Data Model Optimization
Lecture 24
Joins vs Concatenate
07:03
Lecture 25
Join or Concatenate tables
07:45
Lecture 26
Optimize data model
02:32
Lecture 27
Create star schema
19:10
Quiz 5
Data Model Optimization
2 questions
Section 6: Data Model Challenges
Lecture 28
Cross tables
06:23
Lecture 29
Load data from Cross table
11:02
Lecture 30
Link tables
05:41
Lecture 31
Create a Link table
15:55
Quiz 6
Data Model Challenges
2 questions
Section 7: Scripting Considerations
Lecture 32
Slowly Changing Dimensions
05:41
Lecture 33
IntervalMatch function
17:26
Lecture 34
Introduction to Set Analysis
18:03
Lecture 35
Set Analysis Basics
14:34
Lecture 36
Power of Set Analysis Part I
12:45
Lecture 37
Power of Set Analysis Part II
10:21
Lecture 38
AGGR function
12:52
Lecture 39
QlikView Data Files(QVD)
13:34
Lecture 40
Load data from QVD
12:40
Lecture 41
Metadata
06:30
Lecture 42
Add metadata
19:52
Quiz 7
Scripting Considerations
4 questions
Section 8: Security
Lecture 43
Introduction to document security
16:32
Lecture 44
Add Section Access
16:32
Quiz 8
Security
4 questions

Instructor Biography
Shilpan Patel , Certified QlikView Developer and Designer
Greetings! I am a certified QlikView developer and designer 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!

PS - Due to some unavoidable reasons, part 10 and part 18 (worth 15 minutes in total) are not available...