Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provide the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies. The Training in is every thing we explained based on real-time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.
Course Content
QlikView Overview
- Qlikview Introduction
- Traditional BI tools vs. Qlikview
- Qlikview Features
- Architecture of Qlikview
Creating the First Qlikview Document
- How to install Qlikview desktop
- What are types of desktop – Machine wise
- Back end scripting window
- Front end UI window and shortcuts
Loading Data Into QlikView
- Script Editor Basics
- ODBC/OLEDB connection details
- Connect and disconnect
- How to connect to flat files
- Relative and absolute path
Data Structure of Loaded Data
- The Table Viewer
- System Fields
- System Table
Scripting Considerations
- Synthetic Key Tables
- Circular References
- Loosely Coupled Tables
Qlikview Scripting
- Need of data warehouse and ETL tools
- Mapping Tables
- Joins and keep
- Types of joins and Keep
- Concatenation
- incremental load concept in Qlikview
- Web file connection
- Variable creation
- Crosstable
Creating a Master calendar
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
- Document properties
- Preferences
Types of chart
- Best practices of usage of charts
- Tabular reports
- Multidimensional charts and objects
- Advanced visualizations
- Extensions and its usage
- Linked objects
Security in QlikView
- Section Access
- Data Reduction techniques
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
Bookmarks and Alerts
- Creation of bookmark
- Use of bookmark option
- Export and import of bookmark
- Creation of alerts
- Need of alerts
Macros in VB Script
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
For More Details