BI & Data Visualization with Qlikview sdfMonday 21 December 2015 2 comments

Become an expert in Data Visualization with Qlikview by transforming data into interactive charts and graphs using Qlikview features like dashboards, system table, incremental load and object formatting

Lets call BuddhaiSoft.com

1. Qlikview Starter

Learning Objectives - In this module, you will get an introduction to Qlikview and the other associated components.

 

Topics - Introduction to Qlikview, What is Visualization, Components of Qlikview, Create Connection, Create Dashboard Report, Report Interface, Sheet Object-List BOX.

2. Script - Code

Learning Objectives - In this module, you will learn to edit the script and you will understand the working of the different tools to edit the scripts. 

Topics - Script Editing, Edit Script Toolbar, Edit Script Menu Commands, Statements Area, Edit Script Tool Pane, Syntax, Creating tabs in the script, Renaming a Field, Chart Object- Bar Chart, Sheet Object- TABLE Box.

3. Script - Relation

Learning Objectives - In this module, you will learn about Tables, Join, its types and uses.

Topics - The Table Viewer, System Fields, The System Table, Join, Keep, Concatenation, Types of Join, Keep and Concatenation, When to use, Which Type, Chart Object-Line Chart, Sheet Object-Multi Box.

4. Script - Loop & Field Handle

Learning Objectives - In this, module you will learn to use the Synthetic Key tables and the ways to resolve the synthetic keys and circular reference. 

Topics - Synthetic Key Tables, Circular References, Causes of Circular References, Ways to Resolve Synthetic Keys and Circular Reference, Text Files, Excel Files, CSV Files, Others, Chart Object- Combo Chart Sheet Object- Input Box.

5. Script - Load Type & System Table

Learning Objectives - In this module, you will learn to generate the data in Qlikview script, cross tables, mapping tables and various other concepts. 

Topics - Generating Data in the Qlikview Script, Cross Tables, Mapping Tables, Different Types of Loads, Chart Object - Pie Chart, Sheet Object - Buttons, Sheet Object - Current Selections Box.

6. Script - Incremental Load & Files

Learning Objectives - In this module, you will learn about data file types, incremental load, Calendar creation and types of sheet objects.

Topics - Qlikview Data Files Types, Incremental load, Incremental load with qvd file, Creating a Calendar, Sheet Object - Radar Chart, Sheet Object - Scatter Chart, Sheet Object - Text Box.

7. Object/Field Formatting

Learning Objectives - In this module,  you will learn to perform Object / Field formatting. 

Topics - Number Format, Aggregation & Nested level, Calculated Formula, Field Groups, Sheet Object - Grid Chart, Sheet Object - Block Chart, Sheet Object - line/arrow.

8. Data Analysis

Learning Objectives - In this module you will learn to perform Data Analysis like Set, Indirect, and What-If analysis. 

Topics - Set Analysis, Indirect Set Analysis, What-if Analysis, Set vs Let, Sheet Object-Mekko Chart, Sheet Object - Gauge Chart, Sheet Object - Slider/Calendar Box.