Qlikview-training-chennai @Geoinsyssoft

Qlikview Training @ Geoinsyssoft

BI and data warehousing concepts

OLAP types

introduction to QlikTech and QlikView.

 Layout and best application design practices. What should you think about when 

designing an application? 

 How to use QlikView Desktop.

 What is a sheet, sheet object, list box and a table box?

 How do we create the QlikView objects mentioned above, how do we use them, 

including examples such as sorting data, entering data, exporting data.

 You will learn about charts objects, how to create them and the many functionalities, 

how to edit the format and layout.

 How to load data into QlikView.

Introduction to multi dimensional objects such as pivot tables, straight tables with 

multiple expressions.

 Advanced usage of the many QlikView charts and objects, such as tree views in list 

boxes and mini charts.

 Advanced calculations using set analysis and AGGR function.

 Gauges, buttons, actions – what are they and how do you develop them.

 Introduction to some other useful objects such as slider/calendar objects.

 QlikView reports and how do you create and manage them.

 Business case workshop.

The QlikView environment.

 Overview of QlikView development methodology, SAFE.

 How to deploy QlikView, standalone, Server and Publisher.

 Introduction to data and scripting, relational databases and other data structures.

 Connecting to ODBC and also OLEDB data sources.

 Introduction to the underlying scripting language and best practices in how to use this, 

including the use of time functions and creating variables.

 Overview of data preparation required before starting to develop a QlikView 

application.

 Basic data model overview and understanding of QlikView table viewer.

 How to resolve abnormalities in the data structure, such as synthetic keys.

 QlikView QVD file and how to create them and use them.

Learn about the debugger and troubleshooting.

 How to add text data and how to generate data in the QlikView script.

 Mapping tables and cleaning up a data structure.

 How to load budget data.

 Script language and how to aggregate data, joining tables, concatenation, functions, 

interval match and other scripting features.

 Analyze data over time using Set analysis and Aggr Function.

 Data model optimization and performance tuning and how to create incremental loads.

 Overview of QlikView security and various access settings and levels.

 Advanced database connectivity.

 To finish it off a case study - each student gets to develop a QlikView application, which 

includes: loading in data, resolving data issues and building the UI with the help of 

business KPI.

Call us At  :  9884218531 /044 43542263 

Mail us : info@geoinsyssoft.com /geoinsys@gmail.com