QlikView online training in india

Monday 29 July 2013






 United Global Soft

#307, 5th Floor, Liberty Plaza,
opp: Stanza,Himayat Nagar,
Hyderabad - 500029.

Phone No     : 040- 6644 4122
Email           :  info@unitedglobalsoft.com
Website       :  www.unitedglobalsoft.com

 

QlikView Desktop - Version 11.0 SR2
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.
It also focuses on the development side, learning about the script, best practices, loading data and how to deploy QlikView applications. It also covers data modeling and related issues such as database connectivity, advanced scripting and more complex data modeling issues.
Recommended Prerequisite Course(s): Data warehousing concepts, SQL.
Recommended Reading: The Data Warehouse Life Cycle Toolkit, by Ralph Kimball.
Course Outline:
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 QlikView Desktop - Version 11.0 SR2
    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.
    It also focuses on the development side, learning about the script, best practices, loading data and how to deploy QlikView applications. It also covers data modeling and related issues such as database connectivity, advanced scripting and more complex data modeling issues.
    Recommended Prerequisite Course(s): Data warehousing concepts, SQL.
    Recommended Reading: The Data Warehouse Life Cycle Toolkit, by Ralph Kimball.
    Course Outline:
    1. Qlikview Overview
  5. Qlikview Intro
  6. Traditional BI tools vs Qlikview
  7. In-Memory technology
  8. Architecture of Qlikview
  9. Social media analytics
  10. 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




Posted by online-trainings-in-hyderabad at 00:02 0 comments
Labels: , ,
Subscribe to: Posts (Atom)
 

Blogger news

Blogroll

Most Reading