Location
Edison,New Jersey
Course Start Date
2016-01-01

QLIKVIEW OVERVIEW:

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 SCRIPTING:

ODBC/OLEDB connection details
How to connect to flat files
Need of datawarehouse and ETL tools
Joins and keep
Types of joins and Keep
Concatenation
incremental load concept in Qlikview
Webfile connection
Variable creation
Cross table
Relative and absolute path

QLIKVIEW FUNCTIONS:

Call function and procedure
Drop fields and tables
Creation of QVDs
Execute
First and top select
Debug option
Animate option

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 DOCUMENT 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
10. Big data analytics using Qlikview
Connecting facebook
Sentimental analysis – overview

OVERVIEW OF CONNECTING TO TWITTER

LINKEDIN ANALYTICS USING QLIKVIEW:

QLIKVIEW OVERVIEW:
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 SCRIPTING:

ODBC/OLEDB connection details
How to connect to flat files
Need of datawarehouse and ETL tools
Joins and keep
Types of joins and Keep
Concatenation
incremental load concept in Qlikview
Webfile connection
Variable creation
Cross table
Relative and absolute path

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 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 using qlikview