What is Qlikview? Why Qlikview? Who can use Qlikview? Thinking through a BI solution build Structured approach for first dashboard build in a Visualisation tool Understanding Qlikview Desktop, Publisher, Server, …
Necessity of Scripting Connecting to Data Source: Select and Load Connecting to Data Base (thru OLEDB), Excel File, QVDs, Qlikview Application (Binary Load) etc; Understanding Preceding Load What if Analysis: …
Loading Multiple files to QV, Table Viewer Table Joins: Join, Left, Right, Inner Joins Keep: Left, Right, Inner Concatenate Tables (Implicit, Explicit Concatenation), Prevent Implicit Concatenation Start Schema, Snow Flake …
Challenges of Data Modelling: Synthetic Key, Circular References, Loosely Coupled Tables Solution: Rename Fields, Auto number, Qualify (UnQualify), Concatenate, Composite Key Linked Tables Dashboard Real Estate space Optimization Techniques Multi …
Cross Tables Mapping Load and Mapping Tables Reading and Writing QVD files, csv Files in the script Advantages of QVDs and creation of QVDs from Chart Buffer Load, Incremental Load, …
Table Transformation Generic Load Cross Tables Hierarchy Create Theme File Book Marks
Qlikview Functions Radar Chart Scatter Chart Grid Chart Fast Change of Charts Cyclic Chart Drill Down Chart
Set Analysis Set Identifier, Operator, Modifier Indirect Set Analysis: P(), E() Mekko Chart Tips and Tricks
