Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to QlikView|
Introduction to QlikView as a Business Discovery Platform
Overview of QlikView Personal Edition, QlikView Desktop, QlikVew Server and QlikView Publisher
Introduction to Relational Database
Dimensions and MeasuresPreview
|Quiz 1||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 DesktopPreview
Introduction to Scripting
Connect to the Database
Conceptual overview of script syntax
Load Fact Tables
Introduction to Scripting
|Section 3: Data Modeling Basics|
Understanding data modelPreview
Remove Synthetic Key from the Data Model
Data load from an Excel file
Load a table from an Excel file
Load data from XML file
How to resolve circular loops and synthetic keys
Data Modeling Basics
|Section 4: Generating Data in the Script|
How to generate data in the script
Generating data in the script using Resident load
Master Calendar Script
Improved Master Calendar Script
Add Mapping tables and Preceding load to the script
Generating data in the script
|Section 5: Data Model Optimization|
Joins vs Concatenate
Join or Concatenate tables
Optimize data model
Create star schema
Data Model Optimization
|Section 6: Data Model Challenges|
Load data from Cross table
Create a Link table
Data Model Challenges
|Section 7: Scripting Considerations|
Slowly Changing Dimensions
Introduction to Set Analysis
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
Power of Set Analysis Part II
QlikView Data Files(QVD)
Load data from QVD
|Section 8: Security|
Introduction to document security
Add Section Access
|Section 9: QlikView Scripting: Tips and Tricks|
QlikView Script Syntax: 3 Pitfalls to Avoid
QlikView Substring Functions
QlikView Set analysis Cheat Sheet
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!