Udemy - Become QlikView Developer from Scratch (2015)
WEBRip | English | MP4 | 1280 x 720 | AVC ~578 kbps | 30 fps
AAC | 37.4 Kbps | 37.4 KHz | 2 channels | 7h 30mins | 1.11 GB
Genre: Video Tutorial / Development, Programming
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 45 lectures and 7.5 hours of content!
You will be able to start building QlikView data models after completing this course.
Section 1: Introduction to QlikView
QlikVIew: Course Introduction
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 Measures
Introduction to QlikView
Section 2: Introduction to Scripting
Install QlikView Desktop
Introduction to Scripting
Connect to the Database
Script Syntax and Data Load
Conceptual overview of script syntax
Load Fact Tables
Introduction to Scripting
Section 3: Data Modeling Basics
Understanding data model
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
Add Master calendar to the 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
Set Analysis Basics
This is a hands-on side example to go over basics of Set Analysis from my blog
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