mail info@ascendinfosolutions.com    phn 732- 645-7910

Quickview
1. Qlikview Overview

  1. Qlikview Intro
  2. Traditional BI tools vs Qlikview
  3. In-Memory technology
  4. Architecture of Qlikview
  5. Social media analytics
  6. Collaboration

2. Creating the First Qlikview Document

  1. How to install Qlikview desktop
  2. What are types of desktop - Machine wise
  3. Back end scritping window
  4. Front end UI window and shortcuts

3. Qlikview Scripting

  1. ODBC/OLEDB connection details
  2. How to connect to flat files
  3. Need of datawarehouse and ETL tools
  4. Joins and keep
  5. Types of joins and Keep
  6. Concatenation
  7. incremental load concept in Qlikview
  8. Webfile connection
  9. Variable creation
  10. Cross table
  11. Relative and absolute path

4. Qlikview Functions

  1. Call function and procedure
  2. Connect and disconnect
  3. Drop fields and tables
  4. Creation of QVDs
  5. Execute
  6. First and top select
  7. Debug option
  8. Animate option

5. Qlikview Sheet and Objects

  1. 13 types of chart
  2. Best practices of usage of charts
  3. Tabular reports
  4. Multidimensional charts and objects
  5. Advanced visualizations
  6. Extensions and its usage
  7. Linked objects

6. BookMarks and Alerts

  1. Creation of bookmark
  2. Use of bookmark option
  3. Export and import of bookmark
  4. Creation of alerts
  5. Need of alerts
  6. Macros

7. Set Analysis Overview

  1. What is set analysis and its usage
  2. Set
  3. Modifier
  4. Practical uses
  5. Complex set analysis using Union, intersection
  6. Probability usage in set analysis

8. Qlikview Server and Doocument manager

  1. Types of server
  2. Server configuration
  3. Installation
  4. screenshots of server
  5. Role of admin
  6. services in Qlikview server
  7. Publisher and its usage

9. QlikView-Licensing-Overview

  1. Types of License - types of server
  2. What is cal and its usage
  3. What is cost of each license
  4. Scenarios of which license to be used for projects
  5. Effective and best practices of license usage

10. Big data analytics using Qlikview

  1. Connecting facebook
  2. Sentimental analysis - overview
  3. Overview of connecting to twitter
  4. Linkedin analytics using qlikview

Note: Duration of the Course is 20+ hours daily one hour.