QLIKVIEW ONLINE TRAINING
COURSE DESCRIPTION
This course structure is a mixture of demonstrations and hands on exercises of the many QlikView components. Topics covered in this course, include fundamental user interface layout and design best practices. It also covers how to view and read QlikView application and objects such as sheets, list boxes, various charts and graphs. All the basic knowledge required to get started with QlikView.
PREREQUISITE COURSE(S):
Data warehousing concepts, SQL.Recommended Reading: The Data Warehouse Life Cycle Toolkit, by Ralph Kimball.
QLIKVIEW CONTENT:
Qlikview Intro
Traditional BI tools vs Qlikview
In-Memory technology
Architecture of Qlikview
Social media analytics
Collaboration
CREATING THE FIRST QLIKVIEW DOCUMENT
How to install Qlikview desktop
What are types of desktop - Machine wise
Back end scritping window
Front end UI window and shortcuts
QLIKVIEW FUNCTIONS
Call function and procedure
Connect and disconnect
Drop fields and tables
Creation of QVDs
Execute
First and top select
Debug option
Animate option
QLIKVIEW SCRIPTING
ODBC/OLEDB connection details
How to connect to flat files
Need of data warehouse and ETL tools
Joins and keep
TYPES OF JOINS AND KEEP
Concatenation
incremental load concept in Qlikview
Web file connection
Variable creation
Cross table
Relative and absolute path
QLIKVIEW SHEET AND OBJECTS
13 types of chart
Best practices of usage of charts
Tabular reports
Multidimensional charts and objects
Advanced visualizations
Extensions and its usage
Linked objects
BOOKMARKS AND ALERTS
Creation of bookmark
Use of bookmark option
Export and import of bookmark
Creation of alerts
Need of alerts
Macros
SET ANALYSIS OVERVIEW
What is set analysis and its usage
Set
Modifier
Practical uses
Complex set analysis using Union, intersection
Probability usage in set analysis
QLIKVIEW SERVER AND DOOCUMENT MANAGER
Types of server
Server configuration
Installation
screenshots of server
Role of admin
Services in Qlikview server
Publisher and its usage
QLIKVIEW-LICENSING-OVERVIEW
Types of License - types of server
What is cal and its usage
What is cost of each license
Scenarios of which license to be used for projects
Effective and best practices of license usage
BIG DATA ANALYTICS USING QLIKVIEW
Connecting Facebook
Sentimental analysis - overview
Overview of connecting to twitter
Linkedin analytics
Should you require any further information regarding Qlikview Training Demo sessions, Material, Project Support, Price, interview Questions etc… Please Contact us through Email and Phone
Glory It Technologies Email : info@gloryittechnologies.com Phone (IND) : +91-9032813456 / +91-9160177789 Website : www.gloryittechnologies.com