Qlik view Training in Coimbatore

QLIKVIEW TRAINING COURSE CONTENT

INTRODUCTION

• WHAT IS Reporting/Business Intelligence?
• Why BI tool required?
• WHAT IS QLIKVIEW?
• Merits & Demerits of Qlikview
• Basic Qlikview Terminology-QVW,QVD,QVX,Fields etc.
• Qlikview Architecture-QVS, QVP

BASICS

• StartingQlikView
The Start Page
• Opening a document
• Saving a document
• Closing a document
• QlikView Help
• Using Documents on a QlikView Server

WORKING WITH QLIKVIEW INTRODUCTION

• Loading Data from different sources
• ODBC, OLEDB connections
• Other connections

MAKING QUERIES IN QLIKVIEW

• Opening the document
• Basic QlikView terminology
• Selections
• Stepping back or forward in the list of selections
• Locking and unlocking selections
• Searching values
• Saving your work
• Checking your work

HANDLING SHEETS AND SHEET OBJECTS

• Opening the document
• Sheets
• Logical connections between sheets
• Adding a sheet
• Moving a sheet
• Adding new sheet objects
• Saving, closing and exiting

LIST BOXES AND STATISTICS BOXES

• Opening the document
• The list box
• The statistics box
• Saving, closing and exiting

BAR CHARTS AND PIE CHARTS

• Introduction
• Opening the document
• Making selections in a chart
• Changing chart types using a fast type change icon
• Creating a bar chart using the Quick Chart Wizard
• Creating a bar chart using the full chart wizard
• Removing a chart
• Changing a few properties
• Cloning and detaching your chart
• Turning the bar chart into a pie chart
• Saving, closing and exiting

PIVOT TABLES AND STRAIGHT TABLES

• Opening the document
• Adding a dimension to a bar chart
• Turning a bar chart into a multidimensional pivot table
• Creating a straight table
• Saving, closing and exiting

MORE CHART TYPES

• Opening the document
• Creating a line chart
• Adding an expression to a bar chart
• Turning the bar chart into a combo chart
• Turning the combo chart into a scatter chart
• Creating a scatter chart from scratch
• Creating a gauge chart
• Working with drill-down functionality
• Copying to Clipboard and printing
• Saving, closing and exiting

MULTI BOXES, TABLE BOXES AND INPUT BOXES

• Opening the document
• The multi box
• The table box
• Using an input box
• Saving, closing and exiting

BUTTONS, TEXT OBJECTS AND LINE/ARROW OBJECTS

• Opening the document
• The text object
• The line/arrow object
• The button
• Saving, closing and exiting

SLIDERS, CURRENT SELECTION OBJECTS AND BOOKMARK

• OBJECTS 119
• Opening the document>
• The slider/calendar object (in slider mode)
• Creating a Current Selections box
• Creating a bookmark object
• Saving, closing and exiting

DOCUMENT PROPERTIES, USER PREFERENCES AND RELOAD

• Opening the document
• Setting Document Properties
• User Preferences
• Reloading data
• Saving, closing and exiting
• Checking your work
• What’s next?

CREATING A DOCUMENT INTRODUCTION LOADING DATA INTO QLIKVIEW

• Looking at a delimited text file
• Creating a new QlikView document
• Loading a text file into QlikView
• Saving, closing and exiting

ASSOCIATING DATA FROM MANY TABLES

• Associations
• Opening the document
• Loading and associating a second table
• Renaming fields
• Saving, closing and exiting

CONCATENATING TABLES

• Opening the document
• Automatic concatenation
• Forced concatenation
• Saving, closing and exiting

THE TABLE STRUCTURE

• Using the Table Viewer
• Labeling tables in the script
• Improving the layout
• Saving, closing and exiting

LAYOUT THEMES

• Creating a theme
• Applying a theme
• Saving, closing and exiting

LOADING ADDITIONAL FILES

• Opening the document
• Loading a tab separated file without labels
• Loading a file via OLE DB
• Saving, closing and exiting

LINKING EXTERNAL INFORMATION TO A DOCUMENT

• Opening the document
• Looking at an info table
• Loading the info table
• Viewing the linked information
• Embedding external info
• Displaying info in a text object
• Saving, closing and exiting
• What’s next?

ADVANCED FEATURES INTRODUCTION DATA MODELING

• Creating a simple data model>
• Finding synthetic keys
• Removing Synthetic keys
• Creating keys/composite keys/renaming/Auto number

LOAD INLINE

• Adding a record with load inline
  
• Adding a table with load inline

FIELD GROUPS AND CYCLIC DISPLAY

• Field groups
• Cyclic display of expressions

VARIABLES

• Working with Variables

TRIGGERS

• Working on triggers
• Create an action

CONFIGURATION

• Connection string configuration
• Scheduling data load
• Auto reloads application

SECURITY

• Data level security
• Sections in the Script
• Access levels
• Loading security tables
• Using the Security pages
• Opening a document with access restriction

WHAT’S NEXT?

• QlikViewTraining Program
• QlikCommunity
• QlikViewDemo Applications
• Nprinting