Monday 30 December 2013

Qlikview Online Training Call : +91 9441233734


QLIKVIEW ONLINE TRAINING


Course syllabus


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
  • Linkdin analytics using qlikview

No comments:

Post a Comment