image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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.


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!
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

What you'll learn

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

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 to QlikView
7
1.1-QlikVIew: Course Introduction
1.2-Course Syllabus
1.3-QlikView Overview
1.4-Introduction to Relational Database
1.5-Data Files
1.6-Dimensions and Measures
1.7-Introduction to QlikView
2-Introduction to Scripting
6
2.1-Install QlikView Desktop
2.2-Introduction to Scripting
2.3-Connect to the Database
2.4-Script Syntax and Data Load
2.5-Load Fact Tables
2.6-Introduction to Scripting
3-Data Modeling Basics
8
3.1-Understanding data model
3.2-Synthetic Keys
3.3-Remove Synthetic Key from the Data Model
3.4-Data load from an Excel file
3.5-Load a table from an Excel file
3.6-Load data from XML file
3.7-How to resolve circular loops and synthetic keys
3.8-Data Modeling Basics
4-Generating Data in the Script
8
4.1-How to generate data in the script
4.2-Generating data in the script using Resident load
4.3-Master Calendar
4.4-Master Calendar Script
4.5-Improved Master Calendar Script
4.6-Mapping tables
4.7-Add Mapping tables and Preceding load to the script
4.8-Generating data in the script
5-Data Model Optimization
5
5.1-Joins vs Concatenate
5.2-Join or Concatenate tables
5.3-Optimize data model
5.4-Create star schema
5.5-Data Model Optimization
6-Data Model Challenges
5
6.1-Cross tables
6.2-Load data from Cross table
6.3-Link tables
6.4-Create a Link table
6.5-Data Model Challenges
7-Scripting Considerations
13
7.1-Slowly Changing Dimensions
7.2-IntervalMatch function
7.3-Introduction to Set Analysis
7.4-Set Analysis Basics
7.5-Set Analysis Basics - QVW
7.6-Power of Set Analysis Part I
7.7-Power of Set Analysis Part II
7.8-AGGR function
7.9-QlikView Data Files(QVD)
7.10-Load data from QVD
7.11-Metadata
7.12-Add metadata
7.13-Scripting Considerations
8-Security
4
8.1-Introduction to document security
8.2-Add Section Access
8.3-Security
8.4-Summary
9-QlikView Scripting: Tips and Tricks
4
9.1-QlikView Script Syntax: 3 Pitfalls to Avoid
9.2-QlikView Substring Functions
9.3-QlikView Set analysis Cheat Sheet
9.4-Optimize Your QlikView Application Using Document Analyzer