United Global Soft
#307, 5th Floor,
Liberty Plaza,
opp: Stanza,Himayat Nagar,
Hyderabad - 500029.
Phone No : 040- 6644 4122Email : 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 assheets, 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- Qlikview Intro
- Traditional BI tools vs Qlikview
- In-Memory technology
- Architecture of Qlikview
- Social media analytics
- Collaboration
- How to install Qlikview desktop
- What are types of desktop - Machine wise
- Back end scritping window
- Front end UI window and shortcuts
- 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
- Call function and procedure
- Connect and disconnect
- Drop fields and tables
- Creation of QVDs
- Execute
- First and top select
- Debug option
- Animate option
- 13 types of chart
- Best practices of usage of charts
- Tabular reports
- Multidimensional charts and objects
- Advanced visualizations
- Extensions and its usage
- Linked objects
- Creation of bookmark
- Use of bookmark option
- Export and import of bookmark
- Creation of alerts
- Need of alerts
- Macros
- What is set analysis and its usage
- Set
- Modifier
- Practical uses
- Complex set analysis using Union, intersection
- Probability usage in set analysis
- Types of server
- Server configuration
- Installation
- screenshots of server
- Role of admin
- Services in Qlikview server
- Publisher and its usage
- 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
- Connecting facebook
- Sentimental analysis - overview
- Overview of connecting to twitter
- 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
- Qlikview Intro
- Traditional BI tools vs Qlikview
- In-Memory technology
- Architecture of Qlikview
- Social media analytics
- Collaboration
- How to install Qlikview desktop
- What are types of desktop - Machine wise
- Back end scritping window
- Front end UI window and shortcuts
- 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
- Call function and procedure
- Connect and disconnect
- Drop fields and tables
- Creation of QVDs
- Execute
- First and top select
- Debug option
- Animate option
- 13 types of chart
- Best practices of usage of charts
- Tabular reports
- Multidimensional charts and objects
- Advanced visualizations
- Extensions and its usage
- Linked objects
- Creation of bookmark
- Use of bookmark option
- Export and import of bookmark
- Creation of alerts
- Need of alerts
- Macros
- What is set analysis and its usage
- Set
- Modifier
- Practical uses
- Complex set analysis using Union, intersection
- Probability usage in set analysis
- Types of server
- Server configuration
- Installation
- screenshots of server
- Role of admin
- Services in Qlikview server
- Publisher and its usage
- 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
- Connecting facebook
- Sentimental analysis - overview
- Overview of connecting to twitter
- Linkedin analytics using qlikview