Qlikview www.iqonlinetraining.com
Hello!
2
Qlikview Online Training Let’s start
3
“
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
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
◆
Hands On/Demo:
◆
◆
Sheet Objects
Components of QlikView
◆
Dimensions
◆
Architecture of QlikView
◆
Expressions
◆
Layout / Sort tabs
◆ ◆
Installation & Navigation Data Ingestion
◆
Report Interface
◆
QVS, QVW and .log files
Scripting ◆ Topics: ◆ What is Scripting?
◆ Hands On/Demo: ◆ Edit Script
◆ Importance of Scripting ◆ Script Toolbar
◆ QlikView Operations ◆ Creation of variables, Inline load, Functions and Join
◆ Script Menu Commands ◆ QlikView Variables (Set,Let) and Fields ◆ Tabs creation in the script ◆ Adding Sheet Objects ◆ QlikView Functions 6
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. ◆ Data File Types of QlikView ◆ System fields ◆ Star schema ◆ Synthetic Key Tables ◆ Link Table
◆ Circular References & its causes
◆ Concatenation: Forced, Auto, No
◆ Ways to Resolve Synthetic Keys and Circular Reference
◆ Master Calendar
◆ Using Qualify & unqualify
◆ Optimization of Data Model
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
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
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
Thanks! Contact Us:Phone: +91-9849038359 Visit:-www.iqonlinetraining.com email: info@iqtrainings.com
11