- QlikVIew: Course Introduction
- Course Syllabus
- QlikView Overview
- Introduction to Relational Database
- Data Files
- Dimensions and Measures
- Introduction to QlikView
Online
₹ 1,299
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
The Associative Engine of Qlik enables users to perform big data analytics by merging multiple data sources to generate associations and linkages across the data. Using the same engine, the two primary data analytics tools Qlik Sense serve distinct objectives. QlikView is used to analyze static data, whereas Qlik Sense allows for the concatenation of several data sources and drill-down on a single data record. Using open and standard APIs, the Qlik data analytics Platform provides direct access to Qlik's associative data engine. Qlik Data catalyst is an enterprise data catalog management software, whereas Qlik Core is an analytics development platform based on Qlik's Associative engine and company-authored open-source libraries. Become QlikView Developer from Scratch certification is made available by Udemy to candidates who want to master QlikView development without any previous knowledge.
Become QlikView Developer from Scratch online training contains a digital certificate after completing the course, eight hours of video, six articles, and three downloadable materials.
Become QlikView Developer from Scratch online syllabus consists of a QlikView overview, introduction to scripting, data modeling basics, generating data in the script, data model optimization, data model challenges, scripting considerations, document security, and QlikView script syntax.
The highlights
- Full Lifetime Access
- Eight Hours of Video
- Six Articles
- Three Downloadable Resources
- Access on Mobile and TV
- Certificate of Completion
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
Become QlikView Developer from Scratch certification course, the aspirant will be able to begin developing QlikView data models, extract data from many sources, and transform data based on business rules to produce a data model that business analysts may use to create the presentation layer. The candidate will get knowledge of Scripting, databases, synthetic keys, loading data from XML and Microsoft Excel, generating data in the script, the master calendar Script, and joining and concatenating tables. The participant will learn about optimizing data models, Cross tables, challenges, set analysis fundamentals, AGGR function, document security, QlikView Script Syntax, 3 pitfalls to avoid, QlikView substring functions, QlikView set analysis cheat sheet, and how to optimize their QlikView application using document analyzer.
The syllabus
Introduction to QlikView
Introduction to Scripting
- Install QlikView Desktop
- Introduction to Scripting
- Connect to the Database
- Script Syntax and Data Load
- Load Fact Tables
- Introduction to Scripting
Data Modeling Basics
- Understanding data model
- Synthetic Keys
- 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
Generating Data in the Script
- How to generate data in the script
- Generating data in the script using Resident load
- Master Calendar
- Master Calendar Script
- Improved Master Calendar Script
- Mapping tables
- Add Mapping tables and Preceding load to the script
- Generating data in the script
Data Model Optimization
- Joins vs Concatenate
- Join or Concatenate tables
- Optimize data model
- Create star schema
- Data Model Optimization
Data Model Challenges
- Cross tables
- Load data from Cross table
- Link tables
- Create a Link table
- Data Model Challenges
Scripting Considerations
- Slowly Changing Dimensions
- IntervalMatch function
- Introduction to Set Analysis
- Set Analysis Basics
- Set Analysis Basics - QVW
- Power of Set Analysis Part I
- Power of Set Analysis Part II
- AGGR function
- QlikView Data Files(QVD)
- Load data from QVD
- Metadata
- Add metadata
- Scripting Considerations
Security
- Introduction to document security
- Add Section Access
- Security
- Summary
QlikView Scripting: Tips and Tricks
- QlikView Script Syntax: 3 Pitfalls to Avoid
- QlikView Substring Functions
- QlikView Set analysis Cheat Sheet
- Optimize Your QlikView Application Using Document Analyzer
Instructors
Mr Shilpan Patel
Instructor
Freelancer