Qlikview Training | IQ Training

1. Qlikview www.iqonlinetraining.com

2. Hello! 2

3. Qlikview Online Training Let’s start 3

4. “ IQ Training’s QlikView online course will help you become an expert in Data Visualization with qlikview tutorial. In this tutorial, you will learn the QlikView basics and it’s advanced features such as data modelling, reports, dashboards, incremental load formatting and object formatting. Upon completion of this course, you will be able to transform data into interactive charts and graphs by using these Qlikview features. 4

5. Introduction to QlikView Learning Objectives: From this module, you will get an overview of BI tools and the introduction of QlikView, features and its architecture ◆ What is BI? ◆ Visualization Introduction ◆ Different BI Tools ◆ What is QlikView? ◆ Sheet Objects ◆ Dimensions ◆ Expressions ◆ Layout / Sort tabs ◆ Sheet Objects ◆ Features of Qlikiew ◆ Components of QlikView ◆ Architecture of QlikView ◆ Installation & Navigation ◆ Data Ingestion ◆ Report Interface ◆ QVS, QVW and .log files ◆ Hands On/Demo: ◆ Sheet Objects ◆ Dimensions ◆ Expressions ◆ Layout / Sort tabs

6. Scripting ◆ Topics: ◆ What is Scripting? ◆ Importance of Scripting ◆ Script Toolbar ◆ Script Menu Commands ◆ QlikView Variables (Set,Let) and Fields ◆ Tabs creation in the script ◆ Adding Sheet Objects ◆ QlikView Functions ◆ Hands On/Demo: ◆ Edit Script ◆ QlikView Operations ◆ Creation of variables, Inline load, Functions and Join 6

7. Data Model Learning Objectives: From this module, you will understand different QV data file types. You will also learn ways to resolve the synthetic keys and circular reference. ◆ Circular References & its causes ◆ Ways to Resolve Synthetic Keys and Circular Reference ◆ Using Qualify & unqualify ◆ Data File Types of QlikView ◆ System fields ◆ Star schema ◆ Synthetic Key Tables ◆ Link Table ◆ Concatenation: Forced, Auto, No ◆ Optimization of Data Model ◆ Master Calendar

8. Data Transformation Learning Objectives: From this module you will understand how to modify the existing data to a new data format. You will also understand different types of loads and tables. ◆ Data Generation in the QlikView Script ◆ Different Type of Loads ◆ Incremental load with QVD file ◆ Column manipulation ◆ Tables: Rotating, Straight and Pivot, Cross ◆ Mapping Table ◆ Security – Section Access and Control

9. What you will learn in Qlikview Certification Training ? Upon completion of this Qlikview course at IQ training’s, you should be able to: ◆ Understand what is QlikView. How does it work? What makes it a useful tool in the analytics domain? ◆ Learn to edit scripts ◆ Gain in-depth knowledge on generating data using QlikView scripts and also in creating dashboards. ◆ Use multiple charts, tables, synthetic Key tables in order to resolve the synthetic keys and circular reference ◆ Understand data file types and incremental load ◆ Perform object field formatting ◆ Perform set, indirect and what-if analysis

10. Who can go for this training? The Qlikview Certification Training is for all the professionals who are passionate about Business Intelligence and want to go ahead and enhance their career as a Qlikview Business Analyst. It is best suited for the following individuals. ◆ Business Analysts & Business Intelligence Managers ◆ Data Scientist and Analysts ◆ BI /ETL/DW Professionals ◆ Statisticians ◆ Fresher’s aiming to build a career in Visualization & Analysis

11. Thanks! Contact Us:- Phone: +91-9849038359 Visit:-www.iqonlinetraining.com email: info@iqtrainings.com 11