Contact at mumbai.academics@gmail.com or 8097636691
Responsive Ads Here

Sunday, 27 May 2018

Qlikview Qliksence

QlikView is the swiftest growing BI and data visualization tool, which is quick-to-deploy, easy-to-learn and perfect to get started with data visualization. While the first step with data includes collection and extraction, disposing that data to executive level and presenting it to consumers for long-term profitability is equally significant in the industry. QlikView facilitates in-memory platform to perform faster data discovery and take business decisions that are reliable, viable and display data through interactive reports and visuals. It brings into existence a completely new platform to analyze data using clean, simple and precise interfaces. The best part is QlickView is flexible enough such that it allows users to view their own segment of underlying dataQlikView QlikSence

QlikView QlikSence

INTRODUCTION
Who is QlikTech ?
What is QlikView ?
Comparing QlikView with traditional tools.
QLIKVIEW DATA STRUCTURES 
Data structures in QlikView (AQL)
Sample Application walkthrough of QlikView 
Objectivity of Relevant search records (Gray area & White area in Dimension)
 Why it’s called In-memory BI Tool
Thorough Architecture of QlikView (including Multiple Data Source & AJAX Client)
LOADING DATA INTO QLIKVIEW
Script editing
Edit Script Toolbar
Edit Script Menu Commands
Statements Area
Edit Script Tool Pane
Syntax
Renaming a Field
DATA SOURCE FILES 
The QWT primary data source
The QWT secondary data files
CREATING THE SCRIPT 
Script generation
Creating a connection to the database
Reading tables into QlikView
EXERCISES
Script Debugging
STRUCTURING THE SCRIPT
Creating tabs in the script
DATA STRUCTURE OF THE LOADED DATA 
The Table Viewer
System fields
The system tab
The system table
Document Properties: Tables page
 
SCRIPTING CONSIDERATIONS 
Adding Text Data
Loading an XML file
Reading the Shipments table
Synthetic key tables
Circular references
Causes of circular references
Renaming fields using the Qualify statement
QLIKVIEW DATA (QVD) FILES 
QVD file format
Use of QVD files
Creating QVD files
Manual creation of a QVD file in the script
Automatic Creation of a QVD file in the script
QVD file script functions
QLIKVIEW SECURITY 
Access control
Access levels
Hidden script
Adding Section Access
ADVANCED SCRIPTING 
Condition on a field in a table
Aggregating Data in Script (Resident Load and Group Function, Order By etc)
Joining tables (Left, Right, Inner, Outer Joins)
Concatenation
Set Analysis
REPORTS AND BOOKMARKS 
Introduction – Reports
QlikView Report Types
Managing Reports
Creating and editing reports
Introduction – Bookmarks
USING QLIKVIEW PERSONAL EDITION
Starting QlikView
Basic Layout and Navigation
SHEETS AND SHEET OBJECTS 
Sheet Basics &Sheet Objects
THE LIST BOX
Introduction
Creating a List Box
List Box in Action
Properties of the List Box
THE TABLE BOX 
Introduction
Creating a Table Box
Selections in Table Boxes
Sorting in Table Boxes
More Table Box formatting options
Printing data from a table box
Exporting data from a table box to a text file
THE MULTI BOX 
Introduction
Selections in Multi Boxes
Creating a Multi Box
Resizing Multi Boxes
Formatting Multi Boxes
THE TEXT OBJECT 
Introduction
Creating Text Objects
Formatting, Resizing, Copying and Moving Text Objects
CHARTS 
Chart Basics
Creating a Chart
Selections in Charts
Changing the Chart Properties for Existing Charts
Common Chart Types
Exporting charts
References in charts
MULTI DIMENSIONAL CHARTS, PIVOT TABLES,GAUGES 
Straight Table with Multiple Expressions
Pivot Tables with Multiple Dimensions
Grouped bar charts
More about Pivot Tables and Straight Tables
Using a Dropdown Selection List
Using Visual Cues
Summary – Comparing Tables
Types of Gauges
Building Gauges
BUTTONS 
Buttons in QlikView
Creating and Formatting a Button
Shortcut Buttons
Launch/Export-Buttons
Edit Macro (on the fly Grouping/Sheet Enabled Disabled) 
THE OTHER SHEET OBJECTS 
The Statistics Box
The Current Selections Box
The Slider/Calendar Object
The Input Box
The Bookmark Object
The Custom Object
The Other Chart Types
ADDITIONAL EDITING IN THE LAYOUT 
Title Settings
Fast Change Chart Type
Legend Settings
Reference Lines / Text in Chart
Advanced Caption Settings

OTHER USES OF EXPRESSIONS 
Calculated Labels and Dynamic Text in Text Objects
Conditional Functions
Chart Attribute Expressions
Color Expressions
Calculated Fields in List Boxes
Calculated Dimensions in Charts
The Expression Overview Dialog
THE SETTINGS MENU 
User Preferences
Document Properties
Sheet Properties
Inherited settings
SERVER INTRODUCTION
Overview
System Requirements
Installation of QlikView Server
CONFIGURING LDAP
CUSTOM USERS CREATION
SECURITY
Authorization
                NTFS authorization
DMS authorization
Authentication
LICENSING
Client Access License CAL Types
USER DOCUMENT MAPPING
ARCHITECTURE
QlikView Server
Web Server
QlikView with Publisher
QlikView without Publisher
Qlikview Services

No comments:

Post a Comment