FOR FREE DEMO contact :
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894

QlikView Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided
QLIKVIEW COURSE SYLLABUS
(the course content can be modified as per your requirements):

INTRODUCTION
1.1 Who is QlikTech ?
1.2 What is QlikView ?
1.3 QlikView Enterprise
1.4 What is Dash Board & Analysis?
2 A SHORT INTRODUCTION TO DATA STRUCTURES
2.1 Relational databases (OLTP)
2.2 Other data structures (OLAP)
3 A SHORT INTRODUCTION TO DATA WAREHOUSING
3.1 Fundamentals of ETL
3.2 What is the utility of De-normalize data structure in Data warehousing
3.3 Star Schema
3.4 Snow Flake Schema
3.5 SQL Arithmetic Functions, Joins, Aggregation Functions and String Functions
3.6 What are the table and field?
4 QLIKVIEW DATA STRUCTURES
4.1 Why QlikView is Compare with ETL
4.2 Comparing Database structures (OLTP & OLAP) to QlikView data structures
4.3 Data structures in QlikView (AQL).
4.4 Sample Application walkthrough of QlikView.
4.5 Objectivity of Relevant search records (Gray area & White area in Dimension)
4.6 Why it’s called In-memory BI Tool
4.7 Thorough Architecture of QlikView (including Multiple Data Source & AJAX Client)
5 LOADING DATA INTO QLIKVIEW
5.1 Script editing
5.2 Edit Script Toolbar
5.3 Edit Script Menu Commands
5.4 Statements Area
5.5 Edit Script Tool Pane
5.6 Syntax
5.7 Renaming a Field
6 DATA SOURCE FILES
6.1 The QWT (Access File example) primary data source
6.2 The QWT (Access File example with QVD Conversion) secondary data files
7 CREATING THE SCRIPT
7.1 Script generation
7.2 Creating a connection to the database
7.3 Reading tables into QlikView
8 EXERCISES
8.1 Script Debugging
9 STRUCTURING THE SCRIPT
9.1 Creating tabs in the script
10 DATA STRUCTURE OF THE LOADED DATA
10.1 The Table Viewer
10.2 System fields
10.3 The system table
10.4 Document Properties: Tables page
11 SCRIPTING CONSIDERATIONS
11.2 Synthetic key tables
11.3 Circular references
11.4 Causes of circular references
11.5 Loosely Coupled Tables
12 ADDING TEXT DATA
12.1 Employees
12.2 Offices
13 LOADING AN XML FILE
13.1 Loading a text file in XML Format
13.2 Renaming fields using the Qualify statement
14 EXERCISES
15 GENERATING DATA IN THE QLIKVIEW SCRIPT
15.1 Resident Load
15.2 Creating data using Load Inline and Autogenerate
15.3 Inline tables
15.4 Autogenerate tables
16 MAPPING TABLES
16.1 Mapping Quarters to the Orders table
16.2 MonthYear
16.3 Cleaning up the table structure
17 CREATING A CALENDAR
17.1 Getting the Highest and Lowest date from the Orders table
17.2 Creating variables in the script
17.3 Creating the Master Calendar
18 INCLUDE
19 READING BUDGET INTO QLIKVIEW
19.1 Reading Cross Tables
20 QLIKVIEW DATA (QVD) FILES
20.1 QVD file format
20.2 Use of QVD files
20.3 Creating QVD files
20.4 Automatic Creation of a QVD file in the script
21 QLIKVIEW SECURITY
21.1 Access control
21.2 Access levels
21.3 Access control database
21.4 Hidden script
21.5 Adding Section Access
Day 4
1 USING QLIKVIEW 11.0SR1 PERSONAL EDITION
1.1 Starting QlikView
1.2 Basic Layout and Navigation
2 SHEETS AND SHEET OBJECTS
2.1 Sheet Basics
2.2 Sheet Objects
2.3 Exercise – Creating Your Workspace
3 THE LIST BOX
3.1 Introduction
3.2 Creating a List Box
3.3 List Box in Action
3.4 Properties of the List Box
3.5 Exercise – List Boxes
4 THE TABLE BOX
4.1 Introduction
4.2 Creating a Table Box
4.3 Selections in Table Boxes
4.4 Sorting in Table Boxes
4.5 More Table Box formatting options
4.6 Printing data from a table box
4.7 Exporting data from a table box to a text file
4.8 Exercises
5 THE MULTI BOX
5.1 Introduction
5.2 Selections in Multi Boxes
5.3 Creating a Multi Box
5.4 Resizing Multi Boxes
5.5 Formatting Multi Boxes
5.6 Exercises
6 THE TEXT OBJECT
6.1 Introduction
6.2 Creating Text Objects
6.3 Formatting, Resizing, Copying and Moving Text Objects
7 CHARTS
7.1 Chart Basics
7.2 Creating a Chart
7.3 Selections in Charts
7.4 Changing the Chart Properties for Existing Charts
7.5 Common Chart Types
7.6 A Note About Mathematical Expressions
7.7 Exporting charts
7.8 References in charts
7.9 Exercises
8 MULTI DIMENSIONAL CHARTS, PIVOT TABLES
8.1 Straight Table with Multiple Expressions
8.2 Pivot Tables with Multiple Dimensions
8.3 Grouped bar charts
8.4 More about Pivot Tables and Straight Tables
8.5 5.5. Using a Dropdown Selection List
8.6 Using Visual Cues
8.7 Summary – Comparing Tables
8.8 Exercises
9 GAUGES
9.1 Why Use a Gauge Chart?
9.2 8.3. Types of Gauges
9.3 Building Gauges
9.4 Exercises
10 BUTTONS
10.1 Buttons in QlikView
10.2 Creating and Formatting a Button
10.3 Shortcut Buttons
10.4 Launch/Export-Buttons
10.5 Edit Macro (on the fly Grouping/Sheet Enabled Disabled)
10.6 Exercises
11 THE OTHER SHEET OBJECTS
11.1 The Statistics Box
11.2 The Current Selections Box
11.3 The Slider/Calendar Object
11.4 The Input Box
11.5 The Bookmark Object
12 ADDITIONAL EDITING IN THE LAYOUT
12.1 Title Settings
12.2 Fast Change Chart Type
12.3 Legend Settings
12.4 Reference Lines / Text in Chart
12.5 Advanced Caption Settings
12.6 Using Layout Themes
12.7 Exercises
14 OTHER USES OF EXPRESSIONS
14.1 Calculated Labels and Dynamic Text in Text Objects
14.2 Conditional Functions
14.3 Chart Attribute Expressions
14.4 Color Expressions
14.5 Calculated Fields in List Boxes
14.6 Calculated Dimensions in Charts
15 THE SETTINGS MENU
15.1 Sheet Properties